Last 7 connections mssql php

[paulocoré]

Hi there.

I'm trying to do a last 7 Connections to the website but when i make it it just appears 1 user ill add here the image also

here is the code :

      <h2 class="title">Ultimas Conecções</h2>
	  <?php
	  $q = mysql_query("SELECT user from log_connection ORDER by date DESC");
	  if (mysql_num_rows($q) < 1 )
	  {
	  echo "Theres no last connections.";
	  }
	  else
	  {
		echo '<nav>
			<ul>
			<center><li><strong>'.mysql_result($q, 0, 'user').'</li></strong></center>
			<center><li><strong>'.mysql_result($q, 0, 'user').'</li></strong></center>
			<center><li><strong>'.mysql_result($q, 0, 'user').'</li></strong></center>
			<center><li><strong>'.mysql_result($q, 0, 'user').'</li></strong></center>
			<center><li><strong>'.mysql_result($q, 0, 'user').'</li></strong></center>
			<center><li><strong>'.mysql_result($q, 0, 'user').'</li></strong></center>
			<center><li class="last "><strong>'.mysql_result($q, 0, 'user').'</li></strong></center>
			</ul>
			</nav>
			';
	  }
	 ?>

image :




If theres no 7 users logs, the <li> will be as "Theres no more users" . any idea on how can i do it?

Thanks.

[Fou-Lu]

MSSQL or MySQL? You say MSSQL in the title, but you are using the mysql library here. If your using MySQL, you can use the LIMIT on it to pull only the 7 records you need, and in SQLServer you can use the TOP command. This image here shows that you are using MySQL and not MSSQL.

Using mysql_result would be incorrect here (even when you have records). That second argument is the row, so it would pull the same 'user' column out 7 times. That is best iterated with a while loop and a fetch (mysql_result is very slow).