pulling info from two fields

[kappaluppa]

I hope this is not too confusing....

I have this variable:
$Query = "SELECT *, DATE_FORMAT(date, '%m-%d-%Y') AS date_format FROM $TableName where author_name LIKE '$senator_search' ORDER BY date DESC";

i also want to add:
where subject LIKE '$subject_search'

so that it looks at both SUBJECT field and AUTHOR_NAME field and pulls records that match.

Further in the code i have this:
if (!strcmp($senator_search, "%Andrews%"))
{
how do i add:
$subject_search, "%Andrews%"

to this?

Thanks a lot

[thefury]

use AND.

$Query = "SELECT *, DATE_FORMAT(date, '%m-%d-%Y') AS date_format FROM $TableName where author_name LIKE '$senator_search' AND subject LIKE '$subject_search' ORDER BY date DESC";

[sgbalsekar]

hi,

u duc use and clause in the SQL, author_name LIKE '$senator_search' and subject LIKE '$subject_search'..

as with filtering out Andrews..u cud use regular expression or strchr function to check occurence of Andrews...
if an occurence if not found process the row fetched , else reject it...
you cud also create an array of such names and run for each....

hope this solve u r queries...

regs,
sachin balsekar.