How to manage MySQL database in Azure?

How do I get a web form to write to a MySQL database using PHP myAdmin?

• I am trying to use a webform to post data to my MySQL database. I have all of this set up on my website that is hosted on yahoo. I have php MyAdmin installed on the server to manage the database. For some reason, I can't get my webform to post the info to my database. Can anyone help?

• Answer:

  <?php // assuming you are posting a field called 'first_name' $first_name =$_POST['first_name']; //use proper values for mysql_user and mysql_password //use proper value for localhost, if you are not using local host. $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } //assuming you are entering this field in a table called 'myfriends' $query = "INSERT INTO myfriends(first_name) VALUES('$first_name')"; mysql_query($query); mysql_close($link); ?>