get all value from column box_no from all records?

[coder9]

Hi again.

 

this time i have a table again.

 

table name: jtable

columns: id and box_no

 

now what i want is to get all value of box_no column from all records and store that into array.

 

let say my array name is $tmp_array[];

 

You guys really helped me a lot. hoping that you will help me again.

 

Thank you in advance again.

 

 

 

[Xurion]

You can do that by simply doing a standard MySQL query:

 

$sql = "SELECT box_no FROM jtable";
$result = mysql_query($sql);

 

If you wanted a simple array with these values, you could use a while statement:

 

while($row = mysql_fetch_assoc($result)){
    $tmp_array[] = $row['box_no'];
}