Mysql help

[GetRekt]

<?php
require_once "global.php";
$getdata = mysql_query("SELECT * FROM server_status WHERE users_online = '1'");
{
echo '<font color=" #78AB46">Online Status:</font> There are currently <b>'.$data['users_online'].'</b> members online! ';
}
?>

how do I select the text of users_online

 

[Zodiak]

<?php
require_once 'global.php';

$getdata = mysql_query("SELECT `users_online` FROM `server_status`");

$data = mysql_fetch_assoc($getdata);

echo '<font color=" #78AB46">Online Status:</font> There are currently <b>'.$data['users_online'].'</b> members online! ';

?>

 

[GetRekt]

Thank you Zodiak
@Markshall @Lepos @Canadian Close Thread

 

[Markshall]

Try avoiding echoing out HTML within PHP, embed PHP within the HTML, like so:

<?php
require_once 'global.php';
$server = mysql_query("SELECT `users_online` FROM `server_status`");
$result = mysql_fetch_assoc($server);
?>
<font color="#78AB46">Online status:</font> There are currently <strong><?php echo $result['users_online']; ?></strong> users online!

Also, mysql_ is deprecated, switch to MySQLi or PDO.

 

[GetRekt]

Thanks Close Thread now @Markshall

 

[Markshall]

Thanks Close Thread now @Markshall

Don't tell me what to do, or I'll fist you.