nucleardoctor

Do you know how I would define it or what I would define it as... I never messed with trying to check if an AIM is online or not.

And my blast code works fine. When you put your mouse over blast, it displays the small popup tooltip with the text in it.

This is my full code: <? include("./config.php"); if($ladder[id]){ $thisladder=mysql_query("SELECT * FROM ladders WHERE id='$ladder[id]'"); $thisladder=mysql_fetch_array($thisladder); } if($thisladder[id]){ show_standings($ladder,$thisladder); }else{ list_ladders(); } function list_ladders(){ global $config; $out[body].=" <center> <br> <table width='451' border='0' cellspacing='1' cellpadding='1' bgcolor='000000'> <tr background='$config[titlebar]'> <td width='100%' colspan='3' align='left' valign='center' background='$config[titlebar]'><font color='ffffff' size='-2'><center><b>PlayStation Portable</b></font></center></td></tr> <tr bgcolor='#000000'>"; $ladders=mysql_query("SELECT id,name,console,active FROM ladders WHERE console='1' and active < 2 ORDER BY name"); while(list($id,$name,$console,$active)=mysql_fetch_row($ladders)){ if($console == 1){ $c_img="<img src='./ladder_images/console_icons/psp.gif'>"; }else{ $c_img=""; } $out[body].=" <center> <tr bgcolor='$config[altcolorb]' border='1'> <td bgcolor='$config[altcolorb]' align='center' width='5%'> $c_img</td> <td bgcolor='$config[altcolorb]' align='left'>"; if($active==0) { $out[body].="<font size='-2'>$name</font></td>"; } else { $out[body].="<a href='$config[scripturl]/standings.php?ladder[id]=$id'><font size='-2'>$name</font></a></td>"; } $out[body].=" <td bgcolor='$config[altcolorb]' align='center' width='5%'>"; if($active==1) { $out[body].='<img src=./ladder_images/ladder_icons/green.gif width=13 height=13>'; } else { $out[body].='<img src=./ladder_images/ladder_icons/red.gif width=13 height=13>'; } $out[body].="</td></tr>\n"; } $out[body].="</table><br> <table width='451' border='0' cellspacing='1' cellpadding='1' bgcolor='000000'> <tr background='$config[titlebar]'> <td width='100%' colspan='3' align='left' valign='center' background='$config[titlebar]'><font color='ffffff' size='-2'><center><b>PlayStation 2</b></font></center></td></tr> <tr bgcolor='#000000'>"; $ladders=mysql_query("SELECT id,name,console,active FROM ladders WHERE console='2' and active < 2 ORDER BY name"); while(list($id,$name,$console,$active)=mysql_fetch_row($ladders)){ if($console == 2){ $c_img="<img src='./ladder_images/console_icons/ps2.gif'>"; }else{ $c_img=""; } $out[body].=" <tr bgcolor='$config[altcolorb]' border='1'> <td bgcolor='$config[altcolorb]' align='center' width='5%'> $c_img</td> <td bgcolorb='$config[altcolorb]' align='left'>"; if($active==0) { $out[body].="<font size='-2'>$name</font></td>"; } else { $out[body].="<a href='$config[scripturl]/standings.php?ladder[id]=$id'><font size='-2'>$name</font></a></td>"; } $out[body].=" <td bgcolor='$config[altcolorb]' align='center' width='5%'>"; if($active==1) { $out[body].='<img src=./ladder_images/ladder_icons/green.gif width=13 height=13>'; } else { $out[body].='<img src=./ladder_images/ladder_icons/red.gif width=13 height=13>'; } $out[body].="</td></tr>\n"; } $out[body].="</table><br> <table width='451' border='0' cellspacing='1' cellpadding='1' bgcolor='000000'> <tr background='$config[titlebar]'> <td width='100%' colspan='3' align='left' valign='center' background='$config[titlebar]'><font color='ffffff' size='-2'><center><b>PlayStation 3</b></font></center></td></tr> <tr bgcolor='#000000'>"; $ladders=mysql_query("SELECT id,name,console,active FROM ladders WHERE console='3' and active < 2 ORDER BY name"); while(list($id,$name,$console,$active)=mysql_fetch_row($ladders)){ if($console == 3){ $c_img="<img src='./ladder_images/console_icons/ps3.gif'>"; }else{ $c_img=""; } $out[body].=" <tr bgcolor='$config[altcolorb]' border='1'> <td bgcolor='$config[altcolorb]' align='center' width='5%'> $c_img</td> <td bgcolor='$config[altcolorb]' align='left'>"; if($active==0) { $out[body].="<font size='-2'>$name</font></td>"; } else { $out[body].="<a href='$config[scripturl]/standings.php?ladder[id]=$id'><font size='-2'>$name</font></a></td>"; } $out[body].=" <td bgcolor='$config[altcolorb]' align='center' width='5%'>"; if($active==1) { $out[body].='<img src=./ladder_images/ladder_icons/green.gif width=13 height=13>'; } else { $out[body].='<img src=./ladder_images/ladder_icons/red.gif width=13 height=13>'; } $out[body].="</td></tr>\n"; } $out[body].="</table><br> <table width='451' border='0' cellspacing='1' cellpadding='1' bgcolor='000000'> <tr background='$config[titlebar]'> <td width='100%' colspan='3' align='left' valign='center' background='$config[titlebar]'><font color='ffffff' size='-2'><center><b>XBOX</b></font></center></td></tr> <tr bgcolor='#000000'>"; $ladders=mysql_query("SELECT id,name,console,active FROM ladders WHERE console='4' and active < 2 ORDER BY name"); while(list($id,$name,$console,$active)=mysql_fetch_row($ladders)){ if($console == 4){ $c_img="<img src='./ladder_images/console_icons/xbox.gif'>"; }else{ $c_img=""; } $out[body].=" <tr bgcolor='$config[altcolorb]' border='1'> <td bgcolor='$config[altcolorb]' align='center' width='5%'> $c_img</td> <td bgcolor='$config[altcolorb]' align='left'>"; if($active==0) { $out[body].="<font size='-2'>$name</font></td>"; } else { $out[body].="<a href='$config[scripturl]/standings.php?ladder[id]=$id'><font size='-2'>$name</font></a></td>"; } $out[body].=" <td bgcolor='$config[altcolorb]' align='center' width='5%'>"; if($active==1) { $out[body].='<img src=./ladder_images/ladder_icons/green.gif width=13 height=13>'; } else { $out[body].='<img src=./ladder_images/ladder_icons/red.gif width=13 height=13>'; } $out[body].="</td></tr>\n"; } $out[body].="</table><br> <table width='451' border='0' cellspacing='1' cellpadding='1' bgcolor='000000'> <tr background='$config[titlebar]'> <td width='100%' colspan='3' align='left' valign='center' background='$config[titlebar]'><font color='ffffff' size='-2'><center><b>XBOX 360</b></font></center></td></tr> <tr bgcolor='#000000'>"; $ladders=mysql_query("SELECT id,name,console,active FROM ladders WHERE console='5' and active < 2 ORDER BY name"); while(list($id,$name,$console,$active)=mysql_fetch_row($ladders)){ if($console == 5){ $c_img="<img src='./ladder_images/console_icons/x360.gif'>"; }else{ $c_img=""; } $out[body].=" <tr bgcolor='$config[altcolorb]' border='1'> <td bgcolor='$config[altcolorb]' align='center' width='5%'> $c_img</td> <td bgcolor='$config[altcolorb]' align='left'>"; if($active==0) { $out[body].="<font size='-2'>$name</font></td>"; } else { $out[body].="<a href='$config[scripturl]/standings.php?ladder[id]=$id'><font size='-2'>$name</font></a></td>"; } $out[body].=" <td bgcolor='$config[altcolorb]' align='center' width='5%'>"; if($active==1) { $out[body].='<img src=./ladder_images/ladder_icons/green.gif width=13 height=13>'; } else { $out[body].='<img src=./ladder_images/ladder_icons/red.gif width=13 height=13>'; } $out[body].="</td></tr>\n"; } $out[body].="</table><br> <table width='451' border='0' cellspacing='1' cellpadding='1' bgcolor='000000'> <tr background='$config[titlebar]'> <td width='100%' colspan='3' align='left' valign='center' background='$config[titlebar]'><font color='ffffff' size='-2'><center><b>Computer</b></font></center></td></tr> <tr bgcolor='#000000'>"; $ladders=mysql_query("SELECT id,name,console,active FROM ladders WHERE console='6' and active < 2 ORDER BY name"); while(list($id,$name,$console,$active)=mysql_fetch_row($ladders)){ if($console == 6){ $c_img="<img src='./ladder_images/console_icons/pc.gif'>"; }else{ $c_img=""; } $out[body].=" <tr bgcolor='$config[altcolorb]' border='1'> <td bgcolor='$config[altcolorb]' align='center' width='5%'> $c_img</td> <td bgcolor='$config[altcolorb]' align='left'>"; if($active==0) { $out[body].="<font size='-1'>$name</font></td>"; } else { $out[body].="<a href='$config[scripturl]/standings.php?ladder[id]=$id'><font size='-1'>$name</font></a></td>"; } $out[body].=" <td bgcolor='$config[altcolorb]' align='center' width='5%'>"; if($active==1) { $out[body].='<img src=./ladder_images/ladder_icons/green.gif width=13 height=13>'; } else { $out[body].='<img src=./ladder_images/ladder_icons/red.gif width=13 height=13>'; } $out[body].="</td></tr>\n"; } $out[body].="</table><br> <table width='451' border='0' cellspacing='1' cellpadding='1' bgcolor='000000'> <tr background='$config[titlebar]'> <td width='100%' colspan='3' align='left' valign='center' background='$config[titlebar]'><font color='ffffff' size='-2'><center><b>Wii</b></font></center></td></tr> <tr bgcolor='#000000'>"; $ladders=mysql_query("SELECT id,name,console,active FROM ladders WHERE console='7' and active < 2 ORDER BY name"); while(list($id,$name,$console,$active)=mysql_fetch_row($ladders)){ if($console == 7){ $c_img="<img src='./ladder_images/console_icons/wii.gif'>"; }else{ $c_img=""; } $out[body].=" <tr bgcolor='$config[altcolorb]' border='1'> <td bgcolor='$config[altcolorb]' align='center' width='5%'> $c_img</td> <td bgcolor='$config[altcolorb]' align='left'>"; if($active==0) { $out[body].="<font size='-2'>$name</font></td>"; } else { $out[body].="<a href='$config[scripturl]/standings.php?ladder[id]=$id'><font size='-2'>$name</font></a></td>"; } $out[body].=" <td bgcolor='$config[altcolorb]' align='center' width='5%'>"; if($active==1) { $out[body].='<img src=./ladder_images/ladder_icons/green.gif width=13 height=13>'; } else { $out[body].='<img src=images/red.gif width=13 height=13>'; } $out[body].="</td></tr>\n"; } $out[body].="</table><br>"; include("$config[html]"); } function show_standings($ladder,$thisladder){ global $config; if(!$ladder[rank]){ $ladder[rank]="1"; } $ladder[rank]=($ladder[rank] - 1); $rcount="$ladder[rank]"; if($thisladder[isteam]){ $teamsword="Teams"; }else{ $teamsword="Players"; } if($ladder[unranked]){ $whereranked="WHERE rank < 1"; $rankswitch="Showing Unranked $teamsword :: <a href='$config[scripturl]/standings.php?ladder[id]=$ladder[id]&ladder[unranked]=0'><font face='verdana' size='1'>[Ranked]</a>"; }else{ $whereranked="WHERE rank > 0"; $rankswitch="Showing Ranked $teamsword :: <a href='$config[scripturl]/standings.php?ladder[id]=$ladder[id]&ladder[unranked]=1'><font face='verdana' size='1'>[unranked]</a>"; } $out[body].="<center><form><table width='90%' height='10' border='0' cellspacing='0' cellpadding='0'><tr><td width='25%'></td><td align='right'><b><font class='drop' size='-1'>Ladder: </font></td><td align='right' width='5'><b><select class='combobox' name='SiteMap' onchange='if(options[selectedIndex].value){location = options[selectedIndex].value}'>"; $ladders=mysql_query("SELECT id,name FROM ladders where active < 2 ORDER BY id"); while(list($id,$name)=mysql_fetch_row($ladders)){ if($ladder[id] == $id){ $id2="$id' SELECTED"; } else{ $id2="$id'"; } $out[body].="<option value='$config[scripturl]/standings.php?ladder[id]=$id2>$name</option>\n"; } $out[body].="</select></td></tr></table><br>"; $out[body].=" <center> <table width='451' border='0' cellspacing='1' cellpadding='1' bgcolor='000000'> <tr background='$config[titlebar]'> <td width='5%' valign='center' align='center' background='$config[bg5]' colspan='10'><b><font size='-2' color='ffffff'>$thisladder[name] Ladder</b></td> <tr bgcolor='$config[altcolora]'> <td width='9%' valign='center' align='center' title='Rank' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'>Rank</b></td> <td width='5%' valign='center' align='center' title='King' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'></b></td> <td width='23%' valign='center' align='center' title='Name' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'>Name</b></td> <td width='11%' valign='center' align='center' title='Number of Wins' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'>Wins</b></td> <td width='11%' valign='center' align='center' title='Number of Loss' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'>Loss</b></td> <td width='11%' valign='center' align='center' title='Streak' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'>Streak</b></td> <td width='6%' valign='center' align='center' title='XP' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'>XP</b></td> <td width='7%' valign='center' align='center' title='Level' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'>Level</b></td> <td width='11%' valign='center' align='center' title='Strikes' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'>Strikes</b></td> <td width='6%' valign='center' align='center' title='AIM' bgcolor='$config[altcolora]'><b><font size='-2' color='#ffffff'>AIM</b></td> </tr>"; $standings=mysql_query("SELECT s.`tid`,s.`rank`,s.`wins`,s.`loss`,s.`streak`,s.`points`,s.`king`,s.`level`,t.`name`,t.`id`,t.`aim`,t.`aim2`,t.`aim3`,t.`aim4` FROM `stats` as `s`,`teams` as `t` $whereranked and t.id=s.tid ORDER BY points DESC LIMIT $ladder[rank],$config[showranks]") or die(mysql_error()); while(list($tid,$rank,$wins,$loss,$streak,$points,$king,$level,$name,$id,$aim,$aim2,$aim3,$aim4)=mysql_fetch_row($standings)){ include("./level.php"); if ($king == "NULL") { $king = ""; }else{ $king = "<A HREF='javascript: void King($ladder[id])'><img src='./ladder_images/ladder_icons/king.gif' border='0'></A>"; } $war=mysql_query("SELECT * FROM warring WHERE id='$tid'") or die(mysql_error()); $war=mysql_fetch_array($war); if ($warring[war] == '1'){ $msg = "<strong style=\'color:black;\'>This clan is looking for a war! Contact the leader, via AIM, for details.</strong><br>"; } //$war = "<img src='./ladder_images/ladder_icons/war.gif' border='0' onmouseover=\"return overlib('$msg', CAPTION, '<span style=\'color:blue;\'>We\'re looking for a War!</span>');\" onmouseout=\"return nd();\" />$spacer"; $team=mysql_query("SELECT * FROM teams WHERE id='$tid'") or die(mysql_error()); $team=mysql_fetch_array($team); if ($team[blast]){ $blast = addslashes($team[blast]); $message = "<img src='./ladder_images/ladder_icons/blast.gif' border='0' onmouseover=\"return overlib('$blast');\" onmouseout=\"return nd();\">"; }else{ $message = ""; } if ($team[aim]) { $aim = new checkAIM($team[aim]); if ($aim->isOnline()){ $leadimg = "<img src=\'./ladder_images/ladder_icons/aim_online.gif' border=\'0\' align=\'absmiddle\' />"; $leadon = true; }else{ $leadon = false; $leadimg = "<img src=\'./ladder_images/ladder_icons/aim_online.gif' border=\'0\' align=\'absmiddle\' />"; } } if ($team[aim3]) { $coaim = new checkAIM($team[aim3]); if ($coaim->isOnline()){ $coleadimg = "<img src=\'./ladder_images/ladder_icons/aim_online.gif' border=\'0\' align=\'absmiddle\' />"; $coleadon = true; }else{ $coleadon = false; $coleadimg = "<img src=\'./ladder_images/ladder_icons/aim_offline.gif' border=\'0\' align=\'absmiddle\' />"; } } if ($leadon OR $coleadon){ $image = "<img src='./ladder_images/ladder_icons/aim_online.gif' border='0' align='absmiddle' />"; }else{ $image = "<img src='./ladder_images/ladder_icons/aim_offline.gif' border='0' align='absmiddle' />"; } if (!$team[aim] AND !$team[aim3]){ $image = "N/A"; }elseif ($team[aim]){ $leader = "<a href=\'aim:goim?screenname=$team[aim]&message=Hello, would you like a war?\'>$leadimg</a> ($team[aim2])"; }else{ $leader = "None Specified"; } if ($team[aim3]){ $coleader = "<br /><strong>Co-Leader:</strong> <a href=\'aim:goim?screenname=$team[aim3]&message=Hello, would you like a war?\'>$coleadimg</a> ($team[aim3])"; }else{ $coleader = "<br /><strong>Co-Leader:</strong> None Specified"; } //$aim_sn = "<a href='javascript:void(0);' onClick=\"fixedtooltip('<table><tr><td bgcolor=\'#000000\'><div align=\'right\' style=\'float:right\'><a href=\'javascript: void\' onclick=\'delayhidetip()\' style=\'font-weight:bold;color:red;\'>[X]</a></div></td></tr></table><br /> <strong>Leader:</strong> $leader $coleader<br /><br />', this, event, '250px')\">$image</a>"; $aim_sn = "<a href='javascript:void(0);' onClick=\"return overlib('<strong>Leader:</strong> $leader $coleader<br><br>', CAPTION, 'AOL Instant Messenger Contact Details', STICKY)\"\">$image</a>"; if($config[altcolorx]==$config[altcolora]){ $config[altcolorx]="$config[altcolorb]"; }else{ $config[altcolorx]="$config[altcolora]"; } $matches=mysql_query("select (TO_DAYS(now()) - TO_DAYS(max(reported))) as 'numdays' from matchdb WHERE wid='$teamid' or lid='$teamid' group by ladderid"); $matches=mysql_fetch_array($matches); $rcount++; include("./strikes_main.php"); $out[body].=" <tr bgcolor='$config[altcolorb]'> <td width='9%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$rcount</b></td> <td width='5%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$king</b></td> <td width='23%' valign='center' align='left' bgcolor='$config[altcolorb]'><font size='-2'><div align='right' style='float:right'>$message</div><div align='right' style='float:right;'>$war</div><a href='$config[scripturl]/stats.php?account=$tid' title='$name has played $games games with an average of $percent% with $wins Wins and $loss Losses'> <b>$name</a></b></a></td> <td width='11%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$wins</b></td> <td width='11%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$loss</b></td> <td width='11%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$streak</b></td> <td width='6%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$points</b></td> <td width='7%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$level</b></td> <td width='11%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$strike1 | $strike2 | $strike3</b></td> <td width='6%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$aim_sn</b></td>"; } $selectedteams=mysql_query("SELECT COUNT(*) FROM stats $whereranked and lid=$ladder[id]"); $selectedteams=mysql_fetch_array($selectedteams); $selectedteams="$selectedteams[0]"; $totalteams=mysql_query("SELECT COUNT(*) FROM stats WHERE lid=$ladder[id]"); $totalteams=mysql_fetch_array($totalteams); $totalteams="$totalteams[0]"; $pagenow=($ladder[rank] + 1); if($pagenow==1){ $skipranks.="[<a href='$config[scripturl]/standings.php?ladder[id]=$ladder[id]&ladder[rank]=1&ladder[unranked]=$ladder[unranked]'>1-$config[showranks]</a>] "; }else{ $skipranks.="<a href='$config[scripturl]/standings.php?ladder[id]=$ladder[id]&ladder[rank]=1&ladder[unranked]=$ladder[unranked]'>1-$config[showranks]</a> "; } $arank=1; $brank=$config[showranks]; while($brank < $selectedteams){ $arank=($arank + $config[showranks]); $brank=($brank + $config[showranks]); if($pagenow==$arank){ $skipranks.="[<a href='$config[scripturl]/standings.php?ladder[id]=$ladder[id]&ladder[rank]=$arank&ladder[unranked]=$ladder[unranked]'>$arank-$brank</a>] "; }else{ $skipranks.="<a href='$config[scripturl]/standings.php?ladder[id]=$ladder[id]&ladder[rank]=$arank&ladder[unranked]=$ladder[unranked]'>$arank-$brank</a> "; } } $ladder[rank]=($ladder[rank] + 1); $backrank=($ladder[rank] - $config[showranks]); $forwrank=($ladder[rank] + $config[showranks]); if($ladder[rank] > $config[showranks]){ $backwards="<a href='$config[scripturl]/standings.php?ladder[id]=$ladder[id]&ladder[rank]=$backrank&ladder[unranked]=$ladder[unranked]'><<<</a>"; }else{ $backwards="<<<"; } if($forwrank < $selectedteams){ $forwards="<a href='$config[scripturl]/standings.php?ladder[id]=$ladder[id]&ladder[rank]=$forwrank&ladder[unranked]=$ladder[unranked]'>>>></a>"; }else{ $forwards=">>>"; } $out[body].=" <tr> <td width='100%' background='$config[bg4]' valign='center' align='center' colspan='10'><b><font face='verdana' size='0' font color='ffffff'>$backwards :: $totalteams Total $teamsword :: $rankswitch :: $forwards<br> $skipranks</b></td> </tr> </table> <br> </center>"; include("$config[html]"); } ?>

No errors show up. You're suppose to be able to put you click the $image which is the AIM icon, but when you click on it, nothing happens. And its suppose to check to see if the AIM Screen Name is online or offline, but when I go to the file, it always shows the screen name as offline.

I am trying to get my code to check if a user is online, and if they are online to display a java tooltip that pops up when you click on the aim icon. I tryed messing around with the code but I can't seem to get it to work. $team=mysql_query("SELECT * FROM teams WHERE id='$tid'") or die(mysql_error()); $team=mysql_fetch_array($team); if ($team[blast]){ $blast = addslashes($team[blast]); $message = "<img src='./ladder_images/ladder_icons/blast.gif' border='0' onmouseover=\"return overlib('$blast');\" onmouseout=\"return nd();\">"; }else{ $message = ""; } if ($team[aim]) { $aim = new checkAIM($team[aim]); if ($aim->isOnline()){ $leadimg = "<img src=\'./ladder_images/ladder_icons/aim_online.gif' border=\'0\' align=\'absmiddle\' />"; $leadon = true; }else{ $leadon = false; $leadimg = "<img src=\'./ladder_images/ladder_icons/aim_online.gif' border=\'0\' align=\'absmiddle\' />"; } } if ($team[aim3]) { $coaim = new checkAIM($team[aim3]); if ($coaim->isOnline()){ $coleadimg = "<img src=\'./ladder_images/ladder_icons/aim_online.gif' border=\'0\' align=\'absmiddle\' />"; $coleadon = true; }else{ $coleadon = false; $coleadimg = "<img src=\'./ladder_images/ladder_icons/aim_offline.gif' border=\'0\' align=\'absmiddle\' />"; } } if ($leadon OR $coleadon){ $image = "<img src='./ladder_images/ladder_icons/aim_online.gif' border='0' align='absmiddle' />"; }else{ $image = "<img src='./ladder_images/ladder_icons/aim_offline.gif' border='0' align='absmiddle' />"; } if (!$team[aim] AND !$team[aim3]){ $image = "N/A"; }elseif ($team[aim]){ $leader = "<a href=\'aim:goim?screenname=$team[aim]&message=Hello, would you like a war?\'>$leadimg</a> ($team[aim2])"; }else{ $leader = "None Specified"; } if ($team[aim3]){ $coleader = "<br /><strong>Co-Leader:</strong> <a href=\'aim:goim?screenname=$team[aim3]&message=Hello, would you like a war?\'>$coleadimg</a> ($team[aim3])"; }else{ $coleader = "<br /><strong>Co-Leader:</strong> None Specified"; } //$aim_sn = "<a href='javascript:void(0);' onClick=\"fixedtooltip('<table><tr><td bgcolor=\'#000000\'><div align=\'right\' style=\'float:right\'><a href=\'javascript: void\' onclick=\'delayhidetip()\' style=\'font-weight:bold;color:red;\'>[X]</a></div></td></tr></table><br /> <strong>Leader:</strong> $leader $coleader<br /><br />', this, event, '250px')\">$image</a>"; $aim_sn = "<a href='javascript:void(0);' onClick=\"return overlib('<strong>Leader:</strong> $leader $coleader<br><br>', CAPTION, 'AOL Instant Messenger Contact Details', STICKY)\"\">$image</a>"; if($config[altcolorx]==$config[altcolora]){ $config[altcolorx]="$config[altcolorb]"; }else{ $config[altcolorx]="$config[altcolora]"; } $matches=mysql_query("select (TO_DAYS(now()) - TO_DAYS(max(reported))) as 'numdays' from matchdb WHERE wid='$teamid' or lid='$teamid' group by ladderid"); $matches=mysql_fetch_array($matches); $rcount++; include("./strikes_main.php"); $out[body].=" <tr bgcolor='$config[altcolorb]'> <td width='9%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$rcount</b></td> <td width='5%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$king</b></td> <td width='23%' valign='center' align='left' bgcolor='$config[altcolorb]'><font size='-2'><div align='right' style='float:right'>$message</div><div align='right' style='float:right;'>$war</div><a href='$config[scripturl]/stats.php?account=$tid' title='$name has played $games games with an average of $percent% with $wins Wins and $loss Losses'> <b>$name</a></b></a></td> <td width='11%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$wins</b></td> <td width='11%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$loss</b></td> <td width='11%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$streak</b></td> <td width='6%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$points</b></td> <td width='7%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$level</b></td> <td width='11%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$strike1 | $strike2 | $strike3</b></td> <td width='6%' valign='center' align='center' bgcolor='$config[altcolorb]'><font size='-2'><b>$aim_sn</b></td>"; }

