If i want to search a mysql database, through a html form, i can do that fine if i search by a compleate string, but say i wanted to search with a wild char so like this...
normal full text
test.php?search=Tony
but i want it to be like
test.php?search=T
so it gets everything that starts with a "T" i should put "T%" am i right??
but when i do this and pass the variable it doesnt searc corectly and gives an error...
HERE IS THE CODE FOR THE RESULTS FORM
<html>
<head>
<title> / Customer / Search Results.</title>
<LINK href="../config/cass_style.css" type=text/css rel=stylesheet>
</head>
<body>
<?php
$search = $search;
$criteria = $criteria;
switch ($sort)
{
case "custname":
fun_custsearchresults("localhost", "$database", "$criteria", "$search", "cust_name", "aq_info");
break;
default:
fun_custsearchresults("localhost", "$database", "$criteria", "$search", "uid", "aq_info");
break;
}
?>
</body>
</html>
HERE IS THE CODE FOR THE FUNCTION TO SEARCH
<?php
/**
*Author : Tony
*Date : 00-00-00
*File : Auto Quote / fun_custsearchresults.php
**/
function fun_custsearchresults( $host, $db, $field, $uid, $order, $table){ //FUNCTION TO GET A SINGLE CUSTOMER
$link = mysql_connect( "$host", "", "") // connect to database //CONNECTION TO MYSQL
or die ( "Could not connect"); //ERROR MSG
mysql_select_db ( "$db") //SELECTS DATABASE
or die ( "Could not select database"); //ERROR MSG
$query = "SELECT * FROM $table WHERE $field = '$uid' ORDER BY $order ASC"; //MAKES A QUERY
$result = mysql_query( $query); //GETS RESULTS
echo "<table border='1' align='center' cellpadding='0' cellspacing='0' bordercolor='#003366' width='2000'>";
echo "<tr><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Options.</Font></td><td bgcolor='#003366'><a href='cust_results.php?sortby=uid'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>ID Number.</Font></a></td><td bgcolor='#003366'><a href='cust_results.php?sortby=custname'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Customer Name.</Font></a></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Customer Road.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Customer City.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Customer Post Code.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Customer Telephone One.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Customer Telephone Two.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Customer Fax.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Company Name.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Company Road.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Company City.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Company Post Code.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Company Telephone One.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Company Telephone Two.</font></td><td bgcolor='#003366'><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FFFFFF'>Company Fax.</font></td></tr>";
$c = "0" ; //COUNTER FOR LINE COLOR
$howmanyrec = "0";
while ( $row = mysql_fetch_array ( $result)){ //LOOPS THROUGH RESULTS
$howmanyrec = $howmanyrec +1;
$uid = $row[0]; //GETS RESULTS AND PUTS THEM IN ARRAY ACORDING TO ROW
$custname = $row[1];
$custroad = $row[2];
$custcity = $row[3];
$custpost = $row[4];
$custtelone = $row[5];
$custteltwo = $row[6];
$custfax = $row[7];
$compname = $row[8];
$comproad = $row[9];
$compcity = $row[10];
$comppost = $row[11];
$comptelone = $row[12];
$compteltwo = $row[13];
$compfax = $row[14];
if ( $c == "0"){ //VALIDATION FOR LINE COLOR
echo "<tr><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><a href='cust_viewsingle.php?del=0&uid=$uid'>Edit.</a></Font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$uid</Font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custname</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custroad</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custcity</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custpost</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custtelone</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custteltwo</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custfax</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$compname</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$comproad</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$compcity</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$comppost</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$comptelone</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$compteltwo</font></td><td bgcolor='#C0C0C0'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$compfax</font></td></tr>";
$c = "1"; //GREY LINE OUT
}else{
echo "<tr><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><a href='cust_viewsingle.php?del=0&uid=$uid'>Edit.</a></Font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$uid</Font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custname</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custroad</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custcity</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custpost</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custtelone</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custteltwo</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$custfax</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$compname</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$comproad</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$compcity</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$comppost</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$comptelone</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$compteltwo</font></td><td bgcolor='#FFFFFF'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>$compfax</font></td></tr>";
$c = "0"; //WHITE LINE OUT
}
}
echo "</table>"; //END OF TABLE
echo "$howmanyrec Records in total.";
}
?>
Any ideas to improve or solve this problem??
