You are here: Re: loading data from database « PHP « IT news, forums, messages
Re: loading data from database

Posted by Satyam on 04/10/05 22:05

You probably mean to make a joined query:

Select * from table1 inner join table2 on table1.name = table2.name where
movies = yes

Notice that the join clause has a few options, the most important you might
have to consider is the 'left join' or 'right join' which allows you to
still see the records of one table even if there is no corresponding record
on the other table.

Satyam


"Micha Biegnol�" <michabig@tiscali.nl> wrote in message
news:20050410140651.30275.qmail@lists.php.net...
> Hi, I am a student of multimedia design.
>
> I have two tables in a database with one same column(column:Name).
> I ask data from table1 collumn:Name. In table2 I want to use the return of
> data from table1 and search table2 collumn:Name for other information. I
> tried joined SELECT, but it didn't work with me.
>
> I hope someone understands what I mean, my english is not so great.
>
> select data from table1.
> SELECT name FROM table1 WHERE movies='yes'
>
> Then I want to select from table2 using the result of select from table1.
>
> SELECT * WHERE..?
>
> Thank you!

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация