Getting from database from 2 conditions ?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
saumya
Forum Contributor
Posts: 193
Joined: Sun Jan 30, 2005 10:21 pm

Getting from database from 2 conditions ?

Post by saumya »

Hi guys,
can you please help me with this. I want to get a particular row from DB mysql.But I want to check 2 conditions.Presently it does not return the required value.

Code: Select all

$query = "SELECT * FROM `nt_students` WHERE `wo`='$WorkOrderNumber';";
$result = mysql_query($query)
while($row=mysql_fetch_array($result)){
				$d_sl_no=$row['sl_no'];	//from data base
				//echo '................$d_sl_no='.$d_sl_no;
				if($d_sl_no=$sl_no){
				echo '................$d_sl_no='.$d_sl_no;
					$f_name=$row['f_name'];
					$l_name=$row['l_name'];
					$standard = $row['standard'];
					$division= $row['division'];
					$date_of_birth=$row['date_of_birth'];
					$date_of_submission=$row['date_of_submission'];
					$home_address=$row['home_address'];
					$home_phone=$row['home_phone'];
					$mobile=$row['mobile'];
					$e_mail=$row['e_mail'];
					$mom_cell=$row['mom_mobile'];
					$mom_e_mail=$row['mom_e_mail'];
					$dad_cell=$row['dad_mobile'];
					$dad_e_mail=$row['dad_e_mail'];
					$sp_notes=$row['sp_notes'];
					$undertaking_parent=$row['parent_undertaking'];
					$is_jain=$row['is_jain'];
					$is_swimmer=$row['is_swimmer'];
					$bus_no=$row['bus_no'];
					$gender=$row['gender'];
I want to check for a particular "sl_no " after getting the datas from the DB.
Please help.
timclaason
Forum Commoner
Posts: 77
Joined: Tue Dec 16, 2003 9:06 am
Location: WI

DB

Post by timclaason »

Your if statement in the above only has 1 "=". It needs to be "==". Hopefully that's the fix.
saumya
Forum Contributor
Posts: 193
Joined: Sun Jan 30, 2005 10:21 pm

Post by saumya »

WOW buddy,
that worked.
uuummmmmmmmmmmmmmaaaaaaaaahhhh

thanks timclaason. :D
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

It's way easier to add the second condition to the WHERE clause of the sql statement.

Code: Select all

$query = "SELECT
		*
	FROM
		`nt_students`
	WHERE
		`wo`='$WorkOrderNumber'
		AND `sl_no`=$sl_no";
saumya
Forum Contributor
Posts: 193
Joined: Sun Jan 30, 2005 10:21 pm

Post by saumya »

Ohh maan, thats possible !!
I never knew that.
tahnks volka
Post Reply