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

Clevigour Solutions

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
Dislike Bookmark

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
Dislike Bookmark

Related Questions

Which is better, PHP or Python? Why?
Python . Simple syntax,More readable,General purpose programming language
Kartheek
0 0
5
Do you have any project based training program in Bhubaneswar ?
Yes, I can provide you real time project training in php.
Priyasha
Which one is easier to learn, PHP or Python?
PHP
Mahender
0 0
6
What kind of interview questions are asked for Advanced PHP?
http://phpinterviewquestions.co.in/ http://stackoverflow.com/questions/2118755/questions-every-good-php-developer-should-be-able-to-answer http://www.slideshare.net/vineetkumarsaini/top-100-php-interview-questions-and-answers
Manshi
which institution is best for learning pHp class's? and are the requirements I learn pHp in that institution?
Hello Prem, Thank you for the question. You can come down to our institute DishaaPro which is a training division of IDS Logic Pvt Ltd, software company at UK & Noida. You get to learn in a practical...
Prem

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

Ask a Question

Related Lessons

SQL Tips (4 to 6)
SQL tips 4:Avoid INDEX, unless you need to retrieve information quickly. Index will slower insert and update data query.The another way is using sub querySelect MAX(salary)FROM employeeWHERE salary IN(Select...

Umasankar Natarajan

0 0
0
Happiness Or Satisfaction: How To Quit Your Day Job?
Four years ago on a sunny April morning, I slinked into my new office building, suit slightly too big, 24-years-old and clueless. It was my first day working at a large, prestigious Organization. The...

Rohit Raj Verma

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

Dongri Mohammed Jawad

1 0
0
How to Create A Master Page Template In PHP?
A master page template is essential to give a consistent look and feel to any website having multiple pages. It is quite easy to create a master page template in PHP using Dreamweaver. Let’s have...

Karmick I.

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

Parvez Alam

0 0
0

Recommended Articles

Top 5 Skills Every Software Developer Must have

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 >

Make a Career in Mobile Application Programming

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 >

8 Hottest IT Careers of 2014!

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 >

Make a Career as a BPO Professional

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 >

Find PHP Classes near you
PHP Classes in Bangalore
PHP Classes in Delhi
PHP Classes in Mumbai
PHP Classes in Chennai
PHP Classes in Pune
PHP Classes in Hyderabad
PHP Classes in Jaipur
PHP Classes in Kolkata
PHP Classes in Noida
PHP Classes in Ahmedabad
Online PHP Training

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