Re: WHERE clause
| From: | Ralph Friedman | Date: | Mon, 04 Mar 2002 10:33:50 +0000 |
| Subject: | Re: WHERE clause | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17443@lists.php.net to get a copy of this message | ||
In article <20020304002843.67937.qmail@pb1.pair.com>, Jennifer Downey wrote:
> $b=mysql_query( SELECT * FROM my_table) <-----can I use something like this
> or do I have to put WHERE in the statement?
>
you only need a "WHERE" clause when you want to limit the result set from the
query. If you want or need to retrieve all the rows in the data base, your
"SELECT" statement is sufficient.
--
Rgds
Ralph