In article <007901c0b153$ae861a80$660083ca@oemcomputer>,
[EMAIL PROTECTED] ("Mick Lloyd") wrote:
> Thanks for the reply. I tried the variable route but again failed. I think
> from your suggested line of code you may have misunderstood the problem. The
> LIKE option works fine without having to
ot;);
\\Prints: No pcodeid \\ie failed
Regards
Mick Lloyd
[EMAIL PROTECTED]
Tel: +44 (0)1684 560224
- Original Message -
From: Darryl Friesen <[EMAIL PROTECTED]>
To: Database Help PHP <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 1:41 PM
Subject: Re: [PHP-DB] More on s
> $resultp = mysql_query("select Primaryid from primarycodes where Code =
> '".$row['Primaryexpertise']."'") or die (mysql_error());
>
> $resultp = mysql_query("select Primaryid from primarycodes where Code
like
> '%$row[Primaryexpertise]%'") or die (mysql_error());
>
> $pcodeid = mysql_fetch_a