"\n" In Sql Results?

[wright67uk]

The below query returns the correct dataset but without carriage returns, have I used "\n" correctly?

 

$tbl_name = "snag_score";


$result = mysql_query("SELECT * FROM $tbl_name");


while($row = mysql_fetch_array($result)) {   
echo $row['user_id'] . "\t" . $row['total_score']. "\n"; } 
?>

[requinix]

You won't see them in HTML because whitespace, like tabs and newlines, are collapsed into single spaces. Most of the time.

 

Use a
instead, or even better put the content into an appropriate structure (table, span, div, or whatever) and style that as you want.

Edited December 7, 2012 by requinix

[wright67uk]

Thankyou.