NCAA Division I Football and Basketball Twitter Hashtags and Handles


[insert_php]
include(‘db/slbdbmysqli.php’);

echo ‘




‘;

$sql = “SELECT * from hashtags where 1 order by team asc”;

$result=mysqli_query($dbh2,$sql);

if($result = mysqli_query($dbh2, $sql)){
if(mysqli_num_rows($result) > 0){

echo ‘

Below is a comprehensive list of all NCAA Division 1 Twitter handles and hashtags that are representative of each program. Included are the main athletics department twitter handle as well, as some smaller programs may tweet with more frequently using that handle.

Please note that hashtags are not the preferred program hashtag but rather something that can be used representative of the school as a whole. Since program hashtags may change year to year, I\’ve opted to keep it this ways rather than maintaining with a high frequency.

Have you found something wrong on this page? Then please, let me know!

‘;

while($row = mysqli_fetch_array($result)){

$f2=$row[‘team’];
$f3=$row[‘athletic_dept’];
$f4=$row[‘football_team’];
$f5=$row[‘mbb_team’];
$f6=$row[‘football_hashtag’];
$f7=$row[‘basketball_hashtag’];
$f8=$row[‘school_hashtag’];

$f3=’‘.$f3.’‘;
$f4=’‘.$f4.’‘;
$f5=’‘.$f5.’‘;
$f6 == ” ? $f6 = ”: $f6=’#’.$f6.’‘;
$f7 == ” ? $f7 = ”: $f7=’#’.$f7.’‘;
$f8 == ” ? $f8 = ”: $f8=’#’.$f8.’‘;
echo ‘

‘;
$i++;
}

echo “

School Athletic Dept Football Team Men\’s Basketball Team Football Hashtag Basketball Hashtag Alternate Hashtag
‘; echo $f2; echo ‘ ‘; echo $f3; echo ‘ ‘; echo $f4; echo ‘ ‘; echo $f5; echo ‘ ‘; echo $f6; echo ‘ ‘; echo $f7; echo ‘ ‘; echo $f8; echo ‘

“;
// Close result set
mysqli_free_result($result);
} else{
echo “No records matching your query were found.”;
}
} else{
echo “ERROR: Could not execute $sql. ” . mysqli_error($link);
}

[/insert_php]