printing from table problem

[devilinlondon]

Hello all I am trying to print from a table with the following code:
...

	$sql ="SELECT count FROM simplecount WHERE count_id=1"; 
	echo "<mysql_result( mysql_query( $sql ) , 0 )>" ; 

....

BUT This stil does not work? How comes? It just shows a blank line.

The Code above is a part of the code below as can be seen:

if (!isset($_SESSION['counted']))//checks if $session is set or not using the isset
	{   

    mysql_query("UPDATE simplecount SET count=(count + 1) WHERE count_id=1");
	//count is updated in the simplecount table   

	$_SESSION['counted'] = "";  //the session is 'set/registered so the user does not get counted again

$sql ="SELECT count FROM simplecount WHERE count_id=1"; 
echo "<mysql_result( mysql_query( $sql ) , 0 )>" ; 


}

[cafrow]

try this.

if (!$resultcount = mysql_query("SELECT `count` FROM `simplecount` WHERE `count_id`= 1")){
  echo "Error grabing Resultcount ". mysql_error();
}
else {
echo $resultcount;
}

also make sure that you have a field called count_id and that one of the count_id fields have a value of 1.

[jpmoriarty]

i'm not quite sure what you're doing with your echo. If you echo out a < then the browser will think you're starting a html tag, and so won't output it.

then, you can't put PHP code into an echo like that and get it to do anything - it'll just echo the code out, and not do anything with it. I think you want to do:

$sql ="SELECT count FROM simplecount WHERE count_id=1";  

echo "<p>".mysql_result( mysql_query( $sql ) , 0 )."</p>";