RE: [PHP-DB] Remove white space?
| From: | Hutchins, Richard | Date: | Thu, 22 Apr 2004 14:57:56 +0000 |
| Subject: | RE: [PHP-DB] Remove white space? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34038@lists.php.net to get a copy of this message | ||
Robert,
ltrim() or rtrim() to get rid of the whitespace if it's at the beginning or
end of the data.
strtolower() to turn the string into all lowercase characters.
Rich
> -----Original Message-----
> From: Robert Sossomon [mailto:robert@gcnorris.com]
> Sent: Thursday, April 22, 2004 10:51 AM
> To: php-db@lists.php.net; php-general@lists.php.net
> Subject: [PHP-DB] Remove white space?
>
>
> I am pulling data from a MySQL DB and I need to remove the
> whitespace on
> the variable and turn it to lowercase.
>
> <! Code Snippet>
>
> $get_items = "select * from PFS_items";
> $get_items_res = mysql_query($get_items) or die(mysql_error());
> while ($items = mysql_fetch_array($get_items_res))
> {
> $item_id = $items[id];
> $item_num = $items[item_num];
>
> <! End Code Snippet>
>
> Overtime I need to rewrite my DB loading script to handle this for me,
> but right now I need to band-aid it so that I can auto-generate pages
> and get them loaded into a catalog.
>
> Thanks!
>
> Robert
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>