MySql dumb question (maybe) :) - GoFuckYourself.com

MichaelP · 06-19-2004, 02:23 PM

Is there a simple way to show how many entries from a database ?

like " select * FROM thistable limit= total,1..." well you get the idea

Thnaks in advance

AndrewKanuck · 06-19-2004, 02:24 PM

How about using count?

lilj · 06-19-2004, 02:25 PM

Quote:

Originally posted by egonetworks
How about using count?

AndrewKanuck · 06-19-2004, 02:25 PM

that's:

select count(*) from table

just incase you've never used it before

cjnet · 06-19-2004, 02:28 PM

not really i don't think..

in php the easiest way would be:

$query = "SELECT * FROM TABLE"
$result = mysql_query($query) or die("Failed to Get Crap");
$count = mysql_num_rows($result);

i'm pretty sure.. if that helps =O

MichaelP · 06-19-2004, 03:09 PM

Quote:

Originally posted by cjnet
not really i don't think..

in php the easiest way would be:

$query = "SELECT * FROM TABLE"
$result = mysql_query($query) or die("Failed to Get Crap");
$count = mysql_num_rows($result);

i'm pretty sure.. if that helps =O

Thank you but i tried it and it doesn,t work... Maybe if I can just show the highest ID from the db it would be ok too

JSA Matt · 06-19-2004, 03:13 PM

Quote:

Originally posted by egonetworks
select count(*) from table

if that's not the answer, we don't understand the question

MichaelP · 06-19-2004, 03:16 PM

Quote:

Originally posted by JSA Matt
if that's not the answer, we don't understand the question

Ho you REALLY WELL understood it, it is just that I tried this nad it didn,t work.. Sorry guy I am not very used with MySql queries yet

include_once("sql_include.php"); /= this is where i connect to DB

$sql = "SELECT count(*) FROM tblEntries";
$result = SQL_Query($sql);

echo $result ;

I know I am not that far but not there yet

JSA Matt · 06-19-2004, 03:29 PM

Code:

$query = mysql_query("SELECT COUNT(*) FROM table")or die(mysql_error());
    list($rows) = mysql_fetch_row($query);

echo $rows;

MichaelP · 06-20-2004, 07:21 AM

Ok got it

include_once("sql_include.php");
$sql = "SELECT * FROM thistable ORDER BY id DESC LIMIT 0 , 1";
$result = SQL_Query($sql);
while($row = mysql_fetch_array($result["ResultSet"]))
{
print "" . $row["id"] . "" ;
}

Thanks to all for your help. it is very appreciated

s9ann0 · 06-20-2004, 07:23 AM

whats wrong with

select count(*) from table

?

Ash@phpFX · 06-20-2004, 07:42 AM

using count() is the most efficient way

WombRaider · 06-20-2004, 08:17 AM

Here's another way that's worked for me:

$query = mysql_query("SELECT * FROM tableName");
$qty = mysql_num_rows($query);
echo $qty;

Hope that helps.

06-19-2004, 02:23 PM	#1
MichaelP Registered User Industry Role: Join Date: Aug 2003 Location: QWEBEC Corporate Office Posts: 7,124	MySql dumb question (maybe) :) Is there a simple way to show how many entries from a database ? like " select * FROM thistable limit= total,1..." well you get the idea Thnaks in advance

06-19-2004, 02:24 PM	#2
AndrewKanuck Confirmed User Join Date: Jan 2004 Location: Cleveland & Atlanta Posts: 6,706	How about using count? __________________

06-19-2004, 02:25 PM	#4
AndrewKanuck Confirmed User Join Date: Jan 2004 Location: Cleveland & Atlanta Posts: 6,706	that's: select count(*) from table just incase you've never used it before __________________

06-19-2004, 03:29 PM	#9
JSA Matt So Fucking Banned Join Date: Aug 2003 Location: San Diego, CA Posts: 5,464	Code: $query = mysql_query("SELECT COUNT(*) FROM table")or die(mysql_error()); list($rows) = mysql_fetch_row($query); echo $rows;

06-20-2004, 08:17 AM	#13
WombRaider Confirmed User Join Date: Sep 2002 Location: FL Posts: 159	Here's another way that's worked for me: $query = mysql_query("SELECT * FROM tableName"); $qty = mysql_num_rows($query); echo $qty; Hope that helps. __________________ Fred, I think I fried the motherboard.........and the fatherboard, too.

06-19-2004, 02:28 PM	#5
cjnet Registered User Join Date: Mar 2004 Location: i like to make money i like to make money i like to make money i like to make money i like to make money i like to make money i like to make money i like to make money i like to make money i like to make money i like to make money :) Posts: 281	not really i don't think.. in php the easiest way would be: $query = "SELECT * FROM TABLE" $result = mysql_query($query) or die("Failed to Get Crap"); $count = mysql_num_rows($result); i'm pretty sure.. if that helps =O

06-20-2004, 07:21 AM	#10
MichaelP Registered User Industry Role: Join Date: Aug 2003 Location: QWEBEC Corporate Office Posts: 7,124	Ok got it include_once("sql_include.php"); $sql = "SELECT * FROM thistable ORDER BY id DESC LIMIT 0 , 1"; $result = SQL_Query($sql); while($row = mysql_fetch_array($result["ResultSet"])) { print "" . $row["id"] . "" ; } Thanks to all for your help. it is very appreciated

06-20-2004, 07:23 AM	#11
s9ann0 Confirmed User Join Date: Sep 2001 Location: Boston Posts: 4,873	whats wrong with select count(*) from table ?

06-20-2004, 07:42 AM	#12
Ash@phpFX Confirmed User Join Date: Nov 2003 Posts: 4,292	using count() is the most efficient way