Advertisement
Guest User

Untitled

a guest
Jun 24th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. MYSQL TABLE
  2.  
  3. |ID|SOMETHING1|SOMETHING2|SOMETHING3|SOMETHING4
  4.  
  5. $sql="SELECT * FROM TABLE WHERE SOMETHING1 LIKE '%blah%' and SOMETHING2 LIKE '%blah2';
  6. $rs=$conn->execute($sql);
  7. $rsT = $rs->recordcount();
  8. if ($rsT > 0) {
  9. for ($i=0;$i<=$rsT-1;$i++) {
  10. // Randomize Idea Result
  11. $rsRn = rand(0, $rsT - 1);
  12. $results->idea[$i]=$rs->getrows();
  13. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement