Edit Question - KnowledgeHub

Title Body

I am just learning how to wrap my head around sql and php. I have 4 tables structured as follows +-----------+ +------------+ +---------+ +----------+ | Project | | Slide | | Shape | | Points | +-----------+ +------------+ +---------+ +----------+ | id | | id | | id | | id | +-----------+ | project_id | | cont_id | | shape_id | +------------+ +---------+ | x | | y | +----------+ As you can see the tables are linked by id all the way down to points meaning a project will contain a number of slides that contain a number of shapes that contain a number of points. I have a SQL query SELECT slide.`id`, shape.`id`, points.`x_point`, points.`y_point` FROM `project`, `slide`, `shape`, `points` WHERE 1 = slide.`project_id` AND slide.`id` = shape.`slide_id` AND shape.`id` = points.`shape_id` What I want is to take the results of this query that look like this [0] => stdClass Object ( [id] => 27 [x] => 177 [y] => 177 ) [1] => stdClass Object ( [id] => 27 [x] => 178 [y] => 423 ) [2] => stdClass Object ( [id] => 27 [x] => 178 [y] => 419 ) [3] => stdClass Object ( [id] => 27 [x] => 178 [y] => 413 ) [4] => stdClass Object ( [id] => 27 [x] => 181 [y] => 399 ) [5] => stdClass Object ( [id] => 27 [x] => 195 [y] => 387 ) [6] => stdClass Object ( [id] => 27 [x] => 210 [y] => 381 ) [7] => stdClass Object (

Tags (comma-separated) Cancel