testacct,
Monday, June 24, 2002, 3:37:37 PM, you wrote:
t> I am comparing songnames from two tables to find a match.
t> My query looks like this:
t> $querymvideo = "select movietable.id, movietable.songname
t> from movietable where TRIM(movietable.songname) LIKE
t> '__$foo' ";
t> The above quer
I am comparing songnames from two tables to find a match.
My query looks like this:
$querymvideo = "select movietable.id, movietable.songname
from movietable where TRIM(movietable.songname) LIKE
'__$foo' ";
The above query works fine except when a songname has the
single quote symbol: "'" or may
