show query

rakuci

I need help with this code
I have a search form with this code
<table>
<tr>
<?
$sql = "SELECT * FROM blah WHERE keywoord LIKE '%$keywoord%' '";

$result = mysql_query($sql);

if (!mysql_num_rows($result)==0){
while($row = mysql_fetch_array($result)){

 $id    	       = $row["id"];
 $photo       = $row["photo"];

?>
<img src="../img/<?=$photo?>" width="150" height="200">
</td>
</tr>
</table>
</td>

<?
}

 } else { echo("There are no images");

}
?>
I want the result to be shown in one row with 4 columns and then again new row with 4 columns(not more then 4 columns)
How can achieve this ?
Thanx

kevinsequeira

this will give you an idea of how to proceed

http://www.phpbuilder.com/board/showthread.php?threadid=10238651

instead of $count%3 use $count%4

reg
kevin

dalecosp

Hmm, a kludge comes to mind. Set up an array of the multiples of four. Write a for or while loop that echos your info with "<td>$info</td>" and use in_array() to check if your for() value in a multiple of four. If it is, echo "</tr><tr>"...

Isn't that horrible? Surely someone can do better 😃

dalecosp

Originally posted by kevinsequeira
this will give you an idea of how to proceed

http://www.phpbuilder.com/board/showthread.php?threadid=10238651

instead of $count%3 use $count%4

reg
kevin

Doh, yes!!!!!

But wouldn't he want $count%4==0 ?

stolzyboy

just FYI, dalecosp, he is setting it == 0 further down in the code, there are two sections, checking if it is == 1, and checking to see if it is == 0, the two sections obviously do two separate things

rakuci

Thanx Kevin I't works how you sad $count%3 use $count%4

Cheers