major newb question

[zuessh]

I have the following php script to full results from a mysql database. I am new to php html and the whole works. My questions is; where my echo statemensts are, how do I get them to have spaces between them. When they show the results there are no spaces. I would like for it have 10 or so spaces. Thanks in advance.

<?

$db_name = "tim";
$db_user = "testphp";
$db_pass = "test";

$address = $_POST ['address'];

$connection = mysql_connect("localhost", "$db_user", "$db_pass") or die("Couldn't");
$db = mysql_select_db($db_name, $connection) or die("Couldn't Select Database");

$query = "select * from matchbox where make like '%".$address."%'";

//echo $query;

$result = mysql_query($query, $connection)or die ("Couln't execute query.");
if (mysql_num_rows ($result) <1) {
echo "No records were found, please contact your local delivery service, and request they sign up!!";
} else {

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

    echo $row['make'];
echo $row['detail']."<BR>";
} 	

}

?>

[kevinsequeira]

<?php
.
.
.
?>
<table border="1" width="100%">
<?php
while ($row = mysql_fetch_array($result)) {
echo "<tr>";

echo "<td width=50%>".$row['make']."</td>";
echo "<td width=50%>".$row['detail']."</td>";
echo "</tr>";
}
?>
</table>
<?php 
.
.
.
?>

reg
kevin

[zuessh]

perfect, thanks!! One last thing then I will mark this post "resolved". If I want it to search multiple tables would I do something like this;

$query = "select * from "matchbox,hotwheels" where make like '%".$address."%'";

Thanks

[kevinsequeira]

$query = "select * from matchbox, hotwheels where matchbox.make like '%".$address."%' OR hotwheels.make LIKE '%".$address."%'";

reg
kevin