First, Try this:
NOT EQUAL is != rather than <>
$query =
"SELECT * FROM question WHERE answer != '1' AND id>250 ORDER BY id DESC";
$result =
mysql_query($query) or die('MySQL Query Failed. Error '.mysql_errno().':
'.mysql_error());
$number = mysql_num_rows($result);
-Jason Garber
Lead Programmer - pulseaday.com
[EMAIL PROTECTED]
At 10:10 AM 8/23/2001 +0200, you wrote:
>What's wrong with this? I get the error: Warning: Supplied argument is not a
>valid MySQL result resource in /home/sites/site49/web/vragen/vragen.php on
>line 42
>
>
>
>$query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY id
>DESC";
>
>$result = MYSQL_QUERY($query);
>
>$number = MYSQL_NUM_ROWS($result);
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
