PHP mysql leaving out rows

Question

So I am having issues with the first row of the database being left out, not sure as to why yet. Here is the code in a nutshell, leaving out the connection part and such.

$tickets="tickets";
$sql_ticket="SELECT * FROM $tickets WHERE username='$user'";
$ticket_query=mysql_query($sql_ticket);
$ticket_data=mysql_fetch_assoc($ticket_query);
while($ticket_data=mysql_fetch_assoc($ticket_query)){
// echoing in tables
}

Just read the code, this is quite obvious.... If you don't see the error, make sure you understand what each line does. This will be a good exercise. — Bgi
– Bgi, Commented Dec 4, 2012 at 13:57
Please do not continue using mysql_-class functions. Either use mysqli_, MYSQLI::, or PDO. See php.net/manual/en/book.mysqli.php and php.net/manual/en/book.pdo.php — wadie
– wadie, Commented Dec 4, 2012 at 13:57
Every call to mysql_fecch_assoc() advances the record pointer one row. So when you enter your loop, it's already at the second row. — Michael Berkowski
– Michael Berkowski, Commented Dec 4, 2012 at 13:57

Marcin Orlowski · Accepted Answer · 2012-12-04 13:56:07Z

3

Remove this line:

$ticket_data=mysql_fetch_assoc($ticket_query);

as you are fetching 1st row outside of your loop. Corrected code should be:

$tickets="tickets";
$sql_ticket="SELECT * FROM $tickets WHERE username='$user'";
$ticket_query=mysql_query($sql_ticket);
while($ticket_data=mysql_fetch_assoc($ticket_query)){
   // echoing in tables
}

answered Dec 4, 2012 at 13:56

Marcin Orlowski

75.7k11 gold badges128 silver badges152 bronze badges

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

2 Comments

user1868565 Over a year ago

Ah right, so I already assigned the first line by doing this I suppose?

Marcin Orlowski Over a year ago

Exactly, that was your bug.

Collectives™ on Stack Overflow

PHP mysql leaving out rows

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related