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] Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.