Jump to content

Jim R

Members
  • Content count

    598
  • Joined

  • Last visited

  • Days Won

    1

Jim R last won the day on July 26

Jim R had the most liked content!

Community Reputation

1 Neutral

About Jim R

  • Rank
    Prolific Member

Profile Information

  • Gender
    Not Telling
  1. Jim R

    Inner Join help...

    http://metroindybasketball.com/mibfl/2018-mibfl-rosters/ When I was working with the array instead of the a separate data table, the $currentTeam triggered the change. I added the $currentCoach thinking I need to trigger that too.
  2. Jim R

    Inner Join help...

    It looks like the rows are starting to show.
  3. Jim R

    Inner Join help...

    Before I opted for a separate table for the coaches, had them listed as an array to work from. It's much easier to change a data table than peck through code to make changes each time. However, the array version worked quite well for five years. I have one row of data for each coach now. Nothing is being output.
  4. Jim R

    Inner Join help...

    The error message went away when I changed toggle to triple. No results are shown. As of now there are four coaches in that table.
  5. Jim R

    Inner Join help...

    Still no output.
  6. Jim R

    Inner Join help...

    $query = 'SELECT * FROM fallLeague_coaches as c left join fallLeague2018 as p ON p.team = c.team WHERE p.confirm="1" and p.team is not null ORDER BY p.team,p.triple,p.number,p.nameLast';
  7. Jim R

    Inner Join help...

    Current Schema with triple in it: CREATE TABLE `fallLeague2018` ( `id` int(4) NOT NULL AUTO_INCREMENT, `confirm` int(1) DEFAULT NULL, `paid` varchar(10) DEFAULT NULL, `player_coach` varchar(10) DEFAULT NULL, `team` varchar(3) DEFAULT NULL, `nameFirst` varchar(255) DEFAULT NULL, `nameLast` varchar(255) DEFAULT NULL, `school` varchar(255) DEFAULT NULL, `feet` int(1) DEFAULT NULL, `inches` int(2) DEFAULT NULL, `adultEmail` varchar(255) DEFAULT NULL, `adultFirst` varchar(255) DEFAULT NULL, `adultLast` varchar(255) DEFAULT NULL, `aau` varchar(255) DEFAULT NULL, `grade` varchar(10) DEFAULT NULL, `phoneMobile` varchar(14) DEFAULT NULL, `adultMobile` varchar(14) DEFAULT NULL, `video` varchar(1) DEFAULT NULL, `instagram` varchar(30) DEFAULT NULL, `twitter` varchar(30) DEFAULT NULL, `triple` int(1) DEFAULT NULL, `number` int(3) DEFAULT NULL, `color` varchar(11) DEFAULT NULL, `college` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=193 DEFAULT CHARSET=latin1;
  8. Jim R

    Inner Join help...

    I changed Toggle to Triple. I forgot I had done that. Triple exists now, and the boolean error went away. Nothing is output though on the page. teamName, leagueCoach and teamNumber are old values I don't use anymore. I just haven't deleted the columns as I've duplicated the schema to a new table each year.
  9. Jim R

    Inner Join help...

    I know...I guess I was just focusing on the matching columns. CREATE TABLE `fallLeague2018` ( `id` int(4) NOT NULL AUTO_INCREMENT, `confirm` int(1) DEFAULT NULL, `paid` varchar(10) DEFAULT NULL, `player_coach` varchar(10) DEFAULT NULL, `team` varchar(3) DEFAULT NULL, `nameFirst` varchar(255) DEFAULT NULL, `nameLast` varchar(255) DEFAULT NULL, `adultEmail` varchar(255) DEFAULT NULL, `adultFirst` varchar(255) DEFAULT NULL, `adultLast` varchar(255) DEFAULT NULL, `school` varchar(255) DEFAULT NULL, `feet` int(1) DEFAULT NULL, `inches` int(2) DEFAULT NULL, `aau` varchar(255) DEFAULT NULL, `grade` varchar(10) DEFAULT NULL, `phoneMobile` varchar(14) DEFAULT NULL, `adultMobile` varchar(14) DEFAULT NULL, `video` varchar(1) DEFAULT NULL, `instagram` varchar(30) DEFAULT NULL, `twitter` varchar(30) DEFAULT NULL, `toggle` int(1) DEFAULT NULL, `number` int(3) DEFAULT NULL, `teamName` varchar(255) DEFAULT NULL, `color` varchar(11) DEFAULT NULL, `leagueCoach` varchar(255) DEFAULT NULL, `teamNumber` varchar(255) DEFAULT NULL, `college` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=189 DEFAULT CHARSET=latin1;
  10. Jim R

    Inner Join help...

    `fallLeague2018` ( `id` int(4) NOT NULL AUTO_INCREMENT, `confirm` int(1) DEFAULT NULL, `team` varchar(3) DEFAULT NULL, `nameFirst` varchar(255) DEFAULT NULL, `nameLast` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=188 DEFAULT CHARSET=latin1; `fallLeague_coaches` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `team` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL, `coachFirst` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `coachLast` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  11. Jim R

    Inner Join help...

    Still the same error, but here's the query... $query = 'SELECT * FROM fallLeague2018 as p left join fallLeague_coaches as c ON p.team = c.team WHERE p.confirm="1" and p.team is not null ORDER BY p.team,p.triple,p.number,p.nameLast'; $results = mysql_query($query) //or trigger_error('MySQL error: ' . mysql_error()) ; $currentTeam = ''; $currentCoach = ''; while($line = mysql_fetch_assoc($results)) { if($line['p.team'] != $currentTeam) { $currentTeam = $line['p.team']; $currentCoach = $line['c.team']; echo '<tr><td colspan="6"><hr></td></tr> <tr><td colspan="6"><span class="coach">' . $currentTeam . ' - Coach' . $line['c.coachLast'] . '</td></tr>'; } echo '<tr> <td>' . $line['p.triple'] . $line['p.number']. '</td> <td><b>' . $line['p.nameFirst'] . ' ' . $line['p.nameLast'] . '</b></td> <td><center>'. $line['p.feet'] . '\'' . $line['p.inches'] . '"</center></td> <td><center>'. $line['p.grade'] . '</center></td> <td>'. $line['p.school'] . '</td> <td><b>'. $line['p.college'].'</b></td> </tr>'; } echo '</table></div>'; The error is coming from the WHILE clause.
  12. Jim R

    Inner Join help...

    I'm still getting the same error, but I changed the query. $query = 'SELECT * FROM fallLeague2018 as p inner join fallLeague_coaches as c ON p.team = c.team WHERE p.confirm="1" and p.team is not null ORDER BY p.team,p.triple,p.number,p.nameLast';
  13. Jim R

    Inner Join help...

    (please forgive I haven't switched over mysqli yet) My two data tables: One has 400+ players who are on teams. The other has about 40 coaches who coach these teams. I'm trying output rosters of players who play for a coach, with the coach's name heading each roster. Team Name - Coach LAST NAME Player 1 Player 2 Player 3 etc (except I'm using a table) I haven't assigned teams yet to the players, so I'm anticipating my output will just be a list of coaches, but I'm getting this error... $query = 'SELECT * FROM fallLeague2018 as p inner join fallLeague_coaches as c WHERE p.confirm="1" and p.team is not null and p.team = c.team ORDER BY p.team,p.triple,p.number,p.nameLast'; $results = mysql_query($query) //or trigger_error('MySQL error: ' . mysql_error()) ; $currentTeam = ''; $currentCoach = ''; while($line = mysql_fetch_assoc($results)) { if($line['p.team'] != $currentTeam) { $currentTeam = $line['p.team']; $currentCoach = $line['c.team']; echo '<tr><td colspan="6"><hr></td></tr> <tr><td colspan="6"><span class="coach">' . $currentTeam . ' - Coach' . $line['c.coachLast'] . '</td></tr>'; } echo '<tr> <td>' . $line['p.triple'] . $line['p.number']. '</td> <td><b>' . $line['p.nameFirst'] . ' ' . $line['p.nameLast'] . '</b></td> <td><center>'. $line['p.feet'] . '\'' . $line['p.inches'] . '"</center></td> <td><center>'. $line['p.grade'] . '</center></td> <td>'. $line['p.school'] . '</td> <td><b>'. $line['p.college'].'</b></td> </tr>'; } echo '</table></div>'; Below are snapshots of the tables...
  14. I'm mostly just wondering if anyone here has dealt with it directly. From there, I'd ask if I pass what I need via the URL, could I return it back in the Advanced Return section.
  15. I've read through their documentation, but as you could imagine, it's mostly about passing transaction information from PayPal, most of which I don't need/want, and even the email addresses are only the same as the registration addresses 60% of the time. That's the issue. Since I render just a one time service, I have only truly cared about the confirmation email I get that someone paid. I've manually linked the payment to the registration. I'm just at a point where I'd like it to automatically link it. I posted the question in the PayPal community, but they have poor avenues for community help.
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.