[RESOLVED] Drop Down Menu - works locally but error online

[blueleafprint]

I have got a drop down menu that I am using a table to populate, which works fine locally, but not when I upload it.

The error I get is...
mysql_fetch_array(): supplied argument is not a valid MySQL result resource

and the coding i'm using is....

<?php
$sql = "SELECT * FROM groups";
$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['GROUP_ID']."\">".$row['GROUP_NAME']."\n  ";
} 
?>

I exported the table from my local host so it would be the same on the website and checked that the tables and fields have the same case.

Any help would be great.

Thanks,
George

[NogDog]

To help debug, you could do something like this:

$rs = mysql_query($sql);
if($rs == false)
{
   die(mysql_error()."<br />$sql");
}

Hopefully this will tell you why your query failed.

[blueleafprint]

Thanks for the quick response.

Warning>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sites/blueleafprint.co.uk/public_html/qsurveyit/register2.php on line 30

Which is:

while($row = mysql_fetch_array($rs)) 

Or am I meant to get a different message?

[NogDog]

I would have expected something before that line executes, since it's claiming that $rs is not a query result resource, which is what happens if the query fails to execute. So that section of code with my additional debug code should look something like:

<?php
$sql = "SELECT * FROM groups";
$rs = mysql_query($sql);
// debug code:
if($rs == false)
{
   die(mysql_error()."<br />$sql");
}
// end debug code

while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['GROUP_ID']."\">".$row['GROUP_NAME']."\n  ";
}
?>

[blueleafprint]

Hi NogDog

Why is it the easy thing you never look for!!! Just relised that my local db has a slightly different name as my hosting company add 3 numbers on the end.

Thanks for your time, and sure i'll be back on here with some other questions for this site!!

Thanks again.