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" <[EMAIL PROTECTED]>
To: "Rick Emery" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> > Sent: Thursday, August 23, 2001 11:22 PM
> > To: [EMAIL PROTECTED]
> > 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" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > 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: [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]
--
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]