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

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
How can we complete PHP language in 30 days?
First at all as a php trainer i would ask if you know html,csss,javascript nicely or not. As per me you should be at mediator level in those things to start php. Ok hopping you know that. Then go for some...
Veerendra
0 0
6
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
What are global variable in php ?
A variable declared outside a function is global
Ajay
Please Tell Me About PHP ?
PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML. It allows...
Indal

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...

Read Your Gmail Emails Using PHP and IMAP
Hello Friends ,Recently I have worked on drip email campaign project for that I need to read emails using PHP From the gmail inbox. Here is the simple example for Read emails from the gmail: To start...

What is M.S.Project ?
MICROSOFT PROJECT contains project work and project groups, schedules and finances.Microsoft Project permits its users to line realistic goals for project groups and customers by making schedules, distributing...

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...

What is Type Juggle in PHP ?
Type Juggling means dealing with a variable type. PHP does not require explicit type definition in variable declaration. A variable's type is determined by the context in which the variable is used. Example,...

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