Posted by Garry Jones on 10/19/06 23:46

I tried to follow your advice. Not very well I am afraid. These are my
actual table names, field names and the resulting error.

<?
(code to open database)
$upgcollect='SELECT * FROM scfmforening ORDER BY scfmfor';
$upg=mysql_query($upgcollect);
$ml_collect='SELECT * FROM ml_lopp ORDER BY loppnmn';
$ml_upg=mysql_query($ml_collect);
$num_ml=mysql_numrows($ml_upg);
mysql_close();

SELECT;
$upg1.scfmnumm, $num_ml.scfmnum;
FROM scfmforening $upg1;
LEFT JOIN ml_lopp $num_ml;
ON $upg1.scfmfor = $num_ml.loppnmn;

echo '<table>';
$i = 0;
while i < $num_ml{
$scfmnum=mysql_result($ml_upg,$i,"scfmnum");
$loppnmn=mysql_result($ml_upg,$i,"loppnmn");
echo '<tr><td width="225">';
print $loppnmn;
echo '</td><td width="225">';
print upg1.scfmfor;
echo '</td><td width="50">';
print $scfmnum;
echo '</td></tr>';
$i++;
}
echo '</table>';

?>

This give this error

Parse error: syntax error, unexpected T_VARIABLE on line 10

Line 10 is
$upg1.scfmnum, $num_ml.scfmnum

Any idea what I am not grasping?

Garry Jones
Sweden

• Next in forum: Re: How do you pass a variable via a "pseudo-directory" or URL prefix?
• Prev in forum: Re: CSV output
• Thread view: Re: Linking tables to display data?

[Reply to this message]