FUDforum: PHP discussions

Home » General » PHP discussions » MySQL Update (Update Code)

Show: Today's Messages :: Polls :: Message Navigator

MySQL Update [message #37877]

Thu, 28 June 2007 15:07

alhelalat

Messages: 3
Registered: June 2007

Karma: 0

Junior Member

hi all
i need the right code to update (status) from active to inactive when the numbers in
(ad_rec) = the numbers in (add_bought)
here is ad image from my database
index.php?t=getfile&id=3399&private=0

thanks you all

Attachment: untitled.GIF
(Size: 11.19KB, Downloaded 1691 times)

Report message to a moderator

Re: MySQL Update [message #37879 is a reply to message #37877]

Thu, 28 June 2007 16:29

1harsh789

Messages: 4
Registered: September 2006

Karma: 0

Junior Member

Try using this SQL. Please backup your data before using this query.

UPDATE your_table_name
SET `status` = 'inactive'
WHERE ad_rec = add_bought

Report message to a moderator

Re: MySQL Update [message #37880 is a reply to message #37877]

Thu, 28 June 2007 16:59

alhelalat

Messages: 3
Registered: June 2007

Karma: 0

Junior Member

thank you so much
but what i need is the php code to insert in my web so to set the status inactive automatically

Report message to a moderator

Previous Topic:	archive file extractor script
Next Topic:	error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 09:39:41 GMT 2024

Total time taken to generate the page: 0.02444 seconds