PHP Script not returning db rows

Question

include("conn.php");
$result = mysql_query("SELECT * FROM sggame");

while($row = mysql_fetch_assoc($result));
{
    $id = $row['id'];
    echo $id;
    echo 'working?';
}

The above code simply doesn't return anything out of the db. The row name is correct and the loop runs, showing that there is something in the database. However the row is just not echoed out at all. This is code i have used a thousand time before and am rather perplexed as to why it has stopped now! Any help, as always, is much appreciated

Aron Rotteveel · Accepted Answer · 2008-12-11 10:37:15Z

4

replace

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

with

while($row = mysql_fetch_assoc($result))

answered Dec 11, 2008 at 10:37

Aron Rotteveel

83.4k17 gold badges106 silver badges129 bronze badges

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

1 Comment

Aron Rotteveel Over a year ago

No problem, this happens to everyone of us someday, I guess :)

Ronald Conco · Accepted Answer · 2008-12-11 10:51:53Z

0

did this code give off a notice or warning when you where running it ? I am just curious being that the problem was the semicolon.

answered Dec 11, 2008 at 10:51

Ronald Conco

8457 silver badges11 bronze badges

1 Comment

Paul Dixon Over a year ago

while (condition); is the same as while (condition){}, i.e. a while loop with an empty body.

Collectives™ on Stack Overflow

PHP Script not returning db rows

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related