My coding skills are so bad :(

[csk8er59]

I'm trying to make this page look like this:

Welcome to the spinoff reviews database. You can submit a user review here.
1.The Outboards
Owners😮bo and Gas
2.Whitefyre
Owners:Ultimategamer00

It would be appreciated if you could show me the correct code.Here's the current code:

<?php
require ('db.php');
echo 'Welcome to the spinoff reviews database. You can submit a user review here.<br />';
$query1=mysql_query("SELECT `id` FROM `spinoff`");
while ($row1 = mysql_fetch_assoc($query1)) {
echo ''. $row1["id"] .'.'  ;
}
#################################################
$query2=mysql_query("SELECT `name` FROM `spinoff`");
while ($row2 = mysql_fetch_assoc($query2)) {
echo $row2["name"] ;
}
#################################################
echo '<br />';
$query3=mysql_query("SELECT `owner` FROM `spinoff`");
while ($row3 = mysql_fetch_assoc($query3)) {
echo 'Owners:' . $row3["owner"];
}
?> 

[BooRadLey]

<?php 
require ('db.php');

echo 'Welcome to the spinoff reviews database. You can submit a user review here.<br />';

$query = mysql_query("SELECT * FROM spinoff");
while ($row = mysql_fetch_assoc($query)) {

  echo $row["id"] .". ". $row["name"]."<br />";
  echo "Owners: ".$row["owner"];

}
?>

Try that out, I think that covers what you want, I hope there are no mistakes in there h ehe,

Brad

[csk8er59]

I'm such an idiot.D'oh.Thanks a lot.