I am writing a blog application.
Table blog has the blog entries
Table blog_owners is the user profiles
Table blog_responses is responses to the blog entries
I am writing the module where the user approves or deletes user comments
when the blog entry is in 'moderated' mode.
I am trying to find
Ron Piggott wrote:
I am writing a blog application.
Table blog has the blog entries
Table blog_owners is the user profiles
Table blog_responses is responses to the blog entries
I am writing the module where the user approves or deletes user comments
when the blog entry is in 'moderated' mode.
Can you inner join 3 tables together? Do you know what the syntax would be?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
07:07:06 -0500 Subject: [PHP-DB]
inner join Can you inner join 3 tables together? Do you know what the syntax
would be? Ron -- PHP Database Mailing List (http://www.php.net/) To
unsubscribe, visit: http://www.php.net/unsub.php
Hi,
you could use:
select * from pacients p
inner join clinics c on (c.idclinics = p.idclinics)
inner join state s on (p.iodstate = s.idstate)
and so on...
you can use inner join or left join this way with many tables, view,
procedures e etc..
2007/10/21, Ron Piggott [EMAIL PROTECTED]:
Can
Thanks guys. That is really cool ... 3 tables all working together. Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
for building my website i am implementing a tree-style data organization.
for that i have a mysql table called 'jm_tree':
CATID, int(10)auto_increment - Index
PARENT, int(10) -the CATID of
the 'parent' node
TEXT, varchar(40)
: Tuesday, June 25, 2002 6:48 AM
Subject: [PHP-DB] INNER JOIN by field content
for building my website i am implementing a tree-style data organization.
for that i have a mysql table called 'jm_tree':
CATID, int(10)auto_increment - Index
PARENT, int(10