Advertisement
Guest User

Untitled

a guest
Oct 24th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.37 KB | None | 0 0
  1. $result .= "<table border='1'>";
  2. $result .="<tr><td>Cater</td><td>Part</td><td>Gids</td></tr>";
  3. while ($row = mysql_fetch_array($sql)){
  4. $result .= '<tr>';
  5. $result .= '<td>'.$row['Name'].'</td>';
  6. $result .= '<td>'.$row['Part'].'</td>';
  7. $result .= '<td>'.$row['Gid'].'</td>';
  8. $result .= '</tr>';
  9. }
  10. $result .= "</table>";
  11. $result .= "<table border='1'>";
  12. $result .="<tr><td>Cater</td><td>Dish</td><td>Gids</td></tr>";
  13. while ($row = mysql_fetch_array($sql)){
  14. $result .= '<tr>';
  15. $result .= '<td>'.$row['Name'].'</td>';
  16. $result .= '<td>'.$row['Dish'].'</td>';
  17. $result .= '<td>'.$row['Gid'].'</td>';
  18. $result .= '</tr>';
  19. }
  20. $result .= "</table>";
  21.  
  22. Select
  23. 0 as resultset,
  24. Name,
  25. Part,
  26. Gid
  27. From
  28. Parts
  29. Union All
  30. 1,
  31. Name,
  32. Dish,
  33. Gid
  34. From
  35. Dishes
  36. Order By
  37. resultset -- I'm not sure if you need this, or whether you get it for free
  38.  
  39. $result .= "<table border='1'>";
  40. $result .="<tr><td>Cater</td><td>Part</td><td>Gids</td></tr>";
  41. while ($row = mysql_fetch_assoc($sql) && $row['resultset'] === 0) {
  42. $result .= '<tr>';
  43. $result .= '<td>'.$row['Name'].'</td>';
  44. $result .= '<td>'.$row['Part'].'</td>';
  45. $result .= '<td>'.$row['Gid'].'</td>';
  46. $result .= '</tr>';
  47. }
  48. $result .= "</table>";
  49. $result .= "<table border='1'>";
  50. $result .="<tr><td>Cater</td><td>Dish</td><td>Gids</td></tr>";
  51. while ($row){
  52. $result .= '<tr>';
  53. $result .= '<td>'.$row['Name'].'</td>';
  54. $result .= '<td>'.$row['Part'].'</td>';
  55. $result .= '<td>'.$row['Gid'].'</td>';
  56. $result .= '</tr>';
  57. $row = mysql_fetch_assoc($sql);
  58. }
  59. $result .= "</table>";
  60.  
  61. $result .= "<table border='1'>";
  62. $result .="<tr><td>Cater</td><td>Part</td><td>Gids</td></tr>";
  63. while ($row = mysql_fetch_array($sql)){
  64. $result .= '<tr>';
  65. $result .= '<td>'.$row['Name'].'</td>';
  66. $result .= '<td>'.$row['Part'].'</td>';
  67. $result .= '<td>'.$row['Gid'].'</td>';
  68. $result .= '</tr>';
  69. }
  70. $result .= "</table>";
  71.  
  72. $result .= "<hr />"; <=========
  73.  
  74. $result .= "<table border='1'>";
  75. $result .="<tr><td>Cater</td><td>Dish</td><td>Gids</td></tr>";
  76. while ($row = mysql_fetch_array($sql)){
  77. $result .= '<tr>';
  78. $result .= '<td>'.$row['Name'].'</td>';
  79. $result .= '<td>'.$row['Dish'].'</td>';
  80. $result .= '<td>'.$row['Gid'].'</td>';
  81. $result .= '</tr>';
  82. }
  83. $result .= "</table>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement