Quick ways to update mysql?

[ade234uk]

I was wondering how everyone else updates their databases using php and mysql and was wondering if there are any other quicker to update as apposed to doing the following.

// make a connection to the database

include "dbconn.php";
mysql_connect($servername,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "UPDATE test_dbase SET name='$ud_name', email_address='$ud_email_address' WHERE id='$ud_id'";
mysql_query($query);
mysql_close();

[jheitz]

Your method seems fine. What do you mean by quick? does the update take too long or are you referring to the fact that you need 6 lines of code for 1 update? In any case, it doesn't seem like your code has any overkill, it is the way to perform an update in MySQL via PHP

[ade234uk]

I am referring to the fact that I need 6 lines of code for 1 update.

However if this is not overkill and is correct I am happy with this. I am always trying to find ways to reduce code. If you can fit everything on one page instead of two I like this.