Query problem

TomatoLover

I have the following sql script which runs perfectly in MySQL.
However, I tried to do the same thing in PHP, it comes back as error. It complains about WHERE clause.

$query = 'SELECT p.LName, p.FName, p.Mi, p.Phone, h.SecName, s.GClass';
$query .= 'FROM table_personal AS p, table_hs AS h, table_student AS s, table_status AS t';
$query .= 'WHERE t.Program = $_SESSION[\'application\'] AND p.AppId = t.AppId AND p.AppId = h.AppId AND p.AppId = s.AppId';

What's wrong with this code?

stolzyboy

do you get any errors, have you added a mysql_error() in your or die statement when you are actually running the query, like:

$result = mysql_query($query) or die(mysql_error());

TomatoLover

Yes, I do.
And this is the error I got.

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS p, table_hs AS h, table_student AS s, table_status AS tWHERE

stolzyboy

give this one a whirl

<?
$query = "SELECT table_personal.LName, table_personal.FName, table_personal.Mi, table_personal.Phone, table_hs.SecName, table_student.GClass"; 
$query .= " FROM table_personal, table_hs, table_student, table_status";
$query .= " WHERE table_status.Program = '" . $_SESSION['application'] . "' AND table_personal.AppId = table_status.AppId AND";
$query .= " table_personal.AppId = table_hs.AppId AND table_personal.AppId = table_student.AppId";
?>

ramsore

What's wrong with this code?

When you concatenate a string you need to add a space after or before.
So your code should be like this:

$query = 'SELECT p.LName, p.FName, p.Mi, p.Phone, h.SecName, s.GClass ';
$query .= 'FROM table_personal AS p, table_hs AS h, table_student AS s, table_status AS t ';
$query .= 'WHERE t.Program = $_SESSION['application'] AND p.AppId = t.AppId AND p.AppId = h.AppId AND p.AppId = s.AppId';

stolzyboy

that's part of it, but NOT the underlying problem, notice he is selecting stuff AS, ya can't do it like that

TomatoLover

I used AS since table names are long. I created an alias for each table.

Anyway, I tried the way stolzyboy told me but encountered other error. I am trying to fix it now. It has nothing to do with query.

I will let you know if it works after fixing this problem.

TomatoLover

Thanks, stolzyboy.

It seems working....
I guess I cannot use alias.

There is another problem, but it should be my query.
So I will try to fix it.

Thanks again.