Jim R

I had not. I'm not sure what you mean by it. I notice when I see the print_r of the array that the first one is 0. Not really. I tried it various ways, including with your previous FOREACH loop. Mine is mysqli, but I thought may the pdo-prepare's use was relative to my problem.

Seems if I have unused rows, it will cause issues, or worse, I won't have enough rows. The above query is getting this error:

I need for the User (coaches) to be able to add rows. Teams don't have a set number of players.

How do I echo that out to see what's it's producing? Echoing $data just produced 'array', which I'm sure you would figure. I tried this outside the loop: $data = implode(",",$data[$k]); echo $data; It produced the last set of entries 10,Steve,Smith. I put it inside the loop, and it threw an error. Ultimately, I don't need to see it on screen, just insert it into a table.

I'm wanting coaches/teams to input their roster directly onto the site. Right now it's just three columns: uniform, nameLast,nameFirst I'm using jQuery to add and remove the fields, (once I'm done styling, the form will be a row for each name), and that part appears to be functioning quite well. When it's all done, teams will input anywhere from 10-20 players into the form. It's sent to a .php for processing. I was envisioning the data would come out in rows - uniform, nameFirst, nameLast. Imploding it with *comma* separators, then figuring out how to terminate each line with a |. Instead it's coming out in arrays based on the field. (That makes sense to me as I see the code.) So it's coming out... 3,5,10 Joe, Tim, Steve Johnson, Thomas, Smith I just have this so I could make sure I was at least getting the expected data. $uniform = implode(",",$_POST['uniform']); $fname = implode(",",$_POST['nameFirst']); $lname = implode(",",$_POST['nameLast']); echo $uniform; echo $fname; echo $lname; How do I get it to read: 3,Joe,Johnson 5,Tim,Thomas 10,Steve,Smith Here is the form HTML <form role="form" action="/wp-content/plugins/csi_stats/csi_roster_process.php" method="post"> <div id="myRepeatingFields"> <div class="entry input-group col-xs-3"> <input class="form-control" name="uniform[]" type="text" placeholder="Uni #" /> <input class="form-control" name="nameFirst[]" type="text" placeholder="First Name" /> <input class="form-control" name="nameLast[]" type="text" placeholder="Last Name" /> <span class="input-group-btn"> <button type="button" class="btn btn-success btn-lg btn-add"> <span class="glyphicon glyphicon-plus" aria-hidden="true"></span> </button> </span> </div> </div> <input type="submit" value="Send Roster" name="submit"> </form> Here is the jQuery in case you're curious $(function() { $(document).on('click', '.btn-add', function(e) { e.preventDefault(); var controlForm = $('#myRepeatingFields:first'), currentEntry = $(this).parents('.entry:first'), newEntry = $(currentEntry.clone()).appendTo(controlForm); newEntry.find('input').val(''); controlForm.find('.entry:not(:last) .btn-add') .removeClass('btn-add').addClass('btn-remove') .removeClass('btn-success').addClass('btn-danger') .html(''); }).on('click', '.btn-remove', function(e) { e.preventDefault(); $(this).parents('.entry:first').remove(); return false; }); });

I have all of Host Gator stumped. They don't know why I'm getting an access denied error.

I don't have access to that. I'm talking with someone now. They don't see why I don't have permission to use Load Data. I'll report back. Does the query, however, look good?

There is nowhere to type the GRANT

OK, but where do I do that?

I'm working on that. They're telling me I have permission, but I don't. And when you (and my tech) ask me if I have permissions, csi_username has ALL permissions. However, the error shows csi@localhost. Not sure where to check/change csi@localhost.

Hold on...checking for more information.

I don't have a command line.

Looks like Linux.

I have the necessary permissions, according to the tech support, and I know I have file_uploads enabled in php.ini.

I'm not on Linux. I'm accessing my mysql database permissions via my cPanel / phpMyAdmin.

I'm the user running the script. Which command line are you referring to? I checked through cPanel through my host.

I'm the admin (reseller account) so I should have all available privileges. I'm talking to Host Gator now to find out if there is something else.

Where would I check the privileges? I know I had checked whether or not I could write to the folder. I can store the file, but it wasn't uploading the file.

That's fair, and I wondered if I needed to store the file at all, but I kind of want to keep the files. I guess there isn't a need. So I tried it with just this... $filename = $_FILES['fileToUpload']['name']; $query = " LOAD DATA INFILE '$fileName' INTO TABLE a_stats FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n' IGNORE 2 Lines (jersey,points,2pm,2pa,3pm,3pa,ftm,fta,oreb,dreb,treb,ast,blk,stl,deflect,turn,charge,pf,tf) SET team = 426"; It still didn't input the data.

