182x Posted November 17, 2006 Share Posted November 17, 2006 Hey guysI have created the following two queries the first one works fine however the second (insert query) )doesn't. No error message is supplied the data just doesn't enter the table. Any advice would be great thanks.[code]$query="UPDATE cu SET curr ='".$HTTP_SESSION_VARS['curr]."' WHERE Id = '".$HTTP_SESSION_VARS['Id']."'";mysql_query($query, $link_id); $query2="INSERT INTO acc VALUES('','$tha', '$dep', '$HTTP_SESSION_VARS[Id]')";mysql_query($query2, $link_id);[/code] Link to comment https://forums.phpfreaks.com/topic/27577-query-issue/ Share on other sites More sharing options...
komquat Posted November 17, 2006 Share Posted November 17, 2006 It may be tedious, but you should list all the fields you want to insert into[code=php:0]$query2="INSERT INTO acc (field1, field2, field3, field4) VALUES('','$tha', '$dep', '$HTTP_SESSION_VARS[Id]')";[/code]I found this to be good practice, then you do not need '' for the first field Link to comment https://forums.phpfreaks.com/topic/27577-query-issue/#findComment-126124 Share on other sites More sharing options...
182x Posted November 17, 2006 Author Share Posted November 17, 2006 Hi thanks for your reply, I have tried this but the query still won't insert the records, any ideas? Link to comment https://forums.phpfreaks.com/topic/27577-query-issue/#findComment-126126 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.