You could maybe try some SQL like this:
function getEvents() {
$query = "SELECT e.id, e.name, c.name AS city_name,
DATE_FORMAT(e.event_date, '%d/%m/%Y') AS display_date FROM events e,
cities c WHERE e.city_id=c.id";
$resource_id = mysql_query($query);
return $resource_id;
}
(presuming your Cities table is called "cities" and that it has a field
called name in it)
Hope this helps,
Kelvin.
Marcelo de Moraes Serpa wrote:
> Well, let me try to explain this better...
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.2/329 - Release Date: 02/05/2006
_______________________________________________
osflash mailing list
[email protected]
http://osflash.org/mailman/listinfo/osflash_osflash.org
