Hello,
I am a noob with cake, and have read the turorials, manual, blog
tutorial, and am excited about starting. One question I have is this:
I have a site with the following DB (this is dummied down):
------------------------
{Table}clients-
id
name
sitecolor
created
modified
{Data} clients
1
Test CO
#CCC
{Table}urls
id
client_id
url
{Data}urls
1
1
subdomain.mysite.com
So in PHP on my header file I would do:
<?PHP
$cleint = $_SERVER['HTTP_HOST'];
$sql = "
SELECT U.*, C.* FROM urls U
left join clients C on U.client_id = C.id
WHERE U.url='demo.test.com'
LIMIT 1
";
print "<table bgcolor="$sitecolor">dsljadlkaljsdal";
?>
How do I go about this with cake...
Thanks
Chris
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
