On Sat, 17 Feb 2001 04:27, Jeff Oien wrote:
Yes! That was it. Thank you very much.
Jeff Oien
Are you using 3.23.33? If so try removing the space between the
COUNT and the open paren. It looks like there may be a bug in the
latest release (seeing this problem on the mysql list for MAX,
I'm totally stuck on this code. I get the error
"Couldn't execute query." so I know where it's
failing but can't figure out what's wrong. I have
a database with 'title' as one of the fields. Based
on code in PHP Fast and Easy.
Jeff Oien
?php
$db_name = "Music";
$table_name = "music";
PHP] MySQL COUNT Won't Work
I'm totally stuck on this code. I get the error
"Couldn't execute query." so I know where it's
failing but can't figure out what's wrong. I have
a database with 'title' as one of the fields. Based
on code in PHP Fast and Easy.
Jeff Oien
?php
$db_name = "Mus
PROTECTED]'
Subject: RE: [PHP] MySQL COUNT Won't Work
Shouldn't that be
$result = mysql_query($sql,$db)
or die("Couldn't execute query.");
So you're querying the database, and not the connection?
HTH
Jon
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]
HTH
Jon
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: 16 February 2001 17:27
To: PHP
Subject: [PHP] MySQL COUNT Won't Work
I'm totally stuck on this code. I get the error
"Couldn't execute query." so I know where it's
failing but can't figure out
PROTECTED]]
Sent: Friday, February 16, 2001 9:37 AM
To: PHP
Subject: RE: [PHP] MySQL COUNT Won't Work
That's not it. Get:
Warning: Supplied argument is not a valid MySQL-Link resource in
count.php3 on line 14
Jeff Oien
Shouldn't that be
$result = mysql_query($sql,$db)
or die("Cou
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: 16 February 2001 17:27
To: PHP
Subject: [PHP] MySQL COUNT Won't Work
I'm totally stuck on this code. I get the error
"Couldn't execute query." so I know where it's
failing but can't figure out what's wrong. I have
a da
HTH
Jon
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: 16 February 2001 17:27
To: PHP
Subject: [PHP] MySQL COUNT Won't Work
I'm totally stuck on this code. I get the error
"Couldn't execute query." so I know where it's
failing
You should use fieldnames in your selects... I'd imagine count(*) would be
slower just as select * is slower.
-jm
-Original Message-
From: Joe Sheble (Wizaerd) [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 9:46 AM
To: PHP
Subject: RE: [PHP] MySQL COUNT Won't Work
I do
On Friday 16 February 2001 18:27, Jeff Oien wrote:
I'm totally stuck on this code. I get the error
"Couldn't execute query." so I know where it's
failing but can't figure out what's wrong. I have
a database with 'title' as one of the fields. Based
on code in PHP Fast and Easy.
$sql =
Addressed to: Javier Muniz [EMAIL PROTECTED]
Joe Sheble (Wizaerd) [mailto:[EMAIL PROTECTED]]
[EMAIL PROTECTED]
** Reply to note from Javier Muniz [EMAIL PROTECTED] Fri, 16 Feb 2001
10:14:29 -0800
You should use fieldnames in your selects... I'd imagine count(*)
On Friday, February 16, 2001, at 09:27 AM, Jeff Oien wrote:
$result = mysql_query($sql,$connection)
or die("Couldn't execute query."); //error from here
you die argument is next to worthless. change it to:
die("ERROR ".mysql_errno().": ".mysql_error()."pre$query/pre");
this should
12 matches
Mail list logo