connecting to a MySQL db

[Anon]

I have to issues I am trying to connect the MySQL db on my hosts server, my code below is not working. Also, how exactly do you pass and recieve values from one php page to another? Thanks 🙂

    $host="server_name";
$user="user_name";
$password="password";
$dbName="db_name";
$tableName="table";

$link=mysql_connect ($host, $user, $password);
$sql="select * from table where login_name = '"%$login_name%"' and password = '"%$password%"'";
$result=mysql_db_query ($dbName, $sql, $link);
$rs=mysql_fetch_array($result);

[Anon]

Should be:

$link=mysql_connect ($host, $user, $password);
$sql="select * from table where login_name = '$login_name' and password = '$password'";
mysql_select_db($dbName, $link);
$result=mysql_query ($sql, $link);
$rs=mysql_fetch_array($result);

You pass values from one page to another by putting a hidden field in a form, or appending the variables in the query string of the next URL.

Diego