And Or Query Search parameters?

jwilley

Hey again,

Here is my code and I am having search issues... if they put in a search for a latname, firstname, and district it will give back everyone in that district or with any part of those names... how can i do it so that it will narrow the search parameters and just give back relevant data that matches either a firsname and a district , or a last name and a firstname, or a district and a lastname and so on...

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<h4>OATA Search Results:</h4>
<a href="findmem.html">Back>Search Again</a>

<? mysql_connect(localhost,oataorg_ohioata,atmedical);
@mysql_select_db(oataorg_memdb) or die( "Unable to select database");
if(mysql_error())
echo mysql_error();
$lastname = $POST['lastname'];
$firstname = $POST['firstname'];
$district = $_POST['district'];

$query="SELECT * FROM membinfo WHERE lastname = '$lastname' or firstname = '$firstname' or district = '$district'";

$result=mysql_query($query) or die (mysql_error());
$num=mysql_numrows($result);
?>
<table>
<?
while ($row = mysql_fetch_array($result)) // this will grab the results from query
{
?>

<table>
<tr>
<td>
<? echo $row['Id']; ?>
</td>
<td>
<? echo $row['lastname']; ?>, <? echo $row['firstname']; ?> 
District: <? echo $row['district']; ?> 
Work Phone: <? echo $row['work']; ?> 
Email Address: <a href="mailto: <? echo $row['email']; ?>"> <? echo $row['email']; ?> </a> 
<hr width=75%></td>

</tr>

<?
}
?>
</table>

</body>
</html>

any suggestions on making it a better more defined search that won't give me SOOO many results? I assume it has somehting to do with the AND, OR, = parameters and so on... do i need to split it up?

Jon

kevinsequeira

u really need to search the forum ...

jwilley

Here, check it out yourself with the name:

First: Douglas Last: Smith District: E

It's at http://www.oata.org/findmem.html

thanks,
Jonathan

kevinsequeira


<?php

$lastname = $_POST['lastname'];

$firstname = $_POST['firstname'];

$district = $_POST['district'];

$query="SELECT * FROM membinfo WHERE id > 0";

// default condition, im assuming u have a field in table called id, else use the primary key

if($lastname!="")

$query .=" AND lastname='$lastname'";

if($firstname!="")

$query .=" AND firstname='$firstname'";

if($district!="")

$query .=" AND district='$district'";        



echo $query;

$result=mysql_query($query) or die (mysql_error()); 

?>

reg
kevin

jwilley

ok,
been working on this all weekend and searching the forum to no avail... here is my final code with the help form you kevin and it is giving me a "Parse error: parse error, unexpected T_VARIABLE in /home/oataorg/public_html/find.php on line 15" message.... line 15 is the $lastname=$_POST['lastname']; line...

code:

<? mysql_connect(localhost,oataorg_ohioata,atmedical);
@mysql_select_db(oataorg_memdb) or die( "Unable to select database");
if(mysql_error())
echo mysql_error();

$lastname=$POST['lastname'];
$firstname=$POST['firstname'];
$district=$_POST['district'];

$query="SELECT * FROM membinfo WHERE id > 0";

// default condition, im assuming u have a field in table called id, else use the primary key

if($lastname!="")

___$query.="_AND_lastname='$lastname'";

if($firstname!="")

___$query.="_AND_firstname='$firstname'";

if($district!="")

_$query.="AND_district='$district'";_____

echo_$query;

$result=mysql_query($query)or_die(mysql_error());_
$num=mysql_numrows($result);

Any ideas as to why it's giving me that message? everything matches my database field names fine...
jon

jwilley

not sure why it put in all those _____ marks for spaces but disregard those where they went in where they didn't need to be...
Jon

kevinsequeira

repost the code within the php code tag so that its easy to read like this and is that all of the code for find.php ??

[ p h p ]
your code
type the php code tags without the spaces ....
[ / p h p ]

reg
kevin

kevinsequeira

try this

