You can access all the data from a mysql table and access the data individually using php.

First you have to connect to the database server with this function
<? Php
$link= mysql_connect("host server", "user name", "password";

then select data base
$db = mysql_select_db("data base name", $link);

now write the sql query
$sql= "select * from tablename";
$query= mysql_query($sql, $link );

this is where you manipulate the data

while($bb= mysql_fetch_array($query)){
$ab[]= $bb["column name"];
}

?>

this will put all the rows of that column into the array $ab[] and u can access them individually eg. $ab[0] holds the first value and so on.

Visit www.oksoftmarketing..com for more sample codes.