hi i'm not getting it correctly. can you give me an example code.atleast 1 textbox that are already uppercase when you type a word..thanks in advance, coz i can find a way to incorporate it using a textbox.
$sql = mysql_query("select * from sdti where Rnum like '$search'") UNION ("select * from sd where Rnum like '$search'") UNION ("select * from tr where Rnum like '$search'") ;
Hi guys I’m new to this site and i really need a professional help out here. I am trying to make a search form in my page and basically i can search my database already but i need to revised the code because the process of my search form depends on a dropdown menu which contains the table names in my database basically the searching will depend to the selected service form the dropdown menu. what i want to happen is to** eliminate the dropdown menu and make an automatic searching throughout my tables in the database and fetch the necessary data.. thanks in advance ** this is the searchform.html
<html>
<body bgcolor="#CCCCCC">
<form method="post" action="searchresult.php" name="form2">
<p><img src="images/europcar.jpg" width="560" height="162" /></p>
<p align="center">Please dont live any blank space while searching</p>
<p align="center">Search Reservation Number </p>
<p align="center">
<input type="text" name="search" size=25 maxlength=25 >
<select name="table" size="1">
<option selected="selected"></option>
<option value="sd">SelfDrive</option>
<option value="sdti">SelfDrive texas</option>
<option value="ch">Carhire</option>
<option value="chti">Carhire texas</option>
<option value="cd">Chauffeur Drive</option>
<option value="cdti">Chauffeur Drive texas</option>
<option value="pudo">Pick up Drop off</option>
<option value="pudoti">Pick up Drop off texas</option>
</select>
<input type="Submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
**this part is the searching
searchresult.php**
<?php
$table=$_POST['table'];
$search=$_POST['search'];
if ($search == "" or $table=="")
{
echo"<a href='a.html'> back </a>";
echo "<p>You forgot to enter the reservation number";
exit;
}
$dbhost = 'localhost';
$dbuser = 'europcar_msic';
$dbpass = 'msictran';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'europcar_msic';
mysql_select_db($dbname);
if ($table=="cd")
{
$sql = mysql_query("select * from …
