//connect
$dbh = mysql_connect($database,$username,$password);
if (!$dbh) {
die("no db connect " . $mysql_error());
}
//select database
mysql_select_db($database, $dbh);
// mysql_query
$mysql_query = "SELECT date,titel FROM posts WHERE id=$id";
$rv = mysql_query($mysql_query, $dbh);
// mysql_fetch_row
while ($row = mysql_fetch_row($rv)) {
$myDate = $row[0];
$myTitel = $row[1];
}
//mysql_fetch_assoc
while ($row = mysql_fetch_assoc($rv)) {
$myDate = $row["date"];
$myTitel = $tow["titel"];
}
//disconnect
mysql_close($dbh);
|
Sag etwas dazu: