mysql connection

[zuessh]

I have the following script to access a mysql database, but it fails on line 7, couldn't connect. Any suggestions?

<?

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

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

$sql = "SELECT * from table";
$result = mysql_query($sql, $connection)or die ("Couln't execute query.");
while ($row = mysql_fetch_array(result)) {
$id = $row['id'];
$name = $row['name'];

$text = "$id $name <br>";
}
echo $text;
?>

[kevinsequeira]

on this line

$connection = mysql_connect("localhost","$db_user","db_pass") or die("Couldn't")
;

you have to use $db_pass not db_pass

reg
kevin

[zuessh]

Thanks that got me past the connection problems. Now i am getting 'couldn't execute query'. I am posting the code again. Also the name of the db is php and the table I am wanting to pull from is table. Thanks

<?

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

$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");

$sql = "SELECT * from table";
$result = mysql_query($sql, $connection)or die ("Couln't execute query.");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];

$text = "$id $name <br>";
}
echo $text;
?>

[kevinsequeira]

i think you need to change the name of the table cause "table" is a reserved word if im not mistaken

reg
keivn

[zuessh]

That did it. 😃 Thanks

[DigitalExpl0it]

a bit cleaner

<?
$db_name = "php";
$db_user = "testphp";
$db_pass = "test";

$connection = mysql_connect("localhost", $db_user, $db_pass) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$db = mysql_select_db($db_name, $connection) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$sql = "SELECT * from table";
$result = mysql_query($sql, $connection) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");

while ($row = mysql_fetch_array($result)) {
$text = $row['id']." ".$row['name']."<br>";
}
echo $text;
mysql_close($connection);
?>