Where clause - Mysidia Adoptables Support Forum

Home Community Mys-Script Creative Off-Topic

		Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports
Where clause

Thread Tools

Display Modes

04-16-2012, 12:49 AM

Hall of Famer Hall of Famer is offline

Administrator, Lead Coder

Join Date: Dec 2008

Location: South Brunswick

Posts: 4,448

Gender: Male

Credits: 624,662

Hall of Famer is on a distinguished road

Oh my, forgot to enclose PREFIX by double quote. The below code should work:

PHP Code:


			
 $stmt = $adopts->join("adoptables_conditions", "adoptables_conditions.id = adoptables.id")
               ->select("adoptables", array(), constant("PREFIX")."adoptables.whenisavail = 'shop'");

__________________

Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site.

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT -5. The time now is 06:36 AM.

Currently Active Users: 2718 (0 members and 2718 guests)
Threads: 4,081, Posts: 32,032, Members: 2,016
Welcome to our newest members, jolob.

What's New?

What's Hot?

What's Popular?