I want to setup my main page to pull from the database for the main news story url and snippet, I've set that end up and it works.
I want to be able to submit changes to the database via a form for my staff who aren't that tech savvy. I don't know what code to use to tell it to replace the row of the table. It's the only row on the table but if I refer to specifics to replace the code will be invalid on it's next use as they have changed. Is there a way to tell it to delete that row and create a new one? still have a problem with specifics though.
EDIT:
I ran this successfully through phpmyadmin
UPDATE `mainpage` SET `pictureurl` = '3',
`storyurl` = '5',
`headline` = '213',
`snippet` = '2' WHERE `pictureurl` = '%' AND `storyurl` = '%' AND `headline` = '%' AND `snippet` = '%' LIMIT 1 ;
Problem is that it says zero rows affected, how do I change that?
SQL Query problem
Talk about and discuss various advancements and achievents in the arts and sciences of invention and modification; computers, sciences, mathematics, and technology for all.
-
- Posts: 17
- Joined: Tue Jan 10, 2006 10:18 pm
Jump to
- Welcome to ADC
- ↳ Reception Area
- ↳ The Members Forum
- ↳ Site Help and Suggestions
- ↳ The Network
- ↳ Resources
- ↳ Portal
- ↳ Study
- ↳ Workshop
- ↳ AF Awards
- The Perfect Stimulus
- ↳ Vertical University
- ↳ AYHJA Tech
- ↳ AF Worldwide
- ↳ Sports
- ↳ The Mean
- ↳ Entertainment
- ↳ Miscellaneous
- ↳ Shits & Giggles
- ↳ Flame On!
- The Prolific Stimulus
- ↳ The Word
- ↳ Optics
- ↳ Music
- ↳ Hip-Hop
- ↳ RnB
- ↳ Alternative
- ↳ Rock
- ↳ Pop
- ↳ Electronica
- ↳ Reggae
- ↳ Classical
- ↳ Metal/Punk
- ↳ Country/Blues/Jazz
- ↳ Misc
- ↳ Video
- ↳ Movies
- ↳ Television
- ↳ Games
- ↳ Music Videos
- ↳ eBooks
- ↳ Books/Novels
- ↳ Magazines
- ↳ Comics
- ↳ AF Select
- ↳ AFS Music
- ↳ AFS Images
- ↳ AFS Video
- ↳ AFS eBooks
- ↳ AFS Software
- ↳ AFS Games
- ↳ AFS Sports
- ↳ Requests
- ↳ Gostosa League
- ↳ Matches [Current]
- ↳ Matches [Archive]
- ↳ NSFW
- ↳ AF Studios
- ↳ The Stacks
- ↳ Images
- ↳ TGP
- ↳ Exhibition
- ↳ Gravure
- ↳ Clips
- ↳ Movies
- ↳ Passes
- ↳ Indexes