Printing a MySQL query in PHP

Question

function MattsScript()
{
    $query = 'SELECT * FROM `ACCOUNTING` WHERE  `ACCTSTATUSTYPE` = "start" AND `Process_status` IS NULL LIMIT 0,100';
    $result = mysql_query($query);
    $row = mysql_fetch_assoc($result);

    while ($row = mysql_fetch_assoc($result)) 
    {
        echo $row['USERNAME'] . "<br />";
        echo $row['ACCTSTATUSTYPE'];
    }
}

I am trying to echo the results of a query. What I think is happening here is I am saving a query to a variable, the first 100 results (LIMIT 0,100) then using a loop to echo each row to the page.

However nothing is happening, no error and nothing written to the page.

Is there something I am missing?

Are you sure tha tyou have error reporting turned on? Are you sure that MattsScript gets called? — Explosion Pills
– Explosion Pills, Commented Apr 3, 2013 at 22:36
Are you sure that fields names USERNAME and ACCTSTATUSTYPE exists? — shakaran
– shakaran, Commented Apr 3, 2013 at 22:37
The first result is ignored due to $row = mysql_fetch_assoc($result); right after mysql_query; are you sure you have multiple results ? — tmuguet
– tmuguet, Commented Apr 3, 2013 at 22:39
Oh, and you're doing mysql_fetch_assoc twice. No need for the first one. — Ryoku
– Ryoku, Commented Apr 3, 2013 at 22:53

Eduard Luca · Accepted Answer · 2013-04-03 23:25:11Z

3

if you are expecting only one result remove the while loop if not leave the while loop and remove the line $row = mysql_fetch_assoc($result); before the while loop. Also make sure you are querying your database correctly.

Example: $result = mysql_query($query) or die(mysql_error());

edited Apr 3, 2013 at 23:25

Eduard Luca

6,62218 gold badges89 silver badges143 bronze badges

answered Apr 3, 2013 at 23:03

Bruce

631 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

Printing a MySQL query in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related