fetch data from mysql table using php ignoring some values?
I have a table which have a column with name domain_name. in domain_name column, different values stores like google.com, facebook.com, twitter.com etc. I try this which is working.
$query= 'Select * from accountdb WHERE domain_name="twitter.com" order by domain_name ASC';
But I want to pick that rows which have the values facebook.com, twitter.com in one query. I try this to achieve but not working.
$query= 'Select * from accountdb WHERE domain_name="twitter.com" and domain_name="facebook.com" order by domain_name ASC';
Alterring quotes
$query= "Select * from accountdb WHERE domain_name='twitter.com' and name='facebook.com' order by domain_name ASC";
Any hint would be appreciated.
And means that both conditions have to be met which will never ever happen. You want domain_name to be either "twitter.com" or "facebook.com". So you have to use or
$query= 'Select * from accountdb WHERE domain_name="twitter.com" or domain_name="facebook.com" order by domain_name ASC';
If you have more than 2 domains to check, best way is to use in.
$query= 'Select * from accountdb WHERE domain_name in ("twitter.com","facebook.com","google.com") order by domain_name ASC';
You can use OR.
$query= 'Select * from accountdb WHERE domain_name="twitter.com" OR domain_name="facebook.com" order by domain_name ASC';
-
05:30
-
04:00
-
00:00
-
10:30
-
9:10
-
07:40
Firebase Cloud Functions: PubSub, "res.on is not a function"
-
04:00
TypeError: Cannot read properties of undefined (reading 'createMessageComponentCollector')
-
9:20
-
7:40
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 111437 visits
- search for elements in a list 111050 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 98811 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 96311 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 92506 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 62024 visits
- Adding methods to es6 child class 22363 visits
![mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn't match number of parameters](https://cmsdk.com/images/nophoto.png "mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn't match number of parameters")