Can anyone show me how I can get a display view working so above all of the informatin but below the banner, theres a drop down box and it will say like Name, Station, MFG Date.. ect. and when someone selects one of those, and clicks on a Go button next to the drop down box, it will display everything according to what you selected in order. So if I selected Station, then it will show everything with Station 231 first, then after all of them it will show Station 232, or if I do name, it will display all of the names in an aplhabetical order? Im unsure how to do this... thanks. <html> <head> <title> <? include "admin_panel_title.php";?> </title> </head> <body bgcolor="#000000" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FF3333" vlink="#FF3333" alink="#FF3333"> <center> <img src="/newadmin/Administration_Panel_Banner.png"><br> <h3>Turnout Gear Helmets View</h3> <? //include "http://delranfire.org/members/connect.phtml"; include "connect.phtml"; $db="delranfire_org"; $query="select * from togearhelmet order by name desc"; //echo $query; /* ----------------------------------------------------------------------------------------------------------------------------------------- */ /* This is the part I added in. Javascript isn't able to connect to a MySQL database, so you have to add the delete portion inside the PHP. First off, on the first line (the conditional IF statement), I added 2 pieces, first is the ID number of the row you want to delete, second is an action command. Both are passed in the querystring (hence the $_GET). If either one is blank, then nothing is deleted. If the action command is set to the phrase 'del', then it actually deletes the row. To access it via the browser, all you would do is link to: tgearhelmets.phtml?id=1&action=del (changing the ID value to whatever). If you have any questions or it doesn't work like you wanted, just IM me or email me (jpontani@gmail.com) if I'm not on AIM. */ if(isset($_GET['id']) && isset($_GET['action'])) { // make sure both parameters exist and have a value before trying to act on them $tempResult = mysql_db_query($db, "SELECT * FROM togearhelmet WHERE id=" . mysql_escape_string($_GET['id']), $connection); if(mysql_num_rows($tempResult) > 0) { // make sure that the item you want to delete is still in the database if($_GET['action'] == "del") { // if the action command is anything else, it will not delete the item mysql_db_query($db, "DELETE FROM togearhelmet WHERE id=" . mysql_escape_string($_GET['id']), $connection); } } } /* ----------------------------------------------------------------------------------------------------------------------------------------- */ $rows=mysql_db_query($db,$query,$connection) or die("Error in query:$query. " .mysql_error()); ?> <script language=javascript> /* ----------------------------------------------------------------------------------------------------------------------------------------- */ // I also changed this function around. Your original was mixing up Javascript and PHP to try to delete the entry. This way it only // uses the PHP side to delete the entry, and all the Javascript is doing is redirecting to the delete action of the page. function deleteEntry(entry) { location.href = "tgearhelmets.phtml?id=" + entry + "&action=del"; } /* ----------------------------------------------------------------------------------------------------------------------------------------- */ function deleteEntryOld(entry) { var moo = '\"DELETE FROM togearhelmet WHERE id=\'' + entry + '\'\"'; <? $qu = "?><script language=javascript>document.write(moo)</script><?"; mysql_query($qu); ?> var sURL = unescape(window.location.pathname); window.location.href = sURL; } </script> </font> <table width="98%" border="0" cellspacing="0" cellpadding="0" align=center> <tr> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">Name</font></b></td> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">ID</font></b></td> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">Station</font></b></td> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">Type</font></b></td> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">Model</font></b></td> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">Color</font></b></td> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">Ear Flap</font></b></td> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">Liner</font></b></td> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">Chinstrap</font></b></td> <td> <b><font face="Arial, Helvetica, sans-serif" size="1">Mfg. Date</font></b></td> <tr> <tr><td colspan=11><hr></td></tr> <? while($row=mysql_fetch_array($rows)){ ?> <td><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <? $name="$row[name]"; echo $row["name"];?> </font></td> <td><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <?echo $row["id"];?> </font></td> <td><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <?echo $row["station"];?> </font></td> <td><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <?echo $row["htype"];?> </font></td> <td><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <?echo $row["hmodel"];?> </font></td> <td><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <?echo $row["hcolor"];?> </font></td> <td ><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <?echo $row["hflap"];?> </font></td> <td ><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <?echo $row["hliner"];?> </font></td> <td ><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <?echo $row["hstrap"];?> </font></td> <td ><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"> <?echo $row["hdatem"];?> - <?echo $row["hdated"];?> - <?echo $row["hdatey"];?> <tr><td colspan=11><hr></td></tr> <?}?> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> <center><a href="/newadmin/">Back to Administration Panel</a></center> </body></html> <? mysql_close(); ?>

