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]

Reply via email to