"Robert Sossomon" <robert@xxxxxxxxxxxx> wrote in message news:022101c42879$472334e0$6601010a@xxxxxxxx > 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 Use trim() to remove white space at the beginning and end of the string and strtolower() to convert to lower case. Regards, Torsten -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
