law Posted February 18, 2008 Share Posted February 18, 2008 I HAVE NOT INCLUDED THE ENTIRE PAGE..(for ease of read reasons) soo there might be a few $variables that are not defined one of them is $events = 32 (there is another mysql_fetch_array call used early in the page <not shown here> should i close that array fetch out in some way before calling another one??) My current problem is in the EVENT DATA section.. this is the section that is supposed to retrieve the data that is already within the database, and display it in the form below it.. the echo show that im doing something wrong.. im a novice soo this entire thing could be completely wrong but my intent is to show data already within the database on the form so that the user could update it.. hope that makes since thanks in advance (there is another mysql_fetch_array call used early in the page <not shown here> should i close that array fetch out in some way before calling another one??) //---------------------------------EVENTS/GAMES & TEAMS TABLE--------------------------------------------------- //--------------FORM PROCESSOR--------------- $var10 = $_POST['eventname']; $var11 = $_POST['eventfav']; $var12 = $_POST['eventpts']; $var13 = $_POST['eventund']; $var14 = $_POST['eventmonth']; $var15 = $_POST['eventday']; $var16 = $_POST['eventyear']; $var17 = $_POST['row']; echo "<br/><br/><br/>"; if($var10=''){ echo"Event name Missing"; } if($var11=''){ echo"Favorite Team Missing"; } if($var12=''){ echo"Point Spread Missing"; } if($var13=''){ echo"Underdog Team Missing"; } //-------------------INSERT EVENT DATA QUERY----------------------------------- if($_POST['eventsubmit'] && is_numeric($_POST['eventmonth']) && is_numeric($_POST['eventday']) && is_numeric($_POST['eventyear'])){ $equery = "INSERT INTO competitions(competitionname,favorite,pointspread,underdog,month,day,year,competitionid) VALUES($var10,$var11,$var12,$var13,$var14,$var15,$var16,$var17) ON DUPLICATE KEY UPDATE competitionname = $var10, favorite = $var11, pointspread = $var12, underdog = $var13, month = $var14, day = $var15, year = $var16"; $insertupdate= mysql_query($equery) or die(mysql_error()); echo "<font color=orange><b>The events were successfully configured</b></font>"; } //----------END OF FORM PROCESSOR------------ //----------EVENTDATA----------------!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PROBLEM IS HERE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid >= $events "); $eventdatarow= mysql_fetch_array($eventdata); $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; //----------EndOfDATA---------------- echo "$eventdata -- $eventdatarow -- $efav"; // ECHO ABOVE AS SEEN ON WEBSIE resourceid 11 -- -- echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; while ($count <= $events){ echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$count' name='row'></TD> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form> "; //---------------------------------END OF EVENTS/GAMES & TEAMS TABLE-------------------------------------------- FULL PAGE OF CODE FOR THOSE WHO LIKE TO READ <div id="stuff"> <?php session_start(); if(isset($_SESSION['admin_user'])){ $tmp=$_SESSION['admin_user']; // Config fields to determine pool amount, pool charge, last day to enter, refferral reward // Fields to add game name and teams in the game as well as point spread // Ability to select which config to load and run include_once("./dbconfig.php"); include_once("./includes/potmath.inc"); //-------------------FORM PROCESSOR-------------------------------------- if($_POST['submit'] && is_numeric($_POST['month']) && is_numeric($_POST['day']) && is_numeric($_POST['year']) && is_numeric($_POST['events']) && ($_POST['entryprice']) > ($_POST['potamount']) && ($_POST['refreward']) <= '1.00' && ($_POST['firstplace']) + ($_POST['secondplace']) + ($_POST['thirdplace']) < '101' && ($_POST['firstplace']) + ($_POST['secondplace']) + ($_POST['thirdplace']) > '99') { $var1 = $_POST['entryprice']; $var2 = $_POST['potamount']; $var3a = $_POST['month']; $var3b = $_POST['day']; $var3c = $_POST['year']; $var4 = $_POST['refreward']; $var5 = $_POST['firstplace']; $var6 = $_POST['secondplace']; $var7 = $_POST['thirdplace']; $var8 = $_POST['events']; $update= mysql_query("UPDATE config SET poolamount = $var1, poolcharge = $var2, lastmonth = $var3a, lastday = $var3b, lastyear = $var3c, refferralreward = $var4, 1stplace = $var5, 2ndplace = $var6, 3rdplace = $var7, events = $var8 WHERE configid = 1") or die(mysql_error()); echo "<font color=orange><b>The pool was successfully configured</b></font>"; } //-------------------END OF FORM PROCESSOR------------------------------- //-------------------------TABLE------------------------------------------ $data= mysql_query("SELECT * FROM config WHERE configid = 1 "); $datarow= mysql_fetch_array($data); $poolamount=$datarow['poolamount']; $poolcharge=$datarow['poolcharge']; $lastmonth=$datarow['lastmonth']; $lastday=$datarow['lastday']; $lastyear=$datarow['lastyear']; $refreward=$datarow['refferralreward']; $firstplace=$datarow['1stplace']; $secondplace=$datarow['2ndplace']; $thirdplace=$datarow['3rdplace']; $events=$datarow['events']; echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center> <CAPTION ALIGN=TOP><B>The Current Configuration of the Pool</B></CAPTION> <TR> <TH> Entry Price</TH> <TH> Pot Amount</TH> <TH> Last Day to Enter</TH> <TH> Referral Reward</TH> <TH> Events</TH> <TH> 1st Place</TH> <TH> 2nd Place</TH> <TH> 3rd Place</TH> </TR> <TR> <TD align=center>$poolamount</TD> <TD align=center>$poolcharge</TD> <TD align=center>$lastmonth/$lastday/$lastyear</TD> <TD align=center>$refreward</TD> <TD align=center>$events</TD> <TD align=center>$firstplace %</TD> <TD align=center>$secondplace %</TD> <TD align=center>$thirdplace %</TD> </TR> </TABLE> "; //----------------------------------END OF TABLE------------------------------------------------------- //-------------------------RECONFIG TABLE------------------------------------------ echo "<br/> <TABLE BORDER=2 align=center WIDTH=690> <form name='adminconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>The Re-Configuration of the Pool</B></CAPTION> <TR> <TH> Entry Price</TH> <TH> Pot Amount</TH> <TH> Last Day to Enter</TH> <TH> Referral Reward</TH> <TH> Events</TH> <TH> 1st Place</TH> <TH> 2nd Place</TH> <TH> 3rd Place</TH> </TR> <TR> <TD align=center><select name='entryprice'> <option value='5'>5</option> <option value='8'>8</option> <option value='10'>10</option> <option value='12'>12</option> <option value='15'>15</option> <option value='18'>18</option> <option value='20'>20</option> <option value='25'>25</option> <option value='30'>30</option> <option value='35'>35</option> <option value='40'>40</option> <option value='45'>45</option> <option value='50'>50</option> </select></TD> <TD align=center><select name='potamount'> <option value='3'>3</option> <option value='5'>5</option> <option value='7'>7</option> <option value='10'>10</option> <option value='12'>12</option> <option value='15'>15</option> <option value='18'>18</option> <option value='22'>22</option> <option value='27'>27</option> <option value='30'>30</option> <option value='35'>35</option> <option value='40'>40</option> <option value='45'>45</option> </select></TD> <TD> <input type='text' size='2' MAXLENGTH='2' value='mm' name='month'> <input type='text' size='2' MAXLENGTH='2' value='dd' name='day'> <input type='text' size='4' MAXLENGTH='4' value='yyyy' name='year'> </TD> <TD align=center><input type='text' size='3' MAXLENGTH='4' value='0.50' name='refreward'> </TD> <TD align=center><input type='text' size='2' MAXLENGTH='2' value='32' name='events'> </TD> <TD align=center><select name='firstplace'> <option value='100'>100%</option> <option value='90'>90%</option> <option value='80'>80%</option> <option value='70'>70%</option> </select></TD> <TD align=center><select name='secondplace'> <option value='0'>0%</option> <option value='8'>8%</option> <option value='15'>15%</option> <option value='20'>20%</option> </select></TD> <TD align=center><select name='thirdplace'> <option value='0'>0%</option> <option value='2'>2%</option> <option value='5'>5%</option> <option value='10'>10%</option> </select></TD> </TR> </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='submit' value='Re-Configure the Pool'> <input type='reset' name='reset' value='Reset'><br/> </TD> </TR> </TABLE> </form> "; //----------------------------------END OF RECONFIG TABLE------------------------------------------------------- //------------------TEXT------------------------ echo "<b><font color=orange>**Make sure that your Entry Price is ABOVE the Pot Amount**</font></b><br/> <b><font color=orange>**Make sure that your Placement %'s = 100%**</font></b><br/> <font size=0.005>*The <u>entry price</u> the the price the user pays to enter. The <u>pot amount</u> is how much money from the entry price actually enters into the pool.</font><br/> <font size=0.005>*The <u>referral reward</u> is the amount the user makes for a paying referral.</font><br/> <font size=0.005>*The <u>Events</u> is the amount GAMEs that will be in the pool.</font> "; //------------------END OF TEXT------------------------ //---------------------------------EVENTS/GAMES & TEAMS TABLE--------------------------------------------------- //--------------FORM PROCESSOR--------------- $var10 = $_POST['eventname']; $var11 = $_POST['eventfav']; $var12 = $_POST['eventpts']; $var13 = $_POST['eventund']; $var14 = $_POST['eventmonth']; $var15 = $_POST['eventday']; $var16 = $_POST['eventyear']; $var17 = $_POST['row']; echo "<br/><br/><br/>"; if($var10=''){ echo"Event name Missing"; } if($var11=''){ echo"Favorite Team Missing"; } if($var12=''){ echo"Point Spread Missing"; } if($var13=''){ echo"Underdog Team Missing"; } //-------------------INSERT EVENT DATA QUERY----------------------------------- if($_POST['eventsubmit'] && is_numeric($_POST['eventmonth']) && is_numeric($_POST['eventday']) && is_numeric($_POST['eventyear'])){ $equery = "INSERT INTO competitions(competitionname,favorite,pointspread,underdog,month,day,year,competitionid) VALUES($var10,$var11,$var12,$var13,$var14,$var15,$var16,$var17) ON DUPLICATE KEY UPDATE competitionname = $var10, favorite = $var11, pointspread = $var12, underdog = $var13, month = $var14, day = $var15, year = $var16"; $insertupdate= mysql_query($equery) or die(mysql_error()); echo "<font color=orange><b>The events were successfully configured</b></font>"; } //----------END OF FORM PROCESSOR------------ //----------EVENTDATA---------------- $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid >= $events "); $eventdatarow= mysql_fetch_array($eventdata); $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; //----------EndOfDATA---------------- echo "$eventdata -- $ename -- $efav"; echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; while ($count <= $events){ echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$count' name='row'></TD> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form> "; //---------------------------------END OF EVENTS/GAMES & TEAMS TABLE-------------------------------------------- } else { header('Location:admin.php?notloggedin=1'); } ?> </div> Quote Link to comment Share on other sites More sharing options...
btherl Posted February 18, 2008 Share Posted February 18, 2008 Is it possible that the query returns no matches? Add this: echo "Query returns ", mysql_num_rows($eventdata), " rows"; Quote Link to comment Share on other sites More sharing options...
law Posted February 18, 2008 Author Share Posted February 18, 2008 sorry forgot to say this as of right now there is one row of dummy data Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 18, 2008 Share Posted February 18, 2008 under $eventdatarow = mysql_fetch_array...... add this: print_r($eventdatarow); exit(); what does it say? --------- also what is the structure of your table? and the dummy data? (try the query withOUT the WHERE clause) Quote Link to comment Share on other sites More sharing options...
law Posted February 18, 2008 Author Share Posted February 18, 2008 ok great! i printed the array.. and come to find out it was NOT getting data! so i took out the where clause and now i have data! soo thats great.. and i added another row of dummy data unfortunately i now have a new issue.. The that data is showing up in the form is only the first row of data.. how can i modify //----------EVENTDATA---------------- $eventcount=0; While ($eventcount <= $events) { $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $eventcount"); $eventdatarow= mysql_fetch_array($eventdata); $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; $eventcount++; } //----------EndOfDATA---------------- echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; while ($count <= $events){ echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$count' name='row'></TD> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form> "; So that every line of the form represents its corresponding line of information from the database (Example: ID 1 [in database]= ROW 1 [in the form]) Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 18, 2008 Share Posted February 18, 2008 i think i know hwat you mean, like this? //----------EVENTDATA---------------- $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $events"); //----------EndOfDATA---------------- echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; while ($eventdatarow = mysql_fetch_array($eventdata)){ // moved so these are set each time WHILE finds a new ROW. $eid=$eventdatarow['id']; // if you dont have an id field, make one, and always make one. $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; echo " <TR> <TD align=center colspan=5>ROW ID == ".$eid."</TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$eid' name='row'></TD> </TR>"; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form> "; also your script is wide open to sql injection attacks... whenever you pull a variable from $_GET or $_POST, always use $data = mysql_escape_string($_POST['...']); this will prevent mysql injections Quote Link to comment Share on other sites More sharing options...
law Posted February 18, 2008 Author Share Posted February 18, 2008 thanks for the injections warning.. i am a novice and i have no idea how injections work but i assume its a bad thing lol.. thank you any other potential problems in the code would be great to know so if you see anything please tell me! also great work on the table.. i didn't realize that it would update each time if it were included in the actual while loop itself! good to know.. but i have one other problem now.. i would like to add all of the blank rows back onto the table the table is supposed to have a user defined number of rows as dictated by $events.. in this case $events=32 i only have 2 rows of data so i need 30 rows of blank fields.. i assume there is a way to add a clause onto the while loop to make this happen? Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 18, 2008 Share Posted February 18, 2008 yes there is, think of a while loop as a recurring if statement, you can add "&& $count <= $events" to produce: while ($eventdatarow = @mysql_fetch_array($eventdata) || $count <= $events){ (you may need to suppress warnings from an empty mysql_fetch_array() with an "@" symbol before the function, like above) also add $count++; exactly where you placed it before. Quote Link to comment Share on other sites More sharing options...
law Posted February 18, 2008 Author Share Posted February 18, 2008 ok that makes perfect sense to me.. but apparently not to my browser! lol i must be doing something wrong here is the current code i have echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; while ($eventdatarow= @mysql_fetch_array($eventdata) || $count <= $events){ //----------EVENTDATA---------------- $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$count' name='row'></TD> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form> for some reason it is now giving 32 blank lines of code with no filled in ones? (but if i take the || or clause out i get my 2 rows of data back?) Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 18, 2008 Share Posted February 18, 2008 sorry, logic error, my mistake. a for loop is what you need: echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; For($i=0;$i<$events;$i++){ //----------EVENTDATA---------------- $ename=$eventdatarow[$i]['competitionname']; $efav=$eventdatarow[$i]['favorite']; $epts=$eventdatarow[$i]['pointspread']; $eund=$eventdatarow[$i]['underdog']; $emm=$eventdatarow[$i]['month']; $edd=$eventdatarow[$i]['day']; $eyyyy=$eventdatarow[$i]['year']; //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$count' name='row'></TD> </TR>"; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form> Quote Link to comment Share on other sites More sharing options...
law Posted February 18, 2008 Author Share Posted February 18, 2008 ok were getting closer! except this time i have a real strange error $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $events"); $eventdatarow= @mysql_fetch_array($eventdata); echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; For($i=0;$i<$events;$i++){ //----------EVENTDATA---------------- $ename=$eventdatarow[$i]['competitionname']; $efav=$eventdatarow[$i]['favorite']; $epts=$eventdatarow[$i]['pointspread']; $eund=$eventdatarow[$i]['underdog']; $emm=$eventdatarow[$i]['month']; $edd=$eventdatarow[$i]['day']; $eyyyy=$eventdatarow[$i]['year']; //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$count' name='row'></TD> </TR>"; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form>"; all fields in the same row now read the same data instead of having individual data for each row and the data is all screwy its nothing like what should be displayed.. example here is that its supposed to be poinsetta bowl | usm | +2 |olemiss |date here is what i have 1 | 1| 1| 1| 1 p | p| p| p| p o | o| o| o| o 2 | 2| 2| 2| 2 2| 2| 2| 2| 2 Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 18, 2008 Share Posted February 18, 2008 hm strange, are you sure your getting more than one result? if yiu use print_r($eventdatarow); is it a multi-dimensional array? (does it store the row data in a sub-array of each row number?) ex: array( "user", "detail", "etc" ); this is single dimension array (i think is called 2d array), array( "row1"=>array("user,detail"), ""row2=>array("user,detail"), "row3"=>array("user,detail") ); this is a multi-dimensional array. --------------- can you confirm which type of array mysql_fetch_array() is producing from the query results? i dont believe you need the " WHERE competitionid <= $events" in your sql syntax anymore either. ------- to make it a bit easier, the following code and when you view the page in IE: right-click and select view source, copy and paste in here (xxx out any sensitive info if there is any) $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $events"); $eventdatarow= @mysql_fetch_array($eventdata); echo("DEBUG PRINT:\n\n"); print_r($eventdatarow);exit(); // Temp DEBUG line added echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; For($i=0;$i<$events;$i++){ //----------EVENTDATA---------------- $ename=$eventdatarow[$i]['competitionname']; $efav=$eventdatarow[$i]['favorite']; $epts=$eventdatarow[$i]['pointspread']; $eund=$eventdatarow[$i]['underdog']; $emm=$eventdatarow[$i]['month']; $edd=$eventdatarow[$i]['day']; $eyyyy=$eventdatarow[$i]['year']; //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$count' name='row'></TD> </TR>"; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form>"; Quote Link to comment Share on other sites More sharing options...
law Posted February 19, 2008 Author Share Posted February 19, 2008 Thank you so very much for your help btw.. Just got out of classes for the day so im not quite back into the scripting mindset but here is what your debug message reported "DEBUG PRINT: Array ( [0] => 1 [competitionid] => 1 [1] => poinsetta bowl [competitionname] => poinsetta bowl [2] => usm [favorite] => usm [3] => olemiss [underdog] => olemiss [4] => 2 [pointspread] => 2 [5] => 2 [day] => 2 [6] => 2 [month] => 2 [7] => 2 [year] => 2 )" To me this looks correct? Quote Link to comment Share on other sites More sharing options...
law Posted February 19, 2008 Author Share Posted February 19, 2008 OK GOT IT.. im sure there is a prettier way to do this but this code works //-------------------INSERT EVENT DATA QUERY----------------------------------- if($_POST['eventsubmit'] && is_numeric($_POST['eventmonth']) && is_numeric($_POST['eventday']) && is_numeric($_POST['eventyear'])){ $equery = "INSERT INTO competitions(competitionname,favorite,pointspread,underdog,month,day,year,competitionid) VALUES($var10,$var11,$var12,$var13,$var14,$var15,$var16,$var17) ON DUPLICATE KEY UPDATE competitionname = $var10, favorite = $var11, pointspread = $var12, underdog = $var13, month = $var14, day = $var15, year = $var16"; $insertupdate= mysql_query($equery) or die(mysql_error()); echo "<font color=orange><b>The events were successfully configured</b></font>"; } $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $events"); $count=0; //----------END OF FORM PROCESSOR------------ echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; //----------EVENTDATA---------------- WHILE($count <= $events){ if($eventdatarow= @mysql_fetch_array($eventdata)){ $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; } else { $ename=""; $efav=""; $epts=""; $eund=""; $emm=""; $edd=""; $eyyyy=""; } //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$count' name='row'></TD> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form>"; //---------------------------------END OF EVENTS/GAMES & TEAMS TABLE-------------------------------------------- HERE is the HTML it returns <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='poinsetta bowl' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='usm' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='2' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='olemiss' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='2' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='2' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='2' name='eventyear'> </TD> <input type='hidden' value='0' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='bobby bowl' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='state' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='3' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='tech' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='3' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='3' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='3' name='eventyear'> </TD> <input type='hidden' value='1' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='2' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='3' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='4' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='5' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='6' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='7' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='8' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='9' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='10' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='11' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='12' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='13' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='14' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='15' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='16' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='17' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='18' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='19' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='20' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='21' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='22' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='23' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='24' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='25' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='26' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='27' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='28' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='29' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='30' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='31' name='row'></TD> </TR> <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='' name='eventyear'> </TD> <input type='hidden' value='32' name='row'></TD> </TR> </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form> THANKS guys! GIMME about 15 min then ill be asking for help on how to process this LOL!! Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 19, 2008 Share Posted February 19, 2008 GJ lol, sorry i couldnt be more helpful, i think i learned something from this . quick note, if you have more than $events number of rows in your table, only the FIRST $events number of rows will be returned because of this query: WHERE competitionid <= $events so if $events == 32 then row 33,34,35 ... will be ignored, is this what you want? if you just want to limit the number of returned rows you should use "LIMIT 32" or "LIMIT $events" as this is more reliable, as if you delete rows id numbers will still auto-increment; eg: you have 32 rows, then row number 5 is deleted during a process and another row added afterward, the last row would be id 33, the results will only show 31 rows as 33 is greater than $events and row number 5 is missing. i probably explained that the long way but im sure you will understand lol Quote Link to comment Share on other sites More sharing options...
law Posted February 19, 2008 Author Share Posted February 19, 2008 yes i was wanting to limit my code to 32 (or whatever the chosen number was) however my table does not autoincrement because i do not want excess data in the table at all.. well unfortunately i now have a problem processing the form.. just as i was afraid of.. //---------------------------------EVENTS/GAMES & TEAMS TABLE--------------------------------------------------- //--------------FORM PROCESSOR--------------- if($_POST['eventsubmit']){ $var10 = $_POST['eventname']; $var11 = $_POST['eventfav']; $var12 = $_POST['eventpts']; $var13 = $_POST['eventund']; $var14 = $_POST['eventmonth']; $var15 = $_POST['eventday']; $var16 = $_POST['eventyear']; $var17 = $_POST['row']; echo "<br/><br/><br/>"; /* if($var10=''){ echo"Event name Missing"; } if($var11=''){ echo"Favorite Team Missing"; } if($var12=''){ echo"Point Spread Missing"; } if($var13=''){ echo"Underdog Team Missing"; } */ echo "$var10 == $var17"; if($idexist= mysql_query("SELECT competitionid FROM competitions WHERE competitionid = $var17")){ echo "-$idexist-"; $update = mysql_query("UPDATE competitions SET competitionname = '$var10', favorite = '$var11', underdog = '$var13', pointspread = '$var12', day = '$var15', month = '$var14', year = '$var16' WHERE competitionid = '$var17'") or die(mysql_error()); echo "<font color=orange><b>The events were successfully updated</b></font>"; }if($idexist=="0") { echo "==$idexist=="; $insquery = mysql_query("INSERT INTO competitions(competitionname,favorite,pointspread,underdog,month,day,year,competitionid) VALUES($var10,$var11,$var12,$var13,$var14,$var15,$var16,$var17)") or die(mysql_error()); echo "<font color=orange><b>The events were successfully inserted</b></font>"; } } $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $events"); $count=0; //----------END OF FORM PROCESSOR------------ echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; //----------EVENTDATA---------------- WHILE($count <= $events){ if($eventdatarow= @mysql_fetch_array($eventdata)){ $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; } else { $ename=""; $efav=""; $epts=""; $eund=""; $emm=""; $edd=""; $eyyyy=""; } //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear'> </TD> <input type='hidden' value='$count' name='row'></TD> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form>"; this is what the code prints out == 32 -Resource id #9- The events were successfully updated The data im entering should trigger both the INSERT AND UPDATE sqls... so im doing something wrong should i make a new topic for this or just leave it in here? Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 19, 2008 Share Posted February 19, 2008 personally id make a new topic, since its not a "fetching arrays" problem anymore, but since youve posted ill give it a crack in here . just a quick side note, sql injection. please go here: http://www.tizag.com/mysqlTutorial/mysql-php-sql-injection.php as your script is vulnerable to sql injection. ---- ok why do you want to update, and then insert the exact same data? are you trying to insert new rows that weren't there before, and update those that are there? if i am correctly thinking your desired results, try this: change to this code: echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav$count'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund$count'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth$count'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday$count'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear$count'> <input type='hidden' name='eventid$count' value='$eventdatarow['competitionid'];'> </TD> </TR>"; notice ive added a number unique to each result to the end of each input name, i have also added a hidden field with unique competitionid to help determine if an update or an insert query is needed. --- Change to this code: For($i=0;$i<$events;$i++){ $var10 = mysql_escape_string($_POST['eventname'.$i]); $var11 = mysql_escape_string($_POST['eventfav'.$i]); $var12 = mysql_escape_string($_POST['eventpts'.$i]); $var13 = mysql_escape_string($_POST['eventund'.$i]); $var14 = mysql_escape_string($_POST['eventmonth'.$i]); $var15 = mysql_escape_string($_POST['eventday'.$i]); $var16 = mysql_escape_string($_POST['eventyear'.$i]); $var17 = mysql_escape_string($_POST['eventid'.$i]); // Any validation should go here, validate for each result, if validation fails you can use break; to end the loop immediately. if($var17 != null){ $update = mysql_query("UPDATE competitions SET competitionname = '$var10', favorite = '$var11', underdog = '$var13', pointspread = '$var12', day = '$var15', month = '$var14', year = '$var16' WHERE competitionid = '$var17'") or die(mysql_error()); echo "<font color=orange><b>The events were successfully updated</b></font>"; }elseif($var10 != null){ $insquery = mysql_query("INSERT INTO competitions(competitionname,favorite,pointspread,underdog,month,day,year,competitionid) VALUES($var10,$var11,$var12,$var13,$var14,$var15,$var16,$i)") or die(mysql_error()); echo "<font color=orange><b>The events were successfully inserted</b></font>"; } } note i added a for loop. $var17 now equals the posted competitionid (will be empty if its a new row), this way we can check easily if it should be ins or upd. i hope this helps, Quote Link to comment Share on other sites More sharing options...
law Posted February 19, 2008 Author Share Posted February 19, 2008 ok well were making improvements! its processing something! but its doing something wrong.. and it wouldn't let me do this line <input type='hidden' name='eventid$count' value='$eventdatarow['competitionid'];'> i tried it various ways by adjusting the ; and quotes but it kept giving me whitespace and weird errors.. any way.. i think i have rigged up a way around that see code below.. //---------------------------------EVENTS/GAMES & TEAMS TABLE--------------------------------------------------- //--------------FORM PROCESSOR--------------- echo "<br/><br/><br/>"; $i=0; while($i<=$events){ $var10 = mysql_escape_string($_POST['eventname'.$i]); $var11 = mysql_escape_string($_POST['eventfav'.$i]); $var12 = mysql_escape_string($_POST['eventpts'.$i]); $var13 = mysql_escape_string($_POST['eventund'.$i]); $var14 = mysql_escape_string($_POST['eventmonth'.$i]); $var15 = mysql_escape_string($_POST['eventday'.$i]); $var16 = mysql_escape_string($_POST['eventyear'.$i]); $var17 = mysql_escape_string($_POST['eventid'.$i]); if($var10=''){ echo"Event name Missing on line $i"; } if($var11=''){ echo"Favorite Team Missing on line $i"; } if($var12=''){ echo"Point Spread Missing on line $i"; } if($var13=''){ echo"Underdog Team Missing on line $i"; } if($var14=''){ echo"Month Missing on line $i"; } if($var15=''){ echo"Day Missing on line $i"; } if($var16=''){ echo"Year Missing on line $i"; } if($var17 != null){ $update = mysql_query("UPDATE competitions SET competitionname = '$var10', favorite = '$var11', underdog = '$var13', pointspread = '$var12', day = '$var15', month = '$var14', year = '$var16' WHERE competitionid = '$var17'") or die(mysql_error()); echo "<font color=orange><b>The events were successfully updated</b></font>"; }elseif($var10 != null){ $insquery = mysql_query("INSERT INTO competitions(competitionname,favorite,pointspread,underdog,month,day,year,competitionid) VALUES($var10,$var11,$var12,$var13,$var14,$var15,$var16,$i)") or die(mysql_error()); echo "<font color=orange><b>The events were successfully inserted</b></font>"; } $i++; } $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $events"); $count=0; //----------END OF FORM PROCESSOR------------ echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; //----------EVENTDATA---------------- WHILE($count <= $events){ if($eventdatarow= @mysql_fetch_array($eventdata)){ $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; $eid=$eventdatarow['competitionid']; } else { $ename=""; $efav=""; $epts=""; $eund=""; $emm=""; $edd=""; $eyyyy=""; } //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav$count'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund$count'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth$count'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday$count'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear$count'> </TD> <input type='hidden' name='eventid$count' value='$eid'> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form>"; //---------------------------------END OF EVENTS/GAMES & TEAMS TABLE-------------------------------------------- the error is as follows Incorrect integer value: '' for column 'day' at row 1 regardless of how many rows or values i insert into the table it dies @ row 1 and it also does not put any data into the database all of row one's column's data becomes blank?? Quote Link to comment Share on other sites More sharing options...
btherl Posted February 19, 2008 Share Posted February 19, 2008 Instead of $update = mysql_query("UPDATE competitions SET competitionname = '$var10', favorite = '$var11', underdog = '$var13', pointspread = '$var12', day = '$var15', month = '$var14', year = '$var16' WHERE competitionid = '$var17'") or die(mysql_error()); do this: $sql = "UPDATE competitions SET competitionname = '$var10', favorite = '$var11', underdog = '$var13', pointspread = '$var12', day = '$var15', month = '$var14', year = '$var16' WHERE competitionid = '$var17'"; $update = mysql_query($sql) or die("Error in $sql\n" . mysql_error()); The second version will print the exact query you tried to execute, so you can easily see what went wrong. Make the same change to both queries, and you should get enough information to fix it! Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 19, 2008 Share Posted February 19, 2008 //---------------------------------EVENTS/GAMES & TEAMS TABLE--------------------------------------------------- //--------------FORM PROCESSOR--------------- echo "<br/><br/><br/>"; $i=0; print_r($_REQUEST); // DEBUG LINE while($i<=$events){ $var10 = mysql_escape_string($_POST['eventname'.$i]); $var11 = mysql_escape_string($_POST['eventfav'.$i]); $var12 = mysql_escape_string($_POST['eventpts'.$i]); $var13 = mysql_escape_string($_POST['eventund'.$i]); $var14 = mysql_escape_string($_POST['eventmonth'.$i]); $var15 = mysql_escape_string($_POST['eventday'.$i]); $var16 = mysql_escape_string($_POST['eventyear'.$i]); $var17 = mysql_escape_string($_POST['eventid'.$i]); echo($var10."-$var11-$var12-$var13-$var14-$var15-$var16-$var17<br>"); // DEBUG LINE if($var10=''){ echo"Event name Missing on line $i"; } if($var11=''){ echo"Favorite Team Missing on line $i"; } if($var12=''){ echo"Point Spread Missing on line $i"; } if($var13=''){ echo"Underdog Team Missing on line $i"; } if($var14=''){ echo"Month Missing on line $i"; } if($var15=''){ echo"Day Missing on line $i"; } if($var16=''){ echo"Year Missing on line $i"; } if($var17 != null){ // update query $query = "UPDATE competitions SET competitionname = '$var10', favorite = '$var11', underdog = '$var13', pointspread = '$var12', day = '$var15', month = '$var14', year = '$var16' WHERE competitionid = '$var17'"; $result = mysql_query($query) or die("MySQL ERROR: $query <br> ".mysql_error()); echo "<font color=orange><b>The events were successfully updated</b></font>"; }elseif($var10 != null){ $query = "INSERT INTO competitions( competitionname, favorite, pointspread, underdog, month, day, year, competitionid ) VALUES( $var10, $var11, $var12, $var13, $var14, $var15, $var16, $i )"; $result = mysql_query($query) or die("MySQL ERROR: $query <br> ".mysql_error()); echo "<font color=orange><b>The events were successfully inserted</b></font>"; } $i++; } $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $events"); $count=0; //----------END OF FORM PROCESSOR------------ echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; //----------EVENTDATA---------------- WHILE($count <= $events){ if($eventdatarow= @mysql_fetch_array($eventdata)){ $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; $eid=$eventdatarow['competitionid']; } else { $ename=""; $efav=""; $epts=""; $eund=""; $emm=""; $edd=""; $eyyyy=""; } //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav$count'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund$count'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth$count'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday$count'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear$count'> </TD> <input type='hidden' name='eventid$count' value='$eid'> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form>"; //---------------------------------END OF EVENTS/GAMES & TEAMS TABLE-------------------------------------------- what does it say with this instead? Quote Link to comment Share on other sites More sharing options...
law Posted February 19, 2008 Author Share Posted February 19, 2008 here is what it says before submitting the data Array ( [phpSESSID] => 8moukslovo2j8uvk09mfdm5n72 ) ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- Pool Form Setup Table Event Name Favorite Team Point Spread Underdog Event Date here is what it says after submission Array ( [eventname0] => poinsetta bowl [eventfav0] => usm [eventpts0] => 2 [eventund0] => olemiss [eventmonth0] => 2 [eventday0] => 2 [eventyear0] => 2 [eventid0] => 1 [eventname1] => competitionname [eventfav1] => tech [eventpts1] => 3 [eventund1] => state [eventmonth1] => 3 [eventday1] => 3 [eventyear1] => 3 [eventid1] => 2 [eventname2] => NEWEVENT [eventfav2] => NEWFAV [eventpts2] => 4 [eventund2] => NEWUND [eventmonth2] => 4 [eventday2] => 4 [eventyear2] => 4 [eventid2] => 2 [eventname3] => [eventfav3] => [eventpts3] => [eventund3] => [eventmonth3] => [eventday3] => [eventyear3] => [eventid3] => 2 [eventname4] => [eventfav4] => [eventpts4] => [eventund4] => [eventmonth4] => [eventday4] => [eventyear4] => [eventid4] => 2 [eventname5] => [eventfav5] => [eventpts5] => [eventund5] => [eventmonth5] => [eventday5] => [eventyear5] => [eventid5] => 2 [eventname6] => [eventfav6] => [eventpts6] => [eventund6] => [eventmonth6] => [eventday6] => [eventyear6] => [eventid6] => 2 [eventname7] => [eventfav7] => [eventpts7] => [eventund7] => [eventmonth7] => [eventday7] => [eventyear7] => [eventid7] => 2 [eventname8] => [eventfav8] => [eventpts8] => [eventund8] => [eventmonth8] => [eventday8] => [eventyear8] => [eventid8] => 2 [eventname9] => [eventfav9] => [eventpts9] => [eventund9] => [eventmonth9] => [eventday9] => [eventyear9] => [eventid9] => 2 [eventname10] => [eventfav10] => [eventpts10] => [eventund10] => [eventmonth10] => [eventday10] => [eventyear10] => [eventid10] => 2 [eventname11] => [eventfav11] => [eventpts11] => [eventund11] => [eventmonth11] => [eventday11] => [eventyear11] => [eventid11] => 2 [eventname12] => [eventfav12] => [eventpts12] => [eventund12] => [eventmonth12] => [eventday12] => [eventyear12] => [eventid12] => 2 [eventname13] => [eventfav13] => [eventpts13] => [eventund13] => [eventmonth13] => [eventday13] => [eventyear13] => [eventid13] => 2 [eventname14] => [eventfav14] => [eventpts14] => [eventund14] => [eventmonth14] => [eventday14] => [eventyear14] => [eventid14] => 2 [eventname15] => [eventfav15] => [eventpts15] => [eventund15] => [eventmonth15] => [eventday15] => [eventyear15] => [eventid15] => 2 [eventname16] => [eventfav16] => [eventpts16] => [eventund16] => [eventmonth16] => [eventday16] => [eventyear16] => [eventid16] => 2 [eventname17] => [eventfav17] => [eventpts17] => [eventund17] => [eventmonth17] => [eventday17] => [eventyear17] => [eventid17] => 2 [eventname18] => [eventfav18] => [eventpts18] => [eventund18] => [eventmonth18] => [eventday18] => [eventyear18] => [eventid18] => 2 [eventname19] => [eventfav19] => [eventpts19] => [eventund19] => [eventmonth19] => [eventday19] => [eventyear19] => [eventid19] => 2 [eventname20] => [eventfav20] => [eventpts20] => [eventund20] => [eventmonth20] => [eventday20] => [eventyear20] => [eventid20] => 2 [eventname21] => [eventfav21] => [eventpts21] => [eventund21] => [eventmonth21] => [eventday21] => [eventyear21] => [eventid21] => 2 [eventname22] => [eventfav22] => [eventpts22] => [eventund22] => [eventmonth22] => [eventday22] => [eventyear22] => [eventid22] => 2 [eventname23] => [eventfav23] => [eventpts23] => [eventund23] => [eventmonth23] => [eventday23] => [eventyear23] => [eventid23] => 2 [eventname24] => [eventfav24] => [eventpts24] => [eventund24] => [eventmonth24] => [eventday24] => [eventyear24] => [eventid24] => 2 [eventname25] => [eventfav25] => [eventpts25] => [eventund25] => [eventmonth25] => [eventday25] => [eventyear25] => [eventid25] => 2 [eventname26] => [eventfav26] => [eventpts26] => [eventund26] => [eventmonth26] => [eventday26] => [eventyear26] => [eventid26] => 2 [eventname27] => [eventfav27] => [eventpts27] => [eventund27] => [eventmonth27] => [eventday27] => [eventyear27] => [eventid27] => 2 [eventname28] => [eventfav28] => [eventpts28] => [eventund28] => [eventmonth28] => [eventday28] => [eventyear28] => [eventid28] => 2 [eventname29] => [eventfav29] => [eventpts29] => [eventund29] => [eventmonth29] => [eventday29] => [eventyear29] => [eventid29] => 2 [eventname30] => [eventfav30] => [eventpts30] => [eventund30] => [eventmonth30] => [eventday30] => [eventyear30] => [eventid30] => 2 [eventname31] => [eventfav31] => [eventpts31] => [eventund31] => [eventmonth31] => [eventday31] => [eventyear31] => [eventid31] => 2 [eventname32] => [eventfav32] => [eventpts32] => [eventund32] => [eventmonth32] => [eventday32] => [eventyear32] => [eventid32] => 2 [eventsubmit] => Add/Update Events [phpSESSID] => 8moukslovo2j8uvk09mfdm5n72 ) poinsetta bowl-usm-2-olemiss-2-2-2-1 MySQL ERROR: UPDATE competitions SET competitionname = '', favorite = '', underdog = '', pointspread = '', day = '', month = '', year = '' WHERE competitionid = '1' Incorrect integer value: '' for column 'day' at row 1 soo good news! it appears as though the array does infact contain the data.. however apparently something is going wrong in the php code?? because i used SQLyog to build this query which is the query in the code but without variables and it works perfectly in there? "UPDATE competitions SET competitionname = 'test', favorite = 'testfav', underdog = 'testund', pointspread = '2', day = '2', month = '2', year = '2' WHERE competitionid = '1'" Quote Link to comment Share on other sites More sharing options...
law Posted February 19, 2008 Author Share Posted February 19, 2008 im pretty sure the database is fine ive been updating without problems in early iterations of this code but just to be certain here is the table Table Create Table ------------ ----------------------------------------------- competitions CREATE TABLE `competitions` ( `competitionid` int(11) NOT NULL, `competitionname` varchar(20) default NULL, `favorite` varchar(20) default NULL, `underdog` varchar(20) default NULL, `pointspread` varchar(11) default NULL, `day` int(11) default NULL, `month` int(11) default NULL, `year` int(11) default NULL, PRIMARY KEY (`competitionid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 19, 2008 Share Posted February 19, 2008 aha, so there is data, yet the data is not being called properly, try this: //---------------------------------EVENTS/GAMES & TEAMS TABLE--------------------------------------------------- //--------------FORM PROCESSOR--------------- echo "<br/><br/><br/>"; $i=0; while($i<=$events){ $varname10 = 'eventname'.$i; // try this way, my theory might not work as i expected. $varname11 = 'eventfav'.$i; $varname12 = 'eventpts'.$i; $varname13 = 'eventund'.$i; $varname14 = 'eventmonth'.$i; $varname15 = 'eventday'.$i; $varname16 = 'eventyear'.$i; $varname17 = 'eventid'.$i; if($lastid == $varname17){ continue; } // if no data, skip this loop $lastid = $varname17; // used for above check $var10 = mysql_escape_string($_POST[$varname10]); $var11 = mysql_escape_string($_POST[$varname11]); $var12 = mysql_escape_string($_POST[$varname12]); $var13 = mysql_escape_string($_POST[$varname13]); $var14 = mysql_escape_string($_POST[$varname14]); $var15 = mysql_escape_string($_POST[$varname15]); $var16 = mysql_escape_string($_POST[$varname16]); $var17 = mysql_escape_string($_POST[$varname17]); if($var10=''){ echo"Event name Missing on line $i"; } if($var11=''){ echo"Favorite Team Missing on line $i"; } if($var12=''){ echo"Point Spread Missing on line $i"; } if($var13=''){ echo"Underdog Team Missing on line $i"; } if($var14=''){ echo"Month Missing on line $i"; } if($var15=''){ echo"Day Missing on line $i"; } if($var16=''){ echo"Year Missing on line $i"; } if($var17 != null){ // update query $query = "UPDATE competitions SET competitionname = '$var10', favorite = '$var11', underdog = '$var13', pointspread = '$var12', day = '$var15', month = '$var14', year = '$var16' WHERE competitionid = '$var17'"; $result = mysql_query($query) or die("MySQL ERROR: $query <br> ".mysql_error()); echo "<font color=orange><b>The events were successfully updated</b></font>"; }elseif($var10 != null){ $query = "INSERT INTO competitions( competitionname, favorite, pointspread, underdog, month, day, year, competitionid ) VALUES( $var10, $var11, $var12, $var13, $var14, $var15, $var16, $i )"; $result = mysql_query($query) or die("MySQL ERROR: $query <br> ".mysql_error()); echo "<font color=orange><b>The events were successfully inserted</b></font>"; } $i++; } $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $events"); $count=0; //----------END OF FORM PROCESSOR------------ echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; //----------EVENTDATA---------------- WHILE($count <= $events){ if($eventdatarow= @mysql_fetch_array($eventdata)){ $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; $eid=$eventdatarow['competitionid']; } else { $ename=""; $efav=""; $epts=""; $eund=""; $emm=""; $edd=""; $eyyyy=""; } //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav$count'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund$count'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth$count'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday$count'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear$count'> </TD> <input type='hidden' name='eventid$count' value='$eid'> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form>"; //---------------------------------END OF EVENTS/GAMES & TEAMS TABLE-------------------------------------------- hope this helps, Quote Link to comment Share on other sites More sharing options...
law Posted February 19, 2008 Author Share Posted February 19, 2008 ok well were getting closer! here is the error from the page after the data (3 rows of data) was submitted The events were successfully updatedThe events were successfully updatedThe events were successfully updatedMySQL ERROR: UPDATE competitions SET competitionname = '', favorite = '', underdog = '', pointspread = '', day = '', month = '', year = '' WHERE competitionid = '2' Incorrect integer value: '' for column 'day' at row 1 now i went to the database to see what happend.. it appears that a) row 1 remained the same [hopefully that means it updated correctly] b) row 2 was replaced by the new data from row three [judging from the messages above it appears that it updated the original data in row 2 and then replaced/UPDATED the data in row 2 with the data that should have been INSERTED into row 3 but it did NOT change the competitionid #.. its still 2 soo i still only have 2 rows of data in my database] Quote Link to comment Share on other sites More sharing options...
uniflare Posted February 19, 2008 Share Posted February 19, 2008 ok try this (look near the form i add a couple lines) //---------------------------------EVENTS/GAMES & TEAMS TABLE--------------------------------------------------- //--------------FORM PROCESSOR--------------- echo "<br/><br/><br/>"; $i=0; while($i<=$events){ $varname10 = 'eventname'.$i; // try this way, my theory might not work as i expected. $varname11 = 'eventfav'.$i; $varname12 = 'eventpts'.$i; $varname13 = 'eventund'.$i; $varname14 = 'eventmonth'.$i; $varname15 = 'eventday'.$i; $varname16 = 'eventyear'.$i; $varname17 = 'eventid'.$i; if($lastid == $varname17){ continue; } // if no data, skip this loop $lastid = $varname17; // used for above check $var10 = mysql_escape_string($_POST[$varname10]); $var11 = mysql_escape_string($_POST[$varname11]); $var12 = mysql_escape_string($_POST[$varname12]); $var13 = mysql_escape_string($_POST[$varname13]); $var14 = mysql_escape_string($_POST[$varname14]); $var15 = mysql_escape_string($_POST[$varname15]); $var16 = mysql_escape_string($_POST[$varname16]); $var17 = mysql_escape_string($_POST[$varname17]); if($var10=''){ echo"Event name Missing on line $i"; } if($var11=''){ echo"Favorite Team Missing on line $i"; } if($var12=''){ echo"Point Spread Missing on line $i"; } if($var13=''){ echo"Underdog Team Missing on line $i"; } if($var14=''){ echo"Month Missing on line $i"; } if($var15=''){ echo"Day Missing on line $i"; } if($var16=''){ echo"Year Missing on line $i"; } if($var17 != null){ // update query $query = "UPDATE competitions SET competitionname = '$var10', favorite = '$var11', underdog = '$var13', pointspread = '$var12', day = '$var15', month = '$var14', year = '$var16' WHERE competitionid = '$var17'"; $result = mysql_query($query) or die("MySQL ERROR: $query <br> ".mysql_error()); echo "<font color=orange><b>The events were successfully updated</b></font>"; }elseif($var10 != null){ $query = "INSERT INTO competitions( competitionname, favorite, pointspread, underdog, month, day, year, competitionid ) VALUES( $var10, $var11, $var12, $var13, $var14, $var15, $var16, $i )"; $result = mysql_query($query) or die("MySQL ERROR: $query <br> ".mysql_error()); echo "<font color=orange><b>The events were successfully inserted</b></font>"; } $i++; } $eventdata= mysql_query("SELECT * FROM competitions WHERE competitionid <= $events"); $count=0; //----------END OF FORM PROCESSOR------------ echo " <TABLE BORDER=2 CELLPADDING=2 CELLSPACING=2 align=center WIDTH=720> <form name='eventsconfig' action='./adminconfig.php' method='POST'> <CAPTION ALIGN=TOP><B>Pool Form Setup Table</B><br/></CAPTION> <TR> <TH> Event Name</TH> <TH> Favorite Team</TH> <TH> Point Spread</TH> <TH> Underdog</TH> <TH> Event Date</TH> </TR>"; //----------EVENTDATA---------------- WHILE($count <= $events){ if($eventdatarow= @mysql_fetch_array($eventdata)){ $ename=$eventdatarow['competitionname']; $efav=$eventdatarow['favorite']; $epts=$eventdatarow['pointspread']; $eund=$eventdatarow['underdog']; $emm=$eventdatarow['month']; $edd=$eventdatarow['day']; $eyyyy=$eventdatarow['year']; $eid=$eventdatarow['competitionid']; if($eid == null){ $eid = $lasteid+1; } // added these 2 lines, will count up from last known eid (for new entries) $lasteid = $eid; } else { $ename=""; $efav=""; $epts=""; $eund=""; $emm=""; $edd=""; $eyyyy=""; } //----------EndOfDATA---------------- echo " <TR> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$ename' name='eventname$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$efav' name='eventfav$count'></TD> <TD align=center><input type='text' size='6' MAXLENGTH='6' value='$epts' name='eventpts$count'></TD> <TD align=center><input type='text' size='20' MAXLENGTH='20' value='$eund' name='eventund$count'> <TD align=center> <input type='text' size='2' MAXLENGTH='2' value='$emm' name='eventmonth$count'> <input type='text' size='2' MAXLENGTH='2' value='$edd' name='eventday$count'> <input type='text' size='4' MAXLENGTH='4' value='$eyyyy' name='eventyear$count'> </TD> <input type='hidden' name='eventid$count' value='$eid'> </TR>"; $count++; } echo " </TABLE> <TABLE align=center> <TR> <TD> <input type='submit' name='eventsubmit' value='Add/Update Events'> <input type='reset' name='eventreset' value='Reset'><br/> </TD> </TR> </TABLE> </form>"; //---------------------------------END OF EVENTS/GAMES & TEAMS TABLE-------------------------------------------- hope this helps, Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.