I'll be having .txt files uploaded via a form. Upon submission, it will be passed to another .php file to have the data entered into the database. It's not uploading the file to the folder, and while the trigger echoes what's set up to echo, it's loading the data into the database. Here is the form: echo '<form action="/wp-content/plugins/csi_stats/csi_process.php" method="post" enctype="multipart/form-data"> Select Boxscore to upload: <input type="file" name="fileToUpload" id="fileToUpload"> <input type="submit" value="Upload" name="submit"> </form>'; } Here is csi_process.php $filename = $_FILES['fileToUpload']['name']; $target_dir = "/wp-content/uploads/csi_boxscores/21/"; $target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]); $uploadOk = 1; $imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION)); // Check if image file is a actual image or fake image if(isset($_POST["submit"])) { // $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]); echo $target_file . ' Boxscore Sent'; echo '<br>' .$filename; $uploadOk = 0; } $query = " LOAD DATA INFILE '$fileName' INTO TABLE a_stats FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n' IGNORE 2 Lines (jersey,points,2pm,2pa,3pm,3pa,ftm,fta,oreb,dreb,treb,ast,blk,stl,deflect,turn,charge,pf,tf) SET team = 426"; "team" will ultimately be a variable, and I'll have "game" in there too. Here is the data: 235a5d12-be10-43af-abba-e45456d9d8da Jersey|Points|TwoPointsMade|TwoPointAttempts|ThreePointsMade|ThreePointAttempts|FreeThrowsMade|FreeThrowAttempts|OffensiveRebounds|DefensiveRebounds|Rebounds|Assists|BlockedShots|Steals|Deflections|Turnovers|Charges|PersonalFouls|TechnicalFouls 10|8|1|2|2|6|0|0|0|4|4|1|1|1|0|1|0|0|0 12|3|0|5|0|3|3|4|1|2|3|0|1|1|0|0|0|2|0 20|8|4|6|0|0|0|0|1|1|2|0|1|1|0|2|0|0|0 22|3|0|1|1|1|0|0|1|2|3|1|0|0|0|2|0|2|0 24|18|4|7|1|3|7|10|0|2|2|1|0|1|0|3|0|3|0 32|1|0|2|0|3|1|2|2|1|3|0|0|1|0|0|0|2|0 41|8|0|0|2|3|2|2|0|0|0|0|0|1|0|0|0|1|0 43|11|5|7|0|0|1|2|0|6|6|1|0|4|0|2|0|3|0 52|3|1|6|0|0|1|1|4|3|7|0|0|1|0|1|0|4|0

Turns out it was just a typo. wp_terms_relationships - there shouldn't be an 's' in terms. Sorry about that. I should've run the basic query to see if I could get more info.

I assuming if you're here, you know WP table structure, but I also have two of my own tables called events and evaluations. Events columns are id, name, start, end, city, state, tag Evaluations isn't really part of this issue. I have a WP Page with custom code drawing anything from Evaluations that matches the Event to the page. Now, I would also like to list any WP Post that matches event.tag to this page. The error I'm getting: Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home2/csi/public_html/wp-content/plugins/csi_reviews.php on line 970 So it's not finding any matches in the query, but I work it forward and back, the values line up. So I'm clearly missing something. So the URL that reads like this... webaddress.com/event/?event=18 $event = $_GET['event']; $query = "SELECT * FROM wp_posts p LEFT JOIN wp_terms_relationships tr ON p.ID = tr.object_id LEFT JOIN wp_terms t ON tr.term_taxonomy_id = t.term_id LEFT JOIN a_events e ON e.tag = t.slug WHERE e.id = '". $event ."' "; p.ID = 1459 tr.object_id = 1459 tr.term_taxonomy_id = 1231 t.term_id = 1231 e.tag = mibfl t.slug = mibfl e.id = 18 $event = 18

Even simpler as it turns out. This returns every coach whose tenure hasn't ended yet. select s.id as sid,coachFirst,coachLast,season_hired,season_end,username,s.server,toggle,city,school,nickname,bsect from a_coach c left join a_schools s on s.id = c.school_id where season_end is null order by s.id

I also have a seasons table. I could join that for the match, right?

OK...I'll play around with it, and I see what you're saying. I'lll have to set up the coaching tenure table before I can visualize how it will really help me with queries, but as always, I appreciate your input. When you suggested that, I wasn't ready to start adding coaches, and this is the first off-season I've messed with coaching changes. Everything is working well except this view, but I'd like to get the view set up for my writers. There is one issue with this though. When there is a coaching change, there is a change of contact information. I have the server name of each school in the school table, which for the most part is static (some use a personal email address instead of a school address). I have the Username (before the @) in the coach table. So even if using this extra table, I will have to type a new user name on each change. So either I change in the coach table with each change, or add it with a new coaching tenure line.