If in query

[techker]

hey guys i want to echo a sound when there is a message in my Db with status No

i think im close..sound plays all the time..even if the message has status Yes...

 

$query = "SELECT * FROM Message WHERE `Status` = 'No'"; 
$numresults=mysql_query($query);
$row10 = mysql_fetch_assoc($numresults);
if ('Status' == 'Yes') {
    $message  = 'Pas de Message: ' . mysql_error() . "\n";
    die($message);
}
else 
{ 
    echo "<h1>1 message</h1>"; 
echo "<embed src =\"$file\" hidden=\"true\" autostart=\"true\"></embed>";
} 

[techker]

ok got it to work

 

$query = "SELECT * FROM Message WHERE `Status` = 'No'"; 
$numresults=mysql_query($query);

///results



if (!$numresults) {
    $message  = 'Pas de Message: ' . mysql_error() . "\n";
    die($message);
}
else 
{ 
while ($row = mysql_fetch_assoc($numresults)) {
echo "etudiant: ".$row['Etudiant']." du foyer ".$row['Foyer']." secondaire ".$row['Secondaire']." arrive .<br />";
echo "Notes ".$row['Notes'].".<br />";

echo "<embed src =\"$file\" hidden=\"true\" autostart=\"true\"></embed>";
} 
}

[AyKay47]

$query = "SELECT * FROM Message WHERE `Status` = 'No'"; 
$numresults=mysql_query($query);
if (mysql_num_rows($numresults) == 0) { //no results with status = no
    $message  = 'Pas de Message: ' . mysql_error() . "\n";
    die($message);
}
else //status found equal to no
{ 
    echo "<h1>1 message</h1>"; 
echo "<embed src =\"$file\" hidden=\"true\" autostart=\"true\"></embed>";
} 

[techker]

ha lol we were posting at the same time..thx