understanding mysql_query?

[DuaneCawaling]

<?php

$username = "root"; 
$password = "vince";
$hostname = "localhost";

$con = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
$selected = mysql_select_db("dummy") or die ("No existing database".mysql_error());

$query = mysql_query("SELECT * from prepurchase");
$row = mysql_fetch_array($query);

echo $nrow = mysql_num_rows($query); //=4

while ($row = mysql_fetch_array($query)){ //why does this loop only 3times??
	echo $bool = $row['Reply'];
	echo $id = $row['ID'];
	$getinfo = mysql_query("SELECT * from profile where studentid = '$id'");
	$bal = $getinfo['credit'];
	$num = $getinfo['contact'];
	
	if ($bool == "1")
		echo "Your order is ready for pickup.<br>";
	else 
	if ($bool == "2")
		echo "Sorry, your order cound not be processed.<br>
		Your credit is refunded. Remaining credit: $bal.<br>";
}

	
?>

 

i counted the array, it has 4 items in it..why does it loop only 3 times??

awaw1.bmp

Edited March 6, 2013 by DuaneCawaling

[AyKay47]

The first call to mysql_fetch_array is moving the pointer to the next row.

Remove that line and the while loop should work as you expect.

[DuaneCawaling]

now i get it, thanks for that info it helped my others codes alot!