[RESOLVED] Help with db input problem.

AHoward007

I can't figure out what is wrong with the file below. It is not entering the data into the database.

<?php
mysql_connect("localhost","root","");
mysql_select_db("monoling_dictionary");

/ This section inserts values into english, monolingua and comment text fields in the monoling_dictionary database. /

mysql_query("INSERT INTO 'dictionary' ('english','monolingua','comment')
VALUES ('two','dva','russian')");
?>

dagon

mysql_connect("localhost","root","") or die('Could not connect: ' . mysql_error());

AHoward007

I added die syntax to the end of mysql_connect. It still doesn't work. I believe I'm getting a good connection to the database since this file to retrieve data does work.

<?php
mysql_connect("localhost","root","");
mysql_select_db("monoling_dictionary");

$query=mysql_query("SELECT * FROM dictionary");
while($row=mysql_fetch_array($query))
{
$name=$row['english'];
$surname=$row['monolingua'];
echo $name." ".$surname."<br>";
}

dagon

you should add or die ... to the end of every mysql_* function to see where the error is.

AHoward007

After I entered the die syntax, I got a syntax error message on the line with INSERT INTO or VALUES lines. I'm wondering if the " mark before INSERT INTO is the problem. I'm not sure what that's there for or where the closing " mark should be placed on the script line.

dagon

its the single quotes around the table name

bradgrafelman

As dagon pointed out, your error lies in the way you quoted the table/column names. In MySQL, table/database/column/etc. identifiers should be surrounded with backticks (`) or nothing at all.

AHoward007

I tried removing the ticks ' around dictionary but it didn't work.

bradgrafelman

Did you also remove them around your column names?

Similar to PHP, a single quote in a MySQL query denotes a string; database/table/column/view/etc. names are not strings but rather "identifiers" and are treated specially.

EDIT: For more information on identifiers in MySQL, see this page in the manual.

AHoward007

Yeah that did the trick. Quote ticks needed to be removed from data table and column names.

Thanks for the help folks!