macromedia flash flash remoting: My query goes like this:

SELECT * FROM database WHERE table1 LIKE '%$ingr%' OR table2 LIKE '%$ingr%'

mdalene a =E9crit :
[quoted text, click to view]
mhh...
I think :

SELECT * FROM table WHERE field1 LIKE '%$ingr%' OR field2 LIKE '%$ingr%'

Try protecting your variables.....

$ingr is probably being matched!!

therefore try this:

"SELECT * FROM table WHERE field1 LIKE '%" . $ingr . "%' OR field2 LIKE
'%".$ingr."%'";

------ actual code (which assumes you've already connected to the DB)

$sql = "SELECT * FROM table WHERE ";
$sql .= "field1 like '%".$ingr."%' or ";
$sql .= "field2 like '%".$ingr."%'";

$result = mysql_query($sql, $dbcnx);
while ($row = mysql_fetch_row($result)) {
etc...........

Are you sure the SQL syntax is right ?

it's should be
SELECT * FROM tableNameWHERE fieldName1 LIKE '%$ingr%' OR fieldName2 LIKE '%$ingr%'

Have a nice day
--
dott. daniele galiffa
multimedia designer & developer
Macromedia Flash MX Developer Certified
daniele@mentegrafica.it
"mdalene" <webforumsuser@macromedia.com> ha scritto nel messaggio news:cs8hfl$gn8$1@forums.macromedia.com...
[quoted text, click to view]