This is My Array : myArray
Array
(
[animals] => Array
(
[cat] => Miyavv
[dog] => Hav hav
[snake] => sSSSssSssss
[bird] => Cik Cik Cik
)
[a big animal] => dinosaur
[its smaller then 100] => 90
)
|
Fetch All Animals as Objects
<?php
$Linq->Query("SELECT key Animal Name,value As Sound FROM myArray.animals ORDER BY Sound DESC");
?>
Found 4 Animal(s)
Array
(
[Animal Name] => snake
[Sound] => sSSSssSssss
)
Array
(
[Animal Name] => cat
[Sound] => Miyavv
)
Array
(
[Animal Name] => dog
[Sound] => Hav hav
)
Array
(
[Animal Name] => bird
[Sound] => Cik Cik Cik
)
Find all animals which has a sound like "cik cik"
<?php
$Linq->Query("SELECT key Animal Name,value As Sound FROM myArray.animals WHERE value LIKE '%cik cik%' ");
?>
#010 Invalid SQL
|