I was wondering, to work around MySQL's inability to make subselects, couldn't you create a temp table of the inner select statment, and then execute the outer select statement on the temp table?
If so, how would you do so?
dear sir, i requesting you to sir can you give me seggestion about how to store picture in MYSQL table through PHP code and as well as how to reterive picture from MYSQL Table Through PHP code.
rupak
You could create a temp table (RT-'F'-M), but many commonly used subqueries can be solved by using JOINs instead.
Search the forum and look in the articles section for 'storing binary data in a database'