Posted by Shelly on 08/03/05 13:39

"utque" <utqsall@gmail.com> wrote in message
news:1123054221.632845.204180@g14g2000cwa.googlegroups.com...
> while you are accessing the sql database, try using the INNER JOIN
> command.
> $sql = mysql_query("SELECT * FROM logintableb INNER JOIN datatable
> WHERE
> logintable.school = datatable.school");
>
> I am not sure of it but trying doesn't hurt.
>

You post appeared **six** times. There seems to be a problem with your
newsreader.

This works:

$sql = mysql_query("SELECT * FROM logintableb, datatable WHERE
logintable.school = datatable.school");

there is no need to explicitly state "INNER JOIN".

Shelly

• Next in forum: Re: PHP query in URL to show as Filename instead.
• Prev in forum: Re: preg_match - windows filenames
• Thread view: Re: problem with getting info from 2 tables in PHP / MySQL

[Reply to this message]