Re: Suggestion for PHP implementation

Hi Peter, Have a look at PEAR::DB, or PEAR::MDB http://pear.php.net/DB $db->getAll('some query'); This would output exactly as you suggested. "Peter T" <pjoe444@yahoo.com> wrote in message news:20041122134905.43437.qmail@web53501.mail.yahoo.com... > Dear webmaster and php revision groups > > Regarding PhP for use with MySql operations; > > A pity there seems no way of getting the CURRENT row > number that's under iteration in a typical loop, > such as: > while ($row = mysql_fetch_assoc($result)) { } > > After all there is an array of row arrays, as > signified by > mysql_num_rows($result): > > Say this gives "40 rows" : it can be useful for web > layout purposes to know when the iteration is on, say, > row 20 or row 39. > > The nearest seems to be "data seek", but it connects > directly to a > row number, as seen on the mysql_data_seek page: > > for ($i = mysql_num_rows($result) - 1; $i >= 0; $i--) > { > if (!mysql_data_seek($result, $i)) { > echo "Cannot seek to row $i: " . mysql_error() > . "\n"; > continue; > } > > = it doesn't solve using row numbers for different > layout purposes within a continuing 'for' loop. > > One reason for this situation is the PhP language > FETCH (fetch-a-single-row) construction, without any > reasonable FOR loop possibility with row numbers. > > * * Suggestion for PhP implementation: * * > $Rows[$i] possibility where > $i would be the row number > > $Rows[$row[], $row[], $row[].....] > reachable as $Rows[0], $Rows[1], $Row[2] etc > > > -- the excellent retrieval WITHIN a row ( $row[$i] ), > while certainly more important, is not matched by > similar possibilities for rows themselves. > > > Below: > This seems the best workaround to get an 'ordinary' > loop going, with possibility of altering output > according to row number > (eg laying out a schedule) > > $rowno=mysql_num_rows($result); > > for ($i=0; $i<mysql_num_rows($result); $i++) { > $row = mysql_fetch_assoc($result); > > print "<div class=\"happening\">"; > print > "<b>".$row['timeon']."-".$row['timeoff']."</b> > ".$row['event']."<br />"; > if ($i!=$rowno-1) { > print "other-html-within-sched-here</div>"; > } > else print "end-last-entry-html-here</div>"; > } //close loop > > Thank you for considering this! > Best wishes, > Peter T > > > > > > > > ___________________________________________________________ > Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier > anmelden: http://mail.yahoo.de