Re: mySQL problem
| From: | php3 at developersdesk dot com | Date: | Tue, 07 Nov 2000 08:52:07 +0000 |
| Subject: | Re: mySQL problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-24061@lists.php.net to get a copy of this message | ||
Addressed to: "Cybercandy Ltd" <allan@cybercandy.co.uk>
php-general@lists.php.net
** Reply to note from "Cybercandy Ltd" <allan@cybercandy.co.uk> Mon, 6 Nov 2000
23:14:54 -0000
>
> Please someone put me out my misery and tell me why this won't work:
>
> $sql = "SELECT pagebase.* FROM pagebase WHERE ((( page &
> pagenum)=\"$page\"))";
>
> Where page is a column containing a 3 letter string (e.g. ABC) and
> pagenum an integer (e.g 1)
>
> What I though the above would do would allow me to carry out a "where"
> against the fields combined (e.g ABC1). What am I doing wrong?
WHERE CONCAT( page, pagenum ) = '$page'
& is a logical operator.
Rick Widmer
Internet Marketing Specialists
www.developersdesk.com