Re: Remove white space?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



1. Don't cross-post!
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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux