i am loosing the value $areacode when i am resubmitting the form

reddymade

I am loosing the value of the $areacode, when the user clicks the next button to get the next set of 5 records that time, $areacode is becoming null. only first time the value is staying in the variable $areacode, can you please tell me how can i keep the value of $areacode in it. means after i am submitting the form only for the first time the value under areacode is being used and from next time onwards $areacode is becoming null. Please help.
for example if i enter 305 as areacode under text box area code and click button search, it gets the 5 records first time properly and when i click the next hyperlink it has to get the next set of 5 matching areacode records from same table, that time it is $areacode becoming null.


if( $areacode!=null ){
     $areacode_substr = " and a.areacode like '%".$areacode."%' ";
}else{
     $areacode_substr = "";
}


$strSQL = "Select distinct a.id, a.login, SUBSTRING(a.comment,1, 165) as comment, a.gender, a.date_birthday, a.icon_path, j.default_icon as icon_path_default, c.".$field_name." as country 
from ".USERS_TABLE." a
left join ".REFERENCE_LANG_TABLE." c on c.id_reference=a.id_country and c.table_key='".$multi_lang->TableKey(COUNTRY_SPR_TABLE)."'
where a.gender='".$gender_2."'  

and STRCMP(date_format(a.date_birthday, '%Y%m%d'), date_format('".DateFromAge($age_min-1)."', '%Y%m%d')) <=0
and STRCMP(date_format(a.date_birthday, '%Y%m%d'), date_format('".DateFromAge($age_max+1)."', '%Y%m%d')) >= 0
and a.id <> '".$user[0]."' ".$areacode_substr."
and a.id != '".$user[0]."' order by a.id limit 5, 5;


$rs = $dbconn->Execute($strSQL);

thank you very much for the information.

sneakyimp

you post is not very clear and the code you have posted looks incomplete to me

BUT

you should know that if you submit some value for $areacode from a form to a PHP script, then the value $areacode might be defined in that php script that receives the form submission. if you then click 'next' or some other link that takes you to a new script, then that new script will have NO IDEA what the value of areacode was. You will have to find some way to propagate the value to the next page. 1 way is to have the 'next' button submit a form which submits the areacode value to the next script. another way is to append the value of $areacode to the url that takes you to the new script like this

you could also store areacode in the user's session.

reddymade

Hello Sneakyimp,

When the user is clicking next it does'nt go to a next different page, it stays on the same page and page only gets resubmitted. that time i am loosing the value which was in areacode and the condition is showing areacode as null, how can i keep the value of areacode in memory and then reuse it when the user clicks next or previous hyperlinks.

I am also attaching my .php form the code is on line 423, please help that will be a great favor for me. or atleast give me idea.

Thank you very much.

sneakyimp

ok so the page is getting resubmitted but you are not submitting the areacode the second time. the only way variables can have a value in a script is if you

a) define them explicitly in php
b) submit them with a form
c) read them from a database or file
d) read them from a cookie

you should probably put the $areacode value in a hidden input in the form so that when you submit it the second time, it is defined.