Hello!

I try to start doing some basic MySQL but it just wont work.
I've read thru some basic manuals but the problems are awesome.

So far it looks like my server is working, the PHP is doing fine, even the database is somewhere out there but I cant fetch the data...

Here is my simplified attempt to write and read.

All help welcome! If you have the time list up the errors for me.

<?
$user="xxx";
$password="xxx";
$database="xxx";

mysql_connect("mysql",$user,$password);
mysql_select_db($database) or die( "Unable to select database");

// first we create the table, with three fields

mysql_query("CREATE TABLE chat (one, two, three)");

// ... and now we write

mysql_query( "INSERT INTO chat VALUES ('Paul','John','Smith')" );

// ...and now we try to read

$query="SELECT * FROM chat";
$result=mysql_query($query);

$a=mysql_result($result,"0", "one");
$b=mysql_result($result,"0", "two");
$c=mysql_result($result,"0", "three");

// here we print the result

echo "$a $b $c<br>";
mysql_close();
?>

I use something like this:-

if($result)
{
while($row = mysql_fetch_array($result))
{
echo("ID: " .$row["id"]);
echo(" - NAME: " .$row["name"]);
echo(" - NUMBER: " .$row["number"]);
}
}

Nick

Originally Posted by nickc

I use something like this:-
...

Yes, I see. But my problem is that I don't know where I do wrong. That's why I have simplified and done as linear as possible my example...

There's some or more basic errors I do because I just don't get it. Should the example in the beginning of this thread work? If not, then what should I correct?
Does it even appear what it should do, hah haa.

Dunkel

mysql_connect("mysql",$user,$password);

This is probably why you can't connect to your database. This particular function has the sytax of :

PHP Code:

mysql_connect (hostname,username, password); 


Unless your MySQL server is named "mysql" you can't connect this way. If the server is on your own machine then just use "localhost" as the hostname. If it doesn't exist on your own machine you'll have to use the IP address or ask the server administrator to supply you with the hostname.

Originally Posted by compmodder26

...Unless your MySQL server is named "mysql" you can't connect this way. If the server is on your own machine then just use "localhost" as the hostname. ...

In fact the server is named "mysql" but I will double check that.

I have now copied, edited and writed and test drived a dozen of examples (and will continue with that) and everything goes error free until I try to read the database. Nothing dramatic but I just don't get any data out.

Is there somewhere a VERY SIMPLE example how to create, write and read a database? I mean real simple, something that I can deal with.

try doing:

PHP Code:

$link = mysql_connect("mysql",$user,$password) or die(mysql_error());
mysql_select_db($database, $link) or die( "Unable to select database");

// first we create the table, with three fields

mysql_query("CREATE TABLE chat (one, two, three)", $link);

// ... and now we write

mysql_query( "INSERT INTO chat VALUES ('Paul','John','Smith')", $link);

// ...and now we try to read

$query="SELECT * FROM chat";
$result=mysql_query($query, $link);

$a=mysql_result($result,"0", "one");
$b=mysql_result($result,"0", "two");
$c=mysql_result($result,"0", "three");

// here we print the result

echo "$a $b $c<br>";
mysql_close();
?>