Problem with Count(*)

golfinggod

Im trying to count and the echo the number of rows in my mysql table based on the username. The problem is it keeps stating this error

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\phpdev\private\page\pages\account.php on line 306

The code is below, does anyone have an idea.

$Selectid2 = "SELECT Username, count(*) FROM banners WHERE Username = '$Username' GROUP BY Username"; 

      $row = mysql_fetch_row('$Selectid2'); 

	  echo  $row[0] ;

Thanks

laserlight

Firstly, you forgot to use mysql_query().
You also placed $Selectid2 in single quotes, which means that it is literally the string '$Selectid2'.

$Selectid2 = mysql_query("SELECT Username, count(*) FROM banners WHERE Username = '$Username' GROUP BY Username");
$row = mysql_fetch_row($Selectid2);
echo $row[0] ;

devinemke

you are not running the query

$Selectid2 = "SELECT Username, count(*) FROM banners WHERE Username = '$Username' GROUP BY Username";  

$result = mysql_query ($Selectid2);
$row = mysql_fetch_row ($result);
echo  $row[0];

golfinggod

Thanks Alot guys