Re: Remove white space?

1. Don't cross-post! 2. Read the string functions in the php manual. You probably don't want to remove all white space, just trim. Have a look at http://ca3.php.net/manual/en/function.trim.php 3. You will find a function to do exactly what you want. Regards - Miles Thompson At 10:51 AM 4/22/2004 -0400, Robert Sossomon wrote:

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