uot;Jason G." <[EMAIL PROTECTED]>
> Subject: Re: numrows
> Mime-Version: 1.0
> Content-Type: text/plain; charset="us-ascii"; format=flowed
>
> Another tip that I have used ALOT...
>
> When a query fails, go to the command line and try executi
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 handl
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.
Sorry, my bad, <> should work...
do a:
mysql_connect("","","") or
die('MySQL Query Failed. Error '.mysql_errno().': '.mysql_error());
Using a little debugging (or die()) can be very helpful in determining what
the problem is...
-Jason Garber
At 01:36 AM 8/23/2001 -0
On Thu, Aug 23, 2001 at 04:32:57AM -0400, Jason G. wrote:
>
> NOT EQUAL is != rather than <>
Really? I've used them both with good success. Where does one
succeed and the other fail?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax:
Jeremy,
Do you stay up all night also, reading and responding to the MySQL mailing
list? :)
Thanks for the answer on your MySQL setup. I had mistakenly taken 15
connections to be 15 queries. However, I am impressed with the preformance
of MySQL. Do you have any data on how many Connections
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 Progr
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
On Thu, Aug 23, 2001 at 10:10:05AM +0200, Martin Kampherbeek 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
Can we see lines 1-41 as well, if they're relevant. Surely y
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
10 matches
Mail list logo