SELECT COUNT (*)

[tomfmason]

This should be a rather simple fix. I am trying to put the number of matches from a search into a variable
like this


[code=php:0]<?php
include('db.php');
$sql= sprintf("SELECT COUNT(*) AS message_check FROM `messages` WHERE `status` ='new'");
$res= mysql_query($sql) or die(mysql_error());
$message_check= mysql_result($res, 0, 'message_check');

if ( $message_check == 0 ) {
    $text ='You have no new messages';
}elseif ( $message_check == 1) {
      $text ='You have <b>1</b> new message';
}else{
      $text ='You have <b>$message_check</b> new messages';    
}     
?>[/code]



The only problem is, in the html, it just displays the $text like this: You have [b]$message_check[/b] messages. I am using this in the html [code=php:0]<p><?php echo $text; ?></p>[/code] to display $text.

Any suggestions on how to accomplish this would be great.

[OOP]

Hi there;

use double quotes instead of the single quotes that your are currently using. It should look like:
[code]$text ="You have <b>$message_check</b> new messages";[/code]

[brown2005]

yeah $text = "You have <b>$message_check</b> new messages";