[RESOLVED] join not working

[DKY]

I can't seem to get this join to work in php. It works fine in phpmyadmin so the sql should be okay.

$DispQuery = "SELECT tblmaxxforceinventory.*, tblvisiblepsdbsumoneweekpfil.* FROM tblmaxxforceinventory, tblvisiblepsdbsumoneweekpfil WHERE tblmaxxforceinventory.NAV_PN = tblvisiblepsdbsumoneweekpfil.NAV_PN";
$DispResult = mysql_query($DispQuery) or die(mysql_error().'<br />');
while ($Row = mysql_fetch_assoc($DispResult))
{
ECHO $Row('NAV_PN');
}

[laserlight]

How does it not work?

[DKY]

I just get a blank page. It's not echoing anything...

[DKY]

As a matter of fact, here's the whole file and I don't even get the word "test" echoed out.

<?php
require("connect.php");
$connectmysql = mysql_connect($host,$user,$password) or die ($cantconnectmysqlmessage);
$db = mysql_select_db($database,$connectmysql) or die ($cantconnectdatabasemessage);
$DispQuery = "SELECT tblmaxxforceinventory.*, tblvisiblepsdbsumoneweekpfil.* FROM tblmaxxforceinventory, tblvisiblepsdbsumoneweekpfil WHERE tblmaxxforceinventory.NAV_PN = tblvisiblepsdbsumoneweekpfil.NAV_PN";
$DispResult = mysql_query($DispQuery) or die(mysql_error().'<br />');
while ($Row = mysql_fetch_assoc($DispResult))
{
	ECHO "test".$Row('NAV_PN');
}
?>

which normally would lead me to believe that I'm missing a semi-colon or something but I'm stumped...

[DKY]

I don't know what the problem was but it works now...