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 f

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."); //<$queryhttp://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list admini

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

Re: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Jeff Oien
#x27;t execute query."); > > > > So you're querying the database, and not the connection? > > > > > > HTH > > Jon > > > > > > -Original Message- > > From: Jeff Oien [mailto:[EMAIL PROTECTED]] > > Sent: 16 February

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Joe Sheble (Wizaerd)
querying the database, and not the connection? > > > > > > HTH > > Jon > > > > > > -Original Message- > > From: Jeff Oien [mailto:[EMAIL PROTECTED]] > > Sent: 16 February 2001 17:27 > > To: PHP > > Subject: [PHP] MySQL COUNT

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(

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Jeff Oien
he database, and not the connection? > > > 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 thi

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Javier Muniz
;; '[EMAIL 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- F

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Jon Haworth
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 database with 'title' as one of the fields. Based on

[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 General Mailing List (http://www.php.net/) To uns