Untitled

how to store multiple line of result in an array and later read them one by one in PHP-SQL
<?php
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
$result = mysql_query("SELECT <column name> FROM <table name>");
$data=array();  // to create an array to store result
while ( $row= mysql_fetch_array( $result ))
   {
    $data = $row;
   }

?>

<?php
 mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
 mysql_select_db("Database_Name") or die(mysql_error());
$result = mysql_query("SELECT <column name> FROM <table name>");
while ( $row= mysql_fetch_array( $result ))
{
echo $row['column name']; // to check does it works fine.
// pass the variable " $row['column name'] " as paramter to parser function it works.
//I have tried it.
}

?>

$pdo_options = array(
    PDO::ATTR_PERSISTENT => true,
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'
    );
$dataBase = new PDO('mysql:host=ipAddress;dbname=yourDBname', 'user', 'password', $pdo_options);


$request = $dataBase->prepare('SELECT col1,
col2
FROM table1
WHERE colx = :var1');

$request->execute(array('var1' => $_POST['var1']));
$results = $request->fetchAll();
$request->closeCursor();

<?php
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
$result = mysql_query("SELECT <column name> FROM <table name>");
$data=array();  // to create an array to store result
while ( $row= mysql_fetch_array( $result ))
{
    //here you did the mistake if you wanted to store it in a array (like you indicated in the above comment)
    $data[] = $row;


    // Pass anything to the parser here
}

// Or here you can pass it to the parser
// parser($data);

?>

<?php
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
$result = mysql_query("SELECT <column name> FROM <table name>");

$answer = array();  // to create an array to store result

while ( $row= mysql_fetch_array( $result ))
   {

    $answer[] = parser($row);
   }

?>