Can anyone help, I have the following else if statement and it is only showing one record?
else if ($trailers) {
$result = mysql_query("SELECT * FROM vmplay WHERE special = 'trailers' ",$db);
$myrow = mysql_fetch_array($result);
printf("<table width=\"461\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#CCCCCC\">
<!--DWLayoutTable-->
<tr>
<td height=\"1\" colspan=\"3\" valign=\"top\" bgcolor=\"#CC3300\"><img src=\"assests/gfx/spacergif.gif\" width=\"1\" height=\"1\"></td>
</tr>
<tr>", $myrow["null"]);
printf("<td width=\"173\" height=\"161\" valign=\"top\"> <img src=getdata.php?id=%s\n border=0 width=186 height=161 align=center></td>", $myrow["id"]);
printf("<td width=\"14\"> </td>
<td width=\"274\" align=\"left\" valign=\"middle\">
<font color=orange face=verdana size=2><B>%s</B></font><BR><font color=black size=2 face=verdana>%s<br> <a href=http://www.vm-play.net/news?id=%s\n target=_parent>more...</a></font>
</td>
</tr>
<tr bgcolor=\"#CC3300\">
<td height=\"1\" colspan=\"3\" valign=\"top\"><img src=\"assests/gfx/spacergif.gif\ width=\"1\" height=\"1\"></td>
</tr>
</table>
<BR>", $myrow["headline"], $myrow["shortnews"], $myrow["id"]);
}
Hope someone can help me
