my code:
[code=php]
<?php
//connect to database
$connection = mysql_connect (“localhost”, “markbad_drpl1”, “funny”)
or die (‘I cannot connect to the database because: ‘ . mysql_error());
mysql_select_db (“markbad_markbadsql”);
// start the query
$sql = “ALTER TABLE archive DROP barthumb”;
$result = mysql_query(“$sql,$connection”)
or die (“Query failed”);
?>
The worst part is this is how my book says to do it and it just plain out says query error to me. All I really want to do is change it from one name to another but All I can find to help me is DROP and ADD! don’t know hot to set a definition. MAN I WISH THIS WAS A TAD EASIER!