hello, im a newbie, i have a snipit of code which "should" let me view the contents of a selected table in my database.

i uploaded and when i viewed, i got nothing but a blank page!!!

can anyone help me, or does anyone know an easier way to create a register / login databse so people can gain access ect...
please help, im losing my hair.

<?php
// connect to the database

$connection = mysql_connect("local host","mysqlUserName,"MysqlPassWord");

// choose database
$db = mysql_select_db("test", $connection);

$SQL = "SELECT url FROM site01_favwebsites";

$websitesURLs = mysql_query($SQL);
?>

<table border="1">
<?php
for ($i = 1; $i <= $numRows; $i++)
{

// get results

$rowOfResults = mysql_fetch_array ($websiteurls);
?>
<tr>
<td><?php echo $rowOfResults['url'] ?></td>
<tr>
<?php
}
?>
</table>

Oh boy, I'm about to have to do a project like this soon (PhP/MySQL with login access). More opportunities to learn new stuffs.

I don't know if the code is correct or not, but you're missing the closing double quote on mysqlUserName.