WebsiteDesigner Posted October 25, 2011 Share Posted October 25, 2011 I have a multiple choice search page which asks visitors to select one or more choices before rendering the search results. It only works in items 1+2 are selected, or 1+2+3, or 1+2+3+4, or 1+2+3+4, etc... I want to make it so that any combination of choices work. Example: Items 1+6 or 2+3+5 or 1+4+6 etc... I have four hours to fix it before my client shows up and need help BADLY. Anyone out there who can help? Whoever can help me... you are the best and I will have a special prayer for you tonight. Here is the coding: <?php } else{ if(!empty($_GET['latt']) && !empty($_GET['long'])) { $condition="SELECT ( 3959 * acos( cos( radians( '".$_GET['latt']."' ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( '".$_GET['long']."' ) ) + sin( radians( '".$_GET['latt']."' ) ) * sin( radians( latitude ) ) ) ) as distance,id,membership FROM notary_members "; if(!empty($_GET['s'])) { $a=" where and"; } else { $a=" where"; } if($_GET['edoc']!='') { $condition.=$a." edoc= 'yes'"; } if($_GET['esign']!='') { if($_GET['edoc']!='') $condition.=" and esign= 'yes'"; else $condition.=$a." esign= 'yes'"; } if($_GET['laserprinter']!='') { if($_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and laserprinter= 'yes'"; else $condition.=" laserprinter= 'yes'"; } if($_GET['dualtray']!='') { if( $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and dualtray= 'yes'"; else $condition.=" dualtray= 'yes'"; } if($_GET['error_in']!='') { if($_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and error_in= 'yes'"; else $condition.=" error_in= 'yes'"; } if($_GET['bg_checked']!='') { if($_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and bg_checked= 'yes'"; else $condition.=" bg_checked= 'yes'"; } if($_GET['home_insp']!='') { if($_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and home_insp= 'yes'"; else $condition.=" home_insp= 'yes'"; } if($_GET['fingerprint']!='') { if($_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and fingerprint= 'yes'"; else $condition.=" fingerprint= 'yes'"; } if($_GET['hosp_signing']!='') { if($_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and hosp_signing= 'yes'"; else $condition.=" hosp_signing= 'yes'"; } if($_GET['jail_signing']!='') { if($_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and jail_signing= 'yes'"; else $condition.=" jail_signing= 'yes'"; } if($_GET['im_docs']!='') { if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and im_docs= 'yes'"; else $condition.=" im_docs= 'yes'"; } if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='' || $_GET['im_docs']!='') { $condition.=" and status=1 order by distance asc"; } else { $condition.=$a." status=1 order by distance asc"; } $sql=mysql_query($condition); $num=mysql_num_rows($sql); $getmile=explode(' ',$_GET['miles']); $c=0; while($getidres=mysql_fetch_array($sql)) { if($getidres['distance']<=$getmile[0]) { if($getidres['membership']=='premium') { $prefirst[$getidres['id']]=$getidres['distance']; $c++; } else { $basicfirst[$getidres['id']]=$getidres['distance']; $c++; } } } if(!empty($sql)) { if($c!=0) { if(!empty($prefirst) || !empty($basicfirst)) { ?> Quote Link to comment https://forums.phpfreaks.com/topic/249813-php-help-with-multiple-choice-for-search-page-mysql/ Share on other sites More sharing options...
jcbones Posted October 26, 2011 Share Posted October 26, 2011 Your logic doesn't have the right flow, try this: <?php } else{ if(!empty($_GET['latt']) && !empty($_GET['long'])) { $condition="SELECT ( 3959 * acos( cos( radians( '".$_GET['latt']."' ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( '".$_GET['long']."' ) ) + sin( radians( '".$_GET['latt']."' ) ) * sin( radians( latitude ) ) ) ) as distance,id,membership FROM notary_members "; //declare an array, this will hold our columns if they are in the search params. $queryCon = array(); //set the columns to an array ONLY if they exist in our search params. if(!empty($_GET['edoc'])) { $queryCon[] = 'edoc=\'yes\''; } if(!empty($_GET['esign'])) { $queryCon[] ="esign= 'yes'"; } if(!empty($_GET['laserprinter'])) { $queryCon[] ="laserprinter= 'yes'"; } if(!empty($_GET['dualtray'])) { $queryCon[] ="dualtray= 'yes'"; } if(!empty($_GET['error_in'])) { $queryCon[] ="error_in= 'yes'"; } if(!empty($_GET['bg_checked'])) { $queryCon[] ="bg_checked= 'yes'"; } if(!empty($_GET['home_insp'])) { $queryCon[] ="home_insp= 'yes'"; } if(!empty($_GET['fingerprint'])) { $queryCon[] ="fingerprint= 'yes'"; } if(!empty($_GET['hosp_signing'])) { $queryCon[] ="hosp_signing= 'yes'"; } if(!empty($_GET['jail_signing'])) { $queryCon[] ="jail_signing= 'yes'"; } if(!empty($_GET['im_docs'])) { $queryCon[] ="im_docs= 'yes'"; } //since you have a constant column called status, then make your WHERE. $condition .= ' WHERE '; //if the array isn't empty (search params exist ) then implode the columns. if(!empty($queryCon)) { $condition .= implode(' AND ',$queryCon) . ' AND '; } //set the last part of the query, which would be the status column, and order by. $condition .= 'status = 1 ORDER BY distance ASC'; $sql=mysql_query($condition); $num=mysql_num_rows($sql); $getmile=explode(' ',$_GET['miles']); $c=0; while($getidres=mysql_fetch_array($sql)) { if($getidres['distance']<=$getmile[0]) { if($getidres['membership']=='premium') { $prefirst[$getidres['id']]=$getidres['distance']; $c++; } else { $basicfirst[$getidres['id']]=$getidres['distance']; $c++; } } } if(!empty($sql)) { if($c!=0) { if(!empty($prefirst) || !empty($basicfirst)) { ?> Functions used: implode empty Quote Link to comment https://forums.phpfreaks.com/topic/249813-php-help-with-multiple-choice-for-search-page-mysql/#findComment-1282257 Share on other sites More sharing options...
WebsiteDesigner Posted October 26, 2011 Author Share Posted October 26, 2011 I am getting an error: Parse error: syntax error, unexpected '}' in /home/content/76/8298276/html/advdetails.php on line 64 Whoever you are..... I am willing to pay you if you can fix the issue within two hours. Let me know. Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/249813-php-help-with-multiple-choice-for-search-page-mysql/#findComment-1282260 Share on other sites More sharing options...
jcbones Posted October 26, 2011 Share Posted October 26, 2011 Since you posted a code snippet, and all of my brackets line up, I cannot tell where the error lies. I do know that you cut the snippet inside of some brackets, make sure you have closing brackets for every opening one. Quote Link to comment https://forums.phpfreaks.com/topic/249813-php-help-with-multiple-choice-for-search-page-mysql/#findComment-1282262 Share on other sites More sharing options...
WebsiteDesigner Posted October 26, 2011 Author Share Posted October 26, 2011 I am sorry I am new to this forum. Here is the full page: <?php include('includes/db.php'); include('includes/functions.php'); function distance($lat1, $lon1, $lat2, $lon2, $unit) { $theta = $lon1 - $lon2; $dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) + cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta)); $dist = acos($dist); $dist = rad2deg($dist); $miles = $dist * 60 * 1.1515; $unit = strtoupper($unit); if ($unit == "K") { return ($miles * 1.609344); } else if ($unit == "N") { return ($miles * 0.8684); } else { return $miles; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US"> <head profile="http://gmpg.org/xfn/11"> <title></title> <meta http-equiv="content-type" content="text/html;charset=UTF-8" /> <meta name="keywords" content="" /> <meta name="description" content="" /> <link rel="shortcut icon" href="images/favicon.ico" /> <link rel="stylesheet" type="text/css" href="css/stylesheet.css" media="screen" /> <link rel="stylesheet" type="text/css" href="css/coin-slider-styles.css" /> <link rel="stylesheet" type="text/css" href="css/menusm.css" /> <link rel="stylesheet" type="text/css" href="css/superfish.css" media="screen" /> <link rel="stylesheet" href="css/pagenavi-css.css" type="text/css" media="screen" /> <script type="text/javascript" src="js/jquery-1.4.2.min.js"></script> <script type="text/javascript" src="js/menusm.js"></script> <script type="text/javascript" src="js/coin-slider.min.js"></script> <script type="text/javascript" src="js/hoverintent.js"></script> <script type="text/javascript" src="js/superfish.js"></script> <link rel="stylesheet" href="css/pagenavi-css.css" type="text/css" media="screen" /> <script type="text/javascript" src="js/fancybox/jquery.min.js"></script> <script> !window.jQuery && document.write('<script src="js/fancybox/jquery-1.4.3.min.js"><\/script>'); </script> <script type="text/javascript" src="js/fancybox/jquery.mousewheel-3.0.4.pack.js"></script> <script type="text/javascript" src="js/fancybox/jquery.fancybox-1.3.4.pack.js"></script> <link rel="stylesheet" type="text/css" href="js/fancybox/jquery.fancybox-1.3.4.css" media="screen" /> <link rel="stylesheet" href="css/fancystyle.css" /> <script type="text/javascript"> $(document).ready(function() { $("a#example").fancybox(); }); </script> </head> <body> <div id="page"> <?php include('header.php'); ?> <div id="columns"><div class="header_left"> <?php include('menu.php'); ?></div><h2 style="padding-top:200px;padding-left:280px;">Please See Your Search Results Below</h2> <div class="clr"></div> <div id="centercol" style="width:700px;"><div class="box post" id="post-41"> <div class="content"> <div class="clr"></div> <div class="post-excerpt"> <?php if(isset($_GET['latt']) && isset($_GET['long'])) { if($_GET['miles']=="Choose miles option...") { $condition="SELECT ( 3959 * acos( cos( radians( '".$_GET['latt']."' ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( '".$_GET['long']."' ) ) + sin( radians( '".$_GET['latt']."' ) ) * sin( radians( latitude ) ) ) ) as distance,id,membership FROM notary_members "; if(!empty($_GET['s'])) { $a=" where and"; } else { $a=" where"; } if($_GET['edoc']!='') { $condition.=$a." edoc= 'yes'"; } if($_GET['esign']!='') { if($_GET['edoc']!='') $condition.=" and esign= 'yes'"; else $condition.=$a." esign= 'yes'"; } if($_GET['laserprinter']!='') { if($_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and laserprinter= 'yes'"; else $condition.=" laserprinter= 'yes'"; } if($_GET['dualtray']!='') { if( $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and dualtray= 'yes'"; else $condition.=" dualtray= 'yes'"; } if($_GET['error_in']!='') { if($_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and error_in= 'yes'"; else $condition.=" error_in= 'yes'"; } if($_GET['bg_checked']!='') { if($_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and bg_checked= 'yes'"; else $condition.=" bg_checked= 'yes'"; } if($_GET['home_insp']!='') { if($_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and home_insp= 'yes'"; else $condition.=" home_insp= 'yes'"; } if($_GET['fingerprint']!='') { if($_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and fingerprint= 'yes'"; else $condition.=" fingerprint= 'yes'"; } if($_GET['hosp_signing']!='') { if($_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and hosp_signing= 'yes'"; else $condition.=" hosp_signing= 'yes'"; } if($_GET['jail_signing']!='') { if($_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and jail_signing= 'yes'"; else $condition.=" jail_signing= 'yes'"; } if($_GET['im_docs']!='') { if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and im_docs= 'yes'"; else $condition.=" im_docs= 'yes'"; } if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='' || $_GET['im_docs']!='') { $condition.=" and status=1 order by distance asc"; } else { $condition.=$a." status=1 order by distance asc"; } $sql=mysql_query($condition); $num=mysql_num_rows($sql); $c=0; while($getidres=mysql_fetch_array($sql)) { if($getidres['distance']<=30) { if($getidres['membership']=='premium') { $prefirst[$getidres['id']]=$getidres['distance']; $c++; } else { $basicfirst[$getidres['id']]=$getidres['distance']; $c++; } } } if(!empty($sql)) { if($c!=0) { if(!empty($prefirst) || !empty($basicfirst)) { ?> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#D4A017;height:20px;" width="1000px"> <tr> <td width="300px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;"> Name</td> <td width="200px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">Company Name</td> <td width="300px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">City, State and Zip Code</td> <td width="100px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">Profile</td> <td width="100px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;font-variant:small-caps;">Estimated Miles</td> </tr></table> <?php } if(!empty($prefirst)) { ?> <table> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#1b76ff;color:#fff;height:20px;" width="1000px"> <tr> <td colspan="3" style="margin-left:10px;text-align:left;font-weight:bold;padding:10px 10px;">Premium Members</td> </tr></table> <tr><td> </td></tr> </table> <?php foreach($prefirst as $key=>$value) { $sql=mysql_query("SELECT * FROM notary_members WHERE id='".$key."'"); $data=mysql_fetch_object($sql); ?> <table border="0" cellpadding="0" cellspacing="0" width="1000px"> <tr onMouseOver="this.style.backgroundColor='#E1EAFE'"; onMouseOut="this.style.backgroundColor='transparent'"> <td width="300" style="text-align:left; height:28px;"> <img src="images/75px-Blue_check_plus.svg.png" width="20" height="15" align="left" style="padding-right:10px;" /> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->firstname." ".$data->lastname; ?> </a></td> <td width="235" style="text-align:left; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php if(!empty($data->bname)) { echo $data->bname; } ?> </a></td> <td width="243" style="text-align:left; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->city." ".$data->state." ".$data->zipcode;?></a></td> <td width="112" style="text-align:left;font-weight:bold; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;">» Profile </a></td> <td width="110" style="text-align:left;font-weight:bold; height:28px;"> <?php echo round($value, 2)." Miles";?></td> </tr></table> <?php } } if(!empty($basicfirst)) { ?> <table><tr><td> </td></tr></table> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#808080;color:#fff;height:20px;" width="1000px"> <tr> <td colspan="3" style="margin-left:10px;text-align:left;font-weight:bold;padding:2px 10px;">Basic Members</td> </tr></table> <tr><td> </td></tr> </table> <?php foreach($basicfirst as $key=>$value) { $sql=mysql_query("SELECT * FROM notary_members WHERE id='".$key."'"); $data=mysql_fetch_object($sql); ?> <table border="0" cellpadding="0" cellspacing="0" width="1000px"> <tr onMouseOver="this.style.backgroundColor='#E1EAFE'"; onMouseOut="this.style.backgroundColor='transparent'"> <td width="300" style="text-align:left;height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal; margin-left:28px;"> <?php echo $data->firstname." ".$data->lastname; ?> </a></td> <td width="237" style="text-align:left;height:28px; "> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php if(!empty($data->bname)) { echo $data->bname; } ?> </a></td> <td width="241" style="text-align:left;height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->city." ".$data->state." ".$data->zipcode;?></a></td> <td width="112" style="text-align:left;font-weight:bold;height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;">» Profile </a></td> <td width="110" style="text-align:left;height:28px;"> <?php echo round($value, 2)." Miles";?></td> </tr></table> <?php } } } else { ?> <div align="center" style="color:#353635;">We are sorry. There are no registered Notary Publics in the area you have selected. You can choose to start a new search <a href="advancedsearch.php" style="text-decoration:none;">(Advanced Search)</a> or <a href="email.php" style="text-decoration:none;">email us here</a>.</br> </br> If you are a Notary Public and wish to advertise your services, simply click on the following link: <a href="membership.php" style="text-decoration:none;">Sign-up</a>. </div> <?php } } else { ?> <div align="center" style="color:#353635;">We are sorry. There are no registered Notary Publics in the area you have selected. You can choose to start a new search <a href="advancedsearch.php" style="text-decoration:none;">(Advanced Search)</a> or <a href="email.php" style="text-decoration:none;">email us here</a>.</br> </br> If you are a Notary Public and wish to advertise your services, simply click on the following link: <a href="membership.php" style="text-decoration:none;">Sign-up</a>. </div> <?php } ?> <?php } else{ if(!empty($_GET['latt']) && !empty($_GET['long'])) { $condition="SELECT ( 3959 * acos( cos( radians( '".$_GET['latt']."' ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( '".$_GET['long']."' ) ) + sin( radians( '".$_GET['latt']."' ) ) * sin( radians( latitude ) ) ) ) as distance,id,membership FROM notary_members "; if(!empty($_GET['s'])) { $a=" where and"; } else { $a=" where"; } if($_GET['edoc']!='') { $condition.=$a." edoc= 'yes'"; } if($_GET['esign']!='') { if($_GET['edoc']!='') $condition.=" and esign= 'yes'"; else $condition.=$a." esign= 'yes'"; } if($_GET['laserprinter']!='') { if($_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and laserprinter= 'yes'"; else $condition.=" laserprinter= 'yes'"; } if($_GET['dualtray']!='') { if( $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and dualtray= 'yes'"; else $condition.=" dualtray= 'yes'"; } if($_GET['error_in']!='') { if($_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and error_in= 'yes'"; else $condition.=" error_in= 'yes'"; } if($_GET['bg_checked']!='') { if($_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and bg_checked= 'yes'"; else $condition.=" bg_checked= 'yes'"; } if($_GET['home_insp']!='') { if($_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and home_insp= 'yes'"; else $condition.=" home_insp= 'yes'"; } if($_GET['fingerprint']!='') { if($_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and fingerprint= 'yes'"; else $condition.=" fingerprint= 'yes'"; } if($_GET['hosp_signing']!='') { if($_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and hosp_signing= 'yes'"; else $condition.=" hosp_signing= 'yes'"; } if($_GET['jail_signing']!='') { if($_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and jail_signing= 'yes'"; else $condition.=" jail_signing= 'yes'"; } if($_GET['im_docs']!='') { if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and im_docs= 'yes'"; else $condition.=" im_docs= 'yes'"; } if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='' || $_GET['im_docs']!='') { $condition.=" and status=1 order by distance asc"; } else { $condition.=$a." status=1 order by distance asc"; } $sql=mysql_query($condition); $num=mysql_num_rows($sql); $getmile=explode(' ',$_GET['miles']); $c=0; while($getidres=mysql_fetch_array($sql)) { if($getidres['distance']<=$getmile[0]) { if($getidres['membership']=='premium') { $prefirst[$getidres['id']]=$getidres['distance']; $c++; } else { $basicfirst[$getidres['id']]=$getidres['distance']; $c++; } } } if(!empty($sql)) { if($c!=0) { if(!empty($prefirst) || !empty($basicfirst)) { ?> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#D4A017;height:20px;" width="1000px"> <tr> <td width="300px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">Notary Public Name</td> <td width="200px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">Company Name</td> <td width="300px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">City, State and Zip Code</td> <td width="100px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;font-variant:small-caps;">Profile</td> <td width="100px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;font-variant:small-caps;">Estimated Miles</td> </tr></table> <?php } if(!empty($prefirst)) { ?> <table> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#1b76ff;color:#fff;height:20px;" width="1000px"> <tr> <td colspan="3" style="margin-left:10px;text-align:left;font-weight:bold;padding:10px 10px;">Premium Members</td> </tr></table> <tr><td> </td></tr> </table> <?php foreach($prefirst as $key=>$value) { $sql=mysql_query("SELECT * FROM notary_members WHERE id='".$key."'"); $data=mysql_fetch_object($sql); ?> <table border="0" cellpadding="0" cellspacing="0" width="1000px"> <tr> <td width="300" style="text-align:left; height:28px;"> <img src="images/75px-Blue_check_plus.svg.png" width="20" height="15" align="left" style="padding-right:10px;" /> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->firstname." ".$data->lastname; ?> </a></td> <td width="231" style="text-align:left; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php if(!empty($data->bname)) { echo $data->bname; } ?> </a></td> <td width="247" style="text-align:left; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->city." ".$data->state." ".$data->zipcode;?></a></td> <td width="112" style="text-align:left;font-weight:bold; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;"> » Profile </a></td> <td width="110" style="text-align:left;font-weight:bold; height:28px;"> <?php echo round($value, 2)." Miles";?></td> </tr></table> <?php } } if(!empty($basicfirst)) { ?> <table><tr><td> </td></tr></table> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#808080;color:#fff;height:20px;" width="1000px"> <tr> <td colspan="3" style="margin-left:10px;text-align:left;font-weight:bold;padding:2px 10px;">Basic Members</td> </tr></table> <tr><td> </td></tr> </table> <?php foreach($basicfirst as $key=>$value) { $sql=mysql_query("SELECT * FROM notary_members WHERE id='".$key."'"); $data=mysql_fetch_object($sql); ?> <table border="0" cellpadding="0" cellspacing="0" width="1000px"> <tr> <td width="293" style="text-align:left;border-right:solid 1px #fff; height:28px; "> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal; margin-left:28px;"> <?php echo $data->firstname." ".$data->lastname; ?></a></td> <td width="239" style="text-align:left;border-right:solid 1px #fff; height:28px;"><?php if(!empty($data->bname)) { echo $data->bname; } ?></td> <td width="227" style="text-align:left;border-right:solid 1px #fff; height:28px;"> <?php echo $data->city." ".$data->state." ".$data->zipcode;?></td> <td width="21"></td> <td width="110" style="text-align:left;font-weight:bold; height:28px;"><a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;">» Profile </a></td> <td width="110" style="text-align:left; height:28px;"> <?php echo round($value, 2)." Miles";?></td> </tr></table> <?php } } } else { ?> <div align="center" style="color:#353635;">We are sorry. There are no registered Notary Publics in the area you have selected. You can choose to start a new search <a href="advancedsearch.php" style="text-decoration:none;">(Advanced Search)</a> or <a href="email.php" style="text-decoration:none;">email us here</a>.</br> </br> If you are a Notary Public and wish to advertise your services, simply click on the following link: <a href="membership.php" style="text-decoration:none;">Sign-up</a>. </div> <?php } } }else {?> <div align="center" style="color:#353635;">We are sorry. There are no registered Notary Publics in the area you have selected. You can choose to start a new search <a href="advancedsearch.php" style="text-decoration:none;">(Advanced Search)</a> or <a href="email.php" style="text-decoration:none;">email us here</a>.</br> </br> If you are a Notary Public and wish to advertise your services, simply click on the following link: <a href="membership.php" style="text-decoration:none;">Sign-up</a>. </div> <?php } } } ?> </div> </div></div> <div class="clr"></div> </div> <div class="clr"></div></div> <div class="clr"></div></div> <?php include('footer.php'); ?><div class="clr"></div> </div></body></html> Quote Link to comment https://forums.phpfreaks.com/topic/249813-php-help-with-multiple-choice-for-search-page-mysql/#findComment-1282265 Share on other sites More sharing options...
jcbones Posted October 26, 2011 Share Posted October 26, 2011 Please put all future code inside of tags, it will help keep the thread cleaner. This script has no parse errors, I have included what I wrote into the appropriate place. You could also insert it into the top search as well. <?php include('includes/db.php'); include('includes/functions.php'); function distance($lat1, $lon1, $lat2, $lon2, $unit) { $theta = $lon1 - $lon2; $dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) + cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta)); $dist = acos($dist); $dist = rad2deg($dist); $miles = $dist * 60 * 1.1515; $unit = strtoupper($unit); if ($unit == "K") { return ($miles * 1.609344); } else if ($unit == "N") { return ($miles * 0.8684); } else { return $miles; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US"> <head profile="http://gmpg.org/xfn/11"> <title></title> <meta http-equiv="content-type" content="text/html;charset=UTF-8" /> <meta name="keywords" content="" /> <meta name="description" content="" /> <link rel="shortcut icon" href="images/favicon.ico" /> <link rel="stylesheet" type="text/css" href="css/stylesheet.css" media="screen" /> <link rel="stylesheet" type="text/css" href="css/coin-slider-styles.css" /> <link rel="stylesheet" type="text/css" href="css/menusm.css" /> <link rel="stylesheet" type="text/css" href="css/superfish.css" media="screen" /> <link rel="stylesheet" href="css/pagenavi-css.css" type="text/css" media="screen" /> <script type="text/javascript" src="js/jquery-1.4.2.min.js"></script> <script type="text/javascript" src="js/menusm.js"></script> <script type="text/javascript" src="js/coin-slider.min.js"></script> <script type="text/javascript" src="js/hoverintent.js"></script> <script type="text/javascript" src="js/superfish.js"></script> <link rel="stylesheet" href="css/pagenavi-css.css" type="text/css" media="screen" /> <script type="text/javascript" src="js/fancybox/jquery.min.js"></script> <script> !window.jQuery && document.write('<script src="js/fancybox/jquery-1.4.3.min.js"><\/script>'); </script> <script type="text/javascript" src="js/fancybox/jquery.mousewheel-3.0.4.pack.js"></script> <script type="text/javascript" src="js/fancybox/jquery.fancybox-1.3.4.pack.js"></script> <link rel="stylesheet" type="text/css" href="js/fancybox/jquery.fancybox-1.3.4.css" media="screen" /> <link rel="stylesheet" href="css/fancystyle.css" /> <script type="text/javascript"> $(document).ready(function() { $("a#example").fancybox(); }); </script> </head> <body> <div id="page"> <?php include('header.php'); ?> <div id="columns"><div class="header_left"> <?php include('menu.php'); ?></div><h2 style="padding-top:200px;padding-left:280px;">Please See Your Search Results Below</h2> <div class="clr"></div> <div id="centercol" style="width:700px;"><div class="box post" id="post-41"> <div class="content"> <div class="clr"></div> <div class="post-excerpt"> <?php if(isset($_GET['latt']) && isset($_GET['long'])) { if($_GET['miles']=="Choose miles option...") { $condition="SELECT ( 3959 * acos( cos( radians( '".$_GET['latt']."' ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( '".$_GET['long']."' ) ) + sin( radians( '".$_GET['latt']."' ) ) * sin( radians( latitude ) ) ) ) as distance,id,membership FROM notary_members "; if(!empty($_GET['s'])) { $a=" where and"; } else { $a=" where"; } if($_GET['edoc']!='') { $condition.=$a." edoc= 'yes'"; } if($_GET['esign']!='') { if($_GET['edoc']!='') $condition.=" and esign= 'yes'"; else $condition.=$a." esign= 'yes'"; } if($_GET['laserprinter']!='') { if($_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and laserprinter= 'yes'"; else $condition.=" laserprinter= 'yes'"; } if($_GET['dualtray']!='') { if( $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and dualtray= 'yes'"; else $condition.=" dualtray= 'yes'"; } if($_GET['error_in']!='') { if($_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and error_in= 'yes'"; else $condition.=" error_in= 'yes'"; } if($_GET['bg_checked']!='') { if($_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and bg_checked= 'yes'"; else $condition.=" bg_checked= 'yes'"; } if($_GET['home_insp']!='') { if($_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and home_insp= 'yes'"; else $condition.=" home_insp= 'yes'"; } if($_GET['fingerprint']!='') { if($_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and fingerprint= 'yes'"; else $condition.=" fingerprint= 'yes'"; } if($_GET['hosp_signing']!='') { if($_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and hosp_signing= 'yes'"; else $condition.=" hosp_signing= 'yes'"; } if($_GET['jail_signing']!='') { if($_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and jail_signing= 'yes'"; else $condition.=" jail_signing= 'yes'"; } if($_GET['im_docs']!='') { if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='') $condition.=" and im_docs= 'yes'"; else $condition.=" im_docs= 'yes'"; } if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='' || $_GET['im_docs']!='') { $condition.=" and status=1 order by distance asc"; } else { $condition.=$a." status=1 order by distance asc"; } $sql=mysql_query($condition); $num=mysql_num_rows($sql); $c=0; while($getidres=mysql_fetch_array($sql)) { if($getidres['distance']<=30) { if($getidres['membership']=='premium') { $prefirst[$getidres['id']]=$getidres['distance']; $c++; } else { $basicfirst[$getidres['id']]=$getidres['distance']; $c++; } } } if(!empty($sql)) { if($c!=0) { if(!empty($prefirst) || !empty($basicfirst)) { ?> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#D4A017;height:20px;" width="1000px"> <tr> <td width="300px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;"> Name</td> <td width="200px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">Company Name</td> <td width="300px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">City, State and Zip Code</td> <td width="100px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">Profile</td> <td width="100px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;font-variant:small-caps;">Estimated Miles</td> </tr></table> <?php } if(!empty($prefirst)) { ?> <table> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#1b76ff;color:#fff;height:20px;" width="1000px"> <tr> <td colspan="3" style="margin-left:10px;text-align:left;font-weight:bold;padding:10px 10px;">Premium Members</td> </tr></table> <tr><td> </td></tr> </table> <?php foreach($prefirst as $key=>$value) { $sql=mysql_query("SELECT * FROM notary_members WHERE id='".$key."'"); $data=mysql_fetch_object($sql); ?> <table border="0" cellpadding="0" cellspacing="0" width="1000px"> <tr onMouseOver="this.style.backgroundColor='#E1EAFE'"; onMouseOut="this.style.backgroundColor='transparent'"> <td width="300" style="text-align:left; height:28px;"> <img src="images/75px-Blue_check_plus.svg.png" width="20" height="15" align="left" style="padding-right:10px;" /> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->firstname." ".$data->lastname; ?> </a></td> <td width="235" style="text-align:left; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php if(!empty($data->bname)) { echo $data->bname; } ?> </a></td> <td width="243" style="text-align:left; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->city." ".$data->state." ".$data->zipcode;?></a></td> <td width="112" style="text-align:left;font-weight:bold; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;">» Profile </a></td> <td width="110" style="text-align:left;font-weight:bold; height:28px;"> <?php echo round($value, 2)." Miles";?></td> </tr></table> <?php } } if(!empty($basicfirst)) { ?> <table><tr><td> </td></tr></table> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#808080;color:#fff;height:20px;" width="1000px"> <tr> <td colspan="3" style="margin-left:10px;text-align:left;font-weight:bold;padding:2px 10px;">Basic Members</td> </tr></table> <tr><td> </td></tr> </table> <?php foreach($basicfirst as $key=>$value) { $sql=mysql_query("SELECT * FROM notary_members WHERE id='".$key."'"); $data=mysql_fetch_object($sql); ?> <table border="0" cellpadding="0" cellspacing="0" width="1000px"> <tr onMouseOver="this.style.backgroundColor='#E1EAFE'"; onMouseOut="this.style.backgroundColor='transparent'"> <td width="300" style="text-align:left;height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal; margin-left:28px;"> <?php echo $data->firstname." ".$data->lastname; ?> </a></td> <td width="237" style="text-align:left;height:28px; "> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php if(!empty($data->bname)) { echo $data->bname; } ?> </a></td> <td width="241" style="text-align:left;height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->city." ".$data->state." ".$data->zipcode;?></a></td> <td width="112" style="text-align:left;font-weight:bold;height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;">» Profile </a></td> <td width="110" style="text-align:left;height:28px;"> <?php echo round($value, 2)." Miles";?></td> </tr></table> <?php } } } else { ?> <div align="center" style="color:#353635;">We are sorry. There are no registered Notary Publics in the area you have selected. You can choose to start a new search <a href="advancedsearch.php" style="text-decoration:none;">(Advanced Search)</a> or <a href="email.php" style="text-decoration:none;">email us here</a>.</br> </br> If you are a Notary Public and wish to advertise your services, simply click on the following link: <a href="membership.php" style="text-decoration:none;">Sign-up</a>. </div> <?php } } else { ?> <div align="center" style="color:#353635;">We are sorry. There are no registered Notary Publics in the area you have selected. You can choose to start a new search <a href="advancedsearch.php" style="text-decoration:none;">(Advanced Search)</a> or <a href="email.php" style="text-decoration:none;">email us here</a>.</br> </br> If you are a Notary Public and wish to advertise your services, simply click on the following link: <a href="membership.php" style="text-decoration:none;">Sign-up</a>. </div> <?php } ?> <?php } else{ if(!empty($_GET['latt']) && !empty($_GET['long'])) { $condition="SELECT ( 3959 * acos( cos( radians( '".$_GET['latt']."' ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( '".$_GET['long']."' ) ) + sin( radians( '".$_GET['latt']."' ) ) * sin( radians( latitude ) ) ) ) as distance,id,membership FROM notary_members "; //declare an array, this will hold our columns if they are in the search params. $queryCon = array(); //set the columns to an array ONLY if they exist in our search params. if(!empty($_GET['edoc'])) { $queryCon[] = 'edoc=\'yes\''; } if(!empty($_GET['esign'])) { $queryCon[] ="esign= 'yes'"; } if(!empty($_GET['laserprinter'])) { $queryCon[] ="laserprinter= 'yes'"; } if(!empty($_GET['dualtray'])) { $queryCon[] ="dualtray= 'yes'"; } if(!empty($_GET['error_in'])) { $queryCon[] ="error_in= 'yes'"; } if(!empty($_GET['bg_checked'])) { $queryCon[] ="bg_checked= 'yes'"; } if(!empty($_GET['home_insp'])) { $queryCon[] ="home_insp= 'yes'"; } if(!empty($_GET['fingerprint'])) { $queryCon[] ="fingerprint= 'yes'"; } if(!empty($_GET['hosp_signing'])) { $queryCon[] ="hosp_signing= 'yes'"; } if(!empty($_GET['jail_signing'])) { $queryCon[] ="jail_signing= 'yes'"; } if(!empty($_GET['im_docs'])) { $queryCon[] ="im_docs= 'yes'"; } //since you have a constant column called status, then make your WHERE. $condition .= ' WHERE '; //if the array isn't empty (search params exist ) then implode the columns. if(!empty($queryCon)) { $condition .= implode(' AND ',$queryCon) . ' AND '; } //set the last part of the query, which would be the status column, and order by. $condition .= 'status = 1 ORDER BY distance ASC'; $sql=mysql_query($condition); $num=mysql_num_rows($sql); $getmile=explode(' ',$_GET['miles']); $c=0; while($getidres=mysql_fetch_array($sql)) { if($getidres['distance']<=$getmile[0]) { if($getidres['membership']=='premium') { $prefirst[$getidres['id']]=$getidres['distance']; $c++; } else { $basicfirst[$getidres['id']]=$getidres['distance']; $c++; } } } if(!empty($sql)) { if($c!=0) { if(!empty($prefirst) || !empty($basicfirst)) { ?> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#D4A017;height:20px;" width="1000px"> <tr> <td width="300px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">Notary Public Name</td> <td width="200px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">Company Name</td> <td width="300px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;border-right:solid 1px #fff;font-variant:small-caps;">City, State and Zip Code</td> <td width="100px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;font-variant:small-caps;">Profile</td> <td width="100px" style="margin-left:10px;text-align:center;font-weight:bold;padding:10px;font-variant:small-caps;">Estimated Miles</td> </tr></table> <?php } if(!empty($prefirst)) { ?> <table> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#1b76ff;color:#fff;height:20px;" width="1000px"> <tr> <td colspan="3" style="margin-left:10px;text-align:left;font-weight:bold;padding:10px 10px;">Premium Members</td> </tr></table> <tr><td> </td></tr> </table> <?php foreach($prefirst as $key=>$value) { $sql=mysql_query("SELECT * FROM notary_members WHERE id='".$key."'"); $data=mysql_fetch_object($sql); ?> <table border="0" cellpadding="0" cellspacing="0" width="1000px"> <tr> <td width="300" style="text-align:left; height:28px;"> <img src="images/75px-Blue_check_plus.svg.png" width="20" height="15" align="left" style="padding-right:10px;" /> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->firstname." ".$data->lastname; ?> </a></td> <td width="231" style="text-align:left; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php if(!empty($data->bname)) { echo $data->bname; } ?> </a></td> <td width="247" style="text-align:left; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal;"> <?php echo $data->city." ".$data->state." ".$data->zipcode;?></a></td> <td width="112" style="text-align:left;font-weight:bold; height:28px;"> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;"> » Profile </a></td> <td width="110" style="text-align:left;font-weight:bold; height:28px;"> <?php echo round($value, 2)." Miles";?></td> </tr></table> <?php } } if(!empty($basicfirst)) { ?> <table><tr><td> </td></tr></table> <table border="0" cellpadding="0" cellspacing="0" style="background-color:#808080;color:#fff;height:20px;" width="1000px"> <tr> <td colspan="3" style="margin-left:10px;text-align:left;font-weight:bold;padding:2px 10px;">Basic Members</td> </tr></table> <tr><td> </td></tr> </table> <?php foreach($basicfirst as $key=>$value) { $sql=mysql_query("SELECT * FROM notary_members WHERE id='".$key."'"); $data=mysql_fetch_object($sql); ?> <table border="0" cellpadding="0" cellspacing="0" width="1000px"> <tr> <td width="293" style="text-align:left;border-right:solid 1px #fff; height:28px; "> <a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;color:#353635;font-weight:normal; margin-left:28px;"> <?php echo $data->firstname." ".$data->lastname; ?></a></td> <td width="239" style="text-align:left;border-right:solid 1px #fff; height:28px;"><?php if(!empty($data->bname)) { echo $data->bname; } ?></td> <td width="227" style="text-align:left;border-right:solid 1px #fff; height:28px;"> <?php echo $data->city." ".$data->state." ".$data->zipcode;?></td> <td width="21"></td> <td width="110" style="text-align:left;font-weight:bold; height:28px;"><a href="notarydetails.php?id=<?php echo $data->id;?>" style="text-decoration:none;">» Profile </a></td> <td width="110" style="text-align:left; height:28px;"> <?php echo round($value, 2)." Miles";?></td> </tr></table> <?php } } } else { ?> <div align="center" style="color:#353635;">We are sorry. There are no registered Notary Publics in the area you have selected. You can choose to start a new search <a href="advancedsearch.php" style="text-decoration:none;">(Advanced Search)</a> or <a href="email.php" style="text-decoration:none;">email us here</a>.</br> </br> If you are a Notary Public and wish to advertise your services, simply click on the following link: <a href="membership.php" style="text-decoration:none;">Sign-up</a>. </div> <?php } } }else {?> <div align="center" style="color:#353635;">We are sorry. There are no registered Notary Publics in the area you have selected. You can choose to start a new search <a href="advancedsearch.php" style="text-decoration:none;">(Advanced Search)</a> or <a href="email.php" style="text-decoration:none;">email us here</a>.</br> </br> If you are a Notary Public and wish to advertise your services, simply click on the following link: <a href="membership.php" style="text-decoration:none;">Sign-up</a>. </div> <?php } } } ?> </div> </div></div> <div class="clr"></div> </div> <div class="clr"></div></div> <div class="clr"></div></div> <?php include('footer.php'); ?><div class="clr"></div> </div></body></html> Quote Link to comment https://forums.phpfreaks.com/topic/249813-php-help-with-multiple-choice-for-search-page-mysql/#findComment-1282272 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.