Hi,
I'm fairly new to PHPMaker and I'm having the feeling that what I'm doing can be achived much easier but I just cannot figure out a way to do it.
I've searched the forum for hours now...
Firstly I couldn't find a way of filtering with looked up options in a drop down menu. This is why I'm using the $_GET[]-arguments from a dropdown menu I created myself.
My biggest challenge is how to include these selected opions in the query. Including it in the filter (WHERE...) would be easy but how to change the ON argument of the INNER JOIN based on user selection?
Currently I'm running an INNER JOIN query in a custom file like this:
$sql = "SELECT f.ArticelID, f.CustomerPos FROM DTA_AUFPOS f LEFT JOIN DTA_IST_AGANG s ON f.Barcode=s.Barcode AND s.Agang='";
$sql .= $GET['Agang'] . "' WHERE s.ROWID is NULL AND f.ProjectID=";
$sql .= $GET['ProjectID'] . " AND f.OrderID=";
$sql .= $_GET['OrderID'].";
and then print it with
echo $db->ExecuteHtml ...
But in this way it seems I miss out on a lot of further funcionality of the program like formating the results, search options etc. which I need for further development.
Thanking you for any support in this.