[SOLVED] Products in list to start on new line

[mikebyrne]

At present my products are listed one after the other with the code below. How can I make sure the next product starts on a new line??

 

The last vaible to be displayed for each product is Price

 

 

<?php

if (isset($_POST['searchme'])) {

include("adminconnect.php");

$tbl_name = "product";

$cat = mysql_real_escape_string($_POST['cat']);
$input =mysql_real_escape_string($_POST['searchfield']);

$query = "SELECT * FROM product WHERE Producttype = '$cat' AND Productname LIKE '%$input%'";

$result = mysql_query($query) or die ("error in the query" . mysql_error());
  if (mysql_num_rows($result) > 0) {
    while($row = mysql_fetch_array($result)) {
    echo "Title <a href=\"product.php?id=".$row['ProductNo']."\">".$row['ProductName']."\n<br> Price ".$row['Price']."";
    }
  } else {
  echo "No search results found";
  }
} else {
    echo "No search terms entered.";
}

?>    

[p2grace]

You'd have to create a counter, and then based off that counter have it create specific divs (or tables) to create new rows.

[Zhadus]

If I understand correctly, you could just add another

<br>

after the Price statement. Otherwise organize it all into a table and echo each bit of data into it's own row.

[mikebyrne]

Thanks

 

<br><br> sloved my problem