Posted by David Haynes on 02/03/06 17:39

JT wrote:
> I am working on a basic webpage in PHP connecting to a mySQL database,
> here is my query...
>
> //query 1
> $query_rs_staff = "SELECT * FROM jtStaff WHERE
> locationID=".$_GET['myDesk'];
> $rs_staff = mysql_query($query_rs_staff);
> $row_rs_staff = mysql_fetch_assoc($rs_staff);
>
>
> //query 2
> $query_rs_section = "SELECT * FROM jtSection WHERE
> sectionID=$row_rs_staff['sectionID']";
> $rs_section = mysql_query($query_rs_section);
> $row_rs_ssection = mysql_fetch_assoc($rs_section);
> ?>
>
>
> I had it working with query 1. then I added query 2 to get from another
>
> table, some additional data. So i have no problems with query 1. When
> ran thru my server, it throws back a parse error on line 20, which is
> the first line of query 2. can someone tell me the correct syntax for
> what i am trying to do here?
>
>
> thanks
>

Watch the quotes:

$query_rs_section = "SELECT * FROM jtSection WHERE
sectionID=". $row_rs_staff['sectionID'];

Personally, I like to have more structure to my queries:

$query_rs_section = "SELECT * "
."FROM jtSection "
."WHERE sectionID = ".$row_rs_staff['sectionID'];

-david-

[Back to original message]