|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
September 6th, 2006, 10:16 AM
|
|||
|
|||
|
How to do a search?
I have a table in mysql cauled subjects consiting of "id","subject1","subject2","subject3","subject4","subject5". What i want is to write some php code to search these. eg search for all students doing Maths, English and Physics only.
How do i do this?
|
|
#2
September 6th, 2006, 01:23 PM
|
||||
|
||||
|
There are a million-and-one tutorials on how to query a database... but allow me to give you a quick two-liner.
Code:
$query = "SELECT * FROM subjects WHERE subject1='Maths' ";
$result = mysql_query($query) or die("ERROR!! SQL problem? ".mysql_error());
while($row = mysql_fetch_assoc($result))
{
echo "Name :{$row['id']} <br>" .
"Subject : {$row['subject1']} <br>" .
"Subject : {$row['subject2']} <br>" .
"Subject : {$row['subject3']} <br>" .
"Subject : {$row['subject4']} <br>" .
"Subject : {$row['subject5']} <br><br>";
}
You may want to consider Database Normalization on your table... basically, create three tables... Students, Subjects, and Students_Subjects... I assume this is a school assignment though, so don't jump too far ahead of the class.
__________________
Daryl's Homepage | My Blogroll | My Profile | Firefox supporter! DevArticles Forum Moderator "The net is a waste of time, and that's exactly what's right about it." -- William Gibson
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > How to do a search? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
