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 <[EMAIL PROTECTED]> wrote in message 006401c163fd$bbb34bd0$0ce60281@bang">news:006401c163fd$bbb34bd0$0ce60281@bang... > > I don't quite get what you're asking... Could you be more specific? > > > -----Original Message----- > From: Seany [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 02, 2001 5:48 PM > To: [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> wrote in message > 005c01c163e0$5716ca20$0ce60281@bang">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:[EMAIL PROTECTED]] > > Sent: Friday, November 02, 2001 2:09 PM > > To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]