fetch and edit Table

kemper · January 19, 2007

I am hosting a sports website and am processing schedules for the particpating clubs to assign times and field assignments.

[color=blue]I know how to display the data, but not to have the fill in fields for the two cells that my schedules will edit. I created that screenshot manually. How do I write the script to include edittable text fields under "Time" and "Field"? [/color][color=red]I was once told to add:[/color]
[code]echo '<a href="editpage.php?id='.$row[id].'">EDIT</a>';
echo '<a href="deletepage.php?id='.$row[id].'">DELETE</a>'[/code]

[color=blue]But I do not want each line editted individually. This would take forever for my schedulers to edit their schedules. I have 1500 games to be editted, and some clubs have to edit for >150 games each.[/color]

[color=red]This is what I have to display the requested information:[/color]
[code]<?php
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";

if (isset($readmore) && !isNum($readmore)) fallback(FUSION_SELF);
opentable("Team Contacts");
// mySQL Table
$db_con = mysql_connect(MyHost, MyUsername, MyPassword) or die("Connetion to database failed!");
mysql_select_db(MyDatabase);
$age = $_GET['club'];
$sql = "SELECT club, age, date, time_notes, time, cemail, home, visitors, field FROM MyTable WHERE club='$club'";
$result = mysql_query($sql) or die(mysql_error());
$i = 0;

echo "Team contacts for all divisions of $age:
To update your team's contact listing, 
<a href='http://www.myrsl.org/viewpage.php?page_id=43'>
click here </a> \n\n";

echo "
<table width='100%' border='1' cellspacing='0' cellpadding='5' bordercolorlight='#000000' bordercolordark='#000000'><tr>
<th align='left' bgcolor='#FF0000' style='border-style: solid; border-width: 1px' bordercolor='#000000' bordercolorlight='#ff0000' bordercolordark='#000000'>
Club</th>
<th align='left' bgcolor='#FF0000' style='border-style: solid; border-width: 1px' bordercolor='#000000' bordercolorlight='#ff0000' bordercolordark='#000000'>
Age</th>
<th align='left' bgcolor='#FF0000' style='border-style: solid; border-width: 1px' bordercolor='#000000' bordercolorlight='#ff0000' bordercolordark='#000000'>
Date</th>
<th align='left' bgcolor='#FF0000' style='border-style: solid; border-width: 1px' bordercolor='#000000' bordercolorlight='#ff0000' bordercolordark='#000000'>
Time/Notes</th>
<th align='left' bgcolor='#FF0000' style='border-style: solid; border-width: 1px' bordercolor='#000000' bordercolorlight='#ff0000' bordercolordark='#000000'>
Time</th>
<th align='left' bgcolor='#FF0000' style='border-style: solid; border-width: 1px' bordercolor='#000000' bordercolorlight='#ff0000' bordercolordark='#000000'>
Home Team</th>
<th align='left' bgcolor='#FF0000' style='border-style: solid; border-width: 1px' bordercolor='#000000' bordercolorlight='#ff0000' bordercolordark='#000000'>
Visiting Team</th>
<th align='left' bgcolor='#FF0000' style='border-style: solid; border-width: 1px' bordercolor='#000000' bordercolorlight='#ff0000' bordercolordark='#000000'>
Field</th>
</tr>';

while ($row = mysql_fetch_array($result)) {
echo '<tr>
<td valign='top' style='border-style: solid; border-width: 1px' bordercolor='#ff0000' bordercolorlight='#ff0000' bordercolordark='#000000'>
' . $row['club'] . "</td>
<td valign='top' style='border-style: solid; border-width: 1px' bordercolor='#ff0000' bordercolorlight='#ff0000' bordercolordark='#000000'>
' . $row['age'] . '
 
 </td>
<td valign='top' style='border-style: solid; border-width: 1px' bordercolor='#ff0000' bordercolorlight='#ff0000' bordercolordark='#000000'>
' . $row['date'] . '</td>
<td valign='top' style='border-style: solid; border-width: 1px' bordercolor='#ff0000' bordercolorlight='#ff0000' bordercolordark='#000000'>
' . $row['time_notes'] . '</td>
<td valign='top' style='border-style: solid; border-width: 1px' bordercolor='#ff0000' bordercolorlight='#ff0000' bordercolordark='#000000'>
' . $row['time'] . '</td>
<td valign='top' style='border-style: solid; border-width: 1px' bordercolor='#ff0000' bordercolorlight='#ff0000' bordercolordark='#000000'>
" . $row['home']
. "</td>
<td valign='top' style='border-style: solid; border-width: 1px' bordercolor='#ff0000' bordercolorlight='#ff0000' bordercolordark='#000000'>
' . $row['visitors'] . '
</td>
<td valign='top' style='border-style: solid; border-width: 1px' bordercolor='#ff0000' bordercolorlight='#ff0000' bordercolordark='#000000'>
' . $row['field'] . '
</td>
</tr>';
}
echo '</table>\n";

// mySQL ends
closetable();
require_once "side_right.php";
require_once "footer.php";
?>[/code]

[color=blue]In my scheduling process, all data is included in the MySQL table with exception of "Time" ($row['time']) and "Field" ($row['field']). That information is determined by Club Field Schedulers. Those two columns in my table are where I can Text Fields for input.[/color]

Assistance is greatly appreciated.

Sign In

fetch and edit Table

Recommended Posts

kemper

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information