Posted by Kye on 10/10/07 14:20

Please be gentle with me here, but can anybody please suggest to me why it
would be that the below code displays only the link_name and link_url fields
despite the SQL returning all of the desired fields in MySQL???

------START CODE------

mysql_select_db (biodexc_links);

$sol = 'SELECT link_name, link_url, links.description, rating FROM links,
category, rating, logo WHERE links.fk_category = category.id AND
links.fk_rating = rating.id LIMIT 0, 30 ;';

$result = @mysql_query ($sol);

if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_NUM)){
echo "<tr><td>
$row[0]</td></tr>
$row[1]</td></tr>\n";}
mysql_free_result($result);
} else {
echo 'failure';
}

mysql_close();

------END CODE------

Kye.

[Back to original message]