trim($YOUR_VARIABLE) = Remove whitespace from beginning and end of string
http://ie2.php.net/trim

strtolower($YOUR_VARIABLE) = Makes a string lowercase
http://ie2.php.net/strtolower

Hope that helps



"Robert Sossomon" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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 General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to