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