My dbLink Access:
dbusername:a4930120_query12
dbpassword:query12
I want to retrieve data based on subject and Class.column name for classes(Class_I_V Class_VI_VIII Class_IX_X Class_XI_XII).For example.my problem is how to write the search code for row no 8. they subject column contains(engg maths1,2,tpde,numerical methods,pqt,random pr...).like wise in my question is.Shall I want to give all keyword in my query(db column name is subject)?.if you see my subject column in my db.it contain all subject.I want to know how to write the proper code for this search.because user search with subject and class.As per my as per my level I have written the code.kindly make it proper. Here is my code:
<form name="f1" action="" method="post">
Enter the subject to search:
<input type="text" name="search" value="" />
<input type="submit" name="submit" value="submit"/>
</form>
search.php
<?php
if(isset($_POST['submit']))
{
$search=$_POST['search'];
$sql=mysql_query("SELECT name,subject,place,expyrs,Class_I_V FROM tutor WHERE subject LIKE '%$search%' or subject LIKE '%$search%' or subject LIKE '%$search%' or subject LIKE '%$search%' or subject LIKE '%$search%' or subject LIKE '%$search%' or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%' Or Class_I_V LIKE '%Class I -V%' ");
while($row=mysql_fetch_array($sql))
{
?>
<tr>
<td><?php echo ++$sno; ?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['subject'];?></td>
<td><?php echo $row['place'];?></td>
<td><?php echo $row['expyrs'];?></td>
<td><?php echo $row['Class_I_V'];?></td>
</tr>
<?php
}
}
?>
Myurl:http://tutorquery.comuv.com/search.php
Type here:java or Class I -V