Mysql Insert failing

gustave

I am trying to do a simple insert into a mysql database. Here is my simple database structure:
database name is test and table is called primary

Here is my code below. I have named the page test.php and am running it in a browser. I am expecting this to add an entry into the database but it is not. I would very much appreciate some help on this.

<?php
$data = "dog";
mysql_connect("localhost", "root", "br0wnt3b") or
die("Could not connect: " . mysql_error());
mysql_select_db("test");

$sql = "INSERT INTO primary VALUES ('$data')";
$result = mysql_query($sql);
echo $sql;
echo $result;
?>

jeremuck

You need to tell the database which columns you are inserting valuess into (not just the table) and in what order.

Read this and it will become clear (it's not hard to understand)
http://www.mysql.com/doc/en/INSERT.html

Go ahead and bookmark the link I gave you.... you will undoubtably need it many times in the future. (I know I need it all the time).

gustave

Here is try number 2 (more like 500)
The connection is fine to the database but no insert:
root has access to the database as well
Here is the latest code
name is the name of the field

Thanks for helping. This is driving me crazy

<?php
mysql_connect("localhost", "root", "redhat") or
die("Could not connect: " . mysql_error());
mysql_select_db("test");

$sql = "INSERT INTO primary (name) VALUES ('mine')";
$result = mysql_query($sql);
echo $sql;
echo $result;
?>

jeremuck

Hmm... sometimes, when you pick out strange names for your tables and stuff, weird things can happen. I'm not sure is "primary" is a word that you are allowed to use to name a table. try typing primary instead (notice the backticks [near the ESC button]) also, name is a very strange field name, but I guess it's ok. You may want to try name as well.

What does the errors say?
Try this:

function printDBerror($message = "", &$dbLink)
{
	if($dbLink != "")
	{
		echo "MySQL said: " . mysql_error($dbLink) . "<br>";
	}

die(print( $message));
}

function echeckDB($message = "", &$dbLink)
{
	if(mysql_error($dbLink) != "")
	{
		printDBerror($message, &$dbLink);
	}

}

$dbLink = mysql_connect("localhost", "root", "redhat");
echeckDB("Could not connect to DB.<br>", &$dbLink);

$sql = "INSERT INTO `primary` (`name`) VALUES ('mine')";
$result = mysql_query($sql, $dbLink);
echeckDB("Here's the query: " . $sql . "<br>", &$dbLink);

echo $sql;
echo $result;

gustave

That works.

Thanks very much!