Posted by Matthew Weier O'Phinney on 05/05/05 20:57

* Anasta <neretlis@westnet.com.au>:
> 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) {

What are you comparing? is seatnum a constant? is seat1 a constant? or
is one of these a variable? is one a string?

I'm suspecting that what you're trying to compare is more like this:

if ($seatnum == 'seat1') {

but I don't know for sure if you've defined a $seatnum variable
previously.

--
Matthew Weier O'Phinney | WEBSITES:
Webmaster and IT Specialist | http://www.garden.org
National Gardening Association | http://www.kidsgardening.com
802-863-5251 x156 | http://nationalgardenmonth.org
mailto:matthew@garden.org | http://vermontbotanical.org

[Back to original message]