So then it would look like this: <? session_start(); // start session. ?> <html> <head> <title>Login</title> <head> <body> <? if(!isset($username) | !isset($password)) { ?> <form action="<?=$PHP_SELF?><?if($QUERY_STRING){ echo"?". $QUERY_STRING;}?>" method="POST"> <p align="center">Officers only. Please Login.</p> <table align="center" border="0"> <tr> <th> Username: </th> <th> <input type="text" name="username"> </th> </tr> <tr> <th> Password: </th> <th> <input type="password" name="password"> </th> </tr> <tr> <th colspan="2" align="right"> <input type="submit" value="Login"> </form> </th> </tr> </table> <? exit(); } session_register("username"); session_register("password"); $sql = mysql_query("SELECT password FROM members WHERE username = '$username'"); if ($sql) { echo mysql_error(); } $fetch_em = mysql_fetch_array($sql); $numrows = mysql_num_rows($sql); if($numrows != "0" & $password == $fetch_em["password"]) { $valid_user = 1; } else { $valid_user = 0; } if (!($valid_user)) { session_unset(); session_destroy(); ?> <form action="<?=$PHP_SELF?><?if($QUERY_STRING){ echo"?". $QUERY_STRING;}?>" method="POST"> <p align="center">Incorrect login information, please try again.</p> <table align="center" border="0"> <tr> <th> Username: </th> <th> <input type="text" name="username"> </th> </tr> <tr> <th> Password: </th> <th> <input type="password" name="password"> </th> </tr> <tr> <th colspan="2" align="right"> <input type="submit" value="Login"> </form> </th> </tr> </table> </body> </html> <? exit(); } ?>

