bsanderson
IS-IT--Management
I'm joining two MySQL tables linking the JobNo field on one to the JobNumber field on the other.
SELECT * FROM drawings LEFT JOIN jobs ON drawings.JobNo = jobs.JobNumber
$result = mysqli_query($link, $query);
This works as intended but I have a field called Revision in both tables and the data in them is not the same. How do I differentiate between them?
I tried this but it didn't works
$Revision(mysqli_result($result,$i,"jobs.Revision");
$Rev(mysqli_result($result,$i,"drawings.Revision");
Any help will be greatly appreciated
SELECT * FROM drawings LEFT JOIN jobs ON drawings.JobNo = jobs.JobNumber
$result = mysqli_query($link, $query);
This works as intended but I have a field called Revision in both tables and the data in them is not the same. How do I differentiate between them?
I tried this but it didn't works
$Revision(mysqli_result($result,$i,"jobs.Revision");
$Rev(mysqli_result($result,$i,"drawings.Revision");
Any help will be greatly appreciated