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

What are the ideas for final year projects based on PHP?
Social Networking System, College Management System, Inventory Management System, eCommerce portal etc.
Nishit
0 0
5
Can I build iPhone apps using Python?
Yes, you can use PyMob app where apps can be written purely in Python, and the compiler tool flow converts them in native source codes for various platforms. But there are some cons on using PyMob, the...
Sunil
0 0
5
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
Between Java and Python, which one is better to learn first and why?
Both the development programs come with their strong suits. While Java allows you to enjoy the cross-platform support, Python helps you execute on at least ten different operating systems. It would help...
Priyanka
0 0
5
While teaching IT Student (MCA / BCA / BTech), I found most of the students are not having good programming skills but they are still running behind to learn .NET / PHP / PYTHON / ANDROID / JAVA. Why is it so? What we should do better to improve a sound programming skills among most of IT Students?
on college days they r learning c,c++ and following faculties are also giving a road map of "programming means" thease languages only , even these are the languages are familier , where you justify them...
Amit Kumar

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
Truncate, Drop And Delete Commands In SQL
Truncate: Truncate command will delete the Table data only, it keeps the table schema as it is. Table data Can be rollback Example : TRUNCATE TABLE User; Drop: Drop command will delete both...

Umasankar Natarajan

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

Umasankar Natarajan

0 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
How to connect mysql database in PHP ?
<?php//db credential $servername = "localhost"; $username = "dbusername"; $password = "dbpass"; $databasename="dbname"; // Create connection$conn = mysqli_connect($servername, $username, $password,$databasename); //...

Puran Chand Saini

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 Noida
PHP Classes in Kolkata
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