MySQL Statement not echoing variable in while

Question

So I have the following:

$query = "SELECT id,account,status FROM service WHERE status = 'Unpaid'";
        $result = mysql_query($query);  

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

                $id = $row[0];
                $dateEntered = $row[1];
                $type = $row[2];
                $account = $row[3];
                $dateCompleted = $row[4];
                $notes = $row[5];
                $status = $row[6];

            echo $account;
          // mailStatusUpdate($account, $status, $dateEntered);

        }   

echo mysql_error();

Query processes fine in phpmyadmin. When I echo the $account of the unpaid status records, it doesn't echo. Whats the problem? PHPmyadmin processes everything fine and shows me the records?

Variable is row[3] and is not empty. Its being defined in the while right above it? — JD Audi
– JD Audi, Commented Feb 2, 2012 at 16:39
Do a print_r($row); from within the while loop, to see what it says. That will let you know what you're working with. — Tango Bravo
– Tango Bravo, Commented Feb 2, 2012 at 16:39

Tango Bravo · Accepted Answer · 2012-02-02 16:41:20Z

4

You're only retrieving three columns from the query.

$account should be set to $account = $row[1];

$status should be set to $status = $row[2];

answered Feb 2, 2012 at 16:41

Tango Bravo

3,3293 gold badges25 silver badges45 bronze badges

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

2 Comments

Maxim Krizhanovsky Over a year ago

yeah, that the true answer. Just noticed it and you've posted it, great job ;)

JD Audi Over a year ago

Tim, your answer is partly correct. I did what another guy said, the connection wasn't set up properly for some reason. Thank you for your help i appreciate it!

SoWhat · Accepted Answer · 2012-02-02 16:43:37Z

You are only selecting 3 fields(id (0),account (1), status(2) ) so $account=$row[1] will echo account; There is no $row[3]. If you want to get all the columns use SELECT * FROM service WHERE.....

also to fetch values, use keys

    $query = "SELECT * FROM service WHERE status = 'Unpaid'";
    $result = mysql_query($query);  

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

            $id = $row['id'];
            $dateEntered = $row['dateEntered'];
            $type = $row['type'];
            $account = $row['account'];
            $dateCompleted = $row['dateCompleted'];
            $notes = $row['notes'];
            $status = $row['status'];

        echo $account;
      // mailStatusUpdate($account, $status, $dateEntered);

    }

Collectives™ on Stack Overflow

MySQL Statement not echoing variable in while

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related