mysql_query return an error, but not in phpmyadmin

Question

It's really not my first SQL query;), but ...!, I've a weird error : I am doing an import from a CSV file into my db, and the query returns an error with mysql_query, and in phpmyadmin, if I copy/paste the query, all is ok.

$result = mysql_query ($ sql);
echo $ sql. "=>". $result. ','. Mysql_error ($this-> cnx). '<br> cnx ='. $this-> cnx. '<br>';

In the echo :

INSERT INTO tiny_url (`id`, `url`, `tiny_url`, `page_rank`, `link_name`, `destination_url`, `anchor`, `active`) VALUES (NULL, "111", "222", 3, "444", "555", 1,1)
=>, 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 '
'At line 3
cnx = Resource id # 27

and if I do that : it works:

$sql = 'INSERT INTO tiny_url (`id`, `url`, `tiny_url`, `page_rank`, `link_name`, `destination_url`, `anchor`, `active `) VALUES (NULL," 111 "," 222 ", 3," 444 "," 555 ", 1,1) ';

$result = mysql_query ($sql);
echo $sql. "=>". $result. ','. mysql_error($this-> cnx). '<br> cnx ='. $this-> cnx. '<br>';

Can U help me please ?

Fab

please don't use mysql_* functions, it's deprecated (see red box) and vulnerable to sql-injection. Use PDO or MySQLi. — Nir Alfasi
– Nir Alfasi, Commented Aug 30, 2012 at 15:11
Can you share the code that involves $this->cnx? It looks like you are trying to include an object or resource instead of a number? — Dameo
– Dameo, Commented Aug 30, 2012 at 15:14
Is there any reason you have spaces around your integers in your INSERT? ...VALUES (NULL," 111 "," 222 "... — Kermit
– Kermit, Commented Aug 30, 2012 at 15:15

Nir Alfasi · Accepted Answer · 2012-08-30 15:14:33Z

1

Your columns is called active (followed by a space).

answered Aug 30, 2012 at 15:14

Nir Alfasi

53.6k11 gold badges94 silver badges138 bronze badges

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

Comments

James · Accepted Answer · 2012-08-30 15:19:00Z

0

I've found the problem : In my code, i've added this

$sql .= ")<br>";

Of course, no html code is allowed in a query.. of course.

Et voila... :(

Fab

answered Aug 30, 2012 at 15:19

James

1,4811 gold badge19 silver badges33 bronze badges

2 Comments

Nir Alfasi Over a year ago

According to this - the second query should have failed.

James Over a year ago

Thanks everyone your for all your help, but i've found my problem... it was a silly error... :(

Collectives™ on Stack Overflow

mysql_query return an error, but not in phpmyadmin

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related