That should be fetch
G
george wrote:
I would tend to use a while loop
while($row=mysql_fetch_array($results))
{
// Do some stuff
}
to be perfectly honest I would probably use mysql_feetch_object() instead
George
Ismail Murat Dilek wrote:
Hi
Sillly me. Removing redirect header to out side for loop and adding
exit solved it,
Graeme Chambers wrote:
Hi,
The For loop on first execution sends the redirect header based on first
test 9i.e. first email address returned from database).
Suggest you include email address from form into SELECT query and decide
what to do on basis of number of records returned.
HTH
Graeme
On Tue, 2003-02-11 at 12:22, Ismail Murat Dilek wrote:
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 [EMAIL PROTECTED] 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
[EMAIL PROTECTED]
http://mailman.lug.org.uk/mailman/listinfo/scottish
_______________________________________________
Scottish mailing list
[EMAIL PROTECTED]
http://mailman.lug.org.uk/mailman/listinfo/scottish
_______________________________________________
Scottish mailing list
[EMAIL PROTECTED]
http://mailman.lug.org.uk/mailman/listinfo/scottish
_______________________________________________
Scottish mailing list
[EMAIL PROTECTED]
http://mailman.lug.org.uk/mailman/listinfo/scottish
