retreiving data from two tables

[droidus]

I am trying to retreive data from two tables. when I run it, it only shows the one file in documents, and not the other one in uploads.

Select *
from uploads, documents 
WHERE uploads.user = '$userID' AND documents.user = '$userID'
ORDER BY uploads.title ASC, documents.title ASC

[Dasher]

Since MySQL is a relational database you need to indicate that relationship such as

WHERE uploads.user = documents.user AND uploads.user = $userID

are the titles also identical ?

WHERE uploads.title = documents.title

Your SELECT statement may need to be more specific too.

[droidus]

What I have is two tables. one is general uploads (pictures, videos, etc.). the other one is of documents. i wanted to combine the two so that the user can see what they have.

[The Little Guy]

Try this:

Select *
from uploads left join documents on (uploads.user = documents.user)
WHERE uploads.user = '$userID'
ORDER BY uploads.title ASC, documents.title ASC

[droidus]

i don't get anything then for this.

[ssystems]

Provide everyone with your current structure and what you want to extract from them. Our mind reading skills haven't been upgraded for a while