stephen_
01-20-2012, 03:36 PM
I have some .js that allows me to connect to my sql database and plot all lat's and longs, yet the page I want it displayed is a results page from a form.
The query I currently have in the google api script is;
<?
$query = mysql_query("SELECT * FROM `family_support` WHERE 1");
while ($row = mysql_fetch_array($query)){
$org_name=$row['org_name'];
$lat=$row['lat'];
$long=$row['long'];
$org_address=$row['org_address'];
echo ("addMarker($lat, $long,'<b>$org_name</b><br/>$org_address');\n");
}
?>
i would like this to change (as it is displaying all rows currently) to the query I have in the results page;
$sql_result= "SELECT * FROM family_support WHERE org_name LIKE '%$org_name%'";
if ($area != 'All') {
$sql_result .=" AND area LIKE '%$area%'";
}
if ($services != 'All') {
$sql_result .=" AND services LIKE '%$services%'";
}
if ($hardiker != 'All') {
$sql_result .=" AND hardiker = '$hardiker'";
}
$sql_result .=" ORDER BY org_name";
//echo $sql_result;
$result = mysql_query($sql_result, $dbh) or die ('Database currently being updated, please try again later!');
$num=mysql_numrows($result);
Is this possible?
The query I currently have in the google api script is;
<?
$query = mysql_query("SELECT * FROM `family_support` WHERE 1");
while ($row = mysql_fetch_array($query)){
$org_name=$row['org_name'];
$lat=$row['lat'];
$long=$row['long'];
$org_address=$row['org_address'];
echo ("addMarker($lat, $long,'<b>$org_name</b><br/>$org_address');\n");
}
?>
i would like this to change (as it is displaying all rows currently) to the query I have in the results page;
$sql_result= "SELECT * FROM family_support WHERE org_name LIKE '%$org_name%'";
if ($area != 'All') {
$sql_result .=" AND area LIKE '%$area%'";
}
if ($services != 'All') {
$sql_result .=" AND services LIKE '%$services%'";
}
if ($hardiker != 'All') {
$sql_result .=" AND hardiker = '$hardiker'";
}
$sql_result .=" ORDER BY org_name";
//echo $sql_result;
$result = mysql_query($sql_result, $dbh) or die ('Database currently being updated, please try again later!');
$num=mysql_numrows($result);
Is this possible?