I just saw I ended my html like in the middle, so I removed the </body> and </html> now he login displays, but when I go to login it says Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/delranfd/delranfire-www/newadmin/login.php on line 46 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/delranfd/delranfire-www/newadmin/login.php on line 47

I have a login script but every time I go to it, I get an error but I can't see any problems in the code.. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/delranfd/delranfire-www/newadmin/login.php on line 48 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/delranfd/delranfire-www/newadmin/login.php on line 49 <? session_start(); // start session. ?> <html> <head> <title>Login</title> <head> <body> <? if(!isset($username) | !isset($password)) { ?> <form action="<?=$PHP_SELF?><?if($QUERY_STRING){ echo"?". $QUERY_STRING;}?>" method="POST"> <p align="center">Officers only. Please Login.</p> <table align="center" border="0"> <tr> <th> Username: </th> <th> <input type="text" name="username"> </th> </tr> <tr> <th> Password: </th> <th> <input type="password" name="password"> </th> </tr> <tr> <th colspan="2" align="right"> <input type="submit" value="Login"> </form> </th> </tr> </table> </body> </html> <? exit(); } session_register("username"); session_register("password"); $sql = mysql_query("SELECT password FROM members WHERE username = '$username'"); $fetch_em = mysql_fetch_array($sql); $numrows = mysql_num_rows($sql); if($numrows != "0" & $password == $fetch_em["password"]) { $valid_user = 1; } else { $valid_user = 0; } if (!($valid_user)) { session_unset(); session_destroy(); ?> <form action="<?=$PHP_SELF?><?if($QUERY_STRING){ echo"?". $QUERY_STRING;}?>" method="POST"> <p align="center">Incorrect login information, please try again.</p> <table align="center" border="0"> <tr> <th> Username: </th> <th> <input type="text" name="username"> </th> </tr> <tr> <th> Password: </th> <th> <input type="password" name="password"> </th> </tr> <tr> <th colspan="2" align="right"> <input type="submit" value="Login"> </form> </th> </tr> </table> </body> </html> <? exit(); } ?>

