ghetting data from a table

[Anon]

hello all.

i have a table with three collums: id, ip, and date. i need to get the data from the row where the id feild is 1. I then need to store the data in an array. can anyone help me?

thanks in advance!

[emilienarino]

Hi,

$query = "SELECT * FROM yourtable WHERE id=1";
$result= mysql_query($query, $link_to_your_db);

$your_array=mysql_fetch_row($result);

id will be stored in $your_array[0]
ip in $your_array[1]
date in $your_array[2]

Emilien ARINO