Raised This Month: $ Target: $400
 0% 

mysql / php thing


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
JocAnis
Veteran Member
Join Date: Jun 2010
Old 08-14-2018 , 16:58   Re: mysql / php thing
Reply With Quote #10

i think i understood what you said, but as i said, with that code, chrome is showing me everything with no problems, but in-game it wont show the same...what code should i post?

is this enough:

Code:
<?php
$con=mysqli_connect("localhost","root","","statistic");
$map_name = $_GET['map'];
$sql="SELECT name, time, date FROM rezultati JOIN players ON players .id=rezultati.id WHERE map=$map_name AND time ORDER BY time ASC LIMIT 15 ";
$records=mysqli_query($con,$sql);
?>
<html>
...style, table code...

<?php
while($st=mysqli_fetch_assoc($records))
{
$i=1;
echo "<tr align=center >";
echo "<td>".$i."</td>";
echo "<td>".$st['name']."</td>";
 echo "<td >".$st['time']."</td>";
  echo "<td>".substr($dr['date'], 0, -8)."</td>";
echo "</tr>";
$i=$i++;
}
?>
</table>
</head>
</body>
</html>
the site is like from above: blablabla.com/recs.php?map=dd2

Last edited by JocAnis; 08-14-2018 at 17:01.
JocAnis is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:43.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode