viion Posted February 11, 2009 Share Posted February 11, 2009 Been trying forever to figure this out, driving me nuts! I need this page to search my database and see if the session username exists, if it doesnt it comes back with a form (review form) and also shows a coupon. Now i'm trying to get the coupon bit to work. Basically I am trying to: IF exists: Your coupon is: blah blah IF doesn't exist: Review to receive coupon I can't do a like select * where username='w/e' because, comes back with invalid or i dont know how to do it properly, at the moment i am trying to make it parse out all the usernames in the table, if any of them = the session name, it makes $answer = true, if not then $answer = false, then later on in code, if true, Your coupon is blah blah, if false, review! This is my coding, when I run it, it notices that $answer = "false" but it still shows the coupon code as if it equals true as well. Any help? <? $result = @mysql_query("SELECT * FROM salon_data WHERE salon_name='$name' LIMIT 0,1"); if (!$result) { echo("<strong>Error performing query: " . mysql_error() . "</strong>"); exit(); } $sqlx = @mysql_query("SELECT * FROM salon_stats_data WHERE salon_name='$name'"); // SQL ERROR CHECK if (!$sqlx) { echo("<b>Error performing query: " . mysql_error() . "</b>"); exit(); } $answer = ""; if($session->logged_in) { // ---------- while ($row = mysql_fetch_array($result)) { $salon_coupon = $row["salon_coupon"]; $salon_name = $row["salon_name"]; while ($rw2 = mysql_fetch_array($sqlx) ) { $salon_username = $rw2["salon_username"]; echo "Salon Username: $salon_username<br>"; if ($salon_username == $session->username) { $answer = "true"; } else { $answer = "false"; } } } // ---------- } echo "<br> ($answer) <br>"; // Check Answer if ($answer = "true") { echo "<strong>$session->username</strong>. <br /><img src='img/action_check.png'> Your Coupon for <strong>$salon_name</strong> is: <span id='stat'><strong>$salon_coupon</strong></span><br /><br />"; } if ($answer = "false") { echo "Hello $session->username! If you rate and review this salon, you'll be eligible for a coupon!"; } // If user not logged in: if(!$session->logged_in){ echo "Hello! <a href='?c=a1'>Register now</a> to rate and review this salon, you'll be eligible for a coupon!<br /><br />"; } ?> Link to comment https://forums.phpfreaks.com/topic/144832-need-an-if-doesnt-exist-in-database-statement/ Share on other sites More sharing options...
Mchl Posted February 11, 2009 Share Posted February 11, 2009 if ($answer = "true") { should be if ($answer == "true") { same for 'false' of course What you did wrong: = is for assigning values. == is for comparing values When you use = in if(), PHP assigns a value ("false") to variable ($answer) and says "hey I did it!" - which means the if() evaluates as true. Link to comment https://forums.phpfreaks.com/topic/144832-need-an-if-doesnt-exist-in-database-statement/#findComment-760072 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.