[SOLVED] Error

[Ninjakreborn]

<?php
$category = mysql_real_escape_string($_GET['category']);
$select = "SELECT * FROM embarrassing WHERE category = '$category' AND approved = 'yes'";
while ($row = mysql_fetch_array($select)) {
echo '<a href="embarrassing2.php?id=' . $row['id'] . '" title="' . stripslashes($row['title']) . '">' . stripslashes($row['title']) . '</a>';
echo '<br />';
}
echo mysql_error();
?>

That is returning

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/################# on line 31

Any advice on what could be wrong with that query.  The data is passing properly, very strange...

Any advice?

[AndyB]

Glad it's solved, but do you ever think of error trapping your queries? That would have pointed out the solution in a flash.

[Ninjakreborn]

I use to, but I sort of ended up stopping.

I suppose it's better to, but I ended up just falling out of habit over time, because I don't normally get them wrong (I was in a hurry when I created that one).

Most of the time they get right the first time.

If they don't I normally do error handling on them.