WHERE clause with AND - Joomla! Forum - community, help and support

-

hi there,
just wondering how write clause and.

i have google searched have not found looking for. like:

$query->where($db->quotename('first_name') . '='. $db->quote('bob') , ($db->quotename('last_name') . '='. $db->quote('smith'));

thanks!

see this:
http://docs.joomla.org/selecting_data_using_jdatabase





Comments

Post a Comment

Popular posts from this blog

Joomla 3.3 Installation Error message - Joomla! Forum - community, help and support

-
hi all, bought new hosting account , attempting install joomla 3.3. error message getting, instead of joomla installation page. have spoken godaddy support , claim loaded correctly. error displaying error page: table 'i694666_jos1.jos_template_styles' doesn't exist sql=select id, home, template, s.params jos_template_styles s left join jos_extensions e on e.element=s.template , e.type='template' , e.client_id=s.client_id s.client_id = 0 , e.enabled = 1: table 'i694666_jos1.jos_usergroups' doesn't exist sql=select b.id jos_usergroups left join jos_usergroups b on b.lft <= a.lft , b.rgt >= a.rgt a.id = 1 any idea go here? thanks! robin i guess installation did not completed correctly because looks of it, missing table on site. Board index Joomla! 3.x - Ask Support Questions Here Installation Joomla! 3.x
Read more

Multilanguage infinite redirect loop error. - Joomla! Forum - community, help and support

-
i not sure supposed post description again since it's in fpa generated post, sorry if doubled it: i have error firefox "the page isn't redirecting firefox has detected server redirecting request address in way never complete." other browsers such chromium, chrome, ie , more. goes away if turn off language filter plug in need make multilanguage site. error started after duplicated menus 3 languages (english, thai , italian). erased languages , menus did not resume working correctly (unless disable language filter plug in). right there no other languages menus or modules need use them. site @ http://www.itasne.com/palomnik ps forgot tell when try entering site url looks this: http://www.itasne.com/palomnik/index.php// 2 // language /en/ supposed be. problem description :: forum post assistant (v1.2.4) : 17th april 2014 wrote: multilanguage joomla 2.5 site: have error firefox "the page isn't redirecting firefox has detected server redirecting request address ...
Read more

trim media limit reached

-
hello,   i have installed adobe premiere cs 6....and have trouble videos transitions----->cross disolve. normally not problem, when drag , drop videos transitions, can't drag transitions longer in sequence without comment :trim media limit reached.... so can't work on transition.........   how can solve it, should don't find it...   thanks help.......... you cant make transition past end of source clip.  ie dont have enough media.   transitions made overlapping media .   someone post image illustrates this. More discussions in Premiere Pro CC adobe
Read more