Code: Select all
$i = $_GET['user_id']
$e = $_GET['user_email']
$query = "SELECT maintable.name, maintable.last, ideas.wicked, maintable.past_email, maintable.present_email
FROM maintable
LEFT JOIN ideas ON maintable.user_id = ideas.ideas_id
WHERE (maintable.user_id=? AND maintable.present_email=?)
OR (maintable.user_id=? AND maintable.past_email=?)";
$stmt = $conn->stmt_init();
if ($stmt->prepare($query)){
$stmt->bind_param("ssss", $i, $e, $i, $e);
(note this is just a snippet of code to illustrate this point)
thanks in advance