query search

nuser

Hi
I have created a database and i would like to read the output base on a specific field. Can i do this?😕

<?
include("dbase.php");
$numresults = mysql_query("SELECT * FROM mytable WHERE 
										city LIKE '%{$search}%' AND
		        state LIKE '%{$search1}%'"); 
while ($data=mysql_fetch_array( $numresults )) {
	if ($data['city'] == 'search' and $data['state']=='state'); 
 echo $data['name']."<br />".$data['address']."<br/>".$data['city']."<br />"."<br />";

} else { 
echo "no data found"; 
}

?>

leatherback

yes you can.

Your code is full of inconsistencies, but you are on the right track. Make sure you have the variables names right though..

nuser

I am new to php and sql. Shouldn't the code below just give me result for the city and state i input? are am i way off track? I would like to get the output for just the city and state i select. 😕

<? 
include("dbase.php"); 
$numresults = mysql_query("SELECT * FROM mytable WHERE 
                                        city LIKE '%{$search}%' AND 
                                        state LIKE '%{$search1}%'"); 
while ($data=mysql_fetch_array( $numresults )) { 
    echo $data['name']."<br />".$data['address']."<br/>".$data['city']."<br />"."<br />"; 

} else { 
echo "no data found"; 
} 

?>

leatherback

In principle it should. How do you set the $search and $search1 variables?

// get the data from the post array
$search = $_POST['search'];
$search1 = $_POST['search1'];

if($search <> '' && $search1 <> '')
  {
  // database connection
  include("dbase.php");

  // create the query  

  $query = "SELECT * FROM mytable WHERE
                                        city = '".$search."' AND
                                        state = '".$search1."' ";

  // run the query
  $res = mysql_query($query) or die(mysql_error());
  if($res)
    {
    while($row = mysql_fetch_array($res))
      {
      echo $row['name']."<br />".$row['address']."<br/>".$row['city']."<br />"."<br />";
      }
    }
  }
else
  {
  echo 'You missed a field';
  }

nuser

Thanks for your help it is working fine but i am trying to replace this

<?

//get the data from the post array
$search = $POST['search'];
$search1 = $POST['search1'];

if($search <> '' && $search1 <> '')
{
// database connection
include("db.php");

// create the query

$query = "SELECT * FROM caribbean WHERE
city = '".$search."' AND
state = '".$search1."' ";

// run the query
$res = mysql_query($query) or die(mysql_error());
if($res)
{
while($data = mysql_fetch_array($res))
}
echo $row['name']." ".$row['address']." ".$row['city']." ".$row['state']. $row['zip']." ". $row['country']." ".$row['phone']." ".$row['companytype']." ";
}
}
}
else
{
echo 'You missed a field';
}
?>

with this

<?

//get the data from the post array
$search = $POST['search'];
$search1 = $POST['search1'];

if($search <> '' && $search1 <> '')
{
// database connection
include("db.php");

// create the query

$query = "SELECT * FROM caribbean WHERE
city = '".$search."' AND
state = '".$search1."' ";

// run the query
$res = mysql_query($query) or die(mysql_error());
if($res)
{
while($data = mysql_fetch_array($res))
}
?>
<?=$data['name']?> <?=$data['address']?> <?=.$data['city']?> <?=$data["state"]?> <?=$data["zip"]?> 
<?=$data["country"]?> <?=$data["phone"]?> <?=$data["companytype"]?>
<?
}
}
}
else
{
echo 'You missed a field';
}
?>

and I get this

Parse error: syntax error, unexpected '.' in /home/cgowie/public_html/caribbean/testsearch.php on line 23

laserlight

Look carefully to find the syntax error:

if($res)
{
while($data = mysql_fetch_array($res))
}

You should indent your code.

nuser

Thanks i found the error but now i get output form the echo

you missed a field

<? 

//get the data from the post array 
$search = $_POST['search']; 
$search1 = $_POST['search1']; 

if($search <> '' && $search1 <> '') 
  { 
  // database connection 
  include("db.php"); 

  // create the query   

  $query = "SELECT * FROM mytable WHERE 
                                        city = '".$search."' AND 
                                        state = '".$search1."'"; 

  // run the query 
  $res = mysql_query($query) or die(mysql_error()); 
  if($res) 
    { 
    while($data = mysql_fetch_array($res)) 
   ?> 
 <p><?=$data["name"]?><br><?=$data["address"]?><br><?=$data["city"]?>&nbsp;<?=$data["state"]?>&nbsp;<?=$data["zip"]?><br>
<?=$data["country"]?><br><?=$data["phone"]?><br><?=$data["companytype"]?></p> 
<?
  } 
    } 
  else 
  { 
  echo 'You missed a field'; 
  } 
