mysql query only returning a single row

Question

the following mysql query is only returning a single row when it should be returning 4.

$query = "SELECT * FROM questions";
    $result = mysql_query($query) or die("ERROR: $query.".mysql_error());
    // if records are present
    if (mysql_num_rows($result) > 0) {
    while ( $row = mysql_fetch_object($result) ){

    // get question ID and title
        $qid = $row->qid;
        echo '<div id=ques>';
        echo '<h2>'.$row->qtitle .'</h2>';
        echo '</div>';

        print_r ($row);

the print_r function displays this:

stdClass Object ( [qtitle] => dummy text here [qid] => 1 )

You should be very careful with the way you generate your HTML. If the question titles come from user input you may have an XSS or DoS vulnerability in your code. — Mark Byers
– Mark Byers, Commented Jan 19, 2010 at 22:09

Ignacio Vazquez-Abrams · Accepted Answer · 2010-01-19 22:07:10Z

4

mysql_fetch_*() only pulls a single row at a time. Without seeing the rest of the loop it's impossible to tell if something else is going on down there.

answered Jan 19, 2010 at 22:07

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

3 Comments

AJ. Over a year ago

@Ignacio, doesn't the while loop keep calling mysql_fetch_object until it returns FALSE? I agree the block could contain other code that may break out of the loop.

suitedupgeek Over a year ago

Also looks like it's missing some crucial closing brackets which could possibly be causing it to break, would expect parse errors with that code though ..

amit Over a year ago

this was a really stupid question. it was an error on my part. i took the $row variable for fetching the answers too. thanks for your help.

alemjerus · Accepted Answer · 2010-01-19 22:11:15Z

0

You don't have closing brackets for while-loop and if

answered Jan 19, 2010 at 22:11

alemjerus

8,3443 gold badges34 silver badges40 bronze badges

Collectives™ on Stack Overflow

mysql query only returning a single row

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related