yoshida Posted April 12, 2006 Share Posted April 12, 2006 Hi,I'm figuring out how to link data from multiple tables. This would involve setting a variable, and retrieve data from all tables where the value of that variable is present. This way you can say <? SELECT * FROM database WHERE fieldname='$variable' ?> and make that same query to multiple tables in one script. What's your opinion on how this can be tackled best? Note: since more records in one table can have the same value, the data retrieved this way may not be the data you're looking for.Just a quick mindteaser. Again: I already found a good and reliable way, I'm just curious about your view on this. (file that under 'mutual education')I'll post my code when this post got a view usefull responses, just to prevent biassed replies. Link to comment Share on other sites More sharing options...
Little Goat Posted April 16, 2006 Share Posted April 16, 2006 so what is your code? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now