Query Error

[chelvan]

hi forums !
its me again.

here my code, that i struggles...

         $options=$_POST['options'];
		 $hf=$_POST['hf'];
		 $arr= count($options);
         if ($options){
            for ($i=0;$i<count($options);$i++){
			 $pos[$i]= strlen($options[$i]);
		        $name[$i]=substr($options[$i],0,$pos[$i]);
			echo  $name[$i];

		$sql_user=mysql_query("SELECT*FROM user WHERE username='$name[$i]'");
		while($row=mysql_fetch_array($sql_user)){
			echo $refno=$row['refno']."<br>";
		}
	}	
}

options[] is the name of my listbox. i able to pass it in to php thats print

echo  $name[$i];

but the bellow query does not worked. i used the $name[$i] as where condition.


why any errors in the query?


thanks in advance
chelvan

[dlite922]

do some debugging

do an echo on mysql_error()


Dan

[r035198x]

SELECT*FROM ... won't work. You need spaces.

[chelvan]

hi all

thanks all of your response.

please forgive me, i made a mad mistake on query on my where clause i checked different fields. now i correct that.


so much sorry. before post i tried to find nearly 2 days. but i couldn't. then finally i did.


any how thanks a lot.



regards
chelvan