I´m using a MS access and php4.
i´m trying to send a query with many brackets to make a search on the database:
$connection = odbc_pconnect ('database', 'user', 'pass');
$resultados = odbc_exec($connection,$query2);
my $query2 is this:
SELECT [P-bibliography].ISBN, [P-bibliography].title, [U-authors].name, [U-editors].name, [P-bibliography].year, [P-bibliography].[nbr of pages], InStr(1,Str([year]),"""brazzaville""",1) AS ano, InStr(1,[nbr of pages],"brazzaville",1) AS ndep
FROM ([P-bibliography] INNER JOIN [U-authors] ON [P-bibliography].author = [U-authors].id) INNER JOIN [U-editors] ON [P-bibliography].editor = [U-editors].id
WHERE (((InStr(1,[isbn],"""brazzaville""",1))>"0")) OR (((InStr(1,[title],"""brazzaville""",1))>"0")) OR (((InStr(1,[u-authors].[name],"""brazzaville""",1))>"0")) OR (((InStr(1,[u-editors].[name],"""brazzaville""",1))>"0")) OR (((InStr(1,Str([year]),"""brazzaville""",1))>"0")) OR (((InStr(1,[nbr of pages],"""brazzaville""",1))>"0"));
As you can see it has a lot of " and i can´t replace with '
even if i put ' at the end and beginning of the query code it doesn´t work!
Can you give me a hand, please??
