What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » PHP and MySQL noob

2 votes - 3 average   PHP and MySQL noob
Author: Message:
Ezra
Veteran Member
*****

Avatar
Forgiveness is between them and God

Posts: 1960
Reputation: 31
37 / Male / Flag
Joined: Mar 2003
O.P. Huh?  PHP and MySQL noob
I'm trying to make a webpage, that loads the info from my database, that works fine, and putting info in the database with my self made php works too. But i only want one row, so if i put new info in the database it overwrites the old info.

I read on the mysql page i have to use this:
code:
mysql> INSERT INTO table (a,b,c) VALUES (1,2,3)
    -> ON DUPLICATE KEY UPDATE c=c+1;
mysql> UPDATE table SET c=c+1 WHERE a=1;

But i don't undertand it :S, can someone help me?

TIA
[Image: 1-0.png]
             
01-22-2005 07:47 PM
Profile PM Web Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
PHP and MySQL noob - by Ezra on 01-22-2005 at 07:47 PM
RE: PHP and MySQL noob - by RaceProUK on 01-22-2005 at 08:49 PM
RE: PHP and MySQL noob - by Dempsey on 01-22-2005 at 09:14 PM
RE: PHP and MySQL noob - by Ezra on 01-22-2005 at 09:19 PM
RE: PHP and MySQL noob - by saralk on 01-22-2005 at 09:36 PM
RE: PHP and MySQL noob - by WDZ on 01-23-2005 at 12:44 AM
RE: PHP and MySQL noob - by Ezra on 01-23-2005 at 12:59 AM
RE: PHP and MySQL noob - by WDZ on 01-23-2005 at 01:11 AM
RE: PHP and MySQL noob - by Ezra on 01-23-2005 at 01:33 AM
RE: PHP and MySQL noob - by WDZ on 01-23-2005 at 05:25 AM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On