connecting mysql

[dummmmmbo]

im having trouble viewing any results from my db,
ive recently switched to a mac and have it all running locally, i have no
trouble accessing the db through terminal command line and can see dbs and
tables and run the queries from here also can see db from phpmyadmin and run
queries from there but i just cant access any db from a php script ... i dont
get any error messages just nothing and my tables wont show up in dreamweaver
which says the path to the server is wrong but the normal php scripts run which
dont involve mysql what is going on ! heres a clip of code
<?php
$host="localhost";
$username="root";
$pass="jlkj99";
$database="hayesdec";
$tablename="login";
$connection=mysql_connect($host,$username,$pass);
if(!$connection({
echo"no con";
}
$result=mysql_select_db($database)
if($result({
echo"pppppp";
}
$query="SELECT * from" .$tablename";
$result= mysql_query($query);
if(!$result({
echo"no result";
}

while ($row=mysql_fetch_array($result))
{
echo row["username"];
echo row["password"];
}

?>
thanks chris

[gareth]

Try my MySQL database connection guide at:

[url]http://www.dreamweavermxsupport.com/index.php?type=article&pid=60&sid=61[/url]


--
Gareth - TMM Dreamweaver
[url]http://www.dreamweavermxsupport.com/[/url]
[url]http://www.garethdp.com/[/url]

PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
[url]http://www.phploginsuite.co.uk/[/url]

Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
Co-Author: Practical Intranet Development - Apress
Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
Co-Author: Dreamweaver MX: PHP Web Development - Wrox