display problems

[Anon]

alright, thanks to those who helped me last night.. i've fixed most of the problems in the code, but, though the code is displaying SOMETHING now, it still isn't calling from the database properly. here's (at least what i think) the relevant code:

$result = mysql_db_query($dbname, $str_sql_all, $id_link);

$record = @mysql_fetch_object($result);

for ($iindex = 0; $iindex < $number_of_rows; $iindex++) {
$record = @mysql_fetch_object($result);
echo '$record->date_shown : $record->update_headline <br>';
}

the problem is the colon shows up, but neither the date or the headline do. to see what i mean, http://www.factory201.com/sa/groove.php3 and the full code is at http://www.factory201.com/sa/groove.txt

help is greatly appreciated.

[Anon]

Personally I would do it like this:

while ($row = mysql_fetch_array($result)) {
echo \'$row[\"date_shown\"] : $row[\"update_headline\"] <br>\';
}