Error

2001-08-25 Thread Martin Kampherbeek
I still get this error. Can someone help me to solve this? MySQL Query Failed. Error 1030: Got error -1 from table handler $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY id"; $result = mysql_query($query) or die('MySQL Query Failed. Error '.mysql_errno().': '.mysql_error

numrows

2001-08-23 Thread Martin Kampherbeek
I tried it in the command line. And it works. But in the programm is still doesn't. MySQL Query Failed. Error 1030: Got error -1 from table handler > > Message-Id: <[EMAIL PROTECTED]> > Date: Thu, 23 Aug 2001 04:53:44 -0400 > To: [EMAIL PROTECTED] > From: "Jason G." <[EMAIL PROTECTED]> > Subjec

Re: numrows

2001-08-23 Thread Martin Kampherbeek
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.

Re: numrows

2001-08-23 Thread Martin Kampherbeek
eremy Zawodny <[EMAIL PROTECTED]> To: Martin Kampherbeek <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 10:17 AM Subject: Re: numrows > On Thu, Aug 23, 2001 at 10:10:05AM +0200, Martin Kampherbeek wrote: > > > > What's wrong with t

numrows

2001-08-23 Thread Martin Kampherbeek
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_R

UPDATE problem

2001-08-20 Thread Martin Kampherbeek
Hello, I have created a predictionscompetition and some code counts te total score of a match of a person. On the screen it workes, but in de database it goes wrong. Each person gets the total of the last person. There must be something wrong with the update statement. I hope someone can help m