Posted by Rasmus Lerdorf on 05/05/05 20:57

Anasta wrote:
> 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';
> }
> ?>

That doesn't even look like PHP code. In PHP variables have $ in front
of them, and you are only sending a query, you aren't assignining
anything to the variables. And further, your actual SQL query is
already applying that restriction, so any usernames returned by the
query will by definition have their seatnums be set to 'seat1' in the
database.

-Rasmus

[Back to original message]