PHP and MySQL Data problems?

  • Thread starter Thread starter Mr E
  • Start date Start date
M

Mr E

Guest
ok so i have lots of little problems

fistly i have PHP code which creates and displays some data from a mysql database.

the problem is that it overflows from the <div> layer and creates a scroll bar rather than filling up the rest of the space, because of the fact it just puts it into either a long vertical line of data or a long horizontal line (i've tried several methods)

so the first problem is to get the data and populate a table that is 3 doors in length (the database displays pictures of doors) by however many doors it needs to display long.

secondly i need the name (the database data displays the name of the door also) and the door to be linked. with the door link to open a new window and display the large image of the door. and the name to link to a seperate <div> layer displaying the price, and also an order button and a drag down menu to select the number of doors needed.

this is the current code i've got now

// gathers the door name the final price and the thumbnail for all doors that have Arbury in their name
$result = mysql_query("SELECT DoorName, Thumbimage FROM tblpricelist WHERE DoorName like '%Arbury%'");

echo "<table border='0'>
<tr>
</tr>";while($row = mysql_fetch_array($result))
{

echo "<th>". "<img src='". $row['Thumbimage']."' />";"</th>";

echo "<th>". $row['DoorName']; "</th>";
}
echo "</table>";

?>
</div>

<div id="doorprice">
<?php
echo "Click names to see prices";
echo $_GET["name"];
?>


answers would be greately appreciated.

cheers
 
Back
Top