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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
