
November 27th, 2003, 11:43 AM
|
|
Registered User
|
|
Join Date: Apr 2007
Posts: 22,309
Time spent in forums: < 1 sec
Reputation Power: 24
|
|
|
Missing something simple
Hello,
Maybe one of you can see what I missed cause I can't. Sql won't work unless I hard code email address. On the $post_return where I show what was submit it shows the var $email..
php Code:
Original
- php Code |
|
|
|
<? include "../inc/settings.php"; if (isset ($_POST['submit'])) { $email = $_POST['email']; if (!$db) { echo "Error: Could not connect to database. Please try again later."; } $query = "select * from subscribers where subscribers_email = $email"; //$query = "select * from subscribers where subscribers_email = 'jon@phillipscasa.net'"; if ( $count == 0 ){ // cannot find visitor's email address in the database $post_return = "<h1>Opps </h1>"; $post_return .= "<P>It appears that I don't have your Email Address or you missed type it?<br>"; $post_return .= "Is this the correct login / email address < $email >"; } else{ // the rest works from here }
any ideas why $email is not reconized in the $query?
[
|