Re: [PHP] MySQL COUNT Won't Work

2001-02-18 Thread David Robley
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,

[PHP] MySQL COUNT Won't Work

2001-02-16 Thread Jeff Oien
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";

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Jon Haworth
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

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Javier Muniz
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]

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Jeff Oien
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

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Javier Muniz
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

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Joe Sheble (Wizaerd)
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

Re: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Jeff Oien
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

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Javier Muniz
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

Re: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Christian Reiniger
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 =

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread php3
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(*)

Re: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Andrew Rush
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