I'm trying to pull data from two tables, Details and Variables. The SQL query below gives me data from Details, but nothing from Variables when I loop throught the results array.
$query = "SELECT Details.Description, Details.DetailValue, Variables.VariableName, Variables.Value
INNER JOIN SavedConfigurations
INNER JOIN Variables
ON Variables.OrderID = SavedConfigurations.OrderID
WHERE Variables.VariableName = 'URL1'
Can anyone please offer suggestions?