[Scottish] php and my sql

[george]

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 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
>>
>>
>>  
>>
> 
> 
> 
> _______________________________________________
> Scottish mailing list
> Scottish@mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/scottish
>