fulcrum2

I should have put that up there - it's not That seems to be the first impression people get when they hear the name haha!

Hi everyone. I have a data entry page through which I add stats for the russianprospects.com website. It is basically rows of empty fields that I fill in and then submit into the db. I have an array in place so that I can submit multiple statistic rows at the same time. To make it easier, I am trying to add a drop down for the player name field (right now I just manually enter the player_id for each row). I've tried to create the select box code below, which works in some form for single entry, but doesn't seem to work for this erray. I attached a copy of the most recent version of the page. Could you please take a look and let me know how to fix it? Also - I would be glad to discuss with anyone further over any IM (AIM, ICQ, SKYPE, MSN, Yahoo, etc.). Thank you very much for your time! ----------------DATA ENTRY CODE:-------------------------------------- foreach($stats AS $stat)//Definition of each statistics row of data { // THIS IS THE ISSUE RIGHT HERE //PLAYER DROP DOWN POPULATION CODE $stats = array( "player_id", "team", "GP", "goals", "assists", "PIM", "plusminus", "jersey_id", "team_id"); for ($i = 0; $i < 10; $i++) { if ($x=='0'){ // Added this here to assure that this is displayed for the first column across all 10 rows of the data entry sheet $sql_player = "SELECT * FROM player WHERE draft_year=2003 ORDER BY lname"; $result_player = mysql_query($sql_player); $myrow_player = mysql_fetch_assoc($result_player); echo '<select name=data[$i][$stat]>'; do { $lname = $myrow_player ["lname"]; $player_id = $myrow_player ["player_id"]; echo "<option value=\"$player_id\"> $lname $i $stat</option>\n"; //put the $i and $stat in there just to make sure that these show up correctly as they do for the text fields }while ($myrow_player = mysql_fetch_assoc ($result_player)); echo '</select>'; } //END OF PLAYER DROP DOWN POPULATION CODE //THIS NEXT PART WORKS WELL else { echo "<input type=text name=data[$i][$stat] value=\"\" size=4>"; echo $i; echo $stat; } $x++; } } echo "<input type=submit name=submit value=\"update\">"; echo "</form>"; } --------------SUBMISSION CODE (goes on top):---------------------- if ( $_POST['submit'] ) { if ( isset( $_POST['update'] ) ) { foreach( $_POST['update'] AS $id => $status ) { // status = "On" $sql = "INSERT INTO stats_player (stats_player_id, year,season,league,tour_id,season_part,player_id,team,GP,goals,assists,PIM,plusminus,jersey_id,team_id) VALUES('',"; $sql .= "'$year','$season','$league','$tour_id','$season_part',"; foreach( $_POST['data'][$id] AS $col => $value ) { if ($col=='0') {$heading="player_id";} else if ($col=='1') {$heading="team";} else if ($col=='2') {$heading="GP";} else if ($col=='3') {$heading="goals";} else if ($col=='4') {$heading="assists";} else if ($col=='5') {$heading="PIM";} else if ($col=='6') {$heading="plusminus";} else if ($col=='7') {$heading="jersey_id";} else if ($col=='8') {$heading="team_id";} echo "$col ---- $value <br>"; $sql .= "'$value',"; } $sql = substr($sql,0,-1); // remove trailing comma $sql .= ");"; echo $sql."<br><br>"; echo $player_id_internal; ----------------OUTPUT----------------------------- INSERT INTO stats_player (stats_player_id, year,season,league,tour_id,season_part,player_id,team,GP,goals,assists,PIM,plusminus,jersey_id,team_id) VALUES('','2006','2005-06','NHL','0','1','Pensacola Ice Pirates','42','18','22','30','-','6','7'); --------PROBLEM - completely ignores the select drop down value....-------------------------------- [attachment deleted by admin]

Thank you very much for your feedback and the kind words regarding the site! I fixed the double entry part. Could you provide the link where you saw the duplicate latest player news? Thanks!

Please take a look and let me know what you think. There are a lot of moving pieces and I would appreciate an outside opinion about the design or layout, usability and really anything else. Thanks! www.russianprospects.com

I am currently managing a hockey website www.russianprospects.com (comments welcome regarding the webstie btw ) and in the admin section I post the articles through a self-made admin tool that just submits whatever I input into the text field. So, that means I first format an article or news in an html editor such as dreamweaver before pasting the resulting code into the text field. Is there code I can use to enhance my admin section to automatically insert HTML tags such as line breaks and others? Can I implement a word type editor for the text field within my current website structure (which is all manually programmed and doesn't use any website management software)? Thanks!

Hello - I am trying to create a data submission form using an array of blank fields that when submitted populate entered data into a table. I want to add a drop down select box for one of the entry fields and am having issues for the selected value to propogate to the database entry. Please find the script below. I'd really appreciate your help! THE ORIGINAL SCRIPT THAT WORKS: foreach($stats AS $stat)//Definition of each statistics row of data { $stats = array( "player_id", "team", "GP", "goals", "assists", "PIM", "plusminus", "jersey_id", "team_id"); printf ("<td><input type=text name=data[$i][$stat] value=\"\" size=4></td>"); // data from DB } THEN THE FOLLOWING CODE WOULD SUBMIT INTO THE DB (with separate php file defining the columns) $sql = "INSERT INTO stats_player (stats_player_id, year,season,league,tour_id,season_part,player_id,team,GP,goals,assists,PIM,plusminus,jersey_id,team_id) VALUES('',"; $sql .= "'$year','$season','$league','$tour_id','$season_part',"; foreach( $_POST['data'][$id] AS $col => $value ) { include 'stats_include_headings_tour.php'; $sql .= "'$value',"; THE NEW CODE THAT NEEDS HELP (it successfully displays the select box, but doesn't transfer the entered player_id value into the insert statement above. Can I not use the select code here as part of the stats array? or am I doing it wrong?): foreach($stats AS $stat)//Definition of each statistics row of data { echo "<td>"; // printf ("<td><input type=text name=data[$i][$stat] value=\"\" size=4></td>"); // data from DB if ($x=='0'){ $sql_player = "SELECT * FROM player WHERE draft_year=2003 ORDER BY lname"; $result_player = mysql_query($sql_player); $myrow_player = mysql_fetch_assoc($result_player); echo '<select name=data[$i][$stat]>'; do { $lname = $myrow_player ["lname"]; $player_id_internal = $myrow_player ["player_id"]; //foreach ($lname as $key => $value) { echo "<option value=\"$player_id_internal\"> $lname </option>\n"; }while ($myrow_player = mysql_fetch_assoc ($result_player)); echo '</select>'; } else { echo "<input type=text name=data[$i][$stat] value=\"\" size=4>"; }