Ok, the displaying works but now when I click submit, all it writes to the database is 'Select Member' It doesn't write the people I select... hmm. <? include "connect.phtml"; $db=delranfire_org; if(isset($_POST['select'])){ $query1="insert into 231officers(name)values('$select')"; mysql_db_query($db,$query1,$connection) or die("Error in query:$query. " .mysql_error()); }//end if $query="select name from member order by name asc"; $rows=mysql_db_query($db,$query,$connection) or die("Error in query:$query. " .mysql_error()); ?> <html> <head> <title> <? include "admin_panel_title.php";?> </title> </head> <body bgcolor="#000000" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FF3333" vlink="#CC0000" alink="#CC0000"> <form action="231officers.phtml" method="post"> <center> <img src="/newadmin/Administration_Panel_Banner.png"><br> <h3>Station 231 Officers</h3> <table border="1" cellspacing="0" cellpadding="0" align="center"> <tr> <td colspan="2"> <center> <I>Line Officers</I> </center> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Deputy Chief (2310):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="name"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Captain (2301):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>1st Lieutenant (2303):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>2nd Lieutenant (2305):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Chief Engineer:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Asst. Engineers (5):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Fire Police Captain:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Fire Police Lieutenant:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td colspan="2"> <center> <I>Administrative Officers</I> </center> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>President:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Vice President:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Treasurer:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Financial Secretary:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Corresponding Secretary:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Trustees (3):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select> </td> </tr> <tr> <td colspan="3"> <div align="center"> <input type="submit" name="Submit" value="Update"> <input type="reset" name="reset" value="Clear Information"> </div> </td> </tr> </table> </form> <a href="/newadmin/">Back to Administration Panel</a> </body></html> <? mysql_close(); ?>

