[Scottish] php and my sql

[Gary Campbell]

Try something like this instead.....

	<?

	require("conn.php");
	/// ========================================================
	// following part read values of entered details and prepares them
for 
	mysql data input format

	$email = $HTTP_POST_VARS["email"];
	///========================================================


	$query ="Select email from details where email == '$email' ";
	$result = mysql_query($query);
	if ($result)
	   {
	 //email correct      
	 header("Location:download.php");
	    }
	    else
	   {
	      //email not recognised 
	      header("Location:register.php");
	   }    

	?>

Gary
	  

> -----Original Message-----
> From:	Ismail Murat Dilek [SMTP:olive@zoom.co.uk]
> Sent:	Tuesday, February 11, 2003 12:23 PM
> To:	scottish@mailman.lug.org.uk
> Subject:	[Scottish] php and my sql
> 
> Hi,
> I ve created a mysql database. Basically user fills  the form then  hits 
> submit button and  all data posted to mysql database.This part works fine.
> Next time user return the page enters their email address and hits 
> submit button. my php script
> check if email address exist in our database if exist takes user to 
> download page, if not exist takes them to registration page.
> Some strange reason this comparasing is not working properly. it works 
> for some email addresses,
> e.g. my email address olive@zoom.co.uk is registered in mysql database 
> so script should take to download page but it is taking me registration 
> page instead
> any ideas
> <?
> //Author: Ismail Murat Dilek
> 
> require("conn.php");
> /// ========================================================
> // following part read values of entered details and prepares them for 
> mysql data input format
> 
> $email = $HTTP_POST_VARS["email"];
> ///========================================================
> 
> 
> $query ="Select email from details "; // selects email field from details 
> table
> $result = mysql_query($query); //executes sql select query
> $num_result = mysql_num_rows($result);
> /* searches database for email, if email dosent exist writes details to
> database,then redirects user to download page
> */
> for ($i=0; $i<$num_result; $i++)
> {
>     $row= mysql_fetch_array($result);
>     $eml = stripslashes($row[email]);
>     $email = trim($email);
>     $eml = trim($eml);
>     $eq = strcmp($email,$eml);
>     if ($eq != 0)
>     {
>     header("Location:register.php");
>    
>     }
>     else
>     {
>     header("Location:download.php");
>     }
>    
>    
>    
> }//end for
> 
> ?>
> 
> 
> 
> _______________________________________________
> Scottish mailing list
> Scottish@mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/scottish