That didn't quite work, I tried using single quote enclose within double
quotes and it works.
$sqlstmt="SELECT * FROM dept WHERE shortname='$shortname'";
Thanks anyway
ben wrote:
> On Tue, 20 Mar 2001, Shahmat Dahlan wrote:
>
> > I'm trying to use mysql_result to extract data from one particular field
> > in a record. So I suppose the most viable solution is to use
> > mysql_result. But when I do this:
> >
> > $sqlstmt="SELECT * FROM dept WHERE shortname=$shortname";
> > $result=mysql_query($sqlstmt);
> > $temp=mysql_result($result,0,"shortname"); <-- This will give me an
> > error
> >
> > Did I do anything wrong here?
> >
> > Thanks in advance.
> > Shahmat
>
> The problem is that the query is wrong. Try
> $sqlstmt="SELECT * FROM dept WHERE shortname=\"$shortname\"";
>
> (you need to send quotes to mysql if the type of shortname in your
> database is text or the like, that's why there's the \"$var\")
>
> --
> Ben
> History is curious stuff You'd think by now we had enough Yet the fact
> remains I fear They make more of it every year.
--
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]