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.

Do you ever have those days where you REALLY wish that you had just quietly
muddled along and not asked a blatantly stupid question???

After lots of thumping my head on the wall I realised that I was only
processing two rows hence the two results.

Will somebody please quietly take me out the back and put me out of my
misery now?

--
Yours Sincerely
Kye