Help !

[abo2512]

How do i get 3 different values from one mysql record into 3 different columns <td></td><td></td><td></td> so it will be listed nicely and seperated.

i would like it to be listed like this as in a ordinary table. Can i do that from one record.

<tr><td>New York</td><td>London</td><td>Copenhagen</td></tr>
<tr><td>if ($a==1) { echo ""; }</td><td>if ($a==2) { echo ""; }</td><td>if ($a==3) { echo ""; }</td></tr>

while ($cat = mysql_fetch_array($cats)) {

$sta = array($cat['sta']);

foreach ( $sta as $a ) {

if ( $a == 1 ) {

echo("New York: <input type='checkbox' name='cats[]' value='$cid' />&nbsp;$cname<br />\n"); 

}

if ( $a == 2 ) {

echo("London: <input type='checkbox' name='cats[]' value='$cid' />&nbsp;$cname<br />\n"); 

}


if ( $a == 3 ) {

echo("Copenhagen: <input type='checkbox' name='cats[]' value='$cid' />&nbsp;$cname<br />\n"); 

}

} 

[rfl]

the code i posted next door http://www.sitepointforums.com/showt...hreadid=115830 was suposed to do so...

[abo2512]

That dosn´t help me with my problem ?

[PHP John]

What are your field names?

Let's say your fields are "fldOne, fldTwo, and fldThree":

while($cat = mysql_fetch_array($cats))
{
  echo '<input type="checkbox" name="cats[]" value="'.$cat['fldTwo'].'" />&nbsp;'.$cat['fldThree'].'&nbsp;';
  $rowCount++;
  if($rowCount == 3)
  {
    echo '<br />';
    $rowCount = 0;
  }
} 

This will take each row of retrieved info and display it in three columns.