PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
how can i apply join query in the following code? as i want to display all records from the table. Currently i am getting records from the table but with reptition. I have 2 records but 8 records are retrieving with repitition of previous.
you're using an implicit inner join with no limitations on record matching. You need to add a WHERE clause that locks records together to form the record you wish them to be.
$sql="select * from data, proj_analysis, ser_req where data.c_id=proj_analysis.c_id && data.c_id=ser_req.c_id";
Now i want just to display the names from the table and then by clicking on the names of the person like hyperlink i want to view there records . I don't know how to do that. can any body help me?