Remove white space?
| From: | Robert Sossomon | Date: | Thu, 22 Apr 2004 14:51:20 +0000 |
| Subject: | Remove white space? | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-34037@lists.php.net to get a copy of this message | ||
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