JOIN WHERE

[RON_ron]

Can someone help to fix this piece of code... Does not work?

$checkStudent = "Malakai";

$query = "SELECT * FROM gifts_db LEFT OUTER JOIN grade_db ON gifts_db.student = grade_db.Student WHERE gifts_db.student = ".$checkStudent;

$results = mysql_query($query);

 

while($line = mysql_fetch_array($results)) {

////

}

[trq]

Your going to need to form a proper question before you can expect help.

[RON_ron]

oops.... I get an error.

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ......

 

line: while($line = mysql_fetch_array($results)) {

[RON_ron]

can anyone help?

[jazzman1]

Use 'or die(mysql_error())' at the end of your mysql_query() call.

 

[shlumph]

Malakai isn't in quotes.  That's one problem.  Without knowing your DB structure, and the error you're getting, it's hard to tell what else could be wrong.

[Christian F.]

I strongly recommend that you read this article.