Inner Join Problem

[sd0t1]

HEllo everyone, i have an inner join Select statement that works great in my sql editor, but when I combine it with the PHP code (a while loop) it comes out NULL.
Does anybody have any ideas why???

Here is the code.

$query = "SELECT DISTINCT program.program_name FROM program INNER JOIN schedule ON program.id = schedule.pid ";
$result = mysql_query($query, $user_login) or die(mysql_error());


while ($row = mysql_fetch_assoc($result));
{
echo $row['program_name'];
}

 

[r937]

if the query works great in your sql editor, then this is a php question, yes? could you perhaps post it in the php forum?

r937.com | rudy.ca

 

[don2241]

Try to give your select colum a name

$query = "SELECT DISTINCT program.program_name as name FROM program INNER JOIN schedule ON program.id = schedule.pid ";

and then

while ($row = mysql_fetch_assoc($result));
{
echo $row['name'];
}