Jump to content

Archived

This topic is now archived and is closed to further replies.

birdie

weird sql + vars

Recommended Posts

hi, i'm having problems with this sql code, i just cant find the problem with it.

[code]
$sql = "INSERT INTO `matches` ( `opp` , `time` , `result` , `ip` , `username` ) VALUES ( '$opp' , '$time' , '$result' , '$ip' , '$username' )";
[/code]

if i mysql_query() it, it doesnt insert. the vars are int, varchar with the limits well within boundarys.

Any ideas? thanks a lot [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]

Share this post


Link to post
Share on other sites

[code]
$sql = "INSERT INTO matches ( 'opp' , 'time' , 'result' , 'ip' , 'username' ) VALUES ( '$opp' , '$time' , '$result' , '$ip' , '$username' )";
[/code]

its the quotes most of the time. I run into is all the time use phpadmin and to run sql querys have remove most of the qoutes it puts in

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.