|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
December 15th, 2003, 09:37 PM
|
|||
|
|||
|
Need to figure out a mySQL syntax query, I think....
Hey guys,
Im a 16 year old girl who is not very clever when it comes to computer programing, I need to figure out how to write a php script to update a mysql database. Here is my situation, I need to have mysql do a COUNT(*) in "column C" to see how many times lets say the number 5 appears in that column, and if that number 5 appears more than lets say 10 times, I need for that number 5 to correspond to "row 5" and change another column, "column B" in "row 5" to lets say the number 50. Got it? Anyone know how to do this? Ive been trying to figure it out in my head for a week but I just dont know how to do it. I have done extensive google searches but have come up empty handed. Can anyone jot out the php code here to do this? I deeply thank in advance anyone who can help me out.
|
|
#3
December 19th, 2003, 07:40 PM
|
|||
|
|||
|
RE: Need to figure out a mySQL syntax query, I think....
Bluh! My instant reaction is why?
When a solution becomes this complicated it's normally because you haven't seen the easy one! Could do it with a bit of code and more than one query - but my first point still stands. What are you trying to do and is there an easier way to do it?
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Need to figure out a mySQL syntax query, I think.... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
