Hi.
I have a master table called job and a child table called material.
The SQL for the material is simply
SELECT
Title,
Job_No,
Quantity,
Unit_Price,
Additional_Cost,
Description,
`Date`,
upload,
`File Name`
FROM material
What I would like to do, is on the job_list.php I can view all my jobs by Job_No. I can click on the material and view all the materials for that Job_No which works great.
I have a menu item for Material which uses the above SQL and just lists all the material sorted by Job_No
I can search in the description for an item and view the details. From the view page on the materials, I would like to be able to click on a link to take me to the view page for the job on the Job_No.
I have tried this code
if (@$_REQUEST["editid1"])
echo "<a target=_blank href=\"job_view.php?editid1=".$_REQUEST["editid1"]."\">View Job</a>";
but I can not get it to work.
Any help please?
Thanks
Paul