[SOLVED] Showing data

[dark22horse]

Hi guys, I have been struggling to retreive any data from mysql database and then show it on a webpage.

 

I will post the script below.  Any help would be appreciated!!!

 

^_<?

^{_{$username="root";}}

^{_{$password="";}}

^{_{$database="car";}}

 

^{_{mysql_connect(localhost,$username,$password);}}

^{_{mysql_select_db($database) or die( "Unable to select database");}}

 

 

^{_{$sql = "SELECT * car";}}

^{_{$query = mysql_query($sql);}}

 

^{_{while($row = mysql_fetch_assoc($query)){}}

    ^{_{echo $row['name'].'<br />';}}

    ^{_{echo $row['description'].'<br />';}}

^_}

 

^_?>

 

I want to format it, but that can wait until I actually get something!!!!

[fert]

<?
$username="root";
$password="";
$database="car";

mysql_connect("localhost",$username,$password);
mysql_select_db($database) or die( "Unable to select database");


$sql = "SELECT * FROM car";
$query = mysql_query($sql) or die(mysql_error());;

while($row = mysql_fetch_assoc($query)){
    echo $row['name'].'
';
    echo $row['description'].'
';
}

?>

[dark22horse]

hi guys!

 

Im a complete noob

 

I have hopefully got it working, I saved it as a html file, saved as a php and everything worked