Re: SELECT statement
| From: | Philip Olson | Date: | Tue, 13 Feb 2001 05:39:03 +0000 |
| Subject: | Re: SELECT statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-39352@lists.php.net to get a copy of this message | ||
Assuming you want to select both id and email from table, use commas :
SELECT id,email FROM ...
Also, check out this basic SQL tutorial :
http://www.sqlcourse.com/
It's fairly useful.
regards,
Philip
On Tue, 13 Feb 2001, Peter Houchin wrote:
> Hi,
>
> Can you have a SELECT statement (using mysql) that goes something like
>
> $sql="SELECT id && email FROM table WHERE user='$user' and
> pass='$pass'";
>
> and if you can't is there a away around this?
>
> Thanks
>
> Peter
>