Glossary - First Glitch
am 10.10.2007 16:20:03 von KyePlease 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 "
$row[0]
$row[1]\n";}
mysql_free_result($result);
} else {
echo 'failure';
}
mysql_close();
------END CODE------
Kye.