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
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, probably exists for COUNT as > well). > > -jm

RE: [PHP] MySQL COUNT Won't Work

2001-02-16 Thread Joe Sheble (Wizaerd)
I do lots and lots of count()'s in PHP and have never had any problems... of course, I do it a bit differently than you did.. // I always have these in a top level include $UserName = "noneYa"; $Password = "yeahRight"; $myDatabase = "uhhuh"; $dbConn = mysql_connect( "localhost", $UserName, $Pas

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
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("Couldn't execute query."); > > So you're querying the database, and not the connection? > > > HTH > J

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
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]] Sent: 16 February 2001 17:27 To: PHP Subject: [PHP] MySQL COUN