Insert Form within a table that has PHP

[phpheadaches]

The situation:

I am generating a table from MySQL to display a limited amount of info on each item from my inventory. I then want to add a button/form to each result that the client can click on to view all details. I've inserted the button where I want it, but don't think I have the php syntax around it correct. This is my first time attempting to do this.

<?php 
// Connects to your Database 
require_once('inc/dbstuff.php');
$data = mysql_query($query) 
or die(mysql_error()); 
Echo "<table border cellpadding=3>"; 

Echo "<tr>";
Echo "<th>Photo:</th>"; 
Echo "<th>Year:</th>";  

Echo "<th>Make:</th>";  

Echo "<th>Model:</th>"; 
Echo "<th>Location:</th>";  

Echo "<th>Condition:</th>";  

Echo "<th>Engine:</th>"; 
Echo "<th>Price:</th></tr>\n"; 

while($row = mysql_fetch_array( $data )) 
{ 
Echo"<td><img src=$image_dir{$row['pix']}></td>";
Echo"<td>".$row['year'] . "</td> ";
Echo"<td>".$row['make'] . "</td> ";
Echo"<td>".$row['model'] . "</td> ";
Echo"<td>".$row['location'] . "</td> ";
Echo"<td>".$row['new_pre'] . "</td> ";
Echo"<td>".$row['engine_make'] . "</td> "; 
Echo"<td>".$row['price'] . " </td> ";
Echo"<td>" <form id="search-form" form action="" method="get"><input name="boat_details" type="submit" value="Details" /></form> "</td></tr>\n";
} 
Echo "</table>"; 
?>

[halojoy]

It is not too bad.

I have changed like 3 lines.

1. $query = "SELECT ........"
   But maybe you were going to add $query later

2. First line in WHILE. With <img src=

3. Last line in WHILE. With <form and form 2 times!

   <?php
   // Connects to your Database
   require_once('inc/dbstuff.php');
   
   $query = "SELECT * FROM boats WHERE x=y";
   $data = mysql_query($query)
   or die(mysql_error());
   Echo "<table border cellpadding=3>";
   
   Echo "<tr>";
   Echo "<th>Photo:</th>";
   Echo "<th>Year:</th>";  
   
   Echo "<th>Make:</th>";  
   
   Echo "<th>Model:</th>";
   Echo "<th>Location:</th>";  
   
   Echo "<th>Condition:</th>";  
   
   Echo "<th>Engine:</th>";
   Echo "<th>Price:</th></tr>\n";
   
   while($row = mysql_fetch_array( $data ))
   {
   Echo"<td><img src='".$image_dir.$row['pix']."'></td>";
   Echo"<td>".$row['year'] . "</td> ";
   Echo"<td>".$row['make'] . "</td> ";
   Echo"<td>".$row['model'] . "</td> ";
   Echo"<td>".$row['location'] . "</td> ";
   Echo"<td>".$row['new_pre'] . "</td> ";
   Echo"<td>".$row['engine_make'] . "</td> ";
   Echo"<td>".$row['price'] . " </td> ";
   Echo"<td>".'<form id="search-form" action="" method="get">'
   		  .'<input name="boat_details" type="submit" value="Details" />'
   		  ."</form></td></tr>\n";
   }
   Echo "</table>";
   ?> 

[perpetualshaun]

Also a small issue with the opening <tr> tag within the while loop, but that's really more of a validation issue - it may appear just fine in your browser.

--
Shaun Worcester | senior webologist

design chemistry, llc | next generation web site design
p. 800 640 0424 x 105 | http://www.designchemistry.com/

Are we connected on LinkedIn? http://www.linkedin.com/in/shaunwo
Follow us on Twitter @daytonwebdesign