Database help..

[teongkia]

May i know how to delete the specific row of data and write a new one in MySQL database table using php code?Thanks a lot..

[fert]

[code]
ALTER TABLE `table` DROP * WHERE `value`='value'[/code]

[trq]

Read [url=http://hudzilla.org/phpwiki/index.php?title=Databases]this[/url]. This is just one of MANY tutorials, why do you need us to write another?

[jsladek]

Nice tutorial thorpe, I'll have to read that thing...

[teongkia]

<?php
mysql_connect("localhost","root","")or die(mysql_error());
mysql_select_db("pnecnew")or die(mysql_error());

$result = mysql_query("UPDATE example1 SET name='<a href="a1.php">a1</a>' WHERE id='1'")
or die(mysql_error()); 


$result = mysql_query("SELECT * FROM example1 WHERE id='1'")
or die(mysql_error()); 

// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
echo $row['name']." - ".$row['age']. "<br />";
?>
I want to rename the column name which holds id='1'.Can anyone let me know why it doesn't work?Thanks.

[teongkia]

error in line 5.

[trq]

[code=php:0]
$result = mysql_query("UPDATE example1 SET name='<a href=\"a1.php\">a1</a>' WHERE id='1'")
or die(mysql_error());
[/code]

[teongkia]

Oh Thanks guru.Much appreciated ;D