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
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
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.
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
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
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