So then &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> mysql_data_seek($rows,0); &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> mysql_data_seek($rows,0); &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select>

Where should I put the mysql_data_seek($rows,0); ? After every dropdown box? &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } mysql_data_seek($rows,0); ?> </select>

When I go to load this page, the first drop down box works and it loads everyones names, but every drop down box after the first one won't load anyones names, it just says select member. Did I forget to end the first one or something? <? include "connect.phtml"; $db=delranfire_org; if(isset($_POST['select'])){ }//end if $query="select name from member order by name asc"; $rows=mysql_db_query($db,$query,$connection) or die("Error in query:$query. " .mysql_error()); ?> <html> <head> <title> <? include "admin_panel_title.php";?> </title> </head> <body bgcolor="#000000" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FF3333" vlink="#CC0000" alink="#CC0000"> <form action="231officers.phtml" method="post"> <center> <img src="/newadmin/Administration_Panel_Banner.png"><br> <h3>Station 231 Officers</h3> <table border="1" cellspacing="0" cellpadding="0" align="center"> <tr> <td colspan="2"> <center> <I>Line Officers</I> </center> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Deputy Chief (2310):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Captain (2301):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>1st Lieutenant (2303):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>2nd Lieutenant (2305):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Chief Engineer:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Asst. Engineers (5):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Fire Police Captain:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Fire Police Lieutenant:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td colspan="2"> <center> <I>Administrative Officers</I> </center> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>President:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Vice President:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Treasurer:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Financial Secretary:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Corresponding Secretary:&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Trustees (3):&nbsp</b></div> </td> <td width="51%" valign="middle"> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select><br> &nbsp<select name="select"> <option>Select Member</option> <? while($row=mysql_fetch_array($rows)) { echo "<option value='$row[name]'>$row[name]</option>"; } ?> </select> </td> </tr> <tr> <td colspan="3"> <div align="center"> <input type="submit" name="Submit" value="Update"> <input type="reset" name="reset" value="Clear Information"> </div> </td> </tr> </table> </form> <a href="/newadmin/">Back to Administration Panel</a> </body></html> <? mysql_close(); ?>

