How do I get MySQL Query results into the right spot on the web page?

[vb_guru]

Originally Posted by Colin F

You'll have to add the php code to the php file and have it call a template in the loop, which saves (.=) the data in a variable.

Then, call the variable in the template.

Hi Colin,

Thanks for the repsonse. I have been working on your idea and have had some success. I have created a new template and cleaned up the code a little. I am able to get one row of data to be returned but it doesn't seem to be looping thru the record set here is my code in the .php file below:

if ($_REQUEST['do'] == '')
{

	$tripsresult = $DB_site->query("
		Select * from custom_trips
                WHERE userid = $bbuserinfo[userid]
	");

// Display the text of each trip

echo'<table border=1 width="100%">
 <tr>
  <td>Edit</td>
  <td>Delete</td>
  <td>Name</td>
  <td>Origination</td>
  <td>Destination</td>
  <td>Departure</td>
  <td>Return</td>
  <td>Planning</td>
  <td>Details</td>
 </tr>';

while ($row = mysql_fetch_array($tripsresult)) {
$tripid = $row['tripid'];
$tripname = $row['tripname'];
$destination = $row['destination1'];
$origination = $row['origination'];
$datedepart = $row['datedepart'];
$datereturn = $row['datereturn'];
$planning = $row['planning'];
$tripdetails = $row['tripdetails'];
echo '<tr>';
echo '<td>Edit Here</td>';
echo '<td>';
echo '<form action=./trip_planner_functions.php>';
echo '<input type="hidden" name="do" value="deletetripreport">';
echo '<input type="hidden" name="whatnow" value="deletetripreport">';
echo '<input type="hidden" name="tripid" value=' . $tripid .'>';
echo '<input type="submit" value="Delete">';
echo '</form>';
echo '</td>';
echo '<td>' . $tripname .'</td>';
echo '<td>' . $origination .'</td>';
echo '<td>' . $destination .'</td>';
echo '<td>' . $datedepart .'</td>';
echo '<td>' . $datereturn .'</td>';
echo '<td>' . $planning .'</td>';
echo '<td>' . $tripdetails .'</td>';
echo '</tr>';

}
echo '</table>';
eval('$tripsshowme .= "' . fetch_template('LIST_TRIPS') . '";');
}

Here is my LIST_TRIPS template:

$tripsshowme
<table border=1 width="100%">
 <tr>
  <td>Edit LT</td>
  <td>Delete</td>
  <td>Name</td>
  <td>Origination</td>
  <td>Destination</td>
  <td>Departure</td>
  <td>Return</td>
  <td>Planning</td>
  <td>Details</td>
 </tr>
<tr>
<td>edit on LIST_TRIPS</td>
<td>
<form action=./trip_planner_functions.php>
<input type="hidden" name="do" value="deletetripreport">
<input type="hidden" name="whatnow" value="deletetripreport">
<input type="hidden" name="tripid" value=$tripid >
<input type="submit" value="Delete">
</form>
</td>
<td>$tripname</td>
<td>$origination</td>
<td>$destination</td>
<td>$datedepart</td>
<td>$datereturn</td>
<td>$planning</td>
<td>$tripdetails</td>
</tr>
</table>

Any ideas on what I am doing wrong. I can get the complete record set to be display with all the rows as long as I run the code in the .php file but I return only one row of data when I am using the templates. Any help would be much appreciated.