0){ echo '
'; } else {echo'
';} echo '


'.$board_mfg.' '.$board_who.' '.$board_type.' - MSRP $'.$board_price.'

'; echo '

'.$board_html; if ($board_stat1 != '0') echo '
'; echo'


'; } else { $browser = strtolower($_SERVER['HTTP_USER_AGENT']); if (substr_count($browser, 'iphone') > 0){ echo '
'; } else {echo'
';} echo ''; echo '
'; $query = 'SELECT * from boards where 1=1'; if (isset($_GET['mfg'])){ if ($_GET['mfg'] == '1') $query .= ' and mfg = \'Ronix\''; elseif ($_GET['mfg'] == '2') $query .= ' and mfg = \'Hyperlite\''; elseif ($_GET['mfg'] == '3') $query .= ' and mfg = \'Liquid Force\''; } if (isset($_GET['for'])){ if ($_GET['for'] == '1') $query .= ' and made4 = \'Women\\\'s\''; elseif ($_GET['for'] == '2') $query .= ' and made4 = \'Men\\\'s\''; elseif ($_GET['for'] == '3') $query .= ' and made4 = \'Kids\''; } if (isset($_GET['msrp'])){ if ($_GET['msrp'] == '1') $query .= ' and msrp <= 300'; elseif ($_GET['msrp'] == '2') $query .= ' and msrp > 300 and msrp <= 400'; elseif ($_GET['msrp'] == '3') $query .= ' and msrp > 400'; } $dbh=mysql_connect ('localhost', 'wakeg0_gear1', 'p00kie1') or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ('wakeg0_gear1'); $result = mysql_query($query); $i = 0; $selection = array(); while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $selection[$i] = array(); $selection[$i]['id'] = $row[0]; $selection[$i]['name'] = $row[1]; $selection[$i]['type'] = $row[2]; $selection[$i]['mfg'] = $row[3]; $selection[$i]['msrp'] = $row[4]; $selection[$i]['made4'] = $row[5]; $i++; } mysql_free_result($result); mysql_close($dbh); if (count($selection) == 0) echo ''; else{ shuffle($selection); $counter = 0; echo '
'; $this_many = count($selection); for ($i2 = 0; $i2 < $this_many; $i2++){ echo ''; if ($counter == 4){ echo ''; $counter = 0; } else $counter++; } echo '

'.$selection[$i2]['mfg'].' '.$selection[$i2]['name'].'
'.$selection[$i2]['made4'].' '.$selection[$i2]['type'].'
MSRP $'.$selection[$i2]['msrp'].'
'; } } ?>




'; ?>