|
Posted by Philip Hallstrom on 05/05/05 20:34
> What am i doing wrong here, the output is always 'empty'
>
> <?php
> $result = mysql_query("SELECT username FROM users
> WHERE seatnum='seat1'") or die(mysql_error());
>
> if (seatnum == seat1) {
> echo username;
> } else {
> echo 'empty';
> }
> ?>
Just guessing since I'm not sure what you're trying to do, but...
<?php
$result = mysql_query("SELECT username FROM users WHERE seatnum='seat1'")
or die(mysql_error());
list($username) = mysql_fetch_array($result, MYSQL_NUM);
if ($seatnum == "seat1") {
echo $username;
}else {
echo 'empty';
}
?>
What I'm not seeing is where you set $seatnum in the first place and why
you're doing the if/else at all since your mysql query will only return a
username *if* seatnum='seat1' already so the above code I'm guessing will
always print out $username (or blank if the query returns no results).
Anyway, the above should get you going in the right direction...
-philip
[Back to original message]
|