File "trace.php"

Full Path: /home/analogde/www/download/CHESS_2022/trace.php
File size: 1.29 KB
MIME-type: text/x-php
Charset: utf-8

<?php

		include('database.php');
		DB_connexion(); 

		$sql = "SELECT * FROM clone_chessmaster_new";
		
		echo $sql;
		
		$results = mysql_query($sql);
		
		//$row = mysql_fetch_array($results);
		
		//echo $row;
			
		/*if (mysql_num_rows($results) == 0) 
		{
			echo "Vide";
		}

		
		
		
		else
		{
				echo "Pas vide " .mysql_num_rows($results);
		}			
*/

		
		$sql = "SELECT * FROM clone_parties_new";
			
			$results = mysql_query($sql);
			while($row = mysql_fetch_assoc($results))
			{
				$list_timestamp[] = intval($row["date"]);
			}
		
		print_r($list_timestamp);
		
			
		if (mysql_num_rows($results) != 0) 
		{
								echo "Non vide...";
			
								$sql = "SELECT * FROM clone_chessmaster_new";
								$results = mysql_query($sql);

								$n =  mysql_num_rows($results);
								//$sql = "SELECT * FROM chessmaster WHERE id = '$n' ";
								$sql = "SELECT * FROM clone_chessmaster_new" ." WHERE id = '$n' ";
								
								$sql = "SELECT * FROM clone_chessmaster_new ORDER BY id DESC LIMIT 1 ";
								
								echo $sql;
								
								$results = mysql_query($sql);
								$row = mysql_fetch_assoc($results);
								$master = $row['gagnant'];
								
								echo $master;
			
		}		
		else
		{ 
			echo "EMPTY...";
		}		

?>