Too many rows not enough data

[Kudose]

I appreciate any help in advance. If you would please direct one browser here.[URL=http://]www.blvdcars.com/showcars.php[/URL]

What I want it to do is to select the kind of car (i.e. $kind) from my DB and display all of them in a few rows in 4 columns.

They all need to go in sequential order by an auto_incrementing $carid variable in my DB.

Here is my code:

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

   $stock="SELECT * FROM auto ORDER BY kind LIMIT 100"; 
    $result=mysql_query($stock);
	$row = mysql_fetch_assoc($result);
	$type = $row['kind'];
	$query = mysql_query("SELECT * FROM auto WHERE kind='$type'") or die(mysql_error()); 

$stockid = $row['stockid'];
$year = $row['year'];
$make = $row['make'];
$model = $row['model'];
$color = $row['color'];
$image = $row['image'];  

	$stock="SELECT * FROM auto ORDER BY kind LIMIT 100"; 
    $num=4; 
    $i=0;
	while ($i < $num) { 
    $kind=mysql_result($result,$i,"kind");

?>

<tr>
  <td><center><a href="show.php?<?= $stockid ?>">
				  <img src="cars/<?= $image ?>" alt="<?= $image ?>" height="100" width="250" border="1">
				  <br>
				  <? print('$year $make $model'); ?></a>
				  </center></td>
				  <a href="show.php?<?= $stockid ?>">
				  <img src="cars/<?= $image ?>" alt="<?= $image ?>" height="100" width="250" border="1">
				  <br>
				  <? print('$year $make $model'); ?></a>
				  </center></td>
				  <a href="show.php?<?= $stockid ?>">
				  <img src="cars/<?= $image ?>" alt="<?= $image ?>" height="100" width="250" border="1">
				  <br>
				  <? print('$year $make $model'); ?></a>
				  </center></td>
				  <a href="show.php?<?= $stockid ?>">
				  <img src="cars/<?= $image ?>" alt="<?= $image ?>" height="100" width="250" border="1">
				  <br>
				  <? print('$year $make $model'); ?></a>
				  </center></td></tr>

   <? 
    ++$i; 
    } 
    ?>
  </table>
  </td>

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

PLEASE HELP!!!

[batman]

Well first off, its kind of weird how your doing a query based on the previous query, which still wont give any result. You need to pass the kind and carid variables to this page that way it will know what kind of car / truck the user wants to view.
Secondly, since you want to select $kind and want to order it by $carid try something like this:

$kind = $_POST['kind'];
$carid = $_POST['whatevere goes here'];

$stock=mysql_query("SELECT * FROM auto WHERE kind='$kind' ORDER BY $carid LIMIT 100");  

Then go from there.

Hope that helps,