Re: losing first row of an array

Nice to see someone else is up! Most times I print result sets as given is inside a do echo"$row[fieldname] while loop but when putting html with it ie. building a table tr td td td td tr etc...etc..... you have to close rows before starting new cells data is then shown fieldname1 fieldname2 data_for_row1 data_for_row1 data_for_row2 data_for_row2 what i would like to do is transpose data so as to write as shown like this fieldname1 data_for_row1 data_for_row2 fieldname2 data_for_row1 data_for_row2 I think a for while do loop would work with ++ inexing but u lose the field calling ability any ideas?? or is it just 12.40am here in the UK Cheers Sean Matthew Loff <matt@willetts.com> wrote in message news:006401c163fd$bbb34bd0$0ce60281@bang... > > I don't quite get what you're asking... Could you be more specific? > > > -----Original Message----- > From: Seany [mailto:php@devoy.ws] > Sent: Friday, November 02, 2001 5:48 PM > To: php-db@lists.php.net > Subject: Re: [PHP-DB] losing first row of an array > > > nice spot I went blind for a min.....lol > > is there any to write columns first but still call fields with headers? > as writing in a table would not allow keeping <tr> tags open > ie. > echo"col[1]"; > echo"col[2]"; > > array_flip do the job? > but how? > > Sean > > > > Matthew Loff <matt@willetts.com> wrote in message > news:005c01c163e0$5716ca20$0ce60281@bang... > > > > You are overwriting the first row. > > > > $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id, > > clubac.ac_year, clubac.ac_type, club.id > > FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id = > > club.id"); > > > > if(mysql_num_rows()) > > while ($row = mysql_fetch_array($result) > > { > > echo "$row[club_id]"; > > echo "$row[id]"; > > echo "$row[ac_year]"; > > echo "$row[ac_type]"; > > } > > else .....blablabla.... > > > > ...Or... > > > > $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id, > > clubac.ac_year, clubac.ac_type, club.id > > FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id = > > club.id"); > > > > $row = mysql_fetch_array($result); > > > > if ($row) > > do { > > echo "$row[club_id]"; > > echo "$row[id]"; > > echo "$row[ac_year]"; > > echo "$row[ac_type]"; > > } while($row = mysql_fetch_array($result)); > > else .....blablabla.... > > > > > > -----Original Message----- > > From: Seany [mailto:php@devoy.ws] > > Sent: Friday, November 02, 2001 2:09 PM > > To: php-db@lists.php.net > > Subject: [PHP-DB] losing first row of an array > > > > > > having this code running PHP4.0b2 > > > > $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id, > > clubac.ac_year, clubac.ac_type, club.id > > FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id = > > club.id"); > > > > $row = mysql_fetch_array($result); > > > > if ($row = mysql_fetch_array($result)) { > > > > do { > > echo "$row[club_id]"; > > echo "$row[id]"; > > echo "$row[ac_year]"; > > echo "$row[ac_type]"; > > > > } while($row = mysql_fetch_array($result)); > > > > } else .....blablabla.... > > > > is there a fundamental miss on my part why the is printing the first > or > > not > > even recognising it > > if call direct in mysql with the above query it's fine with the > results > > even > > if there is 1 row > > > > duh??? > > > > Seany > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >