This is the error I get: MySQL Query Failed. Error 1030: Got error -1 from
table handler
> 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
