not a valid MySQL result resource?newbie

[Anon]

i am populating 2 drop downs and get this error, whats up?
Warning: Supplied argument is not a valid MySQL result resource in d:\inetpub\wwwroot\prime\media.php, this is the prob line
while ($row = mysql_fetch_array($category)) {

Thanks in advance, Dom

This is my PHP code

$dbh=mysql_connect ("localhost", "root", "********") or die ('I cannot connect to the database.');
mysql_select_db ("media");

$az = mysql_query("SELECT title_name, title_id FROM title ORDER BY title_name");

if (!$az) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit();}
while ($row = mysql_fetch_array($az)) {
$title_id = $row["title_id"];
$name = $row["title_name"];
$option_block1 .= "<OPTION value=\"$title_id\">$name</OPTION>";
}

if (!$category) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit();}
while ($row = mysql_fetch_array($category)) {
$category_id = $row["category_id"];
$category = $row["category_name"];
$option_block2 .= "<OPTION value=\"$category_id\">$category</OPTION>";
}

This is my HTML

<SELECT name="title_id">
<? echo "$option_block1"; ?> </SELECT>

<SELECT name="category_id">
<? echo "$option_block2"; ?></SELECT>

[gio2k]

Your SQL statement for retrieving the category list is missing

-Gio-

[Anon]

sorry sergio
it was in there i just forgot to paste it

$category = mysql_query("SELECT category_name, category_id FROM category ORDER BY category_name") or DIE(mysql_error());

[gio2k]

Well then what may have happened is that your query did not return any results, and your mysql_fetch_array() statement is trying to retrieve information from an empty resultset.

Always check if your query returned any results:

$qres = mysql_query($sqlquery)
if ($qres)
{
$numresults = mysql_num_rows($qres)
if ($numresults > 0)
{
// Process results
}
else
{
// Query returned no rows
// Display message or whatever
}
}
else
{
// Error message
}

-Gio-

[Anon]

Gio,
Thanks again for your reply, that bit of code I know will come in very handy. Thing is, I know there are rresults to be displayed from that query. I am filling a drop down box for user to select.

I am sure it is something silly that I havent noticed or dont know about

thanks again
dom

[gio2k]

Post the structure of your tables.
And execute the Queries in the mysql command line tool, to be sure if your queries are succesfully run.

I'm pretty sure that your query doesn't return results.

-Gio-

[Anon]

Hey Don, if you still havn't figured this problem out, i've created pull down menus before using PHP, i can e-mail you my code so you have something to build from just e-mail me. [e-mail]