[Resolved] mysql

[addie]

how i modify and delete data with php to mysql ?

[addie]

anyone can reply ?

[eduard]

dude.... you've got to read some documentation, not just asking any question here.... I mean... this is the basics of mysql.. just use simple sql statements... (http://www.mysql.com for documentation)

select field from table where (field = 'value')
delete from table where (field = 'value')
update table set field = 'newvalue' where (field = 'value')
insert into table (field, field) values ('value1','value2')

Hope i got all the italic tags right 🙂

[cahva]

First connect to mysql server like this:

$server='localhost';
$user='someone';
$passwd='password';
$db=mysql_connect($server,$user,$passwd) or die(mysql_error());
mysql_select_db("yourdb",$db);

Changing and deleting values can be done like this:

// To modify data, use UPDATE and to delete data use DELETE in mysql query
// eg.

// Delete
$query="DELETE FROM tablename WHERE id='3'";
mysql_query($query); // Deletes row which id-field is 3

// Update
$query="UPDATE tablename SET field1='blabla',field2='keukeu' WHERE id='3'";
mysql_query($query); // Modifies fiel1 and field2 in row which id is 3

[addie]

thanks ppl that works 🙂