"Robert Sossomon" <[EMAIL PROTECTED]> wrote in message
> 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

Use trim() to remove white space at the beginning and end of the string and
strtolower() to convert to lower case.

Regards, Torsten

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to