elis Posted February 18, 2009 Share Posted February 18, 2009 I'm not sure what happened, this snippet was working perfectly a few days ago and now, it's not. To my knowledge, nothing has been changed. <?php $sql = "INSERT INTO candidateEmails(id,candidate_id) VALUES ('','$cid')"; $stmt = $conn->prepare($sql); $stmt = $conn->query($sql); ?> When I remove the variable "$cid" and input a number like "7"; it works. When I replace the variable - even if I do something like: $fakev = "7"; $sql = "INSERT INTO....VALUES('','$fakev')" Where the variable is directly declared above, it no longer works. I suspect I might have incorrect syntax? But considering it worked with variables before with the exact same code - I'm not sure. ETA: $cid is a global variable that is a $_GET. Quote Link to comment Share on other sites More sharing options...
genericnumber1 Posted February 18, 2009 Share Posted February 18, 2009 if candidate_id is an integer, you'd want to remove the quotes around $cid. Also, no need to insert '' into id, it will do that automatically. Quote Link to comment Share on other sites More sharing options...
NathanLedet Posted February 18, 2009 Share Posted February 18, 2009 One way you can check to see what's being put in is to echo your sql statement. $sql = "INSERT INTO candidateEmails(id,candidate_id) VALUES ('','$cid')"; echo $sql; Quote Link to comment Share on other sites More sharing options...
elis Posted February 18, 2009 Author Share Posted February 18, 2009 Thanks! I got it to work, the echo $sql; helped. Turned out to be a problem within MYSQL not the code. 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.