Menu
Community /Pin to ProfileBookmark
@NogDogSep 23.2004 — #@NogDogSep 23.2004 — #
I was essentially just taking the original poster's code and showing where the mistake was: reading the result of the mysql_query instead of reading the actual value returned by the count(*) in the query itself. Your method will return the same value, and if it's easier for you to read, I have no problem with that. However, I would think that if you were dealing with a database table with several thousand rows and many columns, using a count(*) query would likely be more efficient in terms of response time and memory usage (all the count(*) query has to return is one row with 1 column, instead of every row with every column). But as the Perl users like to say, "TIMTOWTDI" (there is more than on way to do it).@NogDogSep 23.2004 — #
But, if there are 50,000 rows in table "tablenme", you would still be returning all 50,000 1-column result rows to PHP for the $count variable to point to, instead of one 1-column row with a count(*) query. Again, not a big deal 99.9% of the time for most of us, I expect; but if you are working with a very large database it might be a concern. Of course, with the powerful computers we have today and cheap memory, we seldom have to worry too much about such things - at least until they gang up on us when we least expect it and bite us in the butt. ?@NogDogSep 23.2004 — #Awww... come on, argue with me! ?
Anyway, I thought I was just discussing it. Not being much more than a PHP hack (like I am with most things), I was just expressing my doubts (and I guess hoping someone would confirm them or show me the errors in my thinking).
Nah, that's not really it. I was just finding something to do other than concentrate on the boring work I should be concentrating on. :rolleyes:
How To Count All Records..
I HAVE A PHP SCRIPT THAT COUNTS ALL RECORDS IN MY TABLE..I CANT GET IT TO WORK…I KNOW IT MIGHT BE SIMPLE BUT IM LOST..HERE IS THE SCRIPT
[PHP
//DATABASE CONNECTION STUF
$connect=mysql_connect ($mysql_server, $mysql_user, $mysql_password) or die(“cannot make connection”);
$dbselect=mysql_select_db (showcase) or die(“cannot select database”);
$count = mysql_query(“SELECT COUNT(*) FROM `gd-gallery
//$row=mysql_fetch_row($count);
echo $count;
//select count(
?>
[/code]
THIS RETURNS ‘Resource id #2’ ON THE BROWSER…URRR.
Sign in
to post a comment10 Comments(s) ↴
0
@NogDogSep 23.2004 — #[code=php]
$result = mysql_query("SELECT COUNT(*) FROM gd-gallery");
if($result)
{
$row = mysql_fetch_row($result);
echo "<p>Count = $row[0]</p>n";
}
else
{
echo "<p>Query failed.</p>n";
}
[/code]0
@NogDogSep 23.2004 — #[i]Originally posted by Hellspire [/i]
[B]*shrugs* to each his own method..... I hardly use plain sql I have it classed (by myself) so I can do pretty much anything in different ways/... but the original way (i have shown it above) IS SOOOOOO MUCH SIMPLER
E; Dont forget to read my former post, why your code could be flawed (first comment) [/B][/QUOTE]
I was essentially just taking the original poster's code and showing where the mistake was: reading the result of the mysql_query instead of reading the actual value returned by the count(*) in the query itself. Your method will return the same value, and if it's easier for you to read, I have no problem with that. However, I would think that if you were dealing with a database table with several thousand rows and many columns, using a count(*) query would likely be more efficient in terms of response time and memory usage (all the count(*) query has to return is one row with 1 column, instead of every row with every column). But as the Perl users like to say, "TIMTOWTDI" (there is more than on way to do it).
0
@NogDogSep 23.2004 — #[i]Originally posted by pyro [/i]
[B]Also, just to point out...
If you are simply trying to return the number of rows, there is no reason to select everything (SELECT *) or to order it in any way (ORDER BY date ASC). Using the method that Hellspire posted, I'd think this would be a bit more efficient:
[code=php]$query = "SELECT[/B][/QUOTE]column_nameFROMtablename;";
$count = mysql_num_rows(mysql_query($query));
echo $count;[/code]
But, if there are 50,000 rows in table "tablenme", you would still be returning all 50,000 1-column result rows to PHP for the $count variable to point to, instead of one 1-column row with a count(*) query. Again, not a big deal 99.9% of the time for most of us, I expect; but if you are working with a very large database it might be a concern. Of course, with the powerful computers we have today and cheap memory, we seldom have to worry too much about such things - at least until they gang up on us when we least expect it and bite us in the butt. ?
0
@NogDogSep 23.2004 — #Awww... come on, argue with me! ?Anyway, I thought I was just discussing it. Not being much more than a PHP hack (like I am with most things), I was just expressing my doubts (and I guess hoping someone would confirm them or show me the errors in my thinking).
Nah, that's not really it. I was just finding something to do other than concentrate on the boring work I should be concentrating on. :rolleyes: