Guest User

Untitled

a guest
Jan 22nd, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. <?php
  2. $post_title_edited=$post1 . "vs" . $post2;
  3.  
  4. $con2=mysql_connect("$host", "$username", "$password")or die("cannot connect");
  5. mysql_select_db("$db_name2")or die("cannot select DB");
  6.  
  7.  
  8. // Create table
  9. $create = 'CREATE TABLE '. $post_title_edited .'
  10. (
  11. id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  12. user VARCHAR(30) NOT NULL,
  13. user_post VARCHAR(2000) NOT NULL,
  14. date VARCHAR(30) NOT NULL
  15. )';
  16.  
  17.  
  18.  
  19. // Execute query
  20. mysql_query($create,$con2);
  21.  
  22. echo $post_title_edited;
  23.  
  24.  
  25.  
  26. $query='SELECT LAST(id) as LastId FROM '.$post_title_edited.'';
  27. $last=mysql_query($query);
  28.  
  29. echo $last;
  30. ?>
  31.  
  32. $query='SELECT id as LastId FROM '.$post_title_edited.' ORDER BY LastId DESC LIMIT 1';
Add Comment
Please, Sign In to add comment