Displaying result from MySQL ? (Help !)

[BlaZe]

I modified the code and currently, this is working fine. I know its a lame and poor code, but its still doing what it should do.

<?php    $id = $_GET['id'];
$db = mysql_connect($hostname,$username,$password);
if(!$db){
    echo 'Failed to connect to database. Check your info';
    }
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * FROM post";
/*$result = mysql_query($query);*/
$result = mysql_query($query) or die(mysql_error());
$title = mysql_result($result,--$id,"title");
$cover = mysql_result($result,$id,"cover");
$info = mysql_result($result,$id,"info");

echo 'ID='.++$id.' - Title='.$title.'';

mysql_close();?>

If anyone can still clean the code and make it efficient, please feel free to do so.

BlaZe Reviewed by BlaZe on 23rd Nov 2011. Displaying result from MySQL ? (Help !) I'm currently learning how to insert data in MySQL database and fetching data from MySQL database. I have learned how to insert, but displaying the result from MySQL is giving me some problems. This is the command to create the tables. I'm confused with the id structure and I guess thats the main root of the error I'm getting at the output. $query="CREATE TABLE post (id int NOT NULL auto_increment,title text(300) NOT NULL,cover text NOT NULL,info text NOT NULL,PRIMARY KEY (id),UNIQUE id Rating: 5