PHP help

[Ray]

---------------SOLVED---------------

Hi..

I need some php help. I want to remove some data from a string that comes from a mysql database.

Ex: in the database its "first name" I just want it to say just "first" when its displayed without editing the database.

 

[Tree]

$row['user'] = 'First Name';
$data = explode(' ',$row['user']);
echo $data[0]; // echos 'First';

 

[Bruce_KD]

You can also make mySQL do the work (though if you're selecting from large databases, its probably a very bad idea).

Select SubString(`field`, 1, Locate(' ', `field`) - 1) from `table`

Bruce

 

[Eric]

You can also make mySQL do the work (though if you're selecting from large databases, its probably a very bad idea).

Select SubString(`field`, 1, Locate(' ', `field`) - 1) from `table`

Bruce

In PHP =

$row['user'] = 'first name';

echo substr($row['user'], 0, strpos($row['user'], ' '));

Just as an alternative :tu:

 

[Ray]

is there a way to "trim" the word, because it is on every database entry....

 

[Bruce_KD]

Do you mean you want to delete the first word of every entry in the database?

If so, you can use this mySQL query. (It will update Every entry in the table for the field you specify, so be careful.

Update `table` set `field` = SubString(`field`, Locate(' ', `field`))

If that isn't what you needed, please elaborate.


Bruce

 

[Ray]

no.. i want to remove the "name"

 

[Bruce_KD]

Replace `field` in `table` with the first word of `field`:

Update `table` set `field`=SubString(`field`, 1, Locate(' ', `field`) - 1)

You might want to test this first. Eg, use a "Where" condition, so it only updates one row (Maybe where `field2`='somevalue'). You could also do a quick backup by exporting the table data into a text file, then saving it somewhere.

An even better solution would be a Test table that you try it on first.

That way, if the change isn't as expected, your data isn't corrupted.


Bruce