loading data from database
| From: | Micha Biegnol� | Date: | Sun, 10 Apr 2005 14:06:52 +0000 |
| Subject: | loading data from database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-212762@lists.php.net to get a copy of this message | ||
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!