Guest User

Untitled

a guest
Jul 21st, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. $lvarcontributor = "SELECT * FROM dD_Contributors WHERE idAlbum = '".$idAlbum."' ORDER BY idContributor ASC";
  2. $lvarresult=mysql_query($lvarcontributor);
  3. $var = 0;
  4. while ($lvarrow = mysql_fetch_array($lvarresult))
  5. {
  6. $var++;
  7. //STUFF HERE...
  8. }
  9.  
  10. If($var == "LAST RESULT") {
  11. //do this
  12. }
  13.  
  14. if (($var + 1) == musql_num_rows($result))
  15. {
  16. //this is the last row
  17. }
  18.  
  19. if( $var == mysql_num_rows($lvarresult) - 1 ) {
  20. // this is the last row, do your thing
  21. }
  22.  
  23. $lvarcontributor = "SELECT * FROM dD_Contributors WHERE idAlbum = '".$idAlbum."' ORDER BY idContributor DESC LIMIT 1";
  24.  
  25. $nextRow = mysql_fetch_array($lvarresult);
  26. while ($nextRow)
  27. {
  28. $currentRow = $nextRow;
  29. if($nextRow = mysql_fetch_array($lvarresult)) {
  30. //Not the last row, data in $currentRow
  31. }
  32. else {
  33. //Last row, data in $currentRow
  34. }
  35. }
Add Comment
Please, Sign In to add comment