Jump to content

weird sql + vars


birdie

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\" /]
Link to comment
https://forums.phpfreaks.com/topic/12659-weird-sql-vars/
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
Link to comment
https://forums.phpfreaks.com/topic/12659-weird-sql-vars/#findComment-48594
Share on other sites

Archived

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

×
×
  • Create New...

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.