Yea, I know I saw yours already, but it still doesn't post. <?php include "connect.phtml"; $db="delranfire_org"; print_r( $_POST ); if(isset($_POST['select'])) { $query1="insert into member (name,`password`,email) values ('".$_POST['name']."','".$_POST['password']."','".$_POST['email']."')"; mysql_query($query1) or die("Error in query:$query. " .mysql_error()); } ?> <html> <head> <title> <? include "admin_panel_title.php";?> </title> </head> <body bgcolor="#000000" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FF3333" vlink="#CC0000" alink="#CC0000"> <form action="addmember.phtml" method="post"> <center> <img src="/newadmin/Administration_Panel_Banner.png"><br> <h3>Add a Member</h3> <table border="1" cellspacing="0" cellpadding="0" align="center"> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1">First & Last Name:&nbsp</font></b></div> </td> <td width="51%" valign="middle"> &nbsp<INPUT TYPE="text" NAME="name" SIZE="30"></INPUT> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><font face="Verdana, Arial, Helvetica, sans-serif"><b><font size="1">Password:&nbsp</font></b></font></div> </td> <td width="51%" valign="middle"> &nbsp<INPUT TYPE="text" NAME="password" SIZE="30"></INPUT> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>EMail Address**:&nbsp</b></font></div> </td> <td width="51%" valign="middle"> &nbsp<INPUT TYPE="text" NAME="email" SIZE="30"></INPUT> </td> </tr> <tr> <td colspan="3"> <div align="center"> <input type="submit" name="Submit" value="Add Member"> <input type="reset" name="reset" value="Clear Information"> </div> </td> </tr> </table> </form> <a href="/newadmin/">Back to Administration Panel</a><br> <br> <font size="2">**This field will not create an email address. The email address must be added though the CPanel </body></html> <? mysql_close(); ?>

