How to store row/column of mysql data in array

[gaya]

Hi, Please tell me how to store a column from db in array. My table name is qtype, and the fields in table are id & type.

$sql="select type from qtype";$result=mysql_query($sql);

I had selected the type from table.There are some 6types in type field, and i have to store all the 6 in array.How shall i do this. Any ideas please tell me.

[gaya]

I found out the solution for this

$sql="select type from qtype";$result=mysql_query($sql);$var = array();while ($rw = mysql_fetch_array($result)) {  $var[] = $rw['type'];}print_r ($var);

But now i have to compare the two fields.

$quer="select type from qtype whereid='$qtype'";$res=mysql_query($quer);if(mysql_num_rows($res)){while($row=mysql_fetch_array($res)){$qtype1=$row[0];}}

In the above code i take the type corresponding to its id.I have to compare if the type is in the array, and if it is some conditions should be done. please tell me how to do this.

Edited February 13, 2013 by gaya

[justsomeguy]

You can use in_array to check if an item is in an array: http://www.php.net/manual/en/function.in-array.php

[gaya]

Thanks justsomeguy. I used the following code and compared the two values.

for($i=0; $i<6;$i++){if($var[$i]==$str){    echo "welcome----".$str;	    $a=a.php;[/font]} 

Now i have to include another php file inside the if condition,storing the php file name in a variable like $a=a.php,and when clicking it have to open the corresponding output in which a.php file is needed. Any ideas please tell me.

[justsomeguy]

You need to make the filename a string. You can use the variable with include, there's no problem with that as long as the path to the file is correct.

[gaya]

I did it.Thanks justsomeguy.