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:43 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: 625,116

Hall of Famer is on a distinguished road

Oh I see, this is because whenisavail field is present in both columns. The trick here is:

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 02:17 PM.

Currently Active Users: 2512 (0 members and 2512 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?