Code: Select all
Error
SQL-query :
SELECT *
FROM stats
LIMIT 0 , 30
MySQL said:
#1146 - Table 'krunk_gtstat.stats' doesn't existModerator: General Moderators
Code: Select all
Error
SQL-query :
SELECT *
FROM stats
LIMIT 0 , 30
MySQL said:
#1146 - Table 'krunk_gtstat.stats' doesn't existCode: Select all
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 3 in /home/krunk/public_html/gtthing/gtthing3.php on line 25
Username:
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 3 in /home/krunk/public_html/gtthing/gtthing3.php on line 29
Percentage:Code: Select all
<?php
$db = mysql_connect('localhost', 'database', 'password') or die(mysql_error());
mysql_select_db('database') or die(mysql_error());
$sql = "SELECT * FROM stat";
$result = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result)){
$row = mysql_fetch_assoc($result);
echo 'Username: '.$row['username']."<br>\n";
echo 'Percentage: '.$row['percent']."<br>\n";
} else {
echo 'No rows found';
}
?>