Jump to content

Search the Community

Showing results for tags 'table'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Welcome to PHP Freaks
    • Announcements
    • Introductions
  • PHP Coding
    • PHP Coding Help
    • Regex Help
    • Third Party Scripts
    • FAQ/Code Snippet Repository
  • SQL / Database
    • MySQL Help
    • PostgreSQL
    • Microsoft SQL - MSSQL
    • Other RDBMS and SQL dialects
  • Client Side
    • HTML Help
    • CSS Help
    • Javascript Help
    • Other
  • Applications and Frameworks
    • Applications
    • Frameworks
    • Other Libraries
  • Web Server Administration
    • PHP Installation and Configuration
    • Linux
    • Apache HTTP Server
    • Microsoft IIS
    • Other Web Server Software
  • Other
    • Application Design
    • Other Programming Languages
    • Editor Help (Dreamweaver, Zend, etc)
    • Website Critique
    • Beta Test Your Stuff!
  • Freelance, Contracts, Employment, etc.
    • Services Offered
    • Job Offerings
  • General Discussion
    • PHPFreaks.com Website Feedback
    • Miscellaneous

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Age


Donation Link

  1. Could someone show me how to make a table that displays data from a Database and allows you to add and delete from it.
  2. Hello friends,I've a code which I've added below and i want the contents of the first three columns(Sl no,Usn,Name) to be inserted from a mysql database,and the remaining colums have text fields where the end user will enter the information which should be stored in some other mysql table.I was successfull in inserting from mysql to html table but i had troubles dealing with other colums ..I had to create multiple tables and join them which resulted in two tables of different height and the overall look and feel was not good..even had trouble dealing with css and javascript support .So i just want to know if is there a way to insert data from my database to the first three columns without effecting the other colums and also by retaining the js nd css support.I've also attached a small screenshot of how the table looks.(Sorry for poor english ) my code:- <!-- Row Highlight Javascript --> <script type="text/javascript"> window.onload=function(){ var tfrow = document.getElementById('tfhover').rows.length; var tbRow=[]; for (var i=1;i<tfrow;i++) { tbRow[i]=document.getElementById('tfhover').rows[i]; tbRow[i].onmouseover = function(){ this.style.backgroundColor = '#f3f8aa'; }; tbRow[i].onmouseout = function() { this.style.backgroundColor = '#ffffff'; }; } }; </script> <style type="text/css"> table.tftable {font-size:12px;color:#333333;width:100%;border-width: 1px;border-color: #a9a9a9;border-collapse: collapse;} table.tftable th {font-size:12px;background-color:#b8b8b8;border-width: 1px;padding: 8px;border-style: solid;border-color: #a9a9a9;text-align:center;} table.tftable tr {background-color:#ffffff;} table.tftable td {font-size:12px;border-width: 1px;padding: 8px;border-style: solid;border-color: #a9a9a9;} table.input {text-align:center;} </style> <table id="tfhover" class="tftable" border="1"> <tr> <th rowspan = "2"> Sl No</th> <th rowspan = "2"> USN</th> <th rowspan = "2"> Name</th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> <th colspan = "1"> Subj Code </th> </tr> <tr align = "center"> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> <th> IA Marks </th> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "s1i" size = "2" /> </td> <td> <input type = "number" name = "s1e" size = "2" /> </td> <td> <input type = "number" name = "s2i" size = "2" /> </td> <td> <input type = "number" name = "s2e" size = "2" /> </td> <td> <input type = "number" name = "s3i" size = "2" /> </td> <td> <input type = "number" name = "s3e" size = "2" /> </td> <td> <input type = "number" name = "s4i" size = "2" /> </td> <td> <input type = "number" name = "s4e" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> <tr> <td> I'm not editable </td> <td> I'm not editable </td> <td> I'm not editable </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> <td> <input type = "number" name = "ia1" size = "2" /> </td> </tr> my database table :- +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | id | int(3) | NO | PRI | NULL | auto_increment | | usn | varchar(15) | YES | | NULL | | | name | char(50) | YES | | NULL | | +-------+-------------+------+-----+---------+----------------+
  3. Is there a better way to load table values into drop down menus? Basically I have 3 different drop down options which need to have data loaded into them from the same table in a database. Here is what I have so far. It works but I feel like there must be a better way to make this happen. <?php include("connect.php"); mysql_connect("$server", "$username", "$password") or die(mysql_error()); mysql_select_db("$database") or die(mysql_error()); // HEADER INCLUDE include("header.php"); echo "<br/><br/>"; echo "<form action='add-record2.php' method='post'>"; // GET ALL DATA FOR "LOCATION" FROM "ADMIN" TABLE $location = mysql_query("SELECT Location FROM admin") or die(mysql_error()); echo "Location:"; echo "<select name='location'>"; while($row = mysql_fetch_array( $location )) { echo "<option value='". $row['Location'] ."'>"; echo $row['Location']; echo "</option>"; } echo "</select><br/> Task Description: <textarea rows='4' cols='50' name='task'></textarea><br/> Responsibility: <select name='responsibility'>"; // GET ALL DATA FOR "RESPONSIBILITY" FROM "ADMIN" TABLE $responsibility = mysql_query("SELECT Responsibility FROM admin") or die(mysql_error()); while($row = mysql_fetch_array( $responsibility )) { echo "<option value='". $row['Responsibility'] ."'>"; echo $row['Responsibility']; echo "</option>"; } echo "</select><br/> Type: <select name='type'>"; // GET ALL DATA FOR "TYPE" FROM "ADMIN" TABLE $type = mysql_query("SELECT Type FROM admin") or die(mysql_error()); while($row = mysql_fetch_array( $type )) { echo "<option value='". $row['Type'] ."'>"; echo $row['Type']; echo "</option>"; } echo "</select><br/> Frequency(days): <input type='text' name='frequency'> <input type='submit'> </form>"; // END OF FORM ?> Thanks John
  4. Hello, New here so apologies if I commit any rule breaks regarding posting. I have been given basic javascript functions with in a HTML page that is supposed to fetch values from a already created database and input these values into the table on the page. Please see this link as an example: http://www.eng.nene.ac.uk/~10406206/CSY2028/Ajax/Ajax.html As you can see there is a table with headers. When the 'Load Database' button is clicked the function is supposed to load the database values into the correct cells. However this does not happen. There is an alert which displays correct information from the database but the values do not get entered into the table? I need to know why this is the case as I have no idea where to go to fix this. Edit: The alert was displaying my database values but now it is not. No errors displaying in the console. I am new to Javascript and Ajax coding so I apologise in advance. Below is the Javascript Functions. <script language="Javascript"> var xmlHttpReq = false; var xmlHttpReq2 = false; var xmlHttpReq3 = false; function appendRecord (id, carname, fueltype, transmission, enginesize, doors, total, available) { //rowcount ++; //if (firstname == "") return; mytable = document.getElementById ("DBTable"); mycurrent_row = document.createElement ("tr"); mycurrent_row.setAttribute ("id", "DB"+id); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (id); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (carname); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (fueltype); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (transmission); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (enginesize); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (doors); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (total); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); currenttext = document.createTextNode (available); mycurrent_cell.appendChild (currenttext); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); mycurrent_input = document.createElement ("input"); mycurrent_input.setAttribute ("type", "button"); mycurrent_input.setAttribute ("value", "modify"); mycurrent_input.setAttribute ("onclick", "modifyOrUpdateRecord (" + id + ", this)"); mycurrent_cell.appendChild (mycurrent_input); mycurrent_row.appendChild (mycurrent_cell); mycurrent_cell = document.createElement ("td"); mycurrent_input = document.createElement ("input"); mycurrent_input.setAttribute ("type", "button"); mycurrent_input.setAttribute ("value", "delete"); mycurrent_input.setAttribute ("onclick", "deleteRecord (" + id + ")"); mycurrent_cell.appendChild (mycurrent_input); mycurrent_row.appendChild (mycurrent_cell); mytable.appendChild (mycurrent_row); } function loadDatabaseRecordsCallback () { if (xmlHttpReq.readyState == 4) { alert ("From Server (Load Records):\n" + xmlHttpReq.responseText); var record = xmlHttpReq.responseXML.getElementsByTagName('record'); var s = ""; for (var i = 0; i < record.length; i ++) { var rec = record[i]; var id = rec.getElementsByTagName("ID")[0].firstChild.data; var carname = rec.getElementsByTagName("CARNAME")[0].firstChild.data; var fueltype = rec.getElementsByTagName("FUELTYPE")[0].firstChild.data; var transmission = rec.getElementsByTagName("TRANSMISSION")[0].firstChild.data; var enginesize = rec.getElementsByTagName("ENGINESIZE")[0].firstChild.data; var doors = rec.getElementsByTagName("DOORS")[0].firstChild.data; var total = rec.getElementsByTagName("TOTAL")[0].firstChild.data; var available = rec.getElementsByTagName("AVAILBLE")[0].firstChild.data; appendRecord (id, carname, fueltype, transmission, enginesize, doors, total, available); } } } function loadDatabaseRecords () { // Mozilla/Safari if (window.XMLHttpRequest) { xmlHttpReq = new XMLHttpRequest(); } // IE else if (window.ActiveXObject) { xmlHttpReq = new ActiveXObject("Microsoft.XMLHTTP"); } alert ("To Server (Load Records):\n\nload.php"); xmlHttpReq.open('GET', "load.php", true); xmlHttpReq.onreadystatechange = loadDatabaseRecordsCallback; xmlHttpReq.send(null); } The loaddatabaserecords function calls the load.php file which is below <?php $link = mysql_connect ("194.81.104.22", "xxxx", "xxxxx"); mysql_select_db ("db10406206"); $query = "SELECT * from XYZ"; $result = mysql_query ($query); header ("Content-Type: application/xml"); print ("<?xml version=\"1.0\" ?>"); print "\n<database>\n"; for ($i = 0; $i < mysql_num_rows ($result); $i ++) { $row = mysql_fetch_object ($result); print " <record>\n"; print " <id>$row->ID</id>\n"; print " <carname>$row->CARNAME</carname>\n"; print " <fueltype>$row->FUELTYPE</fueltype>\n"; print " <transmission>$row->TRANSMISSION</transmission>\n"; print " <enginesize>$row->ENGINESIZE</enginesize>\n"; print " <doors>$row->DOORS</doors>\n"; print " <total>$row->TOTAL</total>\n"; print " <available>$row->AVAILABLE</available>\n"; print " </record>\n"; } print "</database>\n"; mysql_close ($link); ?> Finally this is the html table etc etc. <form name="f1"> <input value="Load Database" type="button" onclick='JavaScript:loadDatabaseRecords()'></p> </form> <table id="DBTable" border="2"> <tr> <td width="20">ID</td> <td width="100">Car Name</td> <td width="100">Fuel Type</td> <td width="100">Transmission</td> <td width="80">Engine size</td> <td width="20">Doors</td> <td width="20">Total</td> <td width="20">Available</td> </tr> <form name="myform"> <tr> <td><input type="text" name="id"></td> <td><input type="text" name="carname"></td> <td><input type="text" name="fueltype"></td> <td><input type="text" name="transmission"></td> <td><input type="text" name="enginesize"></td> <td><input type="text" name="doors"></td> <td><input type="text" name="total"></td> <td><input type="text" name="available"></td> <td colspan="2"><input type="button" value="add" onClick="JavaScript:addNewRecord()"></td> <td colspan="2"><input type="checkbox" value="update" onClick="JavaScript:updateRecord()"></td> <td colspan="2"><input type="checkbox" value="delete" onClick="JavaScript:deleteRecord()"></td> </tr> </form> </table> So, I just want to know whats going wrong. I have spent so many hours researching how to get my database values into the html table. The only responses I have had so far is to display the data in other ways etc. However, i need to display the values in the table as there is other functions that will use the information. Any help would be greatly appreciated. Thanks. Joey
  5. I'm wondering if it's possible in an easy way that when I use while function to call out a bunch of data and put them into table but I want to use css to make it one row with regular background and one row with light background. hopefully what I sad make sense.... this is what I have echo "<style type='text/css'>"; echo "th {background: #CEED5E;}"; echo "</style>"; echo "<table border=1>"; echo "<tr><th>Product ID</th><th>Title</th><th>Author</th><th>Description</th></tr>"; while ($row = mysqli_fetch_assoc($result)) { echo "<tr><td>" . $row["id"] . "</td><td>" . $row["title"] . "</td><td>" . ucwords(strtolower($row["authorFirstName"] . " " . $row["authorLastName"])) . "</td><td>" . $row["description"] . "</td></tr>"; } echo "</table>";
  6. Hi guys, I know a little bit of PHP but I am very new to mysql. How do I change the value (meta_value) of all the wp_s2member_login_counter in this table (wp_usermeta) using php? Thank you very much! This is what I got so far: <?php // Connect to MySQL $link = mysql_connect('mywebsite.com', 'wrd6rEDgggy', 'password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_select_db(wrd_47io4f3a6l); $result = mysql_query("UPDATE wp_usermeta SET wp_s2member_login_counter='0'") or die(mysql_error()); ?>
  7. Hi guys, i have a db in mysql and a script in php gets data from the db and prints a table. The script is the following $connection = mysql_connect("localhost", "Litsa", "integratorgold"); echo $connection; mysql_select_db("mattrix"); $data = mysql_query("SELECT fNo, FieldA, FieldB FROM matin ORDER BY fNo DESC"); Print "<table border cellpadding=3>"; Print "<tr><th>No</th>"; Print "<th>Field A</th>"; Print "<th>Field B</th>"; Print "</tr>"; while($info = mysql_fetch_array( $data )) { Print "<tr>"; Print "<td>".$info['fNo'] . "</td> "; Print "<td>".$info['FieldA'] . "</td> "; Print "<td>".$info['FieldB'] . "</td> "; Print "</tr>"; } Print "</table>"; Obviously, it's not my invention. The above code appears in many tutorials and although being a rookie i made it work. The file "pict-single.JPG" shows the output of the script. Nothing special, it works as expected. The file "pict-double.JPG" shows what i need to do. The $data variable contains the results of the query. It is an array containing the output records sorted as requested. The while part of the code navigates from the first record of the #data variable to the last.Is it possible to address a specific record in $data?
  8. Hi I want to make a table that has table rows like this: There are 3 horses in the sky. There are 4 cows in the stable. There are 5 dogs in the sea. The numbers, the animal names and the places have to be placed neatly below each other, so therefore I probably need to use the <td></td>. I tried using the printf ($format, $number, $animal, $place) function, and the array's $number=array(3,4,5); $place=array(sky,stable,sea); $animal=array(horses, cows, dogs); But I only get one tablerow that says (, There are, Array, Array, in the, Array); Can anyone please tell me what code I have to use to make this? Thanks already.
  9. Hi Just starting with php... This is the first part of the code: <?php $bestek = array ('vorken' => 5, 'messen' => 6, 'lepels' => 7); $servies = array ('borden' => 5, 'kopjes' => 6, 'schalen' => 2); $keuken = array ('bestek' => $bestek, 'servies' => $servies); echo '<table border=1>'; foreach ($bestek as $key => $value) { echo "<tr>"; echo "<td>". $key."</td>"."<td>".$value."</td>"."<br>\n"; echo "</tr>"; } foreach ($servies as $ke => $valu) { echo "<tr>"; echo "<td>". $ke."</td>"."<td>".$valu."</td>"."<br>\n"; echo "</tr>"; } echo "</table>"; ?> Printing the array's $bestek and $servies is not a problem, but now I want to print the $keuken-array in a table. Can anyone please help me with the code for that? I tried several things, but the result always is: Bestek Array Servies Array Thanks already for your help.
  10. mySQL version:5.5.24 I need help with the column type ENUM. What I want to happen is for this column to get either yes or no values. I think ENUM is used specifically for this but i dont know how to set up the column for this to work. I tried to just select ENUM as the type and leave everything else blank but when I save it gives me the error "This is not a number". I have other columns, but im almost sure the error is coming from the ENUM column. Please help.
  11. I am looking to alternate the row color on this loop I have. I have looked up a couple things through google, but none of them seem to fit into what I have. Let me know if this is simple or any suggestions on how to do this. Here is my code: $fields = array('RefNumber'=>'Reference Number','Status'=>'Status','Rep'=>'Rep','Disposition'=>'Disposition','appNumber'=>'appNumber', 'Con_Number'=>'Contract Number','Finance_Num'=>'Finance Number','Phone_Num'=>'Phone Number','Disc_Amount'=>'Discount Amount', 'Total_Cost'=>'Total Cost','Total_MP'=>'Total Monthly Payments','New_MP_Amt'=>'New MP Amount','New_DP_Amt'=>'New DP Amount','Notes'=>'Notes'); // start table and produce table heading echo "<table>\n<tr>"; $color1 = "#EFEFEF"; $color2 = "#FBFBFB"; foreach($fields as $legend){ echo "<th>$legend</th>"; } echo "</tr>\n"; // output table data while($row = sqlsrv_fetch_array( $result,SQLSRV_FETCH_ASSOC)) { echo "<tr>"; foreach($fields as $key=>$not_used) { echo "<td>$row[$key]</td>"; } echo "</tr>\n"; } echo "</table>\n"; $color1 & $color2 are the background colors I want to alternate on each row.
  12. Right now I have a code that outputs results into a table: <?php include 'includes/db_connect.php'; $List = $_GET['List']; if( $connection === false ) { echo "Unable to connect.</br>"; die( print_r( sqlsrv_errors(), true)); } $query = " SELECT LISTCODE, YEAR, COUNT(YEAR) AS Count FROM Names GROUP BY LISTCODE, RIGHT(LISTCODE, 2), YEAR HAVING (RIGHT(LISTCODE, 2) = '$List') ORDER BY LISTCODE, YEAR "; $result = sqlsrv_query($connection,$query); // each array key is the database column name, the corresponding value is the legend/heading to display in the HTML table // the order of the items in this array are the order they will be output in the HTML table $fields = array('LISTCODE'=>'ListCode','YEAR'=>'Year','Count'=>'Count'); // start table and produce table heading echo "<table>\n<tr>"; foreach($fields as $legend){ echo "<th>$legend</th>"; } echo "</tr>\n"; // output table data while($row = sqlsrv_fetch_array( $result,SQLSRV_FETCH_ASSOC)) { echo "<tr>"; foreach($fields as $key=>$not_used) { echo "<td>$row[$key]</td>"; } echo "</tr>\n"; } echo "</table>\n"; sqlsrv_free_stmt ($result); sqlsrv_close( $connection); ?> That all works great and the attached picture originalqueryoutput is what it looks like. Just a little hard to read. What I would like to is have the output look something like the attached picture wantedqueryoutput, which I just did in excel to show an example of what I am going for. Is this possible? And how would I even begin to manipulate the data rows from the query to the table? Thanks in advance for the help!
  13. Hi, I have just started to learn html and php. I have a webpage which retrieves a list of names from a table and adds them to a drop down list within a form. When a user selects a name and presses submit the name is then passed onto the the next php page which displays all the details. I wanted to make it a little more fancy and so changed the drop down list to a table. The question, is it possible to make the names or rows selectable so the program carries out the same task but instead the user selects a name in the table or a row? The table is dynamic as more users are added or deleted from the system. If any one could point me in the right direction please. Thanks Chris
  14. I have this code here and it works, just wondering if there is an easier and cleaner way to do this or not. Here is the code I have: <?php include 'includes/db_connectdate.php'; $Start_Date = $_GET['start_date']; $End_Date = $_GET['end_date']; $Forte_ID = $_GET['ForteID']; $query = ' SELECT Reps.Rep, Logs.RefNumber, Logs.Disposition, Logs.Cancel_Disposition, Logs.Date, Logs.appNumber, Logs.Phone_Num, Logs.Con_Number, Logs.Finance_Num, Logs.Num_Payments, Logs.ACH_CC, Logs.Post_Date, Logs.Callback, Logs.Disc_Amount, Logs.Total_Cost, Logs.Total_MP, Logs.New_MP_Amt, Logs.New_DP_Amt, Logs.Notes FROM Logs INNER JOIN Reps ON Logs.ForteID = Reps.ForteID WHERE Logs.Date BETWEEN \''.$Start_Date.'\' AND \''.$End_Date.'\' AND Logs.ForteID = \''.$Forte_ID.'\' ORDER BY Logs.RefNumber'; $result = sqlsrv_query($connection,$query); if (!$result) { $message = 'ERROR: ' . sqlsrv_errors(); return $message; } else { echo '<table border="1" cellpadding="5" style="border:3px solid black; text-align: center;"> <tr> <th style="border:3px solid black;">Rep</th> <th style="border:3px solid black;">Reference Number</th> <th style="border:3px solid black;">Call Disposition</th> <th style="border:3px solid black;">Cancel Disposition</th> <th style="border:3px solid black;">Date</th> <th style="border:3px solid black;">AppNumber</th> <th style="border:3px solid black;">Phone Number</th> <th style="border:3px solid black;">Contract Number</th> <th style="border:3px solid black;">Finance Number</th> <th style="border:3px solid black;"># of Payments</th> <th style="border:3px solid black;">ACH/CC</th> <th style="border:3px solid black;">Post Date</th> <th style="border:3px solid black;">Callback</th> <th style="border:3px solid black;">Discount Amount</th> <th style="border:3px solid black;">New Total Cost</th> <th style="border:3px solid black;">Total Monthly Payments</th> <th style="border:3px solid black;">New MP Amount</th> <th style="border:3px solid black;">New DP Amount</th> <th style="border:3px solid black;">Notes</th> </tr>'; while ( $row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC )) { echo '<tr style="border:3px solid black; text-align: center;">'; echo '<td nowrap>'.$row['Rep'].'</td>'; echo '<td nowrap>'.$row['RefNumber'].'</td>'; echo '<td nowrap>'.$row['Disposition'].'</td>'; echo '<td nowrap>'.$row['Cancel_Disposition'].'</td>'; echo '<td nowrap>'.$row['Date'].'</td>'; echo '<td nowrap>'.$row['appNumber'].'</td>'; echo '<td nowrap>'.$row['Phone_Num'].'</td>'; echo '<td nowrap>'.$row['Con_Number'].'</td>'; echo '<td nowrap>'.$row['Finance_Num'].'</td>'; echo '<td nowrap>'.$row['Num_Payments'].'</td>'; echo '<td nowrap>'.$row['ACH_CC'].'</td>'; echo '<td nowrap>'.$row['Post_Date'].'</td>'; echo '<td nowrap>'.$row['Callback'].'</td>'; echo '<td nowrap>'.$row['Disc_Amount'].'</td>'; echo '<td nowrap>'.$row['Total_Cost'].'</td>'; echo '<td nowrap>'.$row['Total_MP'].'</td>'; echo '<td nowrap>'.$row['New_MP_Amt'].'</td>'; echo '<td nowrap>'.$row['New_DP_Amt'].'</td>'; echo '<td nowrap>'.$row['Notes'].'</td>'; echo '</tr>'; } echo '</table>'; } sqlsrv_free_stmt ($result); sqlsrv_close( $connection); ?> Thanks for the help in advance!
  15. Im having a bit of trouble with my script. I wrote the script originaly to run from one variable which i changed manualy, but now im trying to put the whole script inside a loop. The script is now running all the way through fine on the first loop, starting starting the second but getting stuck at the part with my implode. This is my script that is around the implode area. Bear in mind that this code snippet is from a very large script. $t=1; while ($t <= $bm) { $mn=${'m'.$t}; $mn2[$t]="$mn"; $t++; } // The is where the script runs to, and the error comes from the next few lines and the script stops running $implode=implode(',', $mn2); print $implode; $query2="SELECT * FROM artists WHERE id IN(".implode(',', $mn2).")"; $result2=mysql_query($query2) or die(mysql_error()); $i=0; $bm2=$bm-1; while ($i <= $bm2) { $id3=mysql_result($result2,$i,"id"); ${"id3$i"} = $id3; $s1=mysql_result($result2,$i,"s1"); ${"s1$i"} = $s1; $s2=mysql_result($result2,$i,"s2"); ${"s2$i"} = $s2; $sl1=mysql_result($result2,$i,"sl1"); ${"sl1$i"} = $sl1; $sl2=mysql_result($result2,$i,"sl2"); ${"sl2$i"} = $sl2; $i++; } And this is the error that im getting ,,,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,)' at line 1 Any help or point in the right direction would be amazing right no. Thanks Eric
  16. Hello, I have a table that I read in from a postgresql database but I need to add a column that has checkboxes in the final row. It is for a shop so then when the item is selected via checkbox I can then press an add to cart button and send this using an array to the cart.php page. Firstly I need to be able to add checkboxes to the end of each row before I can even do that and I am struggling at how to get a checkbox at the end of each row of my table. <form action="index.php" method="post"> <table> <tr> <th>ref</th> <th>title</th> <th>platform</th> <th>description</th> <th>price</th> <th>select</th> </tr> <?php $resource = pg_query ($connect, "select refnumber,title,platform,description,price from CSGames"); while ($row = pg_fetch_array ($resource)) { $result[] = $row; } foreach($result as $key => $value) { echo "<tr>"; for ($j = 0; $j < pg_num_fields ($resource); $j++) { echo "<td>".$a[$j]."</td>"; } echo "</tr>"; } ?> </table> Could any help with this and explain so I can understand what is occurring in the future please?
  17. Hi friend I try to create a simple html table and put on every cell data from three arrays my arrays are: $one = array('title1','title2','title3','title4','title5','title6'); $two = array('image1','image2','image3','image4','image5','image6'); $three = array('text1','text','text3','text4','text5','text6'); What i like to create is a table like this: ----------------------------------- | title1 | title2 | title3 | ----------------------------------- | image1 | image1 | image3 | ----------------------------------- | text1 | text2 | text3 | ----------------------------------- | title4 | title5 | title6 | ----------------------------------- | image4 | image5 | image6 | ----------------------------------- | text4 | text5 | text6 | ----------------------------------- In other words i need a script to create a rows take the first 3 data from every array put them on cells and every 3 cells create a new set of rows. Until now i'm able using the following cote to put data from only one array $numFiles = count($one); $start = 0; $end = $numFiles; $split = 3; print "<table><tr>"; for($i = $start; $i < $end; $i++) { print "<td>".$one[$i]."</td>"; if(($i) % ($split) == $split-1){ print "</tr><tr>"; } } print"</tr></table>"; If i use something like this: $numFiles = count($one); $start = 0; $end = $numFiles; $split = 3; print "<table><tr>"; for($i = $start; $i < $end; $i++) { print "<td>".$one[$i]."</td>"; if(($i) % ($split) == $split-1){ print "</tr><tr>"; for($i = $start; $i < $end; $i++) { print "<td>".$two[$i]."</td>"; if(($i) % ($split) == $split-1){ print "</tr><tr>"; } } } } print"</tr></table>"; I get this: ----------------------------------- | title1 | title2 | title3 | ----------------------------------- | image1 | image1 | image3 | ----------------------------------- | image4 | image5 | image6 | ----------------------------------- I know that i'm close but i need some help...
  18. Hello, I currently have a table that displays a list of elements from a shop. The information comes from a postgreSQL database and is then shown on index.php using a table. The problem I have is I need to add a checkbox to the end of each row so when I select multiple items I can add them to basket. I have the 'select' column set up but no checkboxes as of yet. I need to first implement the checkboxes and then from there I can get and post the selected items into the basket.php page. Any help would be massively appreciated. This is probably something simple im just overseeing. Would rather you also explain than try and give a straight up answer as I am more likely to learn that way. Thank you
  19. I'm attempting to set display some data pulled from the database and present it in a table so i can get everything to line up correctly. When I attempt to form a table around it, the content hops out of the table or part of it does not display. Working on the first row, it currently displays 'CITIZENSHIP: USA' //if ($citizenship) { echo "<strong>CITIZENSHIP:</strong> $citizenship"; If I try this, it displays 'USA', the citizenship 'vanishes'. //if ($citizenship) { echo "<tr> // <td align=\"right\" valign=\"top\"><p><strong>CITIZENSHIP:</strong></p></td> // <td width=\"10\"> </td> // <td valign=\"top\"><p>" . $citizenship . "</p> // </td></tr>"; <table cellpadding=\"0\" cellspacing=\"0\"> <?php //if ($citizenship) { echo "<tr> // <td align=\"right\" valign=\"top\"><p><strong>CITIZENSHIP:</strong></p></td> // <td width=\"10\"> </td> // <td valign=\"top\"><p>" . $citizenship . "</p> // </td></tr>"; if ($citizenship) { echo "<strong>CITIZENSHIP:</strong> $citizenship"; if ($legalstatus) { echo ", $legalstatus"; } echo "<br >\n"; } else if ($legalstatus) { echo "<strong>Legal Status:</strong> $legalstatus"; } // end legal status if ($type=="administrator" || $type=="alumni" || $type=="faculty" || $type=="staff" || $type=="student") { $theseFields = array("placeofbirth", "maritalstatus", "occupation", "affiliation"); } else { $theseFields = array("placeofbirth", "maritalstatus", "occupation", "affiliation", "baseofoperations"); } // end if resident foreach ($theseFields as $thisField) { if (${$thisField}) { echo "<strong>" . ${$thisField . "Name"} . ":</strong> "; echo ${$thisField}; if (isset(${"former" . $thisField})) { if (${"former" . $thisField}) { echo " (formerly " . ${"former" . $thisField} . ")"; } } // end if set } // end if info } // end FOREACH if ($type=="administrator" || $type=="alumni" || $type=="faculty" || $type=="staff" || $type=="student") { ?> </table> ANy help would be greatly appreciated. I'm very much a newb. Thanks to anyone kind enough to try to help me with this. I've been struggling with this all day and i really thought it'd tage a few minutes. Thanks
  20. Hey All, I always use Blue Host for my websites, but they don't let you use the CREATE TABLE MYSQL command. Does anyone know of any hosting services, reliable ones, that allow you to use this command?? And on a side note, best free web hosting?? Thanks in advance,
  21. MYSQL version --> 5.0.91 ALTER TABLE products ENGINE=INNODB; The error is that it responds that it changed the engine type, but when I view the database in mysqladmin, the tables are still MYISAM. I really wish I saved the CREATE TABLE commands. Basically, there are three tables. The variable types are VARCHAR, INT, TINYINT, DECIMAL, DATETIME, and YEAR. There are no null fields. One of the tables is a JOIN table, and all three of them possess foreign keys. Please let me know if I left out anything, and thank you in advance for your consideration. I threw together a couple of screen shots. Above the red line shows my command and the response showing that I successfully changed the sessions table. Below the red line shows what I see when I view the database in mysqladmin; the sessions table still has a MYISAM engine type.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.