Guest User

Untitled

a guest
Apr 26th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. $list_form = "";
  2. $frame = "Frame1";
  3. $query = mysql_query("SELECT * FROM jobs ORDER BY id ASC");
  4. $productCount = mysql_num_rows($query); // count the output amount
  5. if ($productCount > 0) {
  6. while($row = mysql_fetch_array($query)){
  7. $iName_id = $row["id"];
  8. $iName = $row["jobs"];
  9. $iValue = mysql_real_escape_string($_POST[$iName]);
  10. $query = "UPDATE temp_add ('$iName') VALUES ('$iValue') WHERE id='$Cid'";
  11. $sql = mysql_query( $query ) or die (mysql_error() . $query);
  12. $date_sched = "date_sched_" . $iName;
  13. $iValue = mysql_real_escape_string($_POST[$date_sched]);
  14. $query = "UPDATE temp_add ('$date_sched') VALUES ('$iValue') WHERE id='$Cid'";
  15. $sql = mysql_query( $query ) or die (mysql_error() . $query);
  16. $to_do = "to_do_" . $iName;
  17. $cost = "cost_" . $iName;
  18. $tech_paid = "tech_paid_" . $iName;
  19. $ladder = "ladder_" . $iName;
  20. // $query = "INSERT INTO temp_add ()VALUES ();
  21. }
  22. }
  23. } else {
  24. $list_form = "Nothing posted into database";
  25. }
Add Comment
Please, Sign In to add comment