[thelist] mysql error [was mysql help]

Mark Mckee lists at soddengecko.com
Mon Oct 2 23:23:09 CDT 2006

hi all

thanks to the advice and info from the people here i have managed to 
finish my script.

i do get a slight problem though, when someone tries to add a link when 
a category does not exist, it out puts this mysql error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL 
result resource in /opt/lampp/htdocs/link_manager/add_link.php on line 16

this is the code on that page

// Connect to the correct database
include "dbconnect.php";
// Select correct fileds to show
$sql="SELECT id, catagory FROM catagories ORDER BY catagory";
// Populate the OPTIONS variable
// Fetch the data
while ($row=mysql_fetch_array($result)) {              <---------line 16
// Display data in this format
     $options.="<OPTION VALUE=\"$catagory\">$catagory</option>\n";

what would i have to do so that the script will detect that no category 
has been created and output a message to say that?

kind regards

mark m....

More information about the thelist mailing list