Page 1 of 1

Can anyone help with this query?

Posted: Sun May 21, 2006 8:14 am
by ianhull
Hi guys,

I am having trouble with this count query.

I have never worked with the count beofre and all I get returned is "Array".

Please help.

Code: Select all

<?php session_start();

$coursetitle = $_GET['coursetitle'];
$username = $_SESSION['username'];

include_once("includes/connect.php");
$sql = "SELECT COUNT(*) FROM course_content WHERE coursetitle='$coursetitle'"; 
$numrecords = mysql_query($sql) or die("Select Failed!");
$counter = mysql_fetch_array($numrecords);
?>
<?php echo $counter?>

Posted: Sun May 21, 2006 8:41 am
by shiznatix
not positive but try using mysql_num_rows()

Posted: Sun May 21, 2006 8:44 am
by s.dot

Code: Select all

$sql = "SELECT COUNT(*) FROM course_content WHERE coursetitle='$coursetitle'"; 
$numrecords = mysql_query($sql) or die("Select Failed!");
$count = mysql_result($numrecords,0);
or

Code: Select all

$sql = "SELECT COUNT(*) AS count FROM course_content WHERE coursetitle='$coursetitle'"; 
$numrecords = mysql_query($sql) or die("Select Failed!");
$counter = mysql_fetch_array($numrecords);
echo $counter['count'];