[thelist] mysql error [was mysql help]

[Mark Mckee]

Hi Phil

Maybe it is somethign I have midified while tidying up the code but I do 
not appear to be getting the error message anymore.

I have a colleague who is going to install the app and see if they get 
any errors on that page as well.

lol, I know categories is spelt wrong, comes form coding way into the 
night. far too many to change now so that is an update for a boring day.

I would still like to output a message that states that the categories 
are empty and one should be created. also having a little difficulty 
creating an export/import function so the db can be backed up via the 
application itself.

any ideas or resources would be brilliant, searched google all night and 
what I founf either did not work or was command line info.

Kind regards

Mark M...

Phil Turmel wrote:
> Mark Mckee wrote:
>   
>> 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
>>
>> <!--POPULATE DROPDOWN BOX -->
>> <?
>> // Connect to the correct database
>> include "dbconnect.php";
>> // Select correct fileds to show
>> $sql="SELECT id, catagory FROM catagories ORDER BY catagory";
>> $result=mysql_query($sql);
>> // Populate the OPTIONS variable
>> $options="";
>> // Fetch the data
>> while ($row=mysql_fetch_array($result)) {              <---------line 16
>> // Display data in this format
>>      $id=$row["id"];
>>      $catagory=$row["catagory"];
>>      $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?
>>
>>     
> Mark,
>
> Something else must be wrong, as a zero-rows-result is still a valid 
> result.  If you put in an error check right after mysql_query, you'll 
> learn more:
>
> if ($result===FALSE)
>      printf("Query Error, #%u\n%s\n", mysql_errno(), mysql_error());
>
> Any chance it's the way you are misspelling category?
>
> HTH,
>
> Phil
>