PHP: while loop stops when adding data from function

Question

The following code shows the name of the customer in a line with all the items he/she has purchased in lines below the name line.

As you will see, in the items purchased line I also print the item's price which I get from the getPrice function.

And here's the problem, the first query, the customers query, retrieves several rows of data but as soon as I call the getPrice function I get just the first row.

If instead of calling the function I give price just a value, everything goes right.

Taking this into account, I have changed the getPrice function query, thinking it could be wrong but the problem persists .. the while loop prints just one row.

Any ideas on what is going wrong? What can I try? I’m stuck :(

Thanks !!

<?php

$query1  = "SELECT * FROM Customers"; //this retrieves several rows of data
$result1 = mysql_query($query1) or die(mysql_error());

$flag = -999;
while($row = mysql_fetch_array($result1))
{

    if ($row["id"] != $flag) 
    {

        $content .="<span>".$row["lastName"].", ".$row["Name"]." </span><br />";
        $flag = $row["id"];
    }

    $content .=("Item purchased: " .$row["item"]."Price: ".getPrice($row["ItemID"])."<br />");


    $content .="</br></br>";
}                


function getPrice ($itemID)
{

    $query2  = "SELECT Price FROM Items WHERE ItemID= '".$itemID."'";
    $result2 = mysql_query($query2) or die(mysql_error());

    if($row2 = mysql_fetch_array($result2))
    {
        return $row2[0];
    } 
}

echo $content;
?>

Please post the table structure and some sample records, preferably in form of CREATE TABLE ... and INSERT INTO ... sql statements. — VolkerK
– VolkerK, Commented Jun 26, 2013 at 10:55

Ammar Hayder Khan · Accepted Answer · 2013-06-26 10:55:32Z

0

use while instead of if in getPrice function

function getPrice ($itemID)
{
//Changed this line
$query2="SELECT Price FROM Items WHERE ItemID= '".$itemID."'";
$result2 = mysql_query($query2) or die(mysql_error());

while($row2 = mysql_fetch_array($result2))
{
    return $row2[0];
} 
}

answered Jun 26, 2013 at 10:55

Ammar Hayder Khan

1,3354 gold badges22 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jake1164 · Accepted Answer · 2013-06-26 10:44:01Z

0

function getPrice ($itemID)
{
    //Changed this line
    $query2="SELECT Price FROM Items WHERE ItemID= '".$itemID."'";//;was missing
    $result2 = mysql_query($query2) or die(mysql_error());

    if($row2 = mysql_fetch_array($result2))
    {
        return $row2[0];
    } 
}

edited Jun 26, 2013 at 10:44

Jake1164

12.4k6 gold badges49 silver badges65 bronze badges

answered Jun 26, 2013 at 10:38

Swapnil

6064 silver badges13 bronze badges

1 Comment

ADM Over a year ago

My error when copying the code, in my script is correct .. thanks

Collectives™ on Stack Overflow

PHP: while loop stops when adding data from function

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related