It won't insert user input!

[Doomflame]

The code below enters the values $title, $id, and $value into the database, not their values. All of them are set.

 

$sql = \'INSERT INTO `stocks` (`Title`, `ID`, `Value`) VALUES (\'$title\', \'$id\', \'$value\');\'; 

$query = mysql_query($sql);

if ($query) {

echo "Success!";

} else {

echo "ERROR!";

}

 

Can anyone help me?

[gizmola]

WHen you start a string with a single tic it\'s interpreted to be a string literal by php. Use a double quote around the assignment instead, and php will do the variable replacement you expect.

 

[php:1:501ca3e94d]<?php

$sql = \"INSERT INTO `stocks` (`Title`, `ID`, `Value`) VALUES (\'$title\', \'$id\', \'$value\');\";

$query = mysql_query($sql);

if ($query) {

echo \"Success!\";

} else {

echo \"ERROR!\";

}

?>[/php:1:501ca3e94d]

[shivabharat]

Do the strip slash when u initally get the variable

 

$sql = "INSERT INTO `stocks` (`Title`, `ID`, `Value`) VALUES ($title, $id, $value)"; 

[Doomflame]

I got it to work, I remembered that mysql_error() shows error info, and I just did stripslashes and took the slashes out of that mysql code.