maandag 27 juni 2011

PHP SQL




/* Database config */

$db_host = '';
$db_user = 'blokuser';
$db_pass = '123test';
$db_database = 'blok';


$link = mysql_connect($db_host,$db_user,$db_pass) or die('Unable to establish a DB connection');
mysql_select_db($db_database,$link);

$query = "SELECT * FROM `blok_tips` WHERE 1";
$result = mysql_query($query);

mysql_close();

echo "
Database Output


";
$num=mysql_numrows($result);

$i=0;
while ($i < $num) {
$text=mysql_result($result,$i,"text");
$last=mysql_result($result,$i,"plaatje");
echo "sdf";
echo "$text $last
";
$i++;
}
echo "einde";
?>

Geen opmerkingen:

Een reactie posten