Fetch php Mysql record

Question

I have an array in which 7 Id exist . I want to Fetch Record Of that ids In AND Operator My Query Is this

my array that Hold & ids is this $type_id

$query =("SELECT * FROM property Where Id ='".$id."' AND property_type='".$type_id."' ");

How This Query Execute That it Got all Records Of type_id

 if Print_r($type-id);

Then result is

1,7,5,8,5,4,9

Any Suggetion And Help will Be appreciated

On a side note, please escape the variables in your query if you aren't already doing so. — supakeen
– supakeen, Commented Dec 27, 2011 at 12:49

Sonal Khunt · Accepted Answer · 2011-12-27 12:46:20Z

1

$type-id

is wrong variable in php so your result goes wrong use $type_id instead

answered Dec 27, 2011 at 12:46

Sonal Khunt

1,89612 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sorry i mean variable, - is operator in php so its not allowed in variable name...

$type-id is an invalid identifier, the - character is not allowed.

liquorvicar · Accepted Answer · 2011-12-27 13:02:13Z

0

Not sure if I'm completely clear what you're asking but I think you need the IN operator, something like this:

"SELECT * FROM property 
 Where Id ='".$id."' AND 
 property_type IN (".implode(',',$type_id).") "

answered Dec 27, 2011 at 13:02

liquorvicar

6,1462 gold badges19 silver badges21 bronze badges