mysql_connect("localhost","oataorg_ohioata","atmedical")
;
@mysql_select_db("oataorg_memdb") or die( "Unable to select database");

reg
kevin

jwilley

Still giving me a Parse error: parse error, unexpected T_ECHO in /home/oataorg/public_html/find.php on line 33

i bolded it below...

<? mysql_connect("localhost","oataorg_ohioata","atmedical"); 
@mysql_select_db("oataorg_memdb") or die( "Unable to select database"); 


if(mysql_error()) 
echo mysql_error(); 

$lastname = $_POST['lastname'];
$firstname = $_POST['firstname'];
$district = $_POST['district'];

$query="SELECT * FROM membinfo WHERE id > 0";

// default condition, im assuming u have a field in table called id, else use the primary key

if($lastname!="")
$query .=" AND_lastname='$lastname'";
if($firstname!="")
$query .=" AND_firstname='$firstname'";
if($district!="")
$query .=" AND_district='$district'";________
[B]echo $query;[/B]
$result=mysql_query($query) or die (mysql_error ()); 
?>

<table> 

  <? 
while ($row = mysql_fetch_array($result)) // this will grab the results from query 
{
?>

kevinsequeira

just comment the line. it is pretty difficult to read the posted code cause of all the ________.
if you still have a prob, can u copy the entire code to a text file and upload the file

reg
kevin

jwilley

<? mysql_connect("localhost","oataorg_ohioata","atmedical");
@mysql_select_db("oataorg_memdb") or die( "Unable to select database");

if(mysql_error())
echo mysql_error();

$lastname = $POST['lastname'];
$firstname = $POST['firstname'];
$district = $_POST['district'];

$query="SELECT * FROM membinfo WHERE id > 0";

// default condition, im assuming u have a field in table called id, else use the primary key

if($lastname!="")
$query .=" AND_lastname='$lastname'";
if($firstname!="")
$query .=" AND_firstname='$firstname'";
if($district!="")
$query .=" AND_district='$district'";
echo $query; //here is the line that is giving the parse T_echo problem
$result=mysql_query($query) or die (mysql_error ());
$num=mysql_numrows($result);
?>

<table>

<?
while ($row = mysql_fetch_array($result)) // this will grab the results from query
{
?>

jwilley

 <? mysql_connect("localhost","oataorg_ohioata","atmedical"); 
@mysql_select_db("oataorg_memdb") or die( "Unable to select database"); 


if(mysql_error()) 
echo mysql_error(); 

$lastname = $_POST['lastname'];
$firstname = $_POST['firstname'];
$district = $_POST['district'];

$query="SELECT * FROM membinfo WHERE id > 0";

// default condition, im assuming u have a field in table called id, else use the primary key

if($lastname!="")
$query .=" AND_lastname='$lastname'";
if($firstname!="")
$query .=" AND_firstname='$firstname'";
if($district!="")
$query .=" AND_district='$district'";
echo $query; //here is the line that is giving the parse T_echo problem
$result=mysql_query($query) or die (mysql_error ()); 
$num=mysql_numrows($result);
?>

<table> 

  <? 
while ($row = mysql_fetch_array($result)) // this will grab the results from query 
{
?>

kevinsequeira

try this

if($lastname != "")
	$query = $query." AND lastname='".$lastname."'";

if($firstname != "")
	$query = $query." AND firstname='".$firstname."'";

if($district != "")
	$query =$query." AND district='".$district."'";

print ("query is ".$query);

reg
kevin

jwilley

gives me an unexpected T_VARIABLE error on the following line

_$query_=_$query." AND lastname='".$lastname."'"

kevinsequeira

what are the values you enter in the form that you submit to this page. also try this

$lastname = $POST['lastname'];
$firstname = $POST['firstname'];
$district = $_POST['district'];

print ($lastname." : ".$firstname." : ".$district);

make sure all the lines are terminated with a ; and also delete this line

// default condition, im assuming u have a field in table called id, else use the primary key

reg
kevin

jwilley

GOT IT! Thanks so much kevin for your help with this... i had to basically do some spacing formatting as i was copying and pasting form here and it was adding extra spaces to the code... grrrrrrrrrrrrr....

so, here is my final code...

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<h4><strong><font face="Arial, Helvetica, sans-serif">OATA Search Results:</font></strong></h4>
<p><font size="2" face="Arial, Helvetica, sans-serif"><a href="findmem.html">Back&gt;Search Again</a></font></p>
<p>

  <? mysql_connect("localhost","oataorg_ohioata","atmedical"); 
@mysql_select_db("oataorg_memdb") or die( "Unable to select database"); 


if(mysql_error()) 
echo mysql_error(); 

$lastname = $_POST['lastname'];
$firstname = $_POST['firstname'];
$district = $_POST['district'];

$query="SELECT * FROM membinfo WHERE id > 1";

// default condition, im assuming u have a field in table called id, else use the primary key

if($lastname!="")
$query = $query." AND lastname = '".$lastname."'";

if($firstname!="")
$query = $query." AND firstname = '".$firstname."'";

if($district!="")
$query = $query." AND district = '".$district."'";

$result=mysql_query($query) or die (mysql_error ()); 

?>

<table> 

  <? 
while ($row = mysql_fetch_array($result)) // this will grab the results from query 
{
?> 
</p>
<table> 
<tr> 
<td> 
<? echo $row['Id']; ?> 
</td> 
<td> 
<font color="#0000FF" size="3" face="Arial, Helvetica, sans-serif"><strong><? echo $row['lastname']; ?>,&nbsp;<? echo $row['firstname']; ?></strong></font><br>
<strong><font size="3" face="Arial, Helvetica, sans-serif">District:</font></strong> <? echo $row['district']; ?><br>
<strong><font size="3" face="Arial, Helvetica, sans-serif">Work Place:</font></strong> <? echo $row['workplace']; ?><br>
<strong><font size="3" face="Arial, Helvetica, sans-serif">Work Address:</font></strong> <? echo $row['workaddress']; ?><br>
<strong><font size="3" face="Arial, Helvetica, sans-serif">Work City, State, Zip:</font></strong> <? echo $row['workcitystatezip']; ?><br> 
<strong><font size="3" face="Arial, Helvetica, sans-serif">Work Phone:</font></strong> <? echo $row['work']; ?><br>
<strong><font size="3" face="Arial, Helvetica, sans-serif">Email Address: </font></strong> <a href="mailto: <? echo $row['email']; ?>"> <? echo $row['email']; ?> </a><br>
 <hr width=75%></td>  

</tr>

<? 
}
?> 
</table> 

</body>
</html>

I got everything working ok.... they fill out a search form on a prior page...

another question... if they do a search that doesn't come back with any answers how can i make it print "Nothing found in the database that matches the information you entered!" on the results page???

kevinsequeira

after this line

$result=mysql_query($query) or die (mysql_error ());

if(mysql_num_rows($result)==0){
print ("no results");
}else{
// do the results display
}

reg
kevin

jwilley

thanks again.... it's obvious that i need to work some more on my PHP and MYSQL skills.... is there a referrence that you would suggest? this forum is invaluable but can take some time to search....

i'm gonna post soon about creating a session or logging in against a database and making sure that only the person who logged in can access only his or her information to update.... i've figured out the ligging in against a database part and the updating the database or deleting your file part, now i just need to put them all together in a workable environment.... i'll post it to the newbies section soon hopefully... i wanna search out there some more and make sure i've exhausted MY sources or at least what i understand....

Jon

kevinsequeira

just do a google search for php tutorials and you will find a lot of links, heres one

http://hotwired.lycos.com/webmonkey/programming/php/

reg
kevin

sdjensen

If you are looking for some references try looking through the forum. I have discovered a lot of new function/ways to do things.

Another page I have found usefull is
http://www.devshed.com