•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 361,914 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,580 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 1802 | Replies: 3
 |
•
•
Join Date: Jul 2006
Posts: 173
Reputation: 
Rep Power: 3
Solved Threads: 4
Junior Poster
Need update query--Remove the coma "," Hi friends
Thanks for your repaly for all my question..
I need one update query. I have selected the datas are insert with coma ",".
Query
SELECT city
FROM `locations`
WHERE city REGEXP ','
I got the result..
Silver Spring,
Elkins,
PORTLAND,
Baltimore,
I need like this
Silver Spring
Elkins
PORTLAND
Baltimore
I need to remove the "," and restore the values .
Thanks
Vssp
Thanks for your repaly for all my question..
I need one update query. I have selected the datas are insert with coma ",".
Query
SELECT city
FROM `locations`
WHERE city REGEXP ','
I got the result..
Silver Spring,
Elkins,
PORTLAND,
Baltimore,
I need like this
Silver Spring
Elkins
PORTLAND
Baltimore
I need to remove the "," and restore the values .
Thanks
Vssp
•
•
Join Date: Jul 2004
Location: North East Indiana
Posts: 491
Reputation:
Rep Power: 4
Solved Threads: 20
Posting Pro in Training
That's really more of an SQL thing. You may want to try posting there if you don't find your answer here.
It can be done in PHP, probably not as fast, though.
Run your query, parse the result set (Take a look at http://us2.php.net/manual/en/function.stripos.php) and write the update query.
It can be done in PHP, probably not as fast, though.
Run your query, parse the result set (Take a look at http://us2.php.net/manual/en/function.stripos.php) and write the update query.
www.uncreativelabs.net
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
•
•
Join Date: Jul 2006
Posts: 173
Reputation:
Rep Power: 3
Solved Threads: 4
Junior Poster
Hi thanks for your replay
This is the update query
UPDATE `locations` SET city = replace( city, ',', '' ) WHERE city LIKE '%,'
I just share with u
This is the update query
UPDATE `locations` SET city = replace( city, ',', '' ) WHERE city LIKE '%,'
I just share with u
•
•
Join Date: Sep 2005
Posts: 139
Reputation:
Rep Power: 3
Solved Threads: 0
Junior Poster
I THINK YIU CAN USE str_replace
increase youe site traffic
http://www.articleboards.com
Running free html asp php jsp xml xhtml j2ee mysql tutorials
http://www.freewebschools.com
Submit your design portfolio and increase your popularity
http://designers-portfolio.com
http://www.articleboards.com
Running free html asp php jsp xml xhtml j2ee mysql tutorials
http://www.freewebschools.com
Submit your design portfolio and increase your popularity
http://designers-portfolio.com
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
Linear Mode
- How can i update a query that have more than 3 tables using adodc in vb? (Visual Basic 4 / 5 / 6)
- UPDATE query not working properly... (PHP)
- System 32 at startup and "dwn"/"down" pop up at startup (Viruses, Spyware and other Nasties)
- Error while trying the update query (ASP)
- This ought to be simple - extra spaces (PHP)
- "MiCr0s0ft.exe", "Microsoftx.exe" & "ns.exe" viruses?Please Help (Viruses, Spyware and other Nasties)
Other Threads in the PHP Forum
- Previous Thread: Open the exixting pdf file Using PHP
- Next Thread: Mailing List Scripts
