How do I filter multiple columns in MySQL using PHP? If I have 10 columns and have to filter based on any no. of columns between 10 columns.

Asked by Last Modified  

2 Answers

Learn PHP

Follow 3
Answer

Please enter your answer

Hi Sanisundra Its all up to your requirement of data. SQL provides us a clause named "Where" in which you can use operators (And,Or). it will help you to get the data on the basis of filter.For more contact us.
Comments

Android Trainer with 8 years experience

//some code, connecting to database, etc $result = mysql_query("SELECT * FROM names"); while ($row = mysql_fetch_array($result)){ $Id = $row; $FirstName = $row; } mysql_close($con);
Comments

Related Questions

What is the best way to learn PHP without taking any coaching classes?
If you have prior knowledge on any server side programming definitely you can learn it on your own without attending classes. There are so many online tutorials to learn . Wish you all the best.
Kavidassan
0 0
6
Which is best to build web applications: PHP, Python, or Ruby? Why?
I have used almost all of the three language in my web working experience.PHP:It may be not that cool and I think it doesn't rely too much on the framework. Yes, PHP is just a language, but it is the only...
Sunil
0 0
7
PHP (LAMP) for entrepreneurs, is there any full time, fast track classes on PHP(LAMP) for entrepreneurs, who want are want to do some tech part in their startups
Yes, You have option. You can Join. Xpert Infotech, New Delhi. Before going through Silverlight live project training candidate should have knowledge of given concepts listed below: Knowledge of HTML...
Saee
0 0
6
how to place freshers job opening here?
Hello Rajesh, As an PHP aspirant you should be able to handle Basic HTML and CSS with hands on Javascript like putting together PHP and JS, Good expertise of Jquery like handling all DOM manipulations,...
Rajesh
What is the fee for php classess?
Basic + Advanced + WD + MVC, full php developer profile Rs. 12000/- 4 month with practice.
Manjunath

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

PHP Intro.
What is PHP? PHP is an acronym for "PHP Hypertext Preprocessor" PHP is a widely-used, open source scripting language PHP scripts are executed on the server PHP costs nothing, it is free to download and...

SQL Tips (1 to 3)
SQL tip 1: Instead of Full Outer Join, you can use Union All. Difference is, Full Outer Join provides results side by side. Union All provides result s one by one. Note: MYSQL does not support Full...

How To Connect To Server Using PHP?
It is very easy to connect to server using PHP and MYSQL. PHP is a very friendly Programming Language that any one can learn who know the basics of the Front End Development. PHP is a programming Language...

User Authenication In PHP: Some Advanced echniques
User Authentication in CodeIgniter: Goals Security: We want our login system to be secure, we want to do everything we can to stop people’s accounts being hacked into. Tracking: We’d like...

Web Technology Tutorial
Web Technology has 2 category Front End (HTML,CSS,JS Etc) Back End/Server Side (PHP,JSP,ASP,ROR Etc) Front End technologies are - HTML, CSS, Bootstrap, Javascript, jQuery etc. Using front end...

Recommended Articles

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Looking for PHP Classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you