display search results Horizontally

[bickyz]

hi i have this code which displays search results vertically, how do i display results horizontally like 4 records in per row.

 

<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
?>

<php?
mysql_connect("localhost","user1","password"); 

mysql_select_db("dbimages"); 

$search=$_POST["search"];
$field=$_POST["field"];

if ($search == "")
{
echo "<p>You forgot to enter a search term";
exit;
}

$result = mysql_query("SELECT * FROM tblimg WHERE upper($field) LIKE '%$search%'");

while($r=mysql_fetch_array($result))
{	
  
   $title=$r["firstname"];
   $message=$r["surname"];
   $imgurl=$r["imgurl"];

   echo "$id <br> $title <br> $message <br> $imgurl <br>";
}
?>

[Goat]

echo "$id $title $message $imgurl ";

 

that should do it.

 

Goat

[greatstar00]

use table, and a increment counter

like

$i=1;

echo '<table>';

while($r=mysql_fetch_array($q)){

if($i==1)

echo '<tr>';

echo '<td>'."$id <br> $title <br> $message <br> $imgurl <br>".'</td>';

if($i==1)

echo '</tr>';

if($i==4)

$i=1;

else

$i++;

 

}

[bickyz]

thanks greatstar00 but the results are displayed like this:

 

A

B C D E

J

M N O P

S

U V W X

 

i.e.

for example if there are 15 results from the search they displays like this

 

first row displays 1 result

second displays 4 results

third displays 1 result

fourth displays 4 results

fifth displays 1 result

sixth displays 4 results

 

i dont why they are not displayed 4 results per row.

[jl5501]

A correction to the code you were given earler

$i=1;
echo '<table><tr>';
while($r=mysql_fetch_array($q))
{
        echo '<td>'."$id <br> $title <br> $message <br> $imgurl <br>".'</td>';
        if($i % 4 == 0)
                echo '</tr><tr>';
       $i++;
}
echo '</tr></table>';

[bickyz]

thanks jl5501 it worked perfectly and thanks to greatstar00.

[bickyz]

just a quick ques:

how do i display text "No Results Found" if search cant find anything.

 

this is my final code:

<?php
ini_set('display_errors',2);
error_reporting(E_ALL);
?>
<?php
mysql_connect("localhost","user1","password"); 
mysql_select_db("dbimages"); 

$search=$_POST["search"];
$field=$_POST["field"];

if ($search == "")
{
echo "<p>You forgot to enter a search term";
exit;
}

$result = mysql_query("SELECT * FROM tblimg WHERE upper($field) LIKE '%$search%'");

$i=1;
echo '<table><tr>';
while($r=mysql_fetch_array($result))
{
   		$title=$r["firstname"];
   		$message=$r["surname"];
   		$imgurl=$r["imgurl"];
   		$vdourl=$r["vdourl"];
   		$id=$r["id"];

        echo '<td>'."$id <br> $title <br> $message <br> $imgurl <br>".'</td>';
        if($i % 4 == 0)
                echo '</tr><tr>';
       $i++;
}
echo '</tr></table>';
?>

[jl5501]

just after you get $result

 

if(mysql_num_rows($result))
{
      $i=1;
      echo '<table><tr>';
      while($r=mysql_fetch_array($result))
      {
          ........
          ........
          existing code
      }
}
else
{
     echo 'No results found';
}

[bickyz]

thanks jl5501 for your support.

[bernardmoes]

i've got a better idea, just turn your display 90 degrees and you will see my answer