UPDATE statement in mysql

@diamondsAug 26.2003

I know how to run a SELECT queary in mysql, but how would you execute a update queary?
~~[COLOR=darkred]~~UPDATE `articles` SET `title` = ‘title’,`article` = ‘article text’ WHERE `name` = ‘name’[/COLOR]

to post a comment

PHP

@jacen6678Aug 26.2003 — #I know how to run a SELECT queary in mysql, but how would you execute a update queary?

UPDATE `articles` SET `title` = 'title',`article` = 'article text' WHERE `name` = 'name'
===============

Try:

UPDATE articles SET title='title', article='article text' WHERE name='name'

I think you were using too many quotes.

@diamondsauthorAug 26.2003 — #How do you execute it?

PHP is still looking at it blankly.

[code=php]$sql = "UPDATE articles SET title = '$title',article = '$article_text' WHERE name = '$name'";
 $q = mysql_query($sql);[/code]

@jacen6678Aug 26.2003 — #$sql="UPDATE articles".

" SET title='".$title."', ".

" article='".$article_text."'".

" WHERE name= '".$name."'";

If the query is not the problem, are you sure that the query function is correct? Did you open a connection to the DB, etc?

@diamondsauthorAug 26.2003 — #sure.

Ive connected and selected the database.

PHP is not even returning an error.

?

@jacen6678Aug 26.2003 — #are you using phpMyAdmin? if so, echo the query to screen and paste it into phpMyAdmin's query form... see what happens there.

Can you save the source code as a .txt and attach it here?

@diamondsauthorAug 26.2003 — #Funny...

All of a sudden it is working now?

@jacen6678Aug 26.2003 — #Hahahahaha... computers just dont make sense

UPDATE statement in mysql

7 Comments(s) _↴

UPDATE `articles` SET `title` = 'title',`article` = 'article text' WHERE `name` = 'name'
===============

Also in #PHP _↴

Success!

Social

Version

UPDATE statement in mysql

7 Comments(s) ↴

UPDATE articles SET title = 'title',article = 'article text' WHERE name = 'name' ===============

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

7 Comments(s) _↴

UPDATE `articles` SET `title` = 'title',`article` = 'article text' WHERE `name` = 'name'
===============

Also in #PHP _↴