-
SELECT * FROM table1,table2 WHERE table1.id = $id AND table2.pid = table1.id
the code above loads all info out of table1 and table2.
Now when I parse the id with the URL ../something.php3?id=1 the page doesn't display anything from the tables...
However after I have filled some cells into table2 with a pid..only then all info appears. Whats up?
-
I'm not going to go into detail but....
I think you would benefit from reading up on and instituting some JOINS. Kevin covered them in his PHP/MySQL article on this site.
Chris
