kemper Posted July 30, 2007 Share Posted July 30, 2007 <?php require_once "maincore.php"; require_once "subheader.php"; include LOCALE.LOCALESET."sched.php"; //if (!checkrights("FS")) fallback("../index.php"); if (isset($_POST['edit_sched'])) { $time = stripinput($_POST['time']); $home_field = stripinput($_POST['field']); $field_no = stripinput($_POST['field_no']); $result = dbquery("UPDATE f2007_scheduling SET sched_user='".$userdata['user_id']."', time_text='$time_text', field='$field', field_no='$field_no' WHERE game_id='$game_id' "); //$result = dbquery("UPDATE ".$db_prefix."faq_cats SET faq_cat_name='$faq_cat_name' WHERE faq_cat_id='$faq_cat_id'"); } if ($step == "edit"){ //$data = dbarray(dbquery( // "SELECT ter.*, user_id,user_name FROM f2007_scheduling ter // LEFT JOIN ".$db_prefix."users tusr ON ter.sched_user=tusr.user_id // WHERE game_id='$game_id'" // )); $data = dbarray(dbquery("SELECT * FROM f2007_scheduling WHERE game_id='$game_id'")); // note change here $display_time = date("g:i a", strtotime($data['time'])); opentable ($locale['sched001']); echo "<form name='reportform' method='post' action='".FUSION_SELF."?game_id=$game_id'> ".$locale['sched120']." <table align='center' cellspacing='5' cellpadding='5' class='tbl' width='375'> <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Division:</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'>".$data['div']."</p> </td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Game ID:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['game_id']."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Date:</b></td> <td width=216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['date']=date("D, M j, Y",strtotime($data['date']))."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Time/Notes:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'> <span style='background-color: #FFFF00'>".$data['notes']."</span></td> </tr> <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Time</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='time_text' value='".$data['time_text']."' class='textbox' style='width:50px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Match-up:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['home_team']."</p> <p style='margin-top: 0; margin-bottom: 0'><font color='#0000FF'>vs.</font> ".$data['visit_team']."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field' value='".$data['field']."' class='textbox' style='width:150px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field # or Name:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field_no' value='".$data['field_no']."' class='textbox' style='width:100px;'></td> </tr> <tr> <td align='center' colspan='2'> <input type='submit' name='edit_sched' value='".$locale['sched135']."' class='button'></td> </tr> </table> </form>\n"; closetable (); } opentable ($locale['sched001']); $sql = dbquery( "SELECT ter.*, user_id,user_name FROM f2007_scheduling ter LEFT JOIN ".$db_prefix."users tusr ON ter.sched_user=tusr.user_id WHERE club_id='$club_id' ORDER BY date ASC,time ASC" ); // note change here $display_time = date("g:i a", strtotime($data['time'])); if (dbrows($sql)) { $i = 0; echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'> <tr> <td colspan='8' bgcolor='#FFFF00'> <p style='margin-top: 0; margin-bottom: 0'>Below is a list of games scheduled at your club/district's home fields. To add Times and Field Specifics, click <u><b>Edit</b></u> next to the corresponding game.</p></td> </tr> <tr> <td><b><font size='1'>Division:</font></b></td> <td><b><font size='1'>Game ID:</font></b></td> <td><b><font size='1'>Date:</font></b></td> <td><b><font size='1'>Time/Notes:</font></b></td> <td><b><font size='1'>Time:</font></b></td> <td><b><font size='1'>Teams:</font></b></td> <td><b><font size='1'>Field:</font></b></td> <td><b><font size='1'>Options:</font></b></td> </tr>\n"; while ($data = dbarray($sql)) { $i % 2 == 0 ? $tclass='tbl1' : $tclass='tbl2'; echo "<tr> <td class='$tclass'><font size='1'>".$data['div']."</font></td> <td class='$tclass'><font size='1'>".$data['game_id']."</font></td> <td class='$tclass'><font size='1'>".$data['date']=date("D, M j, Y",strtotime($data['date']))."</font></td> <td class='$tclass'><font size='1'><span style='background-color: #FFFF00'>".$data['notes']."</span></font></td> <td class='$tclass'><font color='#0000FF' size='1'>".$data['time_text']."</font></td> <td class='$tclass'> <p style='margin-top: 0; margin-bottom: 0'><font size='1'>".$data['home_team']." vs.</font></p> <p style='margin-top: 0; margin-bottom: 0'><font size='1'>".$data['visit_team']."</font></font></td> <td class='$tclass'><font color='#0000FF' size='1'>".$data['field']." ".$data['field_no']."</font></td> <td class='$tclass'><center><a href='".FUSION_SELF."?step=edit&game_id=".$data['game_id']."'> <font size='2'>".$locale['sched002']."</font></a></center></td> </tr>\n"; } echo "</table>\n"; } else { echo "<center><br>\n".$locale['sched141']."<br><br>\n</center>\n"; } closetable(); echo "</td>\n"; require_once BASEDIR."footer.php"; ?> My drama: I have club schedulers logging in and editting the schedule table where relevent to their specific club (hence: WHERE club_id='$club_id' in query). Now, once the scheduler logs into www.mysite.com/scheduleing.php?club_id=7003, they see their schedule just fine. Once they click edit, the game details show, but underneath, it says "No Data in Database", nor will any editting accur to the table. What the hell did I do wrong? I have a couple queries, but WHERE statements included with all. Is that my problem? If so, how can I correct this problem? Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/ Share on other sites More sharing options...
teng84 Posted July 30, 2007 Share Posted July 30, 2007 its hard to determine the error because you are using a user define function but myabe to debug that always try to echo the result of the query to see if you really having something to output Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310575 Share on other sites More sharing options...
kemper Posted July 30, 2007 Author Share Posted July 30, 2007 If I remove the WHERE club_id='$club_id' from the one query, all works fine, editting works no problem. But, I only want the games that are pertaining to the individual logged in, hence the WHERE statement above. Instead of a long list of 900 games, I would prefer for them to have the 25 to 75 games that are scheduled at their fields to be in front of them. Which query should I echo? Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310580 Share on other sites More sharing options...
kemper Posted July 30, 2007 Author Share Posted July 30, 2007 Why when accessing a page like www.mysite.com/scheduleing.php?club_id=7003, my table results appear no problem. Then click edit. does the data of the game_id appear, but then says "No Data in Database" appear when the some data is right in my grill? Wierd! Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310581 Share on other sites More sharing options...
teng84 Posted July 30, 2007 Share Posted July 30, 2007 so you need to echo the one that is conditioning the id but the select maybe not working because you dont initialize the $game_id Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310582 Share on other sites More sharing options...
kemper Posted July 30, 2007 Author Share Posted July 30, 2007 in line 21, I have $data = dbarray(dbquery("SELECT * FROM f2007_scheduling WHERE game_id='$game_id'")); Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310584 Share on other sites More sharing options...
teng84 Posted July 30, 2007 Share Posted July 30, 2007 but i dont see where you initialize this $game_id and u always use it? Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310587 Share on other sites More sharing options...
kemper Posted July 30, 2007 Author Share Posted July 30, 2007 i am not exactly sure what you mean. Obviously, I am biting off more that I can chew! Dammit! Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310588 Share on other sites More sharing options...
teng84 Posted July 30, 2007 Share Posted July 30, 2007 require_once "maincore.php"; require_once "subheader.php"; include LOCALE.LOCALESET."sched.php"; if (isset($_POST['edit_sched'])) { $time = stripinput($_POST['time']); $home_field = stripinput($_POST['field']); $field_no = stripinput($_POST['field_no']); $result = dbquery("UPDATE f2007_scheduling SET sched_user='".$userdata['user_id']."', time_text='$time_text', field='$field', field_no='$field_no' WHERE game_id='$game_id' "); //<------------$game_id } if ($step == "edit"){ $data = dbarray(dbquery("SELECT * FROM f2007_scheduling WHERE game_id='$game_id'"));// <-------------$game_id thats the piece of code you have and see this thing i put <-------------$game_id noe tell me where are those being initilize like <-------------$game_id =$_POST['ect'];--------------------> hmm!!! Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310590 Share on other sites More sharing options...
kemper Posted July 30, 2007 Author Share Posted July 30, 2007 I am not exactly sure how to initialize game_id, except for $game_id = stripinput($_POST['game_id']); But I do not see why I need to do that since it is not going to be editted. And, it worked fine without the WHERE statement stated earlier. I need to go back to school and learn this stuff! Dammit! Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310596 Share on other sites More sharing options...
teng84 Posted July 30, 2007 Share Posted July 30, 2007 it will work fine because the query is correct w/o where as i said the value for $game_id is empty and u cant use that as a condition 0 zero may be good but not empty look u said you have to be specific right? like you will only display the user etch so agian you really need a unique identifier or condition and i believe in your db theres a field id for each record which is unique Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310600 Share on other sites More sharing options...
HaLo2FrEeEk Posted July 30, 2007 Share Posted July 30, 2007 Try: $data = dbarray(dbquery("SELECT * FROM f2007_scheduling WHERE game_id='".$game_id."'")); $data = dbarray(dbquery("SELECT * FROM f2007_scheduling WHERE game_id=".$game_id)); If $game_id is a number, you don't need the single quotes, if it is any non numerical character or a string with non-numeric characters in it, you need the single quotes. Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310605 Share on other sites More sharing options...
kemper Posted July 30, 2007 Author Share Posted July 30, 2007 HaLo2FrEeEk: I changed as you suggested and received "No Data in Database" when edittng a specific game_id. teng84: I was hoping to use club_is as that condition. My Table: `club_id` smallint(3) NOT NULL default '0', `status` text NOT NULL, `div` varchar(15) NOT NULL default '', `game_id` int(6) unsigned NOT NULL auto_increment, `date` date NOT NULL default '0000-00-00', `notes` text NOT NULL, `time_text` text NOT NULL, `home_team` varchar(50) NOT NULL default '', `h_score` text NOT NULL, `field` text NOT NULL, `field_no` varchar(25) NOT NULL default '0', `visit_team` varchar(50) NOT NULL default '', `v_score` text NOT NULL, `sched_user` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`game_id`), Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310606 Share on other sites More sharing options...
HaLo2FrEeEk Posted July 30, 2007 Share Posted July 30, 2007 Well what teng84 said, you have to initialize $game_id, meaning you have to give it a value, if you don't set $game_id anywhere then: $data = dbarray(dbquery("SELECT * FROM f2007_scheduling WHERE game_id='".$game_id."'")); Will basically be saying $data = dbarray(dbquery("SELECT * FROM f2007_scheduling WHERE game_id = ''")); Or nothing, you are trying to call up data from using a variable that does not exist. You have to set $game_id to whatever game_id you are trying to edit, then execute the query. You should also be using some form of error protection, meaning use checks to make sure that each step of the query is working, for example: $query = "SELECT * FROM f2007_scheduling WHERE game_id='".$game_id."'"; if($data = dbquery($query)) { dbarray($data); // Do other stuff with it } else { echo "Something went wrong with the query."; } That will check each step of the way. Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310610 Share on other sites More sharing options...
kemper Posted July 30, 2007 Author Share Posted July 30, 2007 I am a bit confused because I am obtainng the data. I just cannot edit it. As soon as I click Submit, it is not recognized. Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310613 Share on other sites More sharing options...
HaLo2FrEeEk Posted July 30, 2007 Share Posted July 30, 2007 Post your edit form, then. Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310618 Share on other sites More sharing options...
kemper Posted July 30, 2007 Author Share Posted July 30, 2007 <?php require_once "maincore.php"; require_once "subheader.php"; include LOCALE.LOCALESET."sched.php"; //if (!checkrights("FS")) fallback("../index.php"); if (isset($_POST['edit_sched'])) { $time = stripinput($_POST['time']); $home_field = stripinput($_POST['field']); $field_no = stripinput($_POST['field_no']); $result = dbquery("UPDATE f2007_scheduling SET sched_user='".$userdata['user_id']."', time_text='$time_text', field='$field', field_no='$field_no' WHERE game_id='$game_id' "); //$result = dbquery("UPDATE ".$db_prefix."faq_cats SET faq_cat_name='$faq_cat_name' WHERE faq_cat_id='$faq_cat_id'"); } if ($step == "edit"){ //$data = dbarray(dbquery( // "SELECT ter.*, user_id,user_name FROM f2007_scheduling ter // LEFT JOIN ".$db_prefix."users tusr ON ter.sched_user=tusr.user_id // WHERE game_id='$game_id'" // )); $data = dbarray(dbquery("SELECT * FROM f2007_scheduling WHERE game_id='$game_id'")); // note change here $display_time = date("g:i a", strtotime($data['time'])); opentable ($locale['sched001']); echo "<form name='reportform' method='post' action='".FUSION_SELF."?game_id=$game_id'> ".$locale['sched120']." <table align='center' cellspacing='5' cellpadding='5' class='tbl' width='375'> <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Division:</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'>".$data['div']."</p> </td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Game ID:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['game_id']."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Date:</b></td> <td width=216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['date']=date("D, M j, Y",strtotime($data['date']))."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Time/Notes:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'> <span style='background-color: #FFFF00'>".$data['notes']."</span></td> </tr> <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Time</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='time_text' value='".$data['time_text']."' class='textbox' style='width:50px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Match-up:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['home_team']."</p> <p style='margin-top: 0; margin-bottom: 0'><font color='#0000FF'>vs.</font> ".$data['visit_team']."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field' value='".$data['field']."' class='textbox' style='width:150px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field # or Name:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field_no' value='".$data['field_no']."' class='textbox' style='width:100px;'></td> </tr> <tr> <td align='center' colspan='2'> <input type='submit' name='edit_sched' value='".$locale['sched135']."' class='button'></td> </tr> </table> </form>\n"; closetable (); } opentable ($locale['sched001']); $sql = dbquery( "SELECT ter.*, user_id,user_name FROM f2007_scheduling ter LEFT JOIN ".$db_prefix."users tusr ON ter.sched_user=tusr.user_id WHERE club_id='$club_id' ORDER BY date ASC,time ASC" ); // note change here $display_time = date("g:i a", strtotime($data['time'])); if (dbrows($sql)) { $i = 0; echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'> <tr> <td colspan='8' bgcolor='#FFFF00'> <p style='margin-top: 0; margin-bottom: 0'>Below is a list of games scheduled at your club/district's home fields. To add Times and Field Specifics, click <u><b>Edit</b></u> next to the corresponding game.</p></td> </tr> <tr> <td><b><font size='1'>Division:</font></b></td> <td><b><font size='1'>Game ID:</font></b></td> <td><b><font size='1'>Date:</font></b></td> <td><b><font size='1'>Time/Notes:</font></b></td> <td><b><font size='1'>Time:</font></b></td> <td><b><font size='1'>Teams:</font></b></td> <td><b><font size='1'>Field:</font></b></td> <td><b><font size='1'>Options:</font></b></td> </tr>\n"; while ($data = dbarray($sql)) { $i % 2 == 0 ? $tclass='tbl1' : $tclass='tbl2'; echo "<tr> <td class='$tclass'><font size='1'>".$data['div']."</font></td> <td class='$tclass'><font size='1'>".$data['game_id']."</font></td> <td class='$tclass'><font size='1'>".$data['date']=date("D, M j, Y",strtotime($data['date']))."</font></td> <td class='$tclass'><font size='1'><span style='background-color: #FFFF00'>".$data['notes']."</span></font></td> <td class='$tclass'><font color='#0000FF' size='1'>".$data['time_text']."</font></td> <td class='$tclass'> <p style='margin-top: 0; margin-bottom: 0'><font size='1'>".$data['home_team']." vs.</font></p> <p style='margin-top: 0; margin-bottom: 0'><font size='1'>".$data['visit_team']."</font></font></td> <td class='$tclass'><font color='#0000FF' size='1'>".$data['field']." ".$data['field_no']."</font></td> <td class='$tclass'><center><a href='".FUSION_SELF."?step=edit&game_id=".$data['game_id']."'> <font size='2'>".$locale['sched002']."</font></a></center></td> </tr>\n"; } echo "</table>\n"; } else { echo "<center><br>\n".$locale['sched141']."<br><br>\n</center>\n"; } closetable(); echo "</td>\n"; require_once BASEDIR."footer.php"; ?> Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310620 Share on other sites More sharing options...
HaLo2FrEeEk Posted July 30, 2007 Share Posted July 30, 2007 You do know that when you do a stright exho everything has to be on the same line, unless you are doing heredoc. Try using heredoc, replace: echo "<form name='reportform' method='post' action='".FUSION_SELF."?game_id=$game_id'> ".$locale['sched120']." <table align='center' cellspacing='5' cellpadding='5' class='tbl' width='375'> <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Division:</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'>".$data['div']."</p> </td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Game ID:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['game_id']."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Date:</b></td> <td width=216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['date']=date("D, M j, Y",strtotime($data['date']))."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Time/Notes:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'> <span style='background-color: #FFFF00'>".$data['notes']."</span></td> </tr> <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Time</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='time_text' value='".$data['time_text']."' class='textbox' style='width:50px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Match-up:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['home_team']."</p> <p style='margin-top: 0; margin-bottom: 0'><font color='#0000FF'>vs.</font> ".$data['visit_team']."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field' value='".$data['field']."' class='textbox' style='width:150px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field # or Name:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field_no' value='".$data['field_no']."' class='textbox' style='width:100px;'></td> </tr> <tr> <td align='center' colspan='2'> <input type='submit' name='edit_sched' value='".$locale['sched135']."' class='button'></td> </tr> </table> </form>\n"; With: echo <<<EOL <form name='reportform' method='post' action='FUSION_SELF?game_id=$game_id'> $locale['sched120'] <table align='center' cellspacing='5' cellpadding='5' class='tbl' width='375'> <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Division:</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'>$data['div']</p> </td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Game ID:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>$data['game_id']</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Date:</b></td> <td width=216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>$data['date']=date("D, M j, Y",strtotime($data['date']))</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Time/Notes:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'> <span style='background-color: #FFFF00'>$data['notes']</span></td> </tr> <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Time</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='time_text' value='$data['time_text']' class='textbox' style='width:50px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Match-up:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>$data['home_team']</p> <p style='margin-top: 0; margin-bottom: 0'><font color='#0000FF'>vs.</font> $data['visit_team']</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field' value='$data['field']' class='textbox' style='width:150px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field # or Name:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field_no' value='$data['field_no']' class='textbox' style='width:100px;'></td> </tr> <tr> <td align='center' colspan='2'> <input type='submit' name='edit_sched' value='$locale['sched135']' class='button'></td> </tr> </table> </form> EOL; Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310630 Share on other sites More sharing options...
kemper Posted July 30, 2007 Author Share Posted July 30, 2007 I have no idea what exho and heredoc are. I will give this a try. Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310639 Share on other sites More sharing options...
HaLo2FrEeEk Posted July 30, 2007 Share Posted July 30, 2007 typo, I meant echo, my bad. Anyways, try what I said and see if it makes any difference. Link to comment https://forums.phpfreaks.com/topic/62401-having-major-issue-with-form-edit-help/#findComment-310652 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.