MySQL substrings?
| From: | Seb Frost | Date: | Sun, 19 Aug 2001 14:12:29 +0000 |
| Subject: | MySQL substrings? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-63388@lists.php.net to get a copy of this message | ||
This is thew sort of thing I want:
SELECT * FROM table ORDER BY substr(field,5,6)
but I don't know the correct function, if there is one, or how to implement
it.
cheers,
- seb
-----Original Message-----
From: Michael [mailto:mwaples@waples.net]
Sent: 19 August 2001 12:51
To: php-general@lists.php.net
Subject: [PHP] Re: transaction
Nafiseh Saberi wrote:
>
> hi.
> in large database with php,postgres
> and when in each time come many request ,
> how do we implement transactions??
> nafiseh.
If you are wanting to run several queries in the one script though the
one transaction -
you'll need to send a begin(as a query) and execute it - then to the
same connection send all your other queries as normal, and follow it up
with a commit.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net