[RESOLVED] $First mysqlquery = "Nightmare"

LiamBailey

This is my mysql code:

if (isset($submit)) {
$con = mysql_connect("myhost", "myusername", "mypassword");
mysql_select_db("bai11814_po, $con");
$query = ("INSERT INTO 'callback' ('id', 'name', 'telephone') VALUES ('', '$name', '$telephone')");

mysql_query("$query")
or die(mysql_error());
echo ("it worked");
}
?>

And this is the error message

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''callback' ('id', 'name', 'telephone') VALUES ('', 'oioiupu', 'opoupip')' at line 1

I have been to various different tutorials and tried different ways of doing it, if I remove the quotations from around my table name (callback) the error is no database selected. I have tried removing the brackets around the entire query string, same syntax error, removing the brackets around (name, telephone etc) an d even tried not putting id into my query, and leaving out the empty space for VALUES, for two days solid I have messed around tweak it here tweak it there, one bit at a time, but the problem is, when you change another thing, you don't know if the way you had a certain bit two tests ago ould work now that you have changed this, when you're a begginner I mean. Even when I came on here I looked at other people's responses and copied how to do it and it still didn't work. Someone please tell me where I'M going wrong.

bradgrafelman

Database/table/column names do not need quotes around them. If, however, you happen to use a reserved word as a column name (or just simply want to always delimit column/table names), you can use the backtick (`); single quotes are used for strings only (such as in the VALUES portion of the query).

LiamBailey

But when I remove the quotes around the table name it comes up no database selected. I have tried an endless amount of tweaking with the mysql_select_db, and the way i have it in my code snippet is the only way i found that I could stop getting the error message no database selected, but only when I use quotes around the table name

bradgrafelman

Ah, that's because of an erroneous double quote on this line:

mysql_select_db("bai11814_po, $con");

Notice that this function, [man]mysql_select_db/man can take one or two parameters, the first being the name of the database.

In the code you have, you only have one parameter, thus you're telling PHP to select the "bai11814_po, $con" database. Notice the problem? Either move the double quote or simply get rid of the second parameter altogether (specifying a connection parameter, unless using MySQLi perhaps(?), is not needed unless you have multiple connections open).

LiamBailey

I just tried taking out the $con for the mysql_select_db and removed the quotes from the tablename and it said

no database selected

laserlight

I just tried taking out the $con for the mysql_select_db and removed the quotes from the tablename and it said

What do you mean by "removed the quotes from the tablename"? bradgrafelman talked about moving, not removing, the double quote. I would expect:

mysql_select_db("bai11814_po", $con);

mysql_select_db("bai11814_po");

If you still get "no database selected", that means that you used an incorrect database name.

bradgrafelman

I believe he meant the quotes in his query around the table name.

Either way, can you post a new copy of your code for us? Don't forget to use the board's [PHP][/PHP] bbcode tags!

LiamBailey

Hi guys, I was pretty sure that after copying code from several tutorials to run my query that I was right, and I cam here for final confirmation. When I was told that if it still said no database selected your putting in an invalid database and inded I was.

Thank you for all your help, I am now running a script that succesfully enters data into mysql.

laserlight

Remember to mark this thread as resolved using the thread tools.

LiamBailey

Marked it resolved straight after posting thank you comment