i can inner join Mysql , but I faced a few complaints in the php part, I can explain well visually;
Select
pick_l.location,return_l.location
From reservation_table
INNER JOIN location_table As pick_l ON
pick_l.location_id=reservation_table.pick_adress
INNER JOIN location_table AS return_l ON
return_l.location_id=reservation_table.return_adress;
Code run properly and output is here.
$rSor=$connect->prepare("Select * From reservation_table
INNER JOIN location_table As pick_l ON
pick_l.location_id=reservation_table.pick_adress
INNER JOIN location_table AS return_l ON
return_l.location_id=reservation_table.return_adress
");
$rSor->execute(array(
));
But i get php error. Output is here, just return_adress it returns.
Thanks in advance.
source https://stackoverflow.com/questions/68154359/php-inner-join-to-mysql
Comments
Post a Comment