Mysql problems - Mysql fetch array and adding to database

Question

Hi I have two mysql problems

a) I'm confused on why this code won't add data to my database:

$con = mysql_connect("localhost","username","password");
mysql_select_db("database", $con);

$sql="INSERT INTO Table ('adder', 'username')
VALUES('$myusername','$username1')";
mysql_query( $sql, $con ) or trigger_error( mysql_error( $con ), E_USER_ERROR );

here is the full error: "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 'Add (username, name, number) VALUES('56', 'Name', 'number')' at line 1"

and before you ask, yes the data is there

b) I'm having problems with mysql_fetch_array

This is the code:

mysql_connect("$host", "$mysqlusername", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql = "SELECT * FROM Add WHERE adder=\"$username\"";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
if (empty($row)) {
echo "$username hasn\'t added anyone";
}
else {
while($row = mysql_fetch_array($result)){
echo "<a href=\"/".$row[username]."><".$row[username]."</a>"; 
}
}

The error here is: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in....

And yes the data is there on the database aswell..

Any ideas??

Thanks for the help :) Niall

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... You omitted the important part that comes afterwards. — AndersTornkvist
– AndersTornkvist, Commented May 25, 2011 at 19:39

Dan Simon · Accepted Answer · 2011-05-25 19:53:12Z

1

a) You really should have included the complete error, but I'm fairly certain the syntax error is that you are attempting to put the names of columns in single quotes, which is not allowed. You should instead use backticks (the key to the left of "1" on your keyboard):

$sql="INSERT INTO Table (`adder`, `username`)
VALUES('$myusername','$username1')";

b) Again, please include the full error. That warning occurs when the mysql_query function fails, since $result is just the value false instead of a MySQL resource. What is the value of $username when you get that error? It's likely something is causing the query to be invalid.

answered May 25, 2011 at 19:53

Dan Simon

13.2k3 gold badges52 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dereleased Over a year ago

I was about to post the same thing.

dar7yl · Accepted Answer · 2011-05-26 23:56:54Z

0

You should have said "INSERT INTO TABLE `Add`(`adder`, `username`)"

and Add should be enclosed in backticks (`) because it could be a reserved word, and you shouldn't name a table like that.

edited May 26, 2011 at 23:56

answered May 26, 2011 at 23:49

dar7yl

3,78728 silver badges20 bronze badges

Collectives™ on Stack Overflow

Mysql problems - Mysql fetch array and adding to database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related