[paligron]

Hi, I am trying to create rows and columns for some data but it is misbehaving, ie, creating one row with 6 columns instead of 'n' rows with only three columns each. Any help will be greatly appreciated. Here is the code:

<? $query = "SELECT * FROM friends WHERE friendid = '".$_SESSION['user_id']."' AND allow = 1 ORDER BY first_name ASC";
$result = mysql_query($query) or die ("Query failed");

//get the number of rows in our result so we can use it in a for loop
$numrows = (mysql_num_rows ($result));

echo "<table width = 100% border = '0' cellspacing = '2' cellpadding = '0'>";

// loop to create rows
if($numrows >= 1){
for ($r = 0; $r <= $numrows; $r++) {
echo "<tr>";

// loop to create columns
while ($friendList = mysql_fetch_array($result)) {

for ($c = 0; $c <= 2; $c++) {

echo "<td><a href='memberindex.php?id = ".$friendList['id']."'><img src='".$friendList['friendImg']."' title='".$friendList['first_name']."' alt='".$friendList['first_name']."'/><br />".$friendList['first_name']."</a><br /></td> "; }}
echo "</tr> "; }}

<? echo "</table> "; ?>

[Jcbones]

PHP Code:

<?php

 $query = "SELECT * FROM friends WHERE friendid = '".$_SESSION['user_id']."' AND allow = 1 ORDER BY first_name ASC";

$result = mysql_query($query) or die ("Query failed");



echo "<table width = 100% border = '0' cellspacing = '2' cellpadding = '0'>";



// loop to create rows

if(mysql_affected_rows() > 0){

while ($friendList = mysql_fetch_array($result)) {



echo "<tr>"

. "<td><a href='memberindex.php?id = ".$friendList['id']."'><img src='".$friendList['friendImg']."' title='".$friendList['first_name']."' alt='".$friendList['first_name']."'/><br />".$friendList['first_name']."</a><br /></td> " 

. "</tr> ";

}



echo "</table> "; ?>

[paligron]

thanks a lot. I will check it out and let you know what happens.

[kodekin]

a little sloppier, but should work.

<?
$query = "SELECT * FROM friends WHERE friendid = '".$_SESSION['user_id']."' AND allow = 1 ORDER BY first_name ASC";
$result = mysql_query($query) or die ("Query failed");

//get the number of rows in our result so we can use it in a for loop
$numrows = (mysql_num_rows ($result));


// loop to create rows
if($numrows >0){
echo "<table width = 100% border = '0' cellspacing = '2' cellpadding = '0'>";
// loop to create columns
$position = 1;
while ($friendList = mysql_fetch_array($result)){
if($position == 1){echo "<tr>";}
echo " <td><a href='memberindex.php?id=".$friendList['id']."'><img src='".$friendList['friendImg']."' title='".$friendList['first_name']."' alt='".$friendList['first_name']."'/><br />".$friendList['first_name']."</a><br /></td> ";
if($position == 3){echo "</tr> "; $position = 1;}else{ $position++;}
}//while

$end = "";
if($position != 1){
for($z=(3-$position); $z>0 ; $z--){
$end .= "<td></td>";
}
$end .= "</tr>";
}

echo $end."</table> ";
}//if
?>

[paligron]

thanks a lot kodekin. I will use yours on another site as i got mine to finally work. Your assistance is much appreciated

[ShahbazAhmed]

Hi, i m begginer in php and this webiste make me a lot os help to understodo basic script, now i m making an assignment, i wat display record in 3 column and pagination also. please can anybody help me