tbl_BBY table in ?? database or your connection in "mysql_select_database(databasename);"
Anuradika wrote:
>This first code is working well, which return the date of the
>server, but, getting rows from the table tbl_BBY doesnt work, please
>help
>
>$query = "Select NOW() ";
>$result = mysql_query($query);
>while($row = mysql_fetch_array($result))
>{
>echo $row[0];
>}
>exit;
>
>$query = "Select txt_ID FROM tbl_BBY ";
>$result = mysql_query($query);
>while($row = mysql_fetch_array($result))
>{
>echo $row['txt_ID'];
>}
>
>--- In php-objects@xxxxxxxxxxxxxxx, Anuradika Jaganadhan
><anuradika80@xxxx> wrote:
>
>
>>i have tried to remove the @ which looks like this now
>>
>>$cx = mysql_connect('localhost', 'db', 'password');
>>mysql_select_db("db") or die( "Unable to select
>>database");
>>
>>and also used without MYSQL_ASSOC, but still im
>>getting the same error message. Can anyone help me
>>please
>>
>>
>>--- Ryan Sexton <rsexton@xxxx> wrote:
>>
>>
>>>Are you sure the Conn_to_Mysql.php contains the
>>>correct username and
>>>password and the correct host to where your mysql
>>>installation is? I'd
>>>say you're failing to make a connection to your
>>>mysql database at the
>>>office because it's setup differently. I'd bet you
>>>have a @ in front of
>>>your mysql_connect() statement in that include file.
>>>remove it and run
>>>your script to see what the error message is.
>>>
>>>Good luck,
>>>Ryan
>>>
>>>On Mar 7, 2005, at 6:42 PM, Anuradika wrote:
>>>
>>>
>>>
>>>Hi there,
>>>I have coded the project using php 5.0.3, with MySQL
>>>4.1. I am using
>>>
>>>require("Conn_to_Mysql.php");
>>>$query = "Select * from tbl_BBY ";
>>>$result = mysql_query($query);
>>>while($row = mysql_fetch_array($result,
>>>MYSQL_ASSOC))
>>>{
>>>
>>>}
>>>
>>>Its running in my office pc, and my home pc, but
>>>when i upload to the
>>>webserver, its giving error as such, anyone able to
>>>help me to solve
>>>this issue.
>>>
>>>Warning: mysql_fetch_array(): supplied argument is
>>>not a valid MySQL
>>>result resource
>>>
>>>Thanks in advance.
>>>
>>>
>>>
>>>
>>
>>
>_____________________________________________________________________
>___
>
>
>>Yahoo! Messenger - Communicate instantly..."Ping"
>>your friends today! Download Messenger Now
>>http://uk.messenger.yahoo.com/download/index.html
>>
>>
>
>
>
>
>
>PHP Data object relational mapping generator - http://www.meta-language.net/
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
<*> To unsubscribe from this group, send an email to:
php-objects-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
