Querying a string
Posted: Thu Nov 01, 2007 6:53 am
Hi,
I have the following query setup:
The problem is that all records are returned no just those specified in the query.
The field in the table is defined as varchar.
Any ideas?
I have the following query setup:
Code: Select all
$listSql=("SELECT * FROM sctblAttendee
LEFT JOIN itvtblRegistrations ON itvtblAttendee.intAttendeeId=itvtblRegistrations.intAttendeeId
WHERE strAttendanceOption='na'");
$listRes=mysql_query($listSql);The field in the table is defined as varchar.
Any ideas?