Move mysql_fetch_array pointer

Question

How can I move mysql_fetch_array pointer in middle of a while loop? something like this:

 while ($subject = mysql_fetch_array($subject_qry))
{
 $output = "<div class=\"left\" id=\"{$subject['id']}\"></div>";
  next($subject);
     $output = "<div class=\"right\" id=\"{$subject['id']}\"></div>";
  return $output;
    }

Please don't use mysql_* functions in new code. They were removed from PHP 7.0.0 in 2015. Instead, use prepared statements via PDO or MySQLi. See Why shouldn't I use mysql_* functions in PHP? for more information. — tereško
– tereško, Commented Jun 10, 2012 at 20:02

Ben · Accepted Answer · 2012-06-10 20:29:47Z

1

How about this:

$counter = 0;
while ($subject = mysql_fetch_array($subject_qry))
{
  if ($counter % 2 == 0)
  {
     $output = "<div class=\"left\" id=\"{$subject['id']}\"></div>";
  }
  else
  {
     $output = "<div class=\"right\" id=\"{$subject['id']}\"></div>";
  }
  // do something with $output here...
  $counter ++;
}

Or you could achieve the same result with a boolean:

$left = true;
while ($subject = mysql_fetch_array($subject_qry))
{
  if ($left)
  {
     $output = "<div class=\"left\" id=\"{$subject['id']}\"></div>";
  }
  else
  {
     $output = "<div class=\"right\" id=\"{$subject['id']}\"></div>";
  }
  // do something with $output here...
  $left = !$left;
}

answered Jun 10, 2012 at 20:29

Ben

68.9k38 gold badges88 silver badges108 bronze badges

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

4 Comments

Mosaic Over a year ago

I'm trying to get the next row in $subject, how does $counter move the pointer?

Ben Over a year ago

I guess it depends on what you're trying to achieve. If you just want to do one thing with even-numbered lines, and another thing with odd-numbered, then my code would solve the problem. If that's not it, let us know what you're trying to do... I.e., why do you want to move the pointer on?

Mosaic Over a year ago

$subject_qry retrieves from the database 10 categories and I wanna float them left and right. (class="left")

Ben Over a year ago

Right -- so it goes left, right, left, right, etc.? So I reckon the code I've suggested does that.

j08691 · Accepted Answer · 2012-06-11 02:17:26Z

1

There are a few things that don't make sense about your example. First, you can't use a name with mysql_fetch_array when retrieving the result. Mysql_fetch_array uses the numeric indices, not the column name. Second, you don't return a value from within a looping while statement. You'd either build up a string or echo it as you're progressing through the loop.

Have you tried something like this:

$counter = 1;
while ($subject = mysql_fetch_array($subject_qry)) {
    echo "<div class=\"left\" id=\"{$subject[0]}\"></div>";
    mysql_data_seek($subject_qry,$counter);
    $subject = mysql_fetch_array($subject_qry);
    echo "<div class=\"right\" id=\"{$subject[0]}\"></div>";
    $counter=$counter+2;
}

answered Jun 11, 2012 at 2:17

j08691

208k33 gold badges269 silver badges281 bronze badges

Comments

Lix · Accepted Answer · 2012-06-10 20:02:09Z

0

You can't do this while you are extracting the data from the database. You have not read the next row with mysql_fetch_array() yet so you can't just skip to the next one.

You'll have to populate an array with all the results first to manipulate the "index" of the array. Alternatively you could just execute an additional mysql_fetch_array() within your loop to read the next row.

answered Jun 10, 2012 at 20:02

Lix

48.2k12 gold badges107 silver badges134 bronze badges

Collectives™ on Stack Overflow

Move mysql_fetch_array pointer

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related