While loop

[Anon]

When this is used it allways skips the first record and diplays all the following records but I can't figure out why.

Thanks
Carmine

$query = mysql_query("SELECT * FROM Calendar where stamp >= \" $year-$month-$day 00:00:00\" and stamp <= \"$year-$month-$day 23:59:59\"  and UserId=\"$UserId\" and CalType=\"Appointment\" ORDER BY stamp");     

         		             				$row = mysql_fetch_array($query);                  

		$subject=$row[subject];   
		$id=$row[id];
		$stamp=$row[stamp];


$newday=day($stamp);
$newmonth=month($stamp);
$newyear=year($stamp);		



// time to start and end day in half hours
$start_index='16';
$stop_index='34';

$person_index='1';




	print "<TABLE width=100% border=1 CELLSPACING=0 CELLPADDING=1 bgcolor=#99CCFF>";
		echo"<tr align=center bgcolor=#000099>";

	echo"<td width=20><font face=ariel><font color=#FFFFFF>Time</font></font></td>";
	echo"<td width=80><font face=ariel><font color=#FFFFFF>subject</font></font></td>";


		echo"</tr>";

		echo"</table>";

	print "<TABLE width=100% border=1 CELLSPACING=0 CELLPADDING=1 bgcolor=#99CCFF>";

print "<TR><TD COLSPAN=1 ALIGN=left>";
print "<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0>\n";

print "<TR HEIGHT=16 align=center><TD width=20% BGCOLOR=#CCCCFF><font color=#CC0000 face=Arial, Helvetica, sans-serif>$year-$month-$day</TD>\n";

for( $i = $start_index ; $i <= $stop_index ; $i++ ) {
	print "<TR >";

	print "<TD  ALIGN=left border=1 BGCOLOR=#9999FF width=10%>";


            $j = intval($i/2);
	$composed_time = mktime( $j ,($i > ($j *2) ? 30 : 0 ) ,0 , $newmonth, $newday, $newyear);

print " <a href=\"../Organizers/operate.php?year=$year&month=$month&day=$day&action=App&hour=$j&start_time=$composed_time\">".$j.":".($i > ($j *2) ? "30" : "00" )."</a>";     

	print "</TD>\n";


			$query2 = mysql_query("SELECT * FROM Calendar where stamp >= \" $year-$month-$day 00:00:00\" and stamp <= \"$year-$month-$day 23:59:59\"  and UserId=\"$UserId\" and CalType=\"Appointment\" ORDER BY stamp");   								 

		while ( $row2=mysql_fetch_array($query2)){

		$subject=$row2[subject];               
		$id=$row2[id];
		$stamp=$row2[stamp];
		$Duration=$row2[Duration];

		$A=get_mysql_to_e($stamp);
		$m=minute($stamp);



			if(($A==$j)&(($i > ($j *2) ? "30" : "00" ))=="$m"){
			echo"<TD WIDTH=50% ALIGN=center border=1 BGCOLOR=#CC99FF ROWSPAN=$Duration >";               

			echo"$subject<br>";

				print"</td>";									

				}
					}
						}




	print "</TR>\n";





print "</TABLE>";
print "</FORM>";
print "</TD></TR></TABLE>";

[Anon]

I didn't look in your code specifically, but this usually happens because you try to use the data more than once. You can "reset" a DB object (much like you would reset an array) by using the following function:

http://www.php.net/manual/en/function.mysql-data-seek.php

doing this in between each use will allow you to re-use it as much as needed.

[techek]

I'm not really quite sure what you're trying to accomplish, but this is the way that I normally "traverse" the output of my SQL-query :

<?php
$sql = "SELECT id, attrib FROM table";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result) > 0) {
$rownr = 0;
while($row = mysql_fetch_array($result)) {
$id = $row['id'];
$attrib = $row['attrib'];
// if($rownr >= 10 && $rownr < 20) {
echo "|$id|$attrib|<br>\n";
// }
$rownr++;
}
}
?>

If you uncomment the two commented lines, you'd only get a certain number of rows, but even that can be handled even better using MySQLs own LIMIT. If this doesn't help you on your troubled way, feel free to write me.