Advertisement
michaelyuen

Untitled

Jan 7th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.58 KB | None | 0 0
  1. $sql = "SELECT * FROM services ORDER BY groupname ASC;
  2.  
  3. //fetch your form like this:
  4.  
  5. <form>
  6.     <table>
  7.         <tr>
  8. <?php while($row = $result->fetch_assc()) :?>
  9.             <td><label><?= $row['groupname']; ?><input type="hidden" name="srvid[]" value="<?= $row['srvid']; ?>"></label>
  10.             <td><textarea name="rate[]"></textarea></td>
  11. <?php endwhile; ?>
  12.         </tr>
  13.     </table>
  14. </form>
  15.  
  16. // get your record like this:
  17.  
  18. $sql = "SELECT * FROM reseller_service_rate as r LEFT JOIN services AS s ON r.srvid = s.srvid WHERE r.id = {$id}";
  19.  
  20. echo $row['id'] . ':' . $row['groupname'] . ':' . $row['rate'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement