Advertisement
Guest User

Untitled

a guest
Apr 17th, 2014
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. Column_1 Column_2
  2. 1 value1
  3. 2 value1
  4. 3 value2
  5.  
  6. $query = "SELECT * FROM `table` WHERE `Column_1` = 'value1' ";
  7. print_r($query);
  8.  
  9. echo count($query);
  10.  
  11. $query = "SELECT * FROM `table` WHERE `Column_2` = 'value1' ";
  12. $res = mysql_query($query);
  13. if(mysql_num_rows($res)!=0) {
  14. while($rowData = mysql_fetch_array($res)) {
  15. var_dump($rowData);
  16. }
  17. }
  18.  
  19. $query = "SELECT * FROM `table` WHERE `Column_1` = 'value1' ";
  20. $res = mysql_query($query);
  21. while($row = mysql_fetch_assoc())
  22. print_r($row);
  23.  
  24. Use mysql_fetch_array() function
  25. $query = "SELECT * FROM `table` WHERE `Column_1` = 'value1' ";
  26. $res = mysql_query($query);
  27. while($row = mysql_fetch_array($res))
  28. {
  29. echo $row['Column_1'];
  30. echo $row['value_1'];
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement