Search result for add more fields script

muzaffar · June 18, 2013, 11:05am

How do i made recordset for add more fields script so that users can update later also
This code is related to Parent adding family details(add more fields script is used) and much more like simple matrimony site.
Example,My name is jone and i have three children ie jone1 (Age:25,Gender:male,status:divorced),jone2
(Age:18,Gender:female,status:unmarried),jone3 (Age:30,Gender:male,status:separated).If user search country:japan,Age:25,Gender:male,status:divorced then use get the result for only jone1 row(add more fields
script) and jone2 + jone3 does not be show in result.Keeping headname,native,country,state of parent default execute.
I put all the detail in server .Please refer to this link and if you have any solution tell me or you can give me hint also. caringhandsrehab.in/addmore/index.php

[php]<!doctype html>

Untitled Document </head Looking for male female Age from 18 19 20 21 22 23 24 25 26 Age to 18 19 20 21 Marital Status Unmarried Widow/Widower

<input type="submit" name="doSearch"  id="doSearch2" value="Search" />
</form>

<?php $doSearch = $_GET['doSearch']; if($_REQUEST["search_gender"] <>'' && $_REQUEST["search_from"] <>'' && $_REQUEST["search_to"] <>'' && $_REQUEST["search_status"] <>'' && $_REQUEST["offcountry"] <>'' && $_REQUEST["offstate"] <>'') { $sql = "select * from users u LEFT JOIN web w on (w.id = u.id) WHERE MATCH(id,full_name,native,country,state) AGAINST('%$doSearch%' IN BOOLEAN MODE) "; } $sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql); if (mysql_num_rows($sql_result)>0) { while ($row = mysql_fetch_assoc($sql_result)) { ?> <?php } } else { ?> <?php } ?>

ID	Head name	Native place	Name	Gender	Birthdate	Age	Relation	Education	Status	Detail
<?php echo $row["id"]; ?>	<?php echo $row["full_name"]; ?>	<?php echo $row["native"]; ?>	<?php echo $row["dynname"]; ?>	<?php echo $row["dyngender"]; ?>	<?php echo $row["dyndob"]; ?>	<?php echo $row["dynage"]; ?>	<?php echo $row["dynrelation"]; ?>	<?php echo $row["dyneducation"]; ?>	<?php echo $row["dynstatus"]; ?>	<?php echo '?id='. $row['id']; ?>
No results found.

[/php]