kemper

Seeing as how often you are on here and how knowledgable you are, I will wait patiently for how fast of an assisting response I get from you or anyone else. I'm sure you are constantly observing all topics and "sub-topics", providing HELP to many.

I am assuming that someone is writing his thesis on this topic. It sure is taking some time for the response. I sure am glad I am upwind in this pissing match. We all know what happens when one is downwind. Or, maybe some people don't know. Take notes!

That's third party, your topic will be moved and forgotten. Sorry, but this site is not for help anymore!

Leave it??? Well, that is exactly what will happen with all your bs moving of topics. Not enough attention is put on those "Sub Categories". They will all be left alone.

Thorpe... That's just a crap answer. That is just a way to avoid some noobies, like myself. If I wrote it or if someone else wrote the code, the PHP Help question is still a PHP Help question because that third Party code is being modified. If the code worked exactly as one wanted it, they would not need PHP Help!

peranha... Are there sub-categories of those different languages??? NO! It's all PHP, just like all OOP goes into OPP board and Java goes into Java. PHP should go into PHP! Thanks for not clarifying a valid answer.

And, what is the point of this category when every new topic can be categorized and moved? After all is said and done, those member topics are asking for HELP!!!

As I quickly browse the new "organization" based categories, most are seldom read (much less answered). This category is what made this website popular and productive. Obviously, that is going to change.

Why have a PHP Help Topic when someone is going to move threads to more more specific thread that is not frequented and ignored??? Those threads are PHP Help questions! Seems a bit counter-productive!

The modified code echos the first teamname with in that specific division as defined by ORDER BY divorder ASC, teamname ASC I need it to echo the team that is assigned to that field. Assistance is appreciated.

The original was a dropdown menu, but the Select was a predetermined teamid. I want to eliminate the risk of changing the team when entering the scores. The Select team is what should be echoing. Thanks!

It is echoing just one team for any game like: Game 1: Team 3 vs. Team 4 (echoing Team 1) Game 2: Team 8 vs. Team 5 (echoing Team 1) It is echoing one team, but the incorrect and same team name in each game.

just the one.

No help I guess. Thanks anyways!

I have a script that I only want to echo: team name (the team that is already assigned). It currently is a dropdown menu with a list teams with a specific division. <tr><td class='tbl1'>Away: <select name="loser"> <?php $query3="SELECT sportsdb_teams.teamid, sportsdb_teams.teamname, sportsdb_divs.divname FROM sportsdb_teams, sportsdb_divs WHERE sportsdb_teams.active=1 AND sportsdb_teams.teamdiv = sportsdb_divs.divid AND sportsdb_divs.conference = $confid ORDER BY divorder ASC, teamname ASC"; $result3=mysql_query($query3); while ($teams = mysql_fetch_array($result3, MYSQL_ASSOC)) { echo "<option value=\"{$teams['teamid']}\""; if ($teams['teamid'] == $score['loser']) { print " selected=\"selected\""; } print ">{$teams['teamname']}</option>\n"; } print "</select></td><td bgcolor='#FFFF00'>Score: <input type=\"text\" name=\"ra\" size=\"2\" maxlength=\"2\" value=\"{$score['ra']}\" /></td></tr>\n"; ?> Assistance is greatly appreciated.

Bueller?!

That field is not blank. It appears when I code it as <tr><td>".$data['dates']." -</td><td>".$data['fields']."</td></tr> So must be my query. How can I remedy?

I guess I assumed that since it was part of the WHERE in the query, it was ok. $queryscores="SELECT sportsdb_wins.winid, sportsdb_wins.windate, sportsdb_wins.wintime, sportsdb_wins.game_date, sportsdb_wins.game_time, sportsdb_wins.rf, sportsdb_wins.ra, sportsdb_wins.wincomments, sportsdb_wins.field, sportsdb_wins.winortie, sportsdb_teams2.teamname AS winningteam, sportsdb_teams.teamname AS losingteam FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams, sportsdb_divs WHERE sportsdb_teams.teamdiv = sportsdb_divs.divid AND sportsdb_divs.conference = $confid AND sportsdb_teams2.teamid = sportsdb_wins.winner AND sportsdb_teams.teamid = sportsdb_wins.loser AND sportsdb_wins.winortie != 3"; How do I fix?

For some reason, it must not be recognizing the confid. For all confid, it displays blank cells for rf and ra.

See originating post. 'dates' field contains the specific weekend that it applies to.

The only echo result is the header row of the table and that is for all confid. Basically, I get: Date Home Team Score Visiting Team Score Field No result rows at all.

No go. That took away the <td> on all confid and skewed the whole table.

echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'> <tr> <td bgcolor='#FFFF00'> <p align='center'><font color='#FF0000'><b>".$locale['fs005']."</b></font> <table border='0' width='100%' id='table1'> </tr><tr><td align='center'><b>".$data['dates']."</b></td></tr>\n"; while ($data = dbarray($sql)) { $i % 2 == 0 ? $tclass="tbl1" : $tclass="tbl2"; if ($data['dates'] != $prev) { // if changed echo "<tr><td colspan='3'><hr></td></tr>\n"; // blank row $prev = $data['dates']; } echo "<tr> <td valign='top'> <font color='#0000FF' size='1'>* ".$data['closures']."</font></td> </tr>\n"; } echo "</table> <p align='center'><font color='#FF0000'>".$locale['fs006']."</font></td></tr> </table>\n"; } else { echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'> <tr> <td bgcolor='#FFFF00'><center><br>\n".$locale['fs007']."<br><br></td></tr></table>\n</center>\n"; Code not displaying ".$data['dates'].".

Well, I have tried to Tried to change the makeup of the <table> and Date was not displaying.

With the great weather we have had this year so far, I have a list of closed fields that is displayed as: Date 1 - Field Date 1 - Another Field Date 1 - Yet Another Field ----------------------- Date 2 - Field Date 2 - Another Field Date 2 - Yet Another Field I would like it to display as: Date 1 - Field Another Field Yet Another Field ----------------------- Date 2 - Field Another Field Yet Another Field echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'> <tr> <td bgcolor='#FFFF00'> <p align='center'><font color='#FF0000'><b>".$locale['fs005']."</b></font> <table border='0' width='100%' id='table1'> </tr>\n"; while ($data = dbarray($sql)) { $i % 2 == 0 ? $tclass="tbl1" : $tclass="tbl2"; if ($data['dates'] != $prev) { // if changed echo "<tr><td colspan='3'><hr></td></tr>\n"; // blank row $prev = $data['dates']; } echo "<tr> <td nowrap valign='top'> <font color='#0000FF' size='1'>".$data['dates']." -</td><td>".$data['fields']."</font></td> </tr>\n"; } echo "</table> <p align='center'><font color='#FF0000'>".$locale['fs006']."</font></td></tr> </table>\n"; How do I alter?