Multiple table query...

[Ivains]

Hi everyone,
I know I am missing something, but after 4 hours I can't see it. I have 3 tables:

Table One name is authuser:
id
fname
lname
etc...

Table Two name is local_signup:
id
stuID
course
etc...

Table Three name is local_courses:
id
coursecode
coursename
stopdate
etc...

Everytime a user signs up it places thier authuser.id in the local_signup.stuID and the local_courses.id into the local_signup.course. That was a tongue twister...

Now what I am trying to do is query and display this information to show up as:

stuID

local_signup.course | local_courses.coursecode | local_courses.coursename

So, it will display Student XX has signup for all these courses.

Here is a sniplet of my code, which I get the local_signup.course to display but not the rest of the info (e.g. coursecode, etc.)

---

if ($sortby!="")
{
$sorted = " order by $sortby ";
}
$bareQuery = "SELECT local_signup.,authuser.,local_courses.* FROM local_signup,authuser,local_courses WHERE local_signup.stuID = authuser.id AND local_courses.id = local_signup.course";
$queryall = $bareQuery.$sorted;
$resultall = MYSQL_QUERY($queryall);
$numberall = mysql_Numrows($resultall);

if ($numberall==0) {

echo "No Records Found !"; 

}
else if ($numberall>0) {

$x=0;

TIA
Ivan

[kevinsequeira]

.
.
.
.
$bareQuery = "SELECT * FROM local_signup, authuser, local_courses WHERE local_signup.stuID = authuser.id AND local_courses.id = local_signup.course";
$queryall = $bareQuery.$sorted;
echo $queryall;
$resultall = MYSQL_QUERY($queryall);
if(mysql_error()){
echo mysql_error();
}
$numberall = mysql_Numrows($resultall);

reg
kevin