[SOLVED] syntax prob

[angelsRock]

why state problem Parse error: syntax error, unexpected ']', expecting T_STRING or T_VARIABLE or '$' in C:\wamp\www\Property\agent-password.php on line 220

 

 

	$connection=mysql_connect($server, $user, $pass);
						if(!$connection)					
							die("Connection failed");		

						else
						{										
							mysql_select_db($db);							



				$query3="select * from all_members where email='".$_SESSION[username]."' and password='".$_POST[new]."'; ";

							$exec=mysql_query($query3);

							$num=mysql_affected_rows();

							if($num<1)
							{													
								echo'<script>alert("Sorry, submission failed")</script>';					
							}	

						}

[Herod]

please verify this

$query3="select * from all_members where email='".$_SESSION[username]."' and password='".$_POST[new]."'; ";

[sneamia]

Shouldn't username and new be in quotes?

[angelsRock]

i don seen a syntax error there to change.. that query is to check the username and password to be matched when user change pasword

[Herod]

write

$query3="select * from all_members where email='".$_SESSION[username]."' and password='".$_POST[new]."'; ";

like this

$query3="select * from all_members where email='".$_SESSION[username]."' and password='".$_POST[new]."';

[angelsRock]

impossible.. cos "select ... "

[Herod]

ah yes

make it like this:

$query3="select * from all_members where email='".$_SESSION[username]."' and password='".$_POST[new]."'";

[sneamia]

Did you try putting username and new in quotes?

[darkfreaks]

<?php

$query3="select * from all_members where email='".$_SESSION['username']."' 
and password='".$_POST['new']."'";?>