RE: [PHP] MySQL substrings?

This is actually not so difficult. Just download the mySQL documentation (from mysql.org or .com I believe is where I got it) and search the function list. Johan Alfredeen -----Original Message----- From: Tom Carter [mailto:subs@roundcorners.com] Sent: Sunday, August 19, 2001 8:53 AM To: Chris Lambert; php-general@lists.php.net Subject: Re: [PHP] MySQL substrings? very hard obviously.. I've looked quite a bit before to no avail! I tried guessing it, obviously stupidity prevailed (note to self.. go back and use substring function instead) ----- Original Message ----- From: "Chris Lambert" <chris@php.net> To: <php-general@lists.php.net> Sent: Sunday, August 19, 2001 3:48 PM Subject: Re: [PHP] MySQL substrings? > There is a SUBSTRING() function, its just hard to find with their search > system. > > /* Chris Lambert, CTO - chris@whitecrown.net > WhiteCrown Networks - More Than White Hats > Web Application Security - www.whitecrown.net > */ > > ----- Original Message ----- > From: Tom Carter <subs@roundcorners.com> > To: Seb Frost <seb@raceshoot.com>; <php-general@lists.php.net> > Sent: Sunday, August 19, 2001 10:32 AM > Subject: Re: [PHP] MySQL substrings? > > > | You can achieve the same effect by using left and right > | ----- Original Message ----- > | From: "Seb Frost" <seb@raceshoot.com> > | To: <php-general@lists.php.net> > | Sent: Sunday, August 19, 2001 3:12 PM > | Subject: [PHP] MySQL substrings? > | > | > | > 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 > | > > | > > | > -- > | > 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 > | > > | > | > | -- > | 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 > | > | > | > > > -- > 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 > -- 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