History function using databases

Stalis

Hello there!!

I'll try to make you all understand but it might not be easy :-)

What I want is to get information from one table and use it for another table.

For example.

Table 1:

Columns: name, dvdid etc. etc.

Table 2:

Columns: id etc. etc.

Now I want to get the dvdid's that match my "name" criteria.
Then use "dvdid" to get specific rows in table 2 and then print it with a while-loop or something.
Like WHERE id = "$dvdid" if it helps to understand what I want.

But the problem is that I have no idea how to solve this.
Do you have to use cookies for this or is there any other way?
I don't know how to use cookies but i'm sure I can learn if necessary.

I hope you all understand what I want to do and do feel free to help 🙂

Please forgive me if there is some bad english, it's not my native language. :rolleyes:

Best regards, Stalis

Edit: Changed Database to Table

planetsim

is it two databases? or two tables?

Basically if its two databases you will have to connect to both databases. This is where a good database abstraction layer will come in handy (probably a little over the top for a beginner in PHP)

Basically you will have to do something like this

SELECT databasename.tablename.*, databasename2.tablename2.* FROM databasename.tablename 
LEFT JOIN databasename.tablename ON (databasename.tablename.dvdid=databasename2.table2.id)

Its not tested and my SQL isnt great .

Stalis

Wooow it was fast 🙂

It's two tables I mean, sorry.

I'll experiment a little and see if it works.

Thanks!!

Stalis

Woohoo!!

It works perfect now!!

Thank you very much.

The modified one I use is:

SELECT * FROM table2 LEFT JOIN table1 ON (table1.dvdid = table2.id) WHERE name = '$name'";

planetsim

Okay glad you got it working and my example sort of helped

Stalis

Hmm, LEFT in LEFT JOIN is not needed.
It works fine anyway or should it be there?

Yes you helped me very much.
Without your code it wouldn't have been solved.