eharetea

Some example SELECT statements.

MySQL queries.

Date Created:Wednesday March 07th, 2007 09:36 PM
Date Modified:Saturday August 02nd, 2008 03:19 PM

SELECT * FROM folders WHERE folder_id = 1;

$query = '
select
a.link_id,
f.title,
comment.short_desc from comment,
folders AS f,
associations AS a,
categories AS c
where
(comment.link_id = f.folder_id && f.folder_id = a.link_id && a.category_id = c.category_id && '.$id.' = a.category_id)';