?>

However when i try to input data i get a blank screen.

<?=$data["name"]?> <?=$data["address"]?> <?=$data["city"]?> <?=$data["state"]?> <?=$data["zip"]?> 
<?=$data["country"]?> <?=$data["phone"]?> <?=$data["companytype"]?>

I also tried putting this to gether with Html code and I get an unexpeded $end

<?
//get the data from the post array 
$search = $_POST['search']; 
$search1 = $_POST['search1']; 

if($search <> '' && $search1 <> '') 
  { 
  // database connection 
  include("db.php"); 

if (!($limit)){
$limit = 10;} // Default results per-page.
if (!($page)){
$page = 0;} // Default page value.
$numresults ="SELECT * FROM mytable WHERE 
	                    city = '".$search."' AND 
                                    state = '".$search1."' ";
$numrows = mysql_num_rows($numresults); // Number of rows returned from above query.
if ($numrows == 0){echo("No results found matching your query - $search"); // bah, modify the "Not Found" error for your needs.
exit();}

$pages = intval($numrows/$limit); // Number of results pages.

// $pages now contains int of pages, unless there is a remainder from division.

if ($numrows%$limit) {
$pages++;} // has remainder so add one page

$current = ($page/$limit) + 1; // Current page number.

if (($pages < 1) || ($pages == 0)) {
$total = 1;} // If $pages is less than one or equal to 0, total pages is 1.

else {
$total = $pages;} // Else total pages is $pages value.

$first = $page + 1; // The first result.

if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) {
$last = $page + $limit;} //If not last results page, last result equals $page plus $limit.

else{$last = $numrows;} // last result equals total number of results.

//escape from PHP mode.
?>
<html>
<head>
<title>Search Results for <?=$query?></title>
</head>
<body>
<center><h2>Search Results for <?=$query?></h2></center>
<table width="100%" border="0">
 <tr>
  <td width="50%" align="left">
Results <b><?=$first?></b> - <b><?=$last?></b> of <b><?=$numrows?></b>
  </td>
  <td width="50%" align="right">
Page <b><?=$current?></b> of <b><?=$total?></b>
  </td>
 </tr>
 <tr>
  <td colspan="2" align="right">
&nbsp;
  </td>
 </tr>
 <tr>
  <td colspan="2" align="right">
Results per-page: <a href="<?=$PHP_SELF?>?query=<?=$query?>&page=<?=$page?>&limit=5">5</a> | <a href="<?=$PHP_SELF?>?query=<?=$query?>&page=<?=$page?>&limit=10">10</a> | <a href="<?=$PHP_SELF?>?query=<?=$query?>&page=<?=$page?>&limit=20">20</a> | <a href="<?=$PHP_SELF?>?query=<?=$query?>&page=<?=$page?>&limit=50">50</a>
  </td>
 </tr>
</table>
<?
//Go back into PHP mode.

// Now we can display results.
$results = ("SELECT * FROM caribbean WHERE 
	            city = '".$search."' AND 
                            state = '".$search1."' ORDER BY name ASC LIMIT $page, $limit");

while ($data = mysql_fetch_array($results))
{
?>
<p><?=$data['name']?><br><?=$data['address']?><br><?=$data['city']?>&nbsp;<?=$data["state"]?>&nbsp;<?=$data["zip"]?><br>
<?=$data["country"]?><br><?=$data["phone"]?><br><?=$data["companytype"]?></p> 
<?
}
?>
<p align="center">
<?
if ($page != 0) { // Don't show back link if current page is first page.
$back_page = $page - $limit;echo("<a href=\"$PHP_SELF?query=$query&page=$back_page&limit=$limit\">back</a>    \n");}

for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it.
{
 $ppage = $limit*($i - 1);
 if ($ppage == $page){ echo("<b>$i</b> \n");} //  page don't give link, just text.
 else{ echo("<a href=\"$PHP_SELF?query=$query&page=$ppage&limit=$limit\">$i</a> \n");}
}

if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link.
$next_page = $page + $limit;
echo("    <a href=\"$PHP_SELF?query=$query&page=$next_page&limit=$limit\">next</a>\n");}
?>
</p>
</body>
</html>