teishu

hi guys,
not posted for a few weeks but anyway, ive got a problem with part of a system im developing at work.

heres the code:

[php]
<?php
$db = mysql_connect("localhost", "Administrator", "pass"); //Server connection
mysql_select_db("learn_php",$db); //Select database on mysql server
$result = mysql_query("SELECT * FROM multi_data",$db); //send mysql query
$num_rows = mysql_num_rows($result); //retreive number of lines

for($i = 0;$i != $num_rows; $i += 1)
{
$query = mysql_query("SELECT `job_ref` FROM `frontscreen` WHERE `ID` = $i+1",$db);
$data =
echo "<tr>
<td
style=\"text-align: center; font-family: Helvetica,Arial,sans-serif;\"
valign=\"undefined\">"mysql_fetch_assoc($query)"</td>
<td
style=\"text-align: center; font-family: Helvetica,Arial,sans-serif;\"
valign=\"undefined\"></td>
<td
style=\"text-align: center; font-family: Helvetica,Arial,sans-serif;\"
valign=\"undefined\">23:41</td>
<td
style=\"text-align: center; font-family: Helvetica,Arial,sans-serif;\"
valign=\"undefined\">1:15</td>
<td
style=\"text-align: center; font-family: Helvetica,Arial,sans-serif;\"
valign=\"undefined\">3:15</td>
<td
style=\"text-align: center; font-family: Helvetica,Arial,sans-serif;\"
valign=\"undefined\">18:00 25/09/2007</td>
</tr>
";
}

?>
[/php]Im trying to retreive the data in the job_ref field for each ID row into the appropriate part of the html table, this is just the php section no the entire code for the page.

here is the error i get:

Any help would be great thanks !


The password in the above has been changed for security...

__________________
AMD Athlon X2 4200+ -- Asus V3-M2V890 -- 2GB Kingston -- Vista Ultimate 32bit + Ubuntu 8.04
Intel C2D T5870 2.0GHZ -- Vostro 1510 -- 2048MB -- Windows XP SP2

ASCII stupid question, get a stupid ANSI !