LiveWhale CMS

Welcome, Guest Login

Support Center

Our documentation is moving:

Please check for the most up-to-date LiveWhale CMS and LiveWhale Calendar documentation. The below legacy documentation will remain available as a reference until the documentation migration is complete.

Long Form (extensive SQL request)

Last Updated: Nov 25, 2015 10:45AM PST

The long form allows you to specify a much more extensive SQL request by utilizing methods that match the SQL commands. Simply chain the needed methods together to complete an entire SQL request.


// reasonably complex example
$_LW->dbo  ->select(array('*', ' AS image_id'))  ->
from('livewhale_news')  -> join('livewhale_images2any', array('id2' => ''))  ->
join('livewhale_images', array('' => 'livewhale_images2any.id1'))  ->
where("livewhale_news.title LIKE '%?%'", $foo);
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found