Re: How do I make all columns line up in the same row?

[Peter Brawley]

What are you trying to accomplish with the asterisks at the ends of column names? They'll generate syntax errors.

Before trying a query in PHP--any query--test it in the mysql client to verify that it delivers precisely what you want.

Why the quotes around PHP function calls!?

$query = mysql_query($q);
$cols = mysql_num_fields($query);
while ($row = mysql_fetch_array($query)) {
$nextline = "";
for($i = 0; $i < $cols; $i++) {
// Use .= tather than += so PHP doesn't try to add numerics
$nextline .= $row[ $i ] . ($i < $cols ? ", " : "");
}
fwrite($fp,$nextline);
}

PB