for() while() I AM LOST in TABLES

Kudose

Thanks to everyone that has helped me in the past. I really appreciate it. But I have one more issue at hand. PLease go here http://www.blvdcars.com/showcars.php?kind=Car

See the huge row of the same car?

Thats my issue. Here is my code, I need it to go from that to how ever many rows it takes to display by 3 columns (across). Thanks!

<?
include('top.php'); 
include('left.php');
include('dbinfo.inc.php'); 
?>  <td width="81%"><table><tr> <?

$kind = $HTTP_GET_VARS['kind'];
$dir = "/home/zayyscec/www/$kind/"; 
$fd = opendir($dir); 
$cnt = 3;
$num = 0;
while($cnt!=$num){
while (False !== ($image=readdir($fd))){

$query = mysql_query("SELECT * FROM auto WHERE kind='$kind'") or die(mysql_error());
$url = mysql_fetch_assoc($query) or die(mysql_error());
$link = $url['stockid'];
$year = $url['year'];
$make = $url['make'];
$model = $url['model'];
echo "<td><a href='show.php?stockid=$link'><img src='$image' width='250' height='100' /><br> $year $make $model </a><td>"; 

}$num++;}

?>

</tr></table>
   </td>

<? include('bottom.php'); ?>

batman

I dont see any cars this is what i get:

Sorry 137.91.114.239 your lost.
Please go here.

/showcar.php?kind=Car does not exsist on www.blvdcars.com

One thing I dont get is, if your trying to get the info out of the database, then why are you even doing the directory. Explain what your trying to accomplish with this lillte bit:

$dir = "/home/zayyscec/www/$kind/";  

$fd = opendir($dir);  

$cnt = 3; 
$num = 0; 
while($cnt!=$num){ 
while (False !== ($image=readdir($fd))){

Kudose

I was telling it what directory to pulls the images from. I fixed the link.

batman

You could try something more along these lines. In your database give each picture a URL field, and type in the coresponding URL for the image into that field.

 <? 
include('top.php');  

include('left.php'); 
include('dbinfo.inc.php');  

?>  <td width="81%"><table><tr> <? 

$kind = $_GET['kind']; 


$query = mysql_query("SELECT * FROM auto WHERE kind='$kind'") or die(mysql_error()); 
$url = mysql_fetch_array($query) or die(mysql_error());
$image = $url['URL']; 
$link = $url['stockid']; 
$year = $url['year']; 
$make = $url['make']; 
$model = $url['model']; 
echo "<td><a href='show.php?stockid=$link'><img src='$image' width='250' height='100' /><br> $year $make $model </a><td>";  


?> 

</tr></table> 
   </td> 

<? include('bottom.php'); ?>

If you still have problems let me know,