domenica 28 novembre 2010

PHP mysql query

$host = "localhost";
$user = "maxx";
$pwd = "maxx";
$db = 'max_db';

$conn = mysql_connect($host, $user, $pwd) or die(mysql_error());
mysql_select_db($db, $conn) or die(mysql_error());

$queryz = "SELECT * FROM jos_k2_items WHERE id = '1'";
$resultz = mysql_query($queryz) or die (mysql_error()."A");

while ($valori = mysql_fetch_array ($resultz)){
$title= $valori ["title"];
$alias= $valori ["alias"];
$id= $valori ["id"];
}

mysql_close($conn);

Nessun commento:

Posta un commento