problem connect to MySql from script

sabra · July 20th, 2006, 09:51 PM

Hello everyone, I ned help to connect from My Pc to MySql on Web by this code !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
  "http://www.w3.org/TR/html4/lose.dtd" >
<html>

<head>
<title>Wines </title>
</head>
<body bgcolor="#F5F5F5">

<pre>
<?php

@ $db = mysql_pconnect("localhost","nbanene","kontakt");
if (!$db)
{
echo "Error: Could not connect to database.";
      exit;
}
mysql_select_db("winestore",$conection);
//
//
$query = "INSERT INTO customer VALUES(NULL,'Marzala','Dimitria','F','Mr','171 Tritshall Ccl','','St Albans','WA','7608','Ausrealia','(618)63576028','' ,'[email protected]','1969-11-08',35000)";
//
//
$result = mysql_query($query);
if (!$result)
echo mysql_affected_rows().'region inserted into database';
  //
echo"\n";
}
//
msql_close($conection);
?>
</pre>
</body>
</html>
.
I don't know what i ned to specify in the code.

panacea · July 25th, 2006, 07:23 PM

First try to connect to your MySQL server with a command-line or graphical query client. For a graphical client, I prefer MySQL Query Browser (http://dev.mysql.com/downloads/query-browser/1.1.html). Once you've figured out how to connect to it manually, it should be pretty straight-forward to copy over the parameters you used into your PHP code.

Jon Emerson
http://www.jonemerson.net/