Darryl
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 put it into a variable.
$sql = "select Primaryid from primarycodes where Code =
'$row[Primaryexpertise]'";
print $sql."<BR>\n";
\\Prints: select Primaryid from primarycodes where Code = 'Biology' \\which
seems OK
$resultp = mysql_query($sql) or die ("Failed"); \\This seems to work
$pcodeid = mysql_fetch_array($resultp) or die("No pcodeid");
\\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 strings
> > $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_array($resultp) or die("No pcodeid");
>
> Two suggestions.:
>
> First, stick the query into a variable instead of using it directly; that
> way you can do some simple debugging (i.e. print the query to the page
> instead of posting this email). Second, take the array variable out of
the
> double quotes, like you did in the first line.
>
> $sql = "select Primaryid from primarycodes where Code like'%" .
> $row[Primaryexpertise] . "%'";
> print $sql . "<BR>\n";
> $resultp = mysql_query($sql) or die (mysql_error());
>
>
> - Darryl
>
> ----------------------------------------------------------------------
> Darryl Friesen, B.Sc., Programmer/Analyst [EMAIL PROTECTED]
> Education & Research Technology Services, http://gollum.usask.ca/
> Department of Computing Services,
> University of Saskatchewan
> ----------------------------------------------------------------------
> "Go not to the Elves for counsel, for they will say both no and yes"
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
