[Irisistable]

I need to count the rows in a mysql table and to find the max value of a column. I
am selecting count and max with mysql queries, but fail getting the results from my php code. For counting the rows I also tried mysql_fetch_array and then counting the rows in the array, but it didn't work either. Does someone know how to retreive the results of count() and max() ?

------------------
Have fun (What else can you do until you die?)

[Shiju Rajan]

you can find out both the things very easily..

if you can issue a select statement like following can get you both count & max

"SELECT count(*) as cnt,max(coulmn) as max_val from tblname";

---------
then you can get the vallues printed very easily..

<?
$con=mysql_connect('localhost','username','password');
//database connectivity

mysql_select_db('databasename',$con);
//select your databasse..

$query="SELECT count(*) as cnt,max(coulmn) as max_val from tblname";


$result=mysql_query($query,$con);
//issue query..

$rows=mysql_fetch_array($result);
//total records to array..

echo "Total number of record".$rows["cnt"];
echo "Max value of column is ".$rows["max_val"];

//echo "total number of records using mysql number of rows funtion is".mysql_num_rows($result);

?>


you can get the total record using mysql_num_rows() as well..




------------------
SR -
webshiju.com
www.jobxyz.com-IT Career Portal
ezipindia.com--WebStudio


"The fear of the LORD is the beginning of knowledge..."