[SOLVED] Getting the number of entries in a table, reading it's index ?!

[shlomikalfa]

hello, i've been wandering if there's a way to read the index of a table in a sort and easy command instead of using this:

$sql = "SELECT ID FROM `downloads` WHERE 1";
$result = mysql_query($sql, $link);
	if (!$result) {
		echo "Error: could not query the database";
		echo 'MySQL Error: ' . mysql_error();
		exit;
	}
$rownum = mysql_num_rows($result);

PS, ID - is an indexed collumn which is auto-incremented.

 

Thanks in advance!!!

[teng84]

$sql = "SELECT count(ID) as my_id FROM `downloads`;

$result = mysql_fetch_assoc(mysql_query($sql, $link));

 

echo $result['my_id'];

 

hmm is that what you mean?

[shlomikalfa]

that does the trick, but so does mine...

- isn't there a way to access and read the last index directly ?

[teng84]

echo mysql_insert_id();<-- returns the last id  try

[Barand]

mysql_insert_id() returns the id of the last record inserted during the current connection. If you haven't inserted a new record since you last connected to the server it will return 0.