php loop through sql result

Question

I have a table called sales_product with columns

sales_product_id, sales_id, type, class, age

I have a query in php saying

$sql = "SELECT * from sales_product WHERE sales_id = " . $_GET['sales_id];

Suppose this query returns two rows.

$result = mysql_query($sql);

How do I loop through this result and save in an array so that later on I can retrieve data like

echo $sales_product[$i]['sales_product_id'];
echo $sales_product[$i]['sales_product_id'];
........

Answer 1

Do mysql_fetch_assoc in while loop:

$result = mysql_query($sql);
$rows[] = array();

while ( $row = mysql_fetch_assoc($result) ) {
    echo $row['sales_product_id'];
    $rows[] = $row;
}

var_dump($rows);

Answer 2

Use mysql_fetch_assoc

while ($row = mysql_fetch_assoc($result)) {
    echo $row["sales_product_id"];
}

Answer 3

Try this,

$result = mysql_query($sql);
while ( $row = mysql_fetch_assoc($result) ) {
    echo $row['columnName'];
}

Use mysql_fetch_array() if u need with index

Answer 4

check this one.

$sql="SELECT sales_product_id, sales_id, type, class, age From sales_product";
$sales= $db->query($sql);
while($sale = $db->fetchByAssoc($sales))
{
    echo $sales['sales_product_id'];
    echo $sales['type'];
 // here instead echo uyou will add data in your array

}

Answer 5

Take a look at

mysql_fetch_array();

Note

Use of this extension is discouraged. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

mysqli_fetch_array()

PDOStatement::fetch()

Answer 6

Something like this should work, this will give you the format you requested (untested):

while($row = mysql_fetch_assoc($result)) {
    $sales_product[] = $row;
}

Answer 7

Since mysql_ has been declared deprecated so i am going to answer your question with
mysqli_* extension

//Prepare an SQL statement for execution
$stmt = $mysqli->prepare("SELECT * from sales_product WHERE sales_id = ?");

//bind parameter to the prepared statement      
$stmt->bind_param("i", $_GET['sales_id]);

//execute it 
$stmt->execute();

//store the result  
$result = $stmt->get_result();

//loop through the  result set
while ($myrow = $result->fetch_assoc()) 
{

      $salesIds[]  = $myrow["sales_product_id"];

}

For more information please refer to php documentation.
Thanks