Adding fields, need help finishing....

Ok, I'm needing to add a few fields to New Threads.

This is what I've done thus far:
I've added the fields I need in the thread table in the vb database.

In showthread.php, I added this:

PHP Code:

$trader_price = $thread['trader_price'];
    $trader_shipping = $thread['trader_shipping'];
    $trader_payment = $thread['trader_payment'];
    $trader_man = $thread['trader_man'];
    $trader_trade = $thread['trader_trade'];
    $trader_condition = $thread['trader_condition'];
    $trader_age = $thread['trader_age']; 


and added the fields to newthread.php, which would look like this:

PHP Code:

$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,
postusername,postuserid,lastposter,dateline,iconid,
visible,attach,trader_price,trader_shipping,trader_payment,
trader_man,trader_trade,trader_condition,trader_age) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."',
'$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount','$trader_price','$trader_shipping','$trader_payment','$trader_man','$trader_trade',
'$trader_condition','$trader_age'"); 


Now, when I submit this stuff, its not writing to the database, so I really don't know if the other parts are working correctly. So, if anyone has any suggestions, please me know. Thanks in advance!

[SuperG]

UPDATE:
I get this error:

PHP Code:

Database error in vBulletin 2.2.7:

Invalid SQL: INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach,trader_price,trader_shipping,trader_payment,trader_man,trader_trade,trader_condition,trader_age) VALUES (NULL,'You can\'t see this either','1034129905','14','1','0','SuperG','1','SuperG','1034129905','1','1','1','1200.00','00.00','Check','WDP','Yes','Brand New','1-3 Months'
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Tuesday 08th of October 2002 08:18:25 PM
Script: [url]http://www.southernpaintball.com/forums/forums/newthread.php[/url]
Referer: [url]http://www.southernpaintball.com/forums/newthread.php?action=newthread&forumid=14[/url] 


[Erwin]

Easy fix:

Change this:

'You can't see this either'

To this:

'You cannot see this either'

You had 2 ' symbols in the wrong place!

You cannot use "can't" because the ' symbol conflicts with the query line.

[SuperG]

ok then, that was the subject of the post so it shouldn't matter, i mean, regular posts have apostrophe's in them.

Any other suggestions?

[Erwin]

I know regular posts have apostrophe's in them, but you are putting that in a query - each query variable has a ' around them to delineate them, but you have a ' inside 2 ' within a variable which will cause a mysql syntax error. PHP thinks your variable is 'You can' because the ' in can't has ended that variable, but there is no comma so the syntax error occurs.

[Erwin]

Just make the changes, and the syntax error should be resolved.

[SuperG]

lemme try dat..i'll post again.....

[SuperG]

I went back to the original newthread.php file and everything worked. THAT has the subject in it, so its not what you suggested. I added my other values back, and it again does not work. So, its something with the new stuff I'm adding which, but I can't find a problem with it. Any other suggestions?

[Erwin]

Ahhh... I see what you mean... you're right... I thought you had that statement in a query in a PHP file... Should have read your posts better...

Try this:

Find:

PHP Code:

'$trader_age'"); 


Change to:

PHP Code:

'$trader_age')"); 


I think you may be missing a bracket ) symbol there.

[SuperG]

Ok, that fixed the problem with writing it to the database.

Now, with what I have posted above, its not calling it up from the database. Any suggestions there?