Let's say I have two tables, and both their primary identifiers use the name 'id'. If I want to perform a join with these two tables, how would I alias the
SELECT * FROM `sites_indexed` LEFT JOIN `individual_data` ON `sites_indexed`.`id` = `individual_data`.`site_id` WHERE `url` LIKE :url
$var = $result['id'];
Instead of selecting all fields with "SELECT *" you should explicitly name each field you need, aliasing them with AS as required. For example:
SELECT si.field1 as si_field1, si.field2 as si_field2, ind_data.field1 as ind_data_field1 FROM sites_indexed as si LEFT JOIN individual_data as ind_data ON si.id = ind_data.site_id WHERE `url` LIKE :url
And then you can reference the aliased names in your result set.