Mysql_fetch_array problem...

[Hall of Famer]

Well I am retrieving database properties from two tables(items and inventory), but I do not know how to do this easily so I tried the method below, in which I use mysql_fetch_array($result) for properties of table prefix_inventory and mysql_fetch_array($result2) for properties of table prefix_items. It does not work at all though, only the first mysql_fetch_array works, the second one will not retrieve any database information for me. What have I done wrong, is there a way to fix this?

 

$result = mysql_query("SELECT * FROM {$prefix}inventory WHERE owner ='{$loggedinname}'");
    
while($row = mysql_fetch_array($result)){
// First we need to retrieve item properties.
$result2 = mysql_query("SELECT * FROM {$prefix}items WHERE itemname ='{$row['itemname']}'");
$items = mysql_fetch_array($result2);
$article_content .= "<tr>
                      <td><img src='{$items['imageurl']}'></td>
					  <td>{$row['category']}</td>
					  <td>{$row['itemname']}</td>
					  <td>{$items['description']}</td>
					  <td>{$row['quantity']}</td>";
                                                  // There are still lines below, but wont make a difference even if I post them

 

[Drummin]

Try

WHERE itemname ='{$row[itemname]}'

[voip03]

$result2 = mysql_query("SELECT * FROM {$prefix}items WHERE itemname ='{$row['itemname']}'");

why curly bracket ?

[Drummin]

I don't use them as posted but some coders do.  Just sticking with the format he posted.

[voip03]

I thought new php syntax to put '{'

 

Hall of Famer  remove the {} and try

[PFMaBiSmAd]

The {} are needed around associative array variables inside of strings so that you can keep the quotes around the associative key name without breaking the string syntax. You can also use them around any php variable inside of a string for those cases where you need to tell php where variables start and end. See the Complex (curly) syntax section at this link - http://cn.php.net/manual/en/language.types.string.php