🔒 Locked

SQL problems

Started by Mupp Feb 2, 2004 at 4:23 AM 0 replies 250+ views

Original Post

Feb 2, 2004 at 4:23 AM

I need to insert a variabel into my sql code int x = 3; mysql_query(conn,"INSERT INTO missedcalls (rNumber, aNumber, dateAndTime, smsId, alertSmsMsgTime, alertSmsMsgAccTime, notificationSmsMsgTime, notificationSmsMsgAccTime, active) VALUES (''1234567889012345'', ''123456789012345'',FROM_UNIXTIME(x), ''1234567890123456789012345678901234567890123456789012345'', NULL, NULL,NULL,NULL, 1)"); ive tried things that worked in asp, such ass FROM_UNIXTIME(''"x"'') and so on, but i cant figure it out, im slowminded

krez

Feb 2, 2004 at 9:06 AM

you''ll have to build the string separately and then pass it to the function.

Topic Locked

This topic has been locked by a moderator. New replies are not allowed.