I've tried what you suggested and it works, thanks.
Russ Michell wrote:
> Try:
>
> $sqlstmt="SELECT * FROM dept WHERE shortname='$shortname'";
> //Include single quotes..
>
> Russ
>
> #-------------------------------------------------------#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> http://gertrude.sipu.anglia.ac.uk/webteam
> [EMAIL PROTECTED]
> +44 (0)1223 363271 ext 2331
>
> www.theruss.com
>
> #-------------------------------------------------------#
--
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]