Hi, the following sql is not returning result I had hoped for
(obviously my problem and not the sql).

I would like to return an array as follows where booking and asset
tables are joined on weeknumber and only results for the current
weeknumber (php variable) are shown

[1] => Array
(
[teacher] => CM
[subject] => Applied Engineering
[yeargroup] => 12
[location] =>
[quantity] =>
)

$sql .= "SELECT booking.*,asset.location,asset.quantity FROM booking
";
$sql .= "LEFT JOIN asset ON booking.weeknumber = asset.weeknumber ";
$sql .= "AND booking.room = asset.room ";
$sql .= "AND booking.period = asset.period ";
$sql .= "AND booking.weeknumber = '$week_number'";

Many thanks,

Chris

In article <0c0a5855-3ad2-4a93-90d6-721b1e41195c (AT) e26g2000vbz (DOT) googlegroups.com>, Chris Percol <chris.percol (AT) gmail (DOT) com> wrote:
It would be a lot easier to suggest how to fix it if you would tell us what
you were expecting to see.

On Nov 20, 8:06*pm, Chris Percol <chris.per... (AT) gmail (DOT) com> wrote:
Yo have neglected to tell us what you are actually getting nor what
teh data in the tables look like.