|
|
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.
Navigation:
[Reply to this message]
|