This question already has an answer here:
Here is warning show : mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in
HERE MY DATABABASE
-------------------------------------------------
'ID Bus_Name Stopage_Name Time Distance
-------------------------------------------------
1 Radha Chandni 5.00 0
-------------------------------------------------
2 Radha Metro 5.30 50
-------------------------------------------------
3 Radha Park 6.00 100
-------------------------------------------------
4 Radha Lal 6.30 150
-------------------------------------------------
5 Rani Lal 5.00 0
-------------------------------------------------
6 Rani Metro 6.00 100
-------------------------------------------------
7 Rani Crossing 6.30 150
-------------------------------------------------
8 Rani Bazzar 7.00 250
-------------------------------------------------
9 Crish Lal 12.00 0
-------------------------------------------------
10 Crish Metro 12.30 50
-------------------------------------------------
11 Crish Crossing 01.00 100
-------------------------------------------------
12 Crish Bazzar 01.30 150
-------------------------------------------------
13 Crish Mill 02.00 200'
-------------------------------------------------
<form action="" method="POST">
<input type="text" name="txtStart">
<input type="text" name="txtEnd">
<input type="submit" value="Search" name="search">
</form>'
PHP
<?php
if(isset($_POST['search']))
{
$strkey1=$_POST['txtStart'];
$strkey2=$_POST['txtEnd'];
$sql="SELECT *FROM bus_details WHERE Stopage_Name BETWEEN
$strkey1 AND $strkey2";
$query=mysqli_query($ccon,$sql);
while($row=mysqli_fetch_assoc($query))
{'
?>'
'<table>
<tr>
<th>BUS NAME</th>
<th>STOPAGE NAME</th>
<th>TIME</th>
<th>DISTANCE</th>
</tr>'
</div>
As per my understanding, you are searching inside varchar datatype and the way you are searching is wrong. You have to place the values between single quote OR double quote
$sql="SELECT * FROM bus_details WHERE Stopage_Name BETWEEN
'$strkey1' AND '$strkey2' ";
How can you apply BETWEEN for varchar DataType? Basically, you can use BETWEEN for a range like dates, numbers, etc...
Your query should be looks like as
sql="SELECT * FROM bus_details WHERE Stopage_Name LIKE
'%$strkey1%' AND '%$strkey2%' ";
Pease refer to MYSQL BETWEEN