[SOLVED] sql query not executing when variables used

[elis]

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.

[genericnumber1]

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.

[NathanLedet]

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;

[elis]

Thanks! I got it to work, the echo $sql; helped. Turned out to be a problem within MYSQL not the code.