Php code results not matching mySQL query

Question

mySQL Table

ID | Name

1 | A

2 | B

3 | C

4 | D

5 | E

mySQL Query

$query = "SELECT * FROM ego_work WHERE 1;
$result = mysql_query($query);

$rows = array();
while ($row = mysql_fetch_array($result)) {
    $rows[] = $row;
}

php Code

<?php foreach ($rows as $work): ?>
     <span> <?php echo $work['id']; ?>, </span>
<?php endforeach; ?>
<br \>
<?php foreach ($rows as $work): ?>
     <span> <?php echo $work['name']; ?>, </span>
<?php endforeach; ?>

RESULT

1,2,3,4,5

E,A,B,C,D

What did I do wrong? I'm trying to get the 2nd result to be A,B,C,D,E

Could you post the result of a var_dump on $rows? I suspect your table's data aren't what you think they are. — Shad
– Shad, Commented Dec 17, 2011 at 5:00

Robin Michael Poothurai · Accepted Answer · 2011-12-18 10:50:35Z

1

can you try below code

<?php foreach ($rows as $work): ?>
<span> <?php echo $work['id']; ?>, </span>
<?php endforeach; ?>

<?php reset($rows);?>
<br \>
<?php foreach ($rows as $work): ?>
 <span> <?php echo $work['name']; ?>, </span>
<?php endforeach; ?>

answered Dec 18, 2011 at 10:50

Robin Michael Poothurai

5,6947 gold badges26 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Php code results not matching mySQL query

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