that line should be ok now
that has put the SQL Server into a variable called recent_sql
Now need to do the actual call
so
$result=mysql_query($recent_sql);;
should give the data from the query into an object called $result
to get from the $result object holing all the data to individual rows we need the next line
$row = mysql_fetch_row($result);
which leaves us pointing at the first row and can access the fields in that row like :
echo $row['price'];
Only difference is that the $link_id optional paremeter has been removed from the mysql_query call - I use $link_id as the return from the module that does the database connection - you don't need it
|