PHP & MySQL - LEFT JOIN issue

[nerdpowah23]

So I have a user_items table that has:
userid (So it keeps track of who has the item)
item_id

However, I also have an items table that has:
item_id
item_name
item_description
item_type
item_desc
item_cost
item_sell_value

<?php require("styles/top.php"); ?>

<?php
if(isLoggedin($valid)){
?>
<center><h1>Your Items</h1></center>
<?php
$query = mysql_query("SELECT items.item_id FROM items LEFT JOIN user_items ON
items.item_id=user_items.item_id WHERE user_items.userid='$userid'");
$numrows = mysql_num_rows($query);
if($numrows > 0){
while($row = mysql_fetch_assoc($query)){
$name = $row['item_name'];
echo "you have a $name";
}
} else {
echo"You have no items.";
}

?>


<?php
} else {
?>


<?php
}
?>When I try to echo out the name, it doesnt echo anything. Any ideas?

 

[descalzo]

At a quick glance:

SELECT items.item_id

only asks for the item_id. It doesn't return the item_name.

 

[nerdpowah23]

That seems to work now, sorry I'm just trying to get this join stuff, I'm over-thinking everything.

 

[misson]

Did you color the sample code by hand? You don't need to do this; just use

, [html], [code] or [c] (for inline code) tags as appropriate, which will also preserve formatting and better delineate the code.