Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[spacing]

ok i made a quick Job just to show the error i am receiving

here it is.. could anyone tell me my problem.

QUERY 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 ' , , , , 7)' at line 1
Query was INSERT INTO jobranks VALUES('', 'jer', 2, 63, , , , , , 7)

[Spudinski]

Code: [Select]

INSERT INTO jobranks VALUES('', 'jer', 2, 63, , , , , , 7)
You can not have blank values, pretty simple.
It's either your script not validating input, or it's not building up the correct theory.

Paste the script segment where this error occurs please.

[Maketextgames.com]

Query was INSERT INTO jobranks VALUES('', 'jer', 2, 63, , , , , , 7)


it's the ,,'s

I beleive

Query was INSERT INTO jobranks VALUES('', 'jer', 2, 63,'','','','','',7)

Might work

Would really need to see about 5-10 lines of the actual code tho :p

[Danny696]

lol, that wont work, when making a jobrank, make sure every box is filled out. even if its a 0

[Maketextgames.com]

Like I said Danny it depends on what it's calling to

'' will work if it's inserting it manually like a user id is called ''

as the database inserts it for you.

Again, would be a lot more helpful if i saw the query tho >,<

[Danny696]

replace the query with this:

Code: [Select]

<?php //do not add to your code.
$query = sprintf("INSERT INTO jobranks VALUES('', '%s', %u, %u, %u, %u, %u, %u, %u, $u)", $_POST['jrNAME'], $i, $_POST['jrPAY'], $_POST['jrLABOURG'], $_POST['jrSTRG'], $_POST['jrIQG'] $_POST['jrLABOURN'], $_POST['jrSTRN'], $_POST['jrIQN']);
if($query === FALSE)
{
echo mysql_error();
}
else
{
$db->query($query);
}


[spacing]

thanks for all the help guys
you were right, i just needed to make sure each box had a number or letter in it
cheers!

*thumbs up to all*