[SOLVED] Need to execute mysql query with php

[DiscoTrio]

Well I know this is easy but I am trying to make a file where it is the simplest possible way to execute a mysql query.

 

I need to fill in the php script with this:

 

Database name, username, pass.  And the sql query which I have.

 

Here is the query:

 

ALTER TABLE `snews`  ORDER BY `id2` DESC

[DiscoTrio]

errrrrrrrrr, hello.............?

[DiscoTrio]

Dont be shy I just need a start.....

[Mundo]

<?php
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("databasename") or die(mysql_error());
$query = mysql_query("ALTER TABLE `snews`  ORDER BY `id2` DESC");
?>

 

It might also be useful for you to read the following: http://www.tizag.com/mysqlTutorial/index.php

[DiscoTrio]

thanx!

[Mundo]

Oops, made a typo. You might want to copy again.