Re: listing

Then you start reading =) http://www.mysql.com/doc/ Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com ----- Original Message ----- From: "Andrius Jakutis" <nfs@cis.lt> To: "Rick Emery" <remery@excel.com>; <php-db@lists.php.net> Sent: Thursday, August 23, 2001 11:50 PM Subject: Re: [PHP-DB] listing > Okay, but what if I want to use data from two tables not only from > "companies" ? > > > > > > > Assuming you've opened a MySQL connection and stored connection in > $connect: > > > > $query="SELECT * FROM mytable"; > > $result = mysql_query($query,$connect) or die("ERROR"); > > > > print "<TABLE>"; > > while( $row = mysql_fetch($result) > > { > > print > > > "<TR><TD>".$row['field1']."<TD>".$row['field2']."<TD>".$row['field3']."</TR> > > "; > > } > > print "</TABLE>"; > > mysql_free_result($result); > > > > The above will create a table and output one table row per row in > database. > > Change field1, fiedl2, field3 to the names of fields in the database. > > > > Richard Emery > > Excel Communications, Inc. > > IT Sr. Project Manager > > (972) 478-3398 > > (972) 944-0542 (pager) > > > > There is no "trying"... > > There is only "Do" or "Not Do" > > > > > > > > -----Original Message----- > > From: Andrius Jakutis [mailto:andrius@internetmedia.lt] > > Sent: Thursday, August 23, 2001 11:22 PM > > To: php-db@lists.php.net > > Subject: Re: [PHP-DB] listing > > > > > > This gives 25 the same entries. I need to list all entries from the table, > > but with loop. > > > > More solutions? > > > > > > "Chris Hobbs" <chobbs@silvervalley.k12.ca.us> wrote in message > > news:3B854E6D.1020107@silvervalley.k12.ca.us... > > > Something like: > > > > > > <? for($i=1; $i<25; $i++) { ?> > > > <table> > > > <tr> > > > <td> > > > <? > > > // php code to output your entry information > > > ?> > > > </td> > > > </tr> > > > </table> > > > > > > <? } ?> > > > > > > Andrius Jakutis wrote: > > > > > > > Hello again, > > > > > > > > Is there oportunity to write this: > > > > > > > > <some php command to loop entries, the way is written bellow> > > > > HTML php coding.+ MYSQL - 1 entries information > > > > <end of loop> > > > > > > > > Something like that: > > > > > > > > <here loop begins> > > > > <table> > > > > <tr> > > > > <td> > > > > first entry information from table "companies" (name, telephone...) > > > > </td> > > > > </tr> > > > > </table> > > > > <loop ends> > > > > > > > > > > > > > > > > THanks. > > > > > > > > > > > > -- > > > > Su pagarba, > > > > > > > > Andrius Jakutis > > > > InternetMedia > > > > http://www.internetmedia.lt > > > > GSM: 370 82 31332 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > Chris Hobbs Silver Valley Unified School District > > > Head geek: Technology Services Coordinator > > > webmaster: > > > http://www.silvervalley.k12.ca.us/~chobbs/ > > > postmaster: chobbs@silvervalley.k12.ca.us > > > > > > > > > > > -- > > 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