Another tip that I have used ALOT...
When a query fails, go to the command line and try executing it and
variations of it there to find the problem.
-Jason Garber
At 10:48 AM 8/23/2001 +0200, you wrote:
>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
