No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi All, here's the query.... $risk_section=$row_risk_category['risksectid']; mysql_select_db($database_auditing, $auditing); $qry_selfsites = sprintf("SELECT tblself.siteid AS selfsite, tblsite.sitename AS sitename, tblsite.address AS address, tblpct.pctname AS pctname, tblresultsnew.total, tblresultsnew.auditid AS auditid, tblriskcategories.risksectid AS risksectid, tblriskcategories.risksection AS risksection FROM tblself LEFT JOIN tblresultsnew ON tblself.auditid = tblresultsnew.auditid LEFT JOIN tblsite ON tblself.siteid = tblsite.siteid LEFT … |
|
Hi all, this is what I've built: A dynamically built form which selects the questions depending on the section of the form it's in. The problem: Each form input is called `answer[]` passing the selected value to an update query $updateSQL = sprintf("UPDATE tblsite SET sitetypeid=%s, pctid=%s, contactname=%s, address=%s, postcode=%s, … |
|
Hi, This is what I'm trying to achieve...... An html table on a page which shows results from a series of races with the competitors listed on the x axis and the results per race on the y. Each series has a different number of races so it isn't possible … |
|
Hello, Despite much searching, I've hit a wall with trying to get a varying number of records inserted into a database. Here's what I'm trying to do..... I'm building an online sign on site for races at a sailing club. For the sign on page, I want to make it … |