[RESOLVED] display items in a sql database on a wepage

[funnylookin]

on this website people are able to select their favorite foods using checkboxes. the checkboxes are entered into the database as bools. for example, a row may be called "Steak" and it would have the value "0" if the user did not check it and "1" if it did.

what i want to do is display to the user on the home page of the website what they have already selected.

here is the code i have created, but it doesn't work. can anybody point me in the right direction? thanks.

<div align="center">
        <table border="1">
            <tr>
                <th>Food</th>
            </tr>
            <tr>
    <th>
    <? $result = mysql_query("SELECT 'Steak' FROM foods WHERE
    uid=".$_SESSION["uid"]);

$row = mysql_fetch_array($result);

if($row == 1)
{
    print("Steak");
}
?>
</th>

[benracer]

Are you using session_start(); at the very top of the page?

[funnylookin]

yes

[bradgrafelman]

funnylookin wrote:

a row may be called "Steak"

What do you mean by this? Rows aren't "called" anything.

With your query, you're simply selecting the string "Steak" for every row where uid is equal to the user's id. I don't quite understand what you're after, but your query doesn't make sense nonetheless.

Showing us your table structure might help. Are you saying that you have columns for each type of food, and that their value contains the user's choice? If so, your problem lies in your database design! Normalize your database first... I would think you'd only need two columns in this table; foodName and uid.