par
Limehit » 22 août 2012, 15:08
<?php
require_once "global.php";
require_once INCLUDES . 'class.db.mysqli.php';
$database = new ClassMySQL($core->config['MySQLi']['hostname'], $core->config['MySQLi']['username'],
$core->config['MySQLi']['password'], $core->config['MySQLi']['database']);
$database->Connect();
$mysqli = $database->link;
$result = $mysqli->query("SELECT username FROM users ORDER BY RAND() LIMIT 1");
$row = $result->fetch_assoc();
echo 'Free = "',$row['username'],'" a été tiré au sort<br>';
echo mysql_result($result);
?>
ça marche, mais n'y a t-il pas moyen de faire plus simple ?
[php]<?php
require_once "global.php";
require_once INCLUDES . 'class.db.mysqli.php';
$database = new ClassMySQL($core->config['MySQLi']['hostname'], $core->config['MySQLi']['username'],
$core->config['MySQLi']['password'], $core->config['MySQLi']['database']);
$database->Connect();
$mysqli = $database->link;
$result = $mysqli->query("SELECT username FROM users ORDER BY RAND() LIMIT 1");
$row = $result->fetch_assoc();
echo 'Free = "',$row['username'],'" a été tiré au sort<br>';
echo mysql_result($result);
?>[/php]
ça marche, mais n'y a t-il pas moyen de faire plus simple ?