mysql syntax error

[ballhogjoni]

I keep getting this error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/realfina/public_html/thediaperbakery/left_nav.php on line 11

 

this is my code:

mysql_connect('localhost',$username,$password);
									@mysql_select_db($database) or die( "Unable to select database");
									$query = mysql_query('SELECT * FROM leftNavigation WHERE ID = 1');
									while ($row = mysql_fetch_assoc($query)) { // line 11
									$Category = $row["Category"];
									}

[cooldude832]

if you have 0 results it will error

 

try this and see if you have errors

$query = mysql_query('SELECT * FROM leftNavigation WHERE ID = 1') or die (mysql_error());

 

[HuggieBear]

Firstly I'd remove the @ from the front of @mysql_select_db.  @ supresses any error messages, which if you're having problems, is probably kind of useful.

 

Regards

Huggie

[trq]

Always check your query succeeds before trying to use any result it produces.

 

<?php

  mysql_connect('localhost',$username,$password);
  mysql_select_db($database) or die( "Unable to select database");
  if ($result = mysql_query('SELECT * FROM leftNavigation WHERE ID = 1')) {
    if (mysql_num_rows($result)) {
      while ($row = mysql_fetch_assoc($result)) {
        $Category = $row["Category"];
      }
    }
  } else { // good place to debug.
    echo mysql_error();
  }

?>

 

Where is $database defined?

[ballhogjoni]

just above all that. Thanks i got it.