SQL Insert Query

galaxyhiker

I am trying to send some values to a database all of which works fine until I try to add the last value being the "$desc" value. There is one more column after the desc column in the database but it allows nulls to be passed. There are also columns inbetween that are not updated but all of those also have default values setup. this is the code I am using....(desc is a text box inside my form allowing upto 255 characters, I have tried configuring it as text, blob and varChar in Mysql with no success on the insertion when $desc is included in the statement.

function addDet($uid, $pwd, $url, $abilt, $self, $group, $desc)
{
	$sql = "insert into table1 (uid, pwd, url, abilt, self, agegroup, desc) values ('" . AddSlashes($uid) . "','" .
		AddSlashes($pwd) . "','" . AddSlashes($url) . "','" . $sex . "','" . $self . "','" . $group . "','" . addslashes($desc) . "')";

Danicek

Query seems right. I do not know where is problem.
If you want more info, give us more info.

P. S.: using DESC for collumn name is not good decission. It is keyword used in sql syntax.

galaxyhiker

Ok I have changed the name for $desc in both the variable and the sql column name just incase that was causing any headaches, but unfortunately to no avail.

I have 3 scripts 2 of which are "included" in the first. I pass the variables in a function call from one script with a line something like.......

if (strlen($mes) == 0)
{
$id = addUser($uid, $pwd, $url, blah blah blah blah);
if ($id == 0)
$message .= "Unknown error, unable to save<br>";

I only pass the variables that either need to be changed or that dont have a null or default value in the table.

I then call the script with what you see in my first post in one of the included scripts.

It all works no problems if I exclude desc(or aboutblur as its now called) which makes me wonder if I have not passed it with the correct syntax. I can insert text into the column from my sql control panel no probs. 😕

AstroTeg

It would be a HUGE help if we could see the contents of $sql (including the text field data that you're having problems with).

Have you tried running the query by itself to see what SQL errors you're getting?