Mysql search

[rudyseema]

Hi,
I need to get a search result from two tables, the details will be filled in and i need the sql statement which will take the filled in data and get the result.

i wrote one statement but its not correct, i am postingit so you can correct it,

"SELECT members_main.*,members_addresses.* FROM members_main,members_addresses WHERE members_main.id=members_addresses.mid
AND partner_code='$_POST[pcode]', $name='$_POST[value]', special_cat='$_POST[cat]', pcountry='$_POST[country]', sex='$_POST[gender]',
age='$_POST[age]', marital_status='$_POST[mart]'"

earlier i've put the values in variables,
Thanks :)

[ronverdonk]

In my opinion this should be:

WHERE members_main.id=members_addresses.mid
AND partner_code='$_POST[pcode]' 
AND $name='$_POST[value]' 
AND special_cat='$_POST[cat]' 
AND pcountry='$_POST[country]' 
AND sex='$_POST[gender]'
AND age='$_POST[age]' 
AND marital_status='$_POST[mart]'"
 

Ronald :cool:

[Devendra]

Currect syntax for post data as a string columnName=\''.$_POST['formFieldName'].'\'
and for numeric value columnName=\''.$_POST['formFieldName'].'/'

'SELECT members_main.*,members_addresses.* FROM members_main,members_addresses WHERE members_main.id=members_addresses.mid
AND partner_code=\''.$_POST[pcode].'\', $name=\''.$_POST[value].'\', special_cat=\''.$_POST[cat].'\',
pcountry=\''$_POST[country].'\', sex=\''.$_POST[gender]\'',
age=\''$_POST[age]', marital_status=\''$_POST[mart]'\' ';