What does this tell you?
$query = "Select txt_ID FROM tbl_BBY ";
$result = mysql_query($query);
if (mysql_errno()) {
echo "<p>MySQL error: ". mysql_error() . "</p>";
echo "<p>SQL: $query</p>";
die;
}
Here's another way to check for errors.
$query = "Select txt_ID FROM tbl_BBY ";
$result = mysql_query($query);
if (!$result) {
echo "<p>MySQL error: ". mysql_error() . "</p>";
echo "<p>SQL: $query</p>";
die;
}
--
Sheila
http://www.shefen.com/
Anuradika Jaganadhan wrote:
> it shows all the tables in the db, but i m aunable to
> connect using
> mysql_fetch_array():
> mysql_fetch_assoc():
> mysql_num_rows():
> please help
>
>>>>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.
>>>>
>>>>
>>>
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/
