RE: [PHP-DB] listing

Then your select might look like: SELECT * FROM tableA, tableB or SELECT * FROM tableA LEFT JOIN tableB USING(field1) Depends upon what you're trying to do. So far, your requirements have been rather vague. -----Original Message----- From: Andrius Jakutis [mailto:nfs@cis.lt] Sent: Thursday, August 23, 2001 11:51 PM To: Rick Emery; php-db@lists.php.net 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 >