MySQL - Newbie query

[rvr1]

Hi,

I am undertaking my first project using PHP and mySQL.

What I wish to do is:

After a user has completed a form, I wish to query a table to see if a record with the same name exists. If this exists, certain fields in that record should be updated.

If a record does not exist, a completely new record is added to the table.

Can anyomre please help me with the SQL query I would need to use for this?

Many Thanks.

 

[sleipnir214]

You can't do it in one query.

You'll have to use PHP to perform a SELECT query against the database, analyze the return and react accordingly by sending either an INSERT or an UPDATE query.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[r937]

you can do it with one query

[ ON DUPLICATE KEY UPDATE col_name=expression, ... ]

13.1.4 INSERT Syntax

http://www.mysql.com/doc/en/INSERT.html

rudy

http://r937.com/

SQL Consulting

 

[sleipnir214]

Yeah, you can do it.

Assuming, of course, that rvr1 is running alpha-revision software. The "ON DUPLICATE KEY UPDATE" clause is only available on MySQL 4.1.0.

I find it best in the fora to assume that members are asking questions about production software unless otherwise specified.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[r937]

excellent point, my good sir

usually i preface my suggestions with "if you're on 4.1..."

musta forgot this time, sorry

rudy

http://r937.com/

SQL Consulting