| Torsten Roehr 2004-04-22, 11:31 am |
| "Robert Sossomon" <robert@gcnorris.com> wrote in message
news:022101c42879$472334e0$6601010a@root
2...
> 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
|