I know this is possible a silly question but my head is spinning now due to trying top
get my head round unix, perl and MySQL at the same time to get my database up and
working.
I am trying to put a search together but am stuck at the correct
where forenames like 'char%' and year = '1967'
if($success) {
print "<H1>Thank you $data_to_input->{firstname}!</H1><P>";
print "I inserted this query: <I>$sql_query</I>";
$returned_table=$DB->query(" select year, surname, forenames, mothers_maiden_name from
FRC_Births where forenames like '$data_to_input->{firstname}%' and year ='1854' order
by id ");
It's ok without the and year = part or without the and forenames part.
Is it possible to put like and = in the same statement, I'll understand if anyone
thinks I should just go bed and try again tomorrow, 19 hrs at this PC is starting to
tell.
I have tried a few diffrent ways but to no avail.
Ken Scotney
