Advertisement
Guest User

Untitled

a guest
Sep 9th, 2017
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.60 KB | None | 0 0
  1. <?php
  2.     $dbhost = '';
  3.     $dbuser = '';
  4.     $dbpass = '';
  5.    
  6.     $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
  7.     $dbname = 'IAMA';
  8.     mysql_select_db($dbname);
  9.    
  10.     $sql = "SELECT * FROM `posts`";
  11.     $result = mysql_query($sql) or die(mysql_error());
  12.     $numRows = mysql_num_rows($result);
  13.        
  14.     $r = rand(1, $numRows);
  15.    
  16.    
  17.  
  18.    
  19.     $sql = "SELECT * FROM `posts` ORDER BY id DESC limit ".$r.",1";
  20.     $result = mysql_query($sql) or die(mysql_error());
  21.    
  22.     while($row = mysql_fetch_array($result))
  23.     {
  24.         $n =  $row['name'];
  25.     }  
  26.  
  27.  
  28.     header('Location: viewPost.php?p='.$n);
  29.  
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement