mmm something i need to know

[Anon]

Hi all again =),
I created a database and created a table in it.
LoOk At ThIs ScRiPt i did:
<?php
mysql_connect("localhost","root","");
mysql_select_db("nsplayers");
$query = "CREATE TABLE test (id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, name varchar(20), PRIMARY KEY(id), UNIQUE id(id));";
mysql_query($query);
$query1 = "INSERT INTO test VALUES (1,'Randy');";
mysql_query($query1);
$result = mysql_query("SELECT name FROM test");

?>
well my english is poor so i dunno wat to say 😛
the table i mean inside the table 'test' got 2 names and 2 IDs
i tried mysql_fetch_array
and it gives me:
Randy Tas <--- Sticked Together
but i want to display it such as it is like:
Randy
Tas <--- Not Sticked
So how do i do it?
Sorry for poor english AND
Thanks 🙂

[khaine]

try

<?

$string="Randy Tas";
$bits=explode(" ", $string);
for ( $loop=0; $loop<count($bits); $loop++ )
{
echo $bits[$loop]."\n<BR>\n";
}

?>

or

<?

$string="Randy Tas";
$string=ereg_replace(" ", "\n", $string);
echo nl2br($string);

?>

The second way is easy to write but if you want to process each part of the name the first is better.

Mark.