i have combined 2 topics into 1 on this. i would like to know your views and methods on this.
i have a database, i also have a viewdb.php file where i can view the contents of the database. i have been testing it out for a while getting the tweeks sorted out. now i an happy with it i want to delete all the TEST DATA. i stress its test data because we havent implemented it yet for live projects. at the moment there is a 'select * from TABLENAME' do i substitue SELECT with DELETE to get all the data that is in the viewdb.php deleted? basically i would like to know how to delete the records that have amassed over a period of TESTING time.
i have seen that the table is going to be a long one and because its a table the scrolling will be important. i would like to stick frames (or iframes) into the viewdb.php file so that i can scroll the data but not the column headers. how do i go about doing this? at the moment this is the code. the whole database is enclosed by a table:
echo "<table border=1 cellpadding=2 cellspacing=2 class=biggertext>";
echo "<tr><td><b>date</b></td><td><b>name</b></td><td><b>email</b></td><td><b>contact address</td><td><b>mobile number</b></td><td><b>work/home telno.</b></td><td><b>contact postcode</b></td><td><b>project postcode</b></td><td><b>starter kit</b></td><td><b>survey kit</b></td><td><b>design kit</b></td><td><b>support kit</b></td><td><b>cost and value kit</b></td><td><b>construction kit</b></td><td><b>starter kit pack</b></td><td><b>design and cost pack</b></td><td><b>drawings kit pack</b></td><td><b>permission kit pack</b></td><td><b>what do you need?</b></td><td><b>design style</b></td><td><b>project</b></td><td><b>use</b></td><td><b>engineer</b></td><td><b>party wall</b></td><td><b>architect</b></td><td><b>project<br>manager</b></td><td><b>design</b></td><td><b>lifestyle</b></td><td><b>structural</b></td><td><b>planning</b></td><td><b>building regs</b></td><td><b>other help</b></td><td><b>wheelchair</b></td><td><b>partial eyesight<b></td><td><b>terraced<b></td><td><b>family and<br>childern</b></td><td><b>semi-detached</b></td><td><b>aged</b></td><td><b>allergy</b></td><td><b>detached</b></td><td><b>other needs</b></td><td><b>specify needs</b></td><td><b>project time</b><br><b>completion</b></td><td><b>budget cost</b></td><td><b>project<br>deadline</b></td><td><b>why build</b></td><td><b>other notes</b></td></tr>";
while ($myrow = mysql_fetch_array($result))
{
echo "<tr><td>";
echo $myrow["my_date"];
echo "<td>";
echo $myrow["name"];
echo "<td>";
echo $myrow["email"];
echo "<td>";
echo $myrow["contactaddress"];
echo "<td>";
echo $myrow["mobile"];
echo "<td>";
echo $myrow["workhometel"];
echo "<td>";
echo $myrow["contactpostcode"];
echo "<td>";
echo $myrow["projectpostcode"];
echo "<td>";
echo $myrow["starterkit"];
echo "<td>";
echo $myrow["surveykit"];
echo "<td>";
echo $myrow["designkit"];
echo "<td>";
echo $myrow["supportkit"];
echo "<td>";
echo $myrow["costvaluekit"];
echo "<td>";
echo $myrow["constructionkit"];
echo "<td>";
echo $myrow["starterkitpack"];
echo "<td>";
echo $myrow["designcostpack"];
echo "<td>";
echo $myrow["drawingskitpack"];
echo "<td>";
echo $myrow["permissionkitpack"];
echo "<td>";
echo $myrow["doyouneed"];
echo "<td>";
echo $myrow["designstyle"];
echo "<td>";
echo $myrow["project"];
echo "<td>";
echo $myrow["uses"];
echo "<td>";
echo $myrow["engineer"];
echo "<td>";
echo $myrow["partywall"];
echo "<td>";
echo $myrow["architect"];
echo "<td>";
echo $myrow["projectmanager"];
echo "<td>";
echo $myrow["design"];
echo "<td>";
echo $myrow["lifestyle"];
echo "<td>";
echo $myrow["structural"];
echo "<td>";
echo $myrow["planning"];
echo "<td>";
echo $myrow["buildingregs"];
echo "<td>";
echo $myrow["otherhelp"];
echo "<td>";
echo $myrow["wheelchair"];
echo "<td>";
echo $myrow["partialeyesight"];
echo "<td>";
echo $myrow["terraced"];
echo "<td>";
echo $myrow["familychildern"];
echo "<td>";
echo $myrow["semidetached"];
echo "<td>";
echo $myrow["aged"];
echo "<td>";
echo $myrow["allergy"];
echo "<td>";
echo $myrow["detached"];
echo "<td>";
echo $myrow["otherneeds"];
echo "<td>";
echo $myrow["specifyneeds"];
echo "<td>";
echo $myrow["programtimecompletion"];
echo "<td>";
echo $myrow["budgetcost"];
echo "<td>";
echo $myrow["projectdeadline"];
echo "<td>";
echo $myrow["whybuild"];
echo "<td>";
echo $myrow["otherpreferences"];
}
echo "</table>";
i would still want tables but i want them inside frames. i am nit sure whether i need to split the file up into 2 or have a scrollable Iframe for the lower table that shows the results.
any help on this would be appreciated.
