searching value from multiple coulmn of mysql table

Question

I want to match a value from multiple columns of a table .but when i execute my code it returns the error Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\srctravellers\php\searchbustiming.php on line 15

My code is :

$tocity=$_POST['tocity'];
$res=mysql_query("SELECT  Route FROM routes where $tocity IN('City1','City2','City3','City4','City5','City6','City7','City8','City9','City10')");
while($result=mysql_fetch_array($res)){
    echo $result['Route'];
}

Here is snapshot of my columns of my table

you have to use LIKE here. – Murad Hasan Apr 21 '16 at 11:11 — Murad Hasan, Apr 21 '16 at 11:11
how can i use like command in multiple columns – irfan spi Apr 21 '16 at 11:12 — irfan spi, Apr 21 '16 at 11:12
`City1 LIKE '%$tocity%' OR City2 LIKE '%$tocity%' ......` – Murad Hasan Apr 21 '16 at 11:13 — Murad Hasan, Apr 21 '16 at 11:13

score 0 · Answer 1 · answered Apr 21 '16 at 11:13

0

when a mysql query fails it returns false so your '$res' variable contains false thats why you get boolean given.You can get the reason of failure for your query by using mysql_error() and then you can handle it accordingly.

answered Apr 21 '16 at 11:13

Shahrukh

102
5

score 0 · Accepted Answer · answered Apr 21 '16 at 11:16

0

You have to use LIKE Operator here.

Query

$tocity=$_POST['tocity'];
$res=mysql_query("SELECT  Route FROM routes where City1 LIKE '%$tocity%' OR City2 LIKE '%$tocity%' OR City3 LIKE '%$tocity%' OR City4 LIKE '%$tocity%' OR City5 LIKE '%$tocity%' OR City6 LIKE '%$tocity%' OR City7 LIKE '%$tocity%' OR City8 LIKE '%$tocity%' OR City9 LIKE '%$tocity%' OR City10 LIKE '%$tocity%' OR )");
while($result=mysql_fetch_array($res)){
    echo $result['Route'];
}

answered Apr 21 '16 at 11:16

Murad Hasan

9,418
2
19
40

1

Ok this query working fine .Actually i want to create a search page where user select 2 cities from 2 drop down lists . First is from city and second is tocity .when user select 2 cities from list it should return the Route after matching cities – irfan spi Apr 21 '16 at 11:43
@irfanspi, If you think this is helpful then you have to mark this as your answer. – Murad Hasan Apr 21 '16 at 11:45
please suggest me how can i search fromcity and tocity values in table columns and return Route – irfan spi Apr 21 '16 at 11:46
can i use AND in 2 matches – irfan spi Apr 21 '16 at 11:52
make a new question with a fresh details about what you want. – Murad Hasan Apr 21 '16 at 11:53

searching value from multiple coulmn of mysql table

2 Answers2