How to connect web pages to MySQL in PHP

[tmyonline]

Hello all!

 

I'm new to this.  I'm having a few days of nightmare in connecting Dreamweaver to MySQL database.  I'm pretty sure that I have the correct MySQL Server name, user-id & password,...  I keep receiving the message "an unidentified error has occured", not so intuitive.

 

I'm wondering if there is a way around this, say, doing it directly in PHP with a few lines of code,...  I'm open to all possible solutions.

 

Many thanks.

 

Tommy

[maliary]

 

Try this,

 

$usr = "root";

$pwd = "dbpassword";

$db = "dbname";

$host = "localhost";

 

 

// Connect to MySQL

$cid = mysql_connect($host,$usr,$pwd);

if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }

 

 

 

Then in your queries do this:

 

      $SQL = "SELECT * FROM tablename";

    $result = mysql_db_query($db,$SQL,$cid);

    while ($row = mysql_fetch_assoc($result))

{

echo  $row['fieldname];

}

 

 

 

 

[ViN86]

 

Try this,

 

$usr = "root";

$pwd = "dbpassword";

$db = "dbname";

$host = "localhost";

 

 

// Connect to MySQL

$cid = mysql_connect($host,$usr,$pwd);

if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }

 

 

 

 

Then in your queries do this:

 

      $SQL = "SELECT * FROM tablename";

    $result = mysql_db_query($db,$SQL,$cid);

    while ($row = mysql_fetch_assoc($result))

{

echo  $row['fieldname];

}

 

 

 

if you will be using the same database frequently, try this:

 

$usr = "root"; 
$pwd = "dbpassword";
$db = "dbname";
$host = "localhost";


// Connect to MySQL
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); 
} else {
    mysql_select_db($db,$cid);
}

$SQL = "SELECT * FROM tablename";
     $result = mysql_query($SQL) or die(mysql_error());
    while ($row = mysql_fetch_assoc($result))
 {
 echo  $row['fieldname];
 }