Pfthb

I'm building a fantasy baseball website in python/flask, using Bulma for the css. I'm fairly new to flask development. MySql is the backend database. The page that I'm building is to show draft results. I'm done with the exception of this little pesky problem. I've done lots of searching, but haven't found my specific answer, so asking for a little help...

The page displays a table of draft results. Each row will contain either a major league baseball player or a minor league player, but not both. In other words, one of the last 2 columns should be blank, one should have a player name with a link to his mlb/milb page. What I'm getting is this:

What I want is for the "None" values to be blank. Here is my relevant code:

app.py

 @app.route('/draft_results_prior/<string:yr>/')
def draft_results_prior(yr)
 try:
 conn = mysql.connect()
 cursor = conn.cursor(pymysql.cursors.DictCursor)
 cursor.execute("SELECT dr.draft_round, dr.pick_no, (SELECT af.city FROM act_franchise as af WHERE af.team_id = dr.original_team_id) orig_team, (SELECT af2.city FROM act_franchise as af2 WHERE af2.team_id = dr.traded_team_id) trade_team, dr.mlb_id, CONCAT('http://m.mlb.com/player/',dr.mlb_id) as Link, (SELECT concat(mlbr.name_first,' ', mlbr.name_last) FROM mlb_rosters as mlbr WHERE mlbr.mlb_id = dr.mlb_id) mlb_name, dr.milb_id, CONCAT('http://www.milb.com/player/index.jsp?sid=milb&player_id=',dr.milb_id) as milb_Link, (SELECT concat(milbr.name_first,' ', milbr.name_last) FROM milb_players as milbr WHERE milbr.milb_id = dr.milb_id) milb_name, dr.intl_id FROM draft_results as dr WHERE dr.ibc_year = %s",(yr))
 thisDraft = cursor.fetchall()`

 return render_template('draft_results_prior.html', thisDraft=thisDraft, yr=yr)
 except Exception as e:
 print(e)
 finally:
 cursor.close() 
 conn.close()
 return render_template('draft_results_prior.html', thisDraft=thisDraft)

In draft_results_prior.html, I have this table:

<table class="table table-bordered is-fullwidth is-striped is-hoverable">
 <thead>
 <tr>
 <th class= "yellowones">Round #</th>
 <th class= "yellowones">Pick #</th>
 <th class= "yellowones">Team</th>
 <th class= "yellowones">Traded To</th>
 <th class= "yellowones">MLB Pick</th>
 <th class= "yellowones">MiLB Pick</th>
 </tr>
 </thead>
 % for dr in thisDraft %
 <tbody>
 <td class= "greenones has-text-left">dr.draft_round</td>
 <td class= "greenones has-text-left">dr.pick_no</td>
 <td class= "greenones has-text-left">dr.orig_team</td>
 <td class= "greenones has-text-left">dr.trade_team</td>
 <td class= "greenones has-text-left"><a href="dr.Link">dr.mlb_name</a></td>
 <td class= "greenones has-text-left"><a href="dr.milb_Link">dr.milb_name</a></td>
 </tbody>
 % endfor %
 </table>

I feel like I need some sort of "if" loop around the last 2 columns to check if the value is null, but I'm unsure of the syntax. Any pointers would be really appreciated!

EDITED BASED ON kungpho's answer below:

If I do this:

<td class= "greenones has-text-left"><a href="dr.Link">dr.mlb_name</a></td>
% if dr.milb_name %
<td class= "greenones has-text-left"><a href="dr.milb_Link">dr.milb_name</a></td>
% else %
&nbsp;
% endif %

I get this:

That is exactly what I want for the MiLB Pick column. So I tried to do the same to the MLB column, but it combined both columns into one:

% if dr.mlb_name %
<td class= "greenones has-text-left"><a href="dr.Link">dr.mlb_name</a></td>
% else %
&nbsp;
% endif %
% if dr.milb_name %
<td class= "greenones has-text-left"><a href="dr.milb_Link">dr.milb_name</a></td>
% else %
&nbsp;
% endif %

This is what it did:

How can I keep both columns?

EDIT #2- CORRECT answer

Here's the correct answer:

% if dr.mlb_name %
<td class= "greenones has-text-left"><a href="dr.Link">dr.mlb_name</a></td>
% else %
<td class= "greenones has-text-left"><a href=""></a></td>
% endif %
% if dr.milb_name %
<td class= "greenones has-text-left"><a href="dr.milb_Link">dr.milb_name</a></td>
% else %
<td class= "greenones has-text-left"><a href=""></a></td>
% endif %

Yields:

Woohoo!

In your case, yes, it looks like a simple if should do the trick. You'll still want to render the column itself, just not the contents, so your HTML stays valid (browsers will often tolerate it if you don't, but it's still better to keep it as clean as possible).

Example:

<td class="greenones has-text-left">
 % if dr.milb_Link %
 <a href=" dr.milb_Link "> dr.milb_name </a>
 % else %
 &nbsp;
 % endif %
</td>

If you were just displaying a value and not an HTML element, Jinja2 has a built-in default filter (true here applies it to falsey values, not just undefined variables):

default(' ', true)