[bmueller77]

Hi altogether,

I want to run SQL-Commands like "UPDATE" in a PHP-Script.
Can anyone please tell me the syntax?

I need two ways to update fields in my MySQL-Database:

- increase a number in a field by pressing a form-button
- run an UPDATE-Command when loading the PHP-File

Thanks

Bjoern

[ermau]

Try researching before you ask, this took me all of 5 seconds (literally) to find.

http://www.mysql.com/doc/en/UPDATE.html
MySQL -> Search -> Update

[bmueller77]

I don't need the syntax of the SQL-Commands.

I need help to integrate it in PHP.

Like this (doesn't work at all)

if ($Submit == "count03")
{$sql = "UPDATE DB3 SET VAR1 = VAR1+1 Where User = 'User01";}
else ?>
<form method="post" action="<?php echo $PHP_SELF?>">
<input type="Submit" name="count3" value>
</form>
<?php

[NeverMind]

it doesn't work because you didn't send the query to database ???
you need to use mysql_query(); to send your query ..
in your post you only defined the query but didn't send it ..
it should be something like this :

PHP Code:

if ($Submit == "count03") 

{

$sql = "UPDATE DB3 SET VAR1 = VAR1+1 Where User = 'User01";

$update=mysql_query($sql)or Die(mysql_error());

$check=mysql_affetced_rows();



if ( $check == 1 ) {

echo'Database was updated succesfully ..';

} else {

echo'database wasn\'t updated !! please try again later ..';

} else { 

try it and see