Robert, ltrim() or rtrim() to get rid of the whitespace if it's at the beginning or end of the data. strtolower() to turn the string into all lowercase characters. Rich > -----Original Message----- > From: Robert Sossomon [mailto:robert@xxxxxxxxxxxx] > Sent: Thursday, April 22, 2004 10:51 AM > To: php-db@xxxxxxxxxxxxx; php-general@xxxxxxxxxxxxx > Subject: Remove white space? > > > 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
