GoFuckYourself.com - Adult Webmaster Forum - View Single Post - php/mysql question, counting number of * results if something = something

quantum-x · 01-17-2010, 07:37 PM

Please read the PHP / mysql manual.

PHP Code:


			
<?php
$sql = "SELECT COUNT(*) as `count` FROM `john` WHERE `status` = 1";
$result = mysql_query($sql);

list($count) = mysql_fetch_row($result);

echo $count;
?>

01-17-2010, 07:37 PM
quantum-x Confirmed User Join Date: Feb 2002 Location: ICQ: 251425 Fr/Au/Ca Posts: 6,863	Please read the PHP / mysql manual. PHP Code: <?php $sql = "SELECT COUNT() as `count` FROM `john` WHERE `status` = 1"; $result = mysql_query($sql); list($count) = mysql_fetch_row($result); echo $count; ?> __________________ PrettyInCash.com* - BoozedGFs.com - TeenGFs.com - JizzGFs.com- MilfUploads.com -