mysql query problem

[hermzz]

this script checks for a offset value in the url and then does one or the other depending on the existence of it, but it gives me an error in the two last lines.
anyone have any idea of what's wrong?

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\WINDOWS\Desktop\webserver\clphp\index.php on line 91

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\WINDOWS\Desktop\webserver\clphp\index.php on line 94

$limit=3;
list($name, $val) = each($HTTP_GET_VARS);
   if ($name = 'offset') {
     $high = $offset+$limit;
     $result = mysql_query("SELECT * FROM `news` LIMIT $offset, $high");

   } else { 
     $offset = 0;
     $high = $limit;
     $result = mysql_query("SELECT * FROM `news` LIMIT $offset, $high");
   }

this is line 91 --> $numrows = mysql_num_rows($result);


this is line 94 --> while($myrow = mysql_fetch_array($result, MYSQL_ASSOC)) {

[steved]

Well, I see a couple of problems...........

The error message you are getting is telling you that you are not getting any results back from your query.

I would remove the single quotes from around your table name so that your query looks like:

$result = mysql_query("SELECT * FROM news LIMIT $offset, $high");

Also, your if statement needs another equal sign, like:

if ($name == 'offset') {

Those changes should get you further on the way.....

[steved]

I also don't see where you are defining $offset anywhere before you are using it in your addition statement. Maybe you want to be using $val instead?

[hermzz]

thanks a lot