Re: [PHP] PHP/MySQL & Control Structures -> if (mysql_query())

2001-03-20 Thread David Robley
On Wed, 21 Mar 2001 16:15, Mike Gifford wrote: > Hi David, > > I counted the number of rows using mysql_numrows(), but I've been told > that count() is way faster. Unfortunately, I can't seem to get count > working.. Any ideas? > > echo mysql_numrows(mysql_query("select * FROM phPetition",$db))

Re: [PHP] PHP/MySQL & Control Structures -> if (mysql_query())

2001-03-20 Thread Don Read
On 21-Mar-01 Mike Gifford wrote: > Hi David, > > I counted the number of rows using mysql_numrows(), but I've been told that > count() is way faster. Unfortunately, I can't seem to get count working.. > Any > ideas? > > echo mysql_numrows(mysql_query("select * FROM phPetition",$db)); > > /

Re: [PHP] PHP/MySQL & Control Structures -> if (mysql_query())

2001-03-20 Thread Mike Gifford
Hi David, I counted the number of rows using mysql_numrows(), but I've been told that count() is way faster. Unfortunately, I can't seem to get count working.. Any ideas? David Robley wrote: > $same_Email_query is a pointer to a result set from the query and will > always be true if the quer

Re: [PHP] PHP/MySQL & Control Structures -> if (mysql_query())

2001-03-20 Thread David Robley
On Wed, 21 Mar 2001 14:58, Mike Gifford wrote: > Hello, > > I'd like the presense or absense of information within a database to be > involved in an if statement, however I'm having trouble getting it to > work. I've set up the following: > > $same_Email_query = mysql_query("SELECT Email FROM phP

[PHP] PHP/MySQL & Control Structures -> if (mysql_query())

2001-03-20 Thread Mike Gifford
Hello, I'd like the presense or absense of information within a database to be involved in an if statement, however I'm having trouble getting it to work. I've set up the following: $same_Email_query = mysql_query("SELECT Email FROM phPetition WHERE Email='" . $Email . "'"); if($same_Email_que