[SOLVED] Get data from a DB

[forumnz]

I really can't figure out whats wrong with this code??

 

<?php
// Make a MySQL Connection
mysql_connect("localhost", "designervi_mag", "***") or die(mysql_error());
mysql_select_db("designervi_mag") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM mag") 
or die(mysql_error());  

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo stg1; 

} 

?>

[jitesh]

<?php

 

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');

if (!$link) {

    die('Not connected : ' . mysql_error());

}

 

// make foo the current db

$db_selected = mysql_select_db('foo', $link);

if (!$db_selected) {

    die ('Can\'t use foo : ' . mysql_error());

}

?>