On Thursday 26 December 2002 07:25, Stephen of Blank Canvas wrote:
> Hi Everyone,
>
> I'm trying to display the content of two mysql tables on a single page,
> I have successfully joined them with the following statement.
>
> $query = "SELECT serv.*, cat.* FROM site_services AS serv,
> site_servicescat AS cat WHERE serv.servicescat_id = cat.servicescat_id
> AND serv.theme_id = $DomainTheme AND serv.status = 1 ORDER BY RAND()
> LIMIT 3";
>
> This works great but my problem is I have a field in each table called
> "title", if I use the normal function of $row[title] I get field from
> the "site_services" table but I cannot work out how to get the
> "site_servicescat" title field. I have tried $row[cat.title] but all I
> get is errors.
>
> Any help would be really appreciated as I think it's just me missing
> something basic.
print_r($row) to see what you have.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
disbar, n:
As distinguished from some other bar.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
