Hello
i am having quite some trouble showing sql results in a table
using php
what i would like to happen is to show the results in a table with 3 coloms and 4 lines with a different result in each case
but all it does is show 3 coloms and 4 lines with the 3 same results in each line
could someone help me???
please, this is urgent!!
here is a piece of the script where the changes need to be made
THANK YOU VERY MUCH IN ADVANCE!!!!
<table border=0 align="center" cellpadding=2 bgcolor="#003E5B" bordercolor="#1EBBFE">
<?
$sql_r = "SELECT FROM $table WHERE rubrik='$rubrik'";
$sql_r .= " ORDER by id, ID LIMIT ".($page12).",12";
$result = mysql_db_query("$bdd",$sql_r);
while ($val = mysql_fetch_array($result)){
$rubrik = $val["rubrik"];
$id = $val["id"];
print ("<tr>");
print ("<td><a href='tofs.php3?id=$id&rubrik=$rubrik&page=$page'>");
echo ("<img src='http://spg.dhs.org/$rubrik/index/$id.jpg' border='0'>");
print ("</a></td>");
print ("<td><a href='tofs.php3?id=$id&rubrik=$rubrik&page=$page'>");
echo ("<img src='http://spg.dhs.org/$rubrik/index/$id.jpg' border='0'>");
print ("</a></td>");
print ("<td><a href='tofs.php3?id=$id&rubrik=$rubrik&page=$page'>");
echo ("<img src='http://spg.dhs.org/$rubrik/index/$id.jpg' border='0'>");
print ("</a></td>");
print ("</tr>");
}
?>