I just made a new database, the old one has alot of entries already and its getting boring scrolling through all of the entries to see if it posted or not, the new one is called members Updated code is below <?php include "connect.phtml"; $db="delranfire_org"; print_r( $_POST ); if(isset($_POST['select'])) { $query1="insert into members('name','password','email')values('".$_POST['name']."','".$_POST['password']."','".$_POST['email']."')"; mysql_query($query1) or die("Error in query:$query. " .mysql_error()); } ?> <html> <head> <title> <? include "admin_panel_title.php";?> </title> </head> <body bgcolor="#000000" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FF3333" vlink="#CC0000" alink="#CC0000"> <form action="addmember.phtml" method="post"> <center> <img src="/newadmin/Administration_Panel_Banner.png"><br> <h3>Add a Member</h3> <table border="1" cellspacing="0" cellpadding="0" align="center"> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1">First & Last Name:&nbsp</font></b></div> </td> <td width="51%" valign="middle"> &nbsp<INPUT TYPE="text" NAME="name" SIZE="30"></INPUT> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><font face="Verdana, Arial, Helvetica, sans-serif"><b><font size="1">Password:&nbsp</font></b></font></div> </td> <td width="51%" valign="middle"> &nbsp<INPUT TYPE="text" NAME="password" SIZE="30"></INPUT> </td> </tr> <tr> <td width="47%" align="center" valign="middle"> <div align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>EMail Address**:&nbsp</b></font></div> </td> <td width="51%" valign="middle"> &nbsp<INPUT TYPE="text" NAME="email" SIZE="30"></INPUT> </td> </tr> <tr> <td colspan="3"> <div align="center"> <input type="submit" name="Submit" value="Add Member"> <input type="reset" name="reset" value="Clear Information"> </div> </td> </tr> </table> </form> <a href="/newadmin/">Back to Administration Panel</a><br> <br> <font size="2">**This field will not create an email address. The email address must be added though the CPanel </body></html> <? mysql_close(); ?> Could my database be wrong? Field - ID Type - int(10) Attributes - UNSIGNED Null - No Default - Extra - auto_increment Action - --- Field - Name Type - Varchar(55) Attributes - Null - Yes Default - NULL Extra - Action - --- Field - Password Type - Varchar(55) Attributes - Null - Yes Default - NULL Extra - Action - --- Field - email Type - Varchar(55) Attributes - Null - Yes Default - NULL Extra - Action -