Sparrow Posted July 31, 2008 Share Posted July 31, 2008 I have the homepage of my website set-up but when I try to run it I get this error: Parse error: syntax error, unexpected '>' in /home/unitedai/public_html/index9.php on line 374 Here is the code: (Line 374 is the last one) <? include 'VirtualAdminII2.0/db.php'; include 'site/site.inc.php'; include 'site/site.funct.php'; echo "<p> </p>"; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>United Virtual Alliance - Home</title> <style type="text/css"> <!-- .style1 {color: #333333} .style4 { color: #FFFFFF; font-size: medium; font-weight: bold; font-family: Verdana, Arial, Helvetica, sans-serif; } .style6 {color: #BF0000} body { background-image: url(images/back.jpg); } .style9 { font-size: 24px; font-weight: bold; color: #333333; font-family: Geneva, Arial, Helvetica, sans-serif; font-style: italic; } .style10 {font-size: 18px} .style11 { font-size: 18px; font-weight: bold; } .style12 {font-size: 12px} --> </style> <script language="JavaScript" type="text/JavaScript"> <!-- function mmLoadMenus() { if (window.mm_menu_0728215159_0) return; window.mm_menu_0728215159_0 = new Menu("root",83,18,"Georgia, Times New Roman, Times, serif",12,"#000000","#FFFFFF","#CCCCCC","#000099","center","middle",3,0,1000,-5,7,true,false,true,0,true,true); mm_menu_0728215159_0.addMenuItem("New item"); mm_menu_0728215159_0.fontStyle="italic"; mm_menu_0728215159_0.hideOnMouseOut=true; mm_menu_0728215159_0.bgColor='#555555'; mm_menu_0728215159_0.menuBorder=1; mm_menu_0728215159_0.menuLiteBgColor='#FFFFFF'; mm_menu_0728215159_0.menuBorderBgColor='#777777'; window.mm_menu_0728215404_0 = new Menu("root",135,18,"Georgia, Times New Roman, Times, serif",12,"#000000","#FFFFFF","#CCCCCC","#A60000","center","middle",3,0,1000,-5,7,true,false,true,0,true,true); mm_menu_0728215404_0.addMenuItem("Bostan Logan"); mm_menu_0728215404_0.addMenuItem("O-Hare"); mm_menu_0728215404_0.addMenuItem("John. F Kennedy "); mm_menu_0728215404_0.addMenuItem("London Heathrow"); mm_menu_0728215404_0.addMenuItem("Los Angles"); mm_menu_0728215404_0.addMenuItem("Miami"); mm_menu_0728215404_0.fontStyle="italic"; mm_menu_0728215404_0.hideOnMouseOut=true; mm_menu_0728215404_0.bgColor='#555555'; mm_menu_0728215404_0.menuBorder=1; mm_menu_0728215404_0.menuLiteBgColor='#FFFFFF'; mm_menu_0728215404_0.menuBorderBgColor='#777777'; window.mm_menu_0728234850_0 = new Menu("root",158,18,"Georgia, Times New Roman, Times, serif",12,"#000000","#FFFFFF","#CCCCCC","#A60000","center","middle",3,0,1000,-5,7,true,false,true,0,true,true); mm_menu_0728234850_0.addMenuItem("New Pilot Application"); mm_menu_0728234850_0.addMenuItem("Forgot Password"); mm_menu_0728234850_0.addMenuItem("Our Policies"); mm_menu_0728234850_0.addMenuItem("Hub Transfer"); mm_menu_0728234850_0.addMenuItem("Contact Us"); mm_menu_0728234850_0.addMenuItem("Resignation"); mm_menu_0728234850_0.addMenuItem("Our Staff"); mm_menu_0728234850_0.addMenuItem("Management"); mm_menu_0728234850_0.addMenuItem("Live Support"); mm_menu_0728234850_0.fontStyle="italic"; mm_menu_0728234850_0.hideOnMouseOut=true; mm_menu_0728234850_0.bgColor='#555555'; mm_menu_0728234850_0.menuBorder=1; mm_menu_0728234850_0.menuLiteBgColor='#FFFFFF'; mm_menu_0728234850_0.menuBorderBgColor='#777777'; window.mm_menu_0728235619_0 = new Menu("root",142,18,"Georgia, Times New Roman, Times, serif",12,"#000000","#FFFFFF","#CCCCCC","#A60000","center","middle",3,0,1000,-5,7,true,false,true,0,true,true); mm_menu_0728235619_0.addMenuItem("Awards"); mm_menu_0728235619_0.addMenuItem("Pilot Ranks"); mm_menu_0728235619_0.addMenuItem("Screenshot Contest"); mm_menu_0728235619_0.fontStyle="italic"; mm_menu_0728235619_0.hideOnMouseOut=true; mm_menu_0728235619_0.bgColor='#555555'; mm_menu_0728235619_0.menuBorder=1; mm_menu_0728235619_0.menuLiteBgColor='#FFFFFF'; mm_menu_0728235619_0.menuBorderBgColor='#777777'; window.mm_menu_0728235924_0 = new Menu("root",104,18,"Georgia, Times New Roman, Times, serif",12,"#000000","#FFFFFF","#CCCCCC","#A60000","center","middle",3,0,1000,-5,7,true,false,true,0,true,true); mm_menu_0728235924_0.addMenuItem("B747-400"); mm_menu_0728235924_0.addMenuItem("King Air 350"); mm_menu_0728235924_0.addMenuItem("B737-800"); mm_menu_0728235924_0.addMenuItem("CRJ 700"); mm_menu_0728235924_0.fontStyle="italic"; mm_menu_0728235924_0.hideOnMouseOut=true; mm_menu_0728235924_0.bgColor='#555555'; mm_menu_0728235924_0.menuBorder=1; mm_menu_0728235924_0.menuLiteBgColor='#FFFFFF'; mm_menu_0728235924_0.menuBorderBgColor='#777777'; mm_menu_0728235924_0.writeMenus(); } // mmLoadMenus() function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); // function FP_swapImg() {//v1.0 var doc=document,args=arguments,elm,n; doc.$imgSwaps=new Array(); for(n=2; n<args.length; n+=2) { elm=FP_getObjectByID(args[n]); if(elm) { doc.$imgSwaps[doc.$imgSwaps.length]=elm; elm.$src=elm.src; elm.src=args[n+1]; } } } function FP_preloadImgs() {//v1.0 var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array(); for(var i=0; i<a.length; i++) { d.FP_imgs[i]=new Image; d.FP_imgs[i].src=a[i]; } } function FP_getObjectByID(id,o) {//v1.0 var c,el,els,f,m,n; if(!o)o=document; if(o.getElementById) el=o.getElementById(id); else if(o.layers) c=o.layers; else if(o.all) el=o.all[id]; if(el) return el; if(o.id==id || o.name==id) return o; if(o.childNodes) c=o.childNodes; if(c) for(n=0; n<c.length; n++) { el=FP_getObjectByID(id,c[n]); if(el) return el; } f=o.forms; if(f) for(n=0; n<f.length; n++) { els=f[n].elements; for(m=0; m<els.length; m++){ el=FP_getObjectByID(id,els[n]); if(el) return el; } } return null; } --> </script> <script language="JavaScript" src="mm_menu.js"></script> </head> <body onload="FP_preloadImgs(/*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button2.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button3B.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button3C.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button3E.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button3F.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button8.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/buttonA.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/buttonB.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/buttonD.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/buttonE.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button17.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button18.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button19.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button1A1.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button1C1.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button1D.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button1F.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button23.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button24.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button25.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button26.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button27.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button28.jpg', /*url*/'file:///D:/My%20Documents/My%20Web%20Sites/public_html/VirtualAdminII2.0/button29.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button59.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button5A.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button5C.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button5D.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button5F.jpg', /*url*/'file:///C:/Documents%20and%20Settings/Captain%20Sparrow/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/button60.jpg')"> <script language="JavaScript1.2">mmLoadMenus();</script> <div align="center"></div> <table width="1094" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td width="846"><img src="welcome%205%20copy.jpg" width="846" height="144"></td> <td width="248"><form action="../checkuser.php" method="post" name="" class="style1" id=""> <table width="248" height="144" border="0" cellpadding="1" cellspacing="0" bgcolor="#292b30"> <tr> <td width="251"><div align="center"><span class="style4">Pilot Login </span></div></td> </tr> <tr> <td><span class="style6">Username </span> <input name="username" type="text" id="username" size="20"></td> </tr> <tr> <td height="59"><span class="style6">Password</span> <input name="password" type="password" id="password" size="20" border="#C10000"></td> </tr> <tr> <td><input type="submit" name="Submit" value="Submit"></td> <center> </center> </tr> </table> </form></td> </tr> <tr bgcolor="#FFFFFF"> <td colspan="3"><img border="0" id="img3" src="button17.jpg" height="20" width="100" alt="Home" onmouseover="FP_swapImg(1,0,/*id*/'img3',/*url*/'button18.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img3',/*url*/'button17.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img3',/*url*/'button19.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img3',/*url*/'button18.jpg')" fp-style="fp-btn: Embossed Rectangle 5" fp-title="Home"><a href="javascript:;" onMouseOver="MM_showMenu(window.mm_menu_0728215404_0,0,20,null,'image1')" onMouseOut="MM_startTimeout();"><img src="button1A.jpg" alt="Hubs" name="image1" width="100" height="20" border="0" id="img4" onmousedown="FP_swapImg(1,0,/*id*/'img4',/*url*/'button1C.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img4',/*url*/'button1B.jpg')" onmouseover="FP_swapImg(1,0,/*id*/'img4',/*url*/'button1B.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img4',/*url*/'button1A.jpg')" fp-style="fp-btn: Embossed Rectangle 5" fp-title="Hubs"></a><img border="0" id="img5" src="button1D.jpg" height="20" width="100" alt="Join Us!" onmouseover="FP_swapImg(1,0,/*id*/'img5',/*url*/'button1E.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img5',/*url*/'button1D.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img5',/*url*/'button1F.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img5',/*url*/'button1E.jpg')" fp-style="fp-btn: Embossed Rectangle 5" fp-title="Join Us!"><img border="0" id="img6" src="button20.jpg" height="20" width="100" alt="Flight Bids" onmouseover="FP_swapImg(1,0,/*id*/'img6',/*url*/'button21.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img6',/*url*/'button20.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img6',/*url*/'button22.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img6',/*url*/'button21.jpg')" fp-style="fp-btn: Embossed Rectangle 5" fp-title="Flight Bids"><a href="javascript:;" onMouseOver="MM_showMenu(window.mm_menu_0728234850_0,0,20,null,'image2')" onMouseOut="MM_startTimeout();"><img src="button23.jpg" alt="Human Resources" name="image2" width="100" height="20" border="0" id="img7" onmousedown="FP_swapImg(1,0,/*id*/'img7',/*url*/'button25.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img7',/*url*/'button24.jpg')" onmouseover="FP_swapImg(1,0,/*id*/'img7',/*url*/'button24.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img7',/*url*/'button23.jpg')" fp-style="fp-btn: Embossed Rectangle 5; fp-font-size: 8" fp-title="Human Resources"></a><img border="0" id="img8" src="button29.jpg" height="20" width="100" alt="Useful Tools" onmouseover="FP_swapImg(1,0,/*id*/'img8',/*url*/'button2A.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img8',/*url*/'button29.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img8',/*url*/'button2B.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img8',/*url*/'button2A.jpg')" fp-style="fp-btn: Embossed Rectangle 5" fp-title="Useful Tools"><a href="http://unitedairlinesva.com/forums/"><img border="0" id="img9" src="button2C.jpg" height="20" width="100" alt="Fourm" onmouseover="FP_swapImg(1,0,/*id*/'img9',/*url*/'button2D.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img9',/*url*/'button2C.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img9',/*url*/'button2E.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img9',/*url*/'button2D.jpg')" fp-style="fp-btn: Embossed Rectangle 5" fp-title="Fourm"></a><a href="javascript:;" onMouseOver="MM_showMenu(window.mm_menu_0728235924_0,0,20,null,'image4')" onMouseOut="MM_startTimeout();"><img src="button2F.jpg" alt="Fleet" name="image4" width="100" height="20" border="0" id="img10" onmousedown="FP_swapImg(1,0,/*id*/'img10',/*url*/'button31.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img10',/*url*/'button30.jpg')" onmouseover="FP_swapImg(1,0,/*id*/'img10',/*url*/'button30.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img10',/*url*/'button2F.jpg')" fp-style="fp-btn: Embossed Rectangle 5" fp-title="Fleet"></a><img border="0" id="img11" src="button32.jpg" height="20" width="100" alt="Events" onmouseover="FP_swapImg(1,0,/*id*/'img11',/*url*/'button33.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img11',/*url*/'button32.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img11',/*url*/'button34.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img11',/*url*/'button33.jpg')" fp-style="fp-btn: Embossed Rectangle 5" fp-title="Events"><img border="0" id="img12" src="button35.jpg" height="20" width="100" alt="File PIREPs" onmouseover="FP_swapImg(1,0,/*id*/'img12',/*url*/'button36.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img12',/*url*/'button35.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img12',/*url*/'button37.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img12',/*url*/'button36.jpg')" fp-style="fp-btn: Embossed Rectangle 5" fp-title="File PIREPs"><a href="javascript:;" onMouseOver="MM_showMenu(window.mm_menu_0728235619_0,0,20,null,'image3')" onMouseOut="MM_startTimeout();"><img src="button38.jpg" alt="Recognition" name="image3" width="94" height="20" border="0" id="img13" onmousedown="FP_swapImg(1,0,/*id*/'img13',/*url*/'button3A.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img13',/*url*/'button39.jpg')" onmouseover="FP_swapImg(1,0,/*id*/'img13',/*url*/'button39.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img13',/*url*/'button38.jpg')" fp-style="fp-btn: Embossed Rectangle 5; fp-font-size: 9" fp-title="Recognition"></a></td> </tr> </table> <table width="1095" height="348" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td width="642" height="30" bgcolor="#FFFFFF" colspan="3"><div align="center" class="style9"> <p align="left"><span class="style10"> Welcome Aboard United Virtual Alliance</span> <img src="images/Underline.png" width="638" height="3" align="top"></p> </div></td> <td width="68"> </td> <td width="68"> </td> <td width="68"> </td> <td width="389" rowspan="2"> <p> </p> <p> </p> <p> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="300" height="100" align="middle"> <param name="BGCOLOR" value=""> <param name="movie" value="button14.swf"> <param name="quality" value="high"> <embed src="button14.swf" width="300" height="100" align="middle" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" ></embed> </object> </p> <p>We are currently Recruiting Pilots. Join Us today! </p></td> </tr> <tr> <td rowspan="9" valign="top" width="10"> </td> <td rowspan="9" valign="top" width="612"><p>Hello and Welcome to United Virtual Alliance! Here at UVA our goal is to have a fun, rewarding, challenging and realistic environment for pilots and fellow aviation fans. </p> <p>Join us now, and enjoy participating in our Pilot Award program where you get recognition for flying with us! Or if you would like to add more purpose and realism to your flights join us. Participate in one of our online events and have fun with fellow pilots. Whether you are a new pilot to the flight simulation world or a flight simulator veteran you are sure to enjoy UVA. We would love to have you! </p> <p>Please take the time to familiarize yourself with our website and see what we have to offer. Visit our forums and get to know our pilots and members of staff. If you have any question fell free to contact our human resources. If you would like to join us please fill out a pilot application form. If you interested in joining use as a staff member visit out staff page for more details. </p> <p>Join UVA today and see what we are all about! </p> <table border="0" width="100%" id="table3" height="642" cellspacing="0" cellpadding="0"> <tr> <td valign="top" height="38"><i><b><font face="Arial"> <span class="style10"> News</span></font></b></i> <img src="images/Underline.png" width="583" height="3" align="top"></td> </tr> <tr> <td valign="top" height="214"> <? db_login(); //Generate the query so we can retrieve all titles in the DB in descending ID order $query = "SELECT id, title, date FROM news ORDER BY id DESC"; $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); // if records are present if (mysql_num_rows($result) > 0) { while($send = mysql_fetch_object($result)) { echo"$send->title -"; echo formatDate($send->date); echo" - <a href='r.php?id=$send->id'>Click Here to Read</a><br /><br />"; } } ?></td> </tr> <tr> <td valign="top" height="36"><i><b><font face="Arial"> <span class="style10"> Partners and Affiliations </span></font></b></i> <img src="images/Underline.png" width="583" height="3" align="top"></td> </tr> <tr> <td valign="top"> <a href="http://vatsim.net/"> <img border="0" src="images/vatsim%20logo.gif" width="175" height="64"></a> <a href="http://www.va-zone.com"> <img border="0" src="images/va%20zone.jpg" width="363" height="102"></a></td> </tr> </table> </td> <td rowspan="9" valign="top" width="16"> <img border="0" src="images/vertical%20sep.jpg" width="3" height="1062" align="absmiddle"></td> <td height="133" align="left" valign="top"> </td> <td height="133" align="left" valign="top"> </td> <td height="133" align="left" valign="top"> </td> </tr> <tr> <td colspan="4" align="left" valign="top"><div align="center" class="style11">Current Flights</div></td> </tr> <tr> <td colspan="4" align="left" valign="top"><img src="images/Online.jpg" width="455" height="202"></td> </tr> <tr> <td colspan="4" align="left" valign="top"> <p align="center"> <? $result = mysql_query("select * from users order by signup_date desc limit 10"); $num = mysql_num_rows($result); $i = 0; ?>Click the above image to see who's flying.</p> <tr> <td colspan="4" align="left" valign="top"> <p align="center"> <u><font size="6" color="#000000"> <p align="center"> <img border="0" src="images/new%20pilots.jpg" width="456" height="65"><tr> <td colspan="4" align="left" valign="top"> <u><font size="6" color="#000000"> <table cellpadding="4" cellspacing="3" align="center" style=" border: solid #000000 1px" width="100%" id="table2"> <tr bgcolor="#b5d0e5" style="color: #997711"> <th bgcolor="#CC0000" style="font-family: tahoma; font-size: 11px; color: #414141"><font color="#FFFFFF">Pilot Callsign</font></th> <th bgcolor="#CC0000" style="font-family: tahoma; font-size: 11px; color: #414141"><font color="#FFFFFF">Pilot Name</font></th> <th bgcolor="#CC0000" style="font-family: tahoma; font-size: 11px; color: #414141"><font color="#FFFFFF">Country</font></th> <th bgcolor="#CC0000" style="font-family: tahoma; font-size: 11px; color: #414141"><font color="#FFFFFF">Date Joined</font></th> </tr> <? while($i < $num) { $ghours = mysql_query("select * from users order by signup_date desc limit 10"); $hourcount = mysql_num_rows($ghours); $a = 0; $hourstrue = 0; $hours = 0.0; $username = mysql_result($result,$i,"username"); $name = mysql_result($result,$i,"name"); $location = mysql_result($result,$i,"location"); $signup_date = mysql_result($result,$i,"signup_date"); ?> <tr style="color: #997711"> <td align="center" style="font-family: tahoma; font-size: 11px; color: #414141"<?echo $username;?></td> <td align="center" style="font-family: tahoma; font-size: 11px; color: #414141"><?echo $name;?></td> <td align="center" style="font-family: tahoma; font-size: 11px; color: #414141"><?echo $location;?></td> <td align="center" style="font-family: tahoma; font-size: 11px; color: #414141"><?echo $signup_date;?></td> </tr> <? $i++;} ?> </table> <tr> <td colspan="4" align="left" valign="top"> <tr> <td colspan="4" align="left" valign="top"> <img border="0" src="images/welcome%204%20copy.jpg" width="457" height="267"><tr> <td colspan="4" align="left" valign="top"> <p align="center"><font face="Lucida Handwriting"> Got a good Screenshot? </font></p> <p align="center"><font face="Lucida Handwriting">Post it in our Screenshot contest and you could win!</font> </table> <div align="center"> <table border="0" width="1095" id="table4" cellspacing="0" cellpadding="0" height="52" bgcolor="#FFFFFF"> <tr> <td> <img border="0" src="images/Footer.jpg" width="1096" height="75"></td> </tr> </table> </div> <? echo "<p> </p></td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> </body> </html> <? mysql_close($connection); echo "<p> </p>"; ?> Any Idea? ??? Quote Link to comment Share on other sites More sharing options...
DarkWater Posted July 31, 2008 Share Posted July 31, 2008 You missed a ?> and some other stuff. Also, DON'T USE SHORT TAGS. =P <? echo "<p> </p></td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> </body> </html>"; ?> <? mysql_close($connection); echo "<p> </p>"; ?> Quote Link to comment Share on other sites More sharing options...
Sparrow Posted July 31, 2008 Author Share Posted July 31, 2008 Thank you so much. That error is gone. Now the page displays but somewhere on the page I get this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/unitedai/public_html/index9.php on line 276 This is line 276 and the lines around it: (Line 276 is in Bold) <? $result = mysql_query("select * from users order by signup_date desc limit 10"); $num = mysql_num_rows($result); $i = 0; ?>Click the above image to see who's flying.</p> Any Idea? For the full code see the top post. Quote Link to comment Share on other sites More sharing options...
DarkWater Posted July 31, 2008 Share Posted July 31, 2008 $result = mysql_query("select * from users order by signup_date desc limit 10") OR die(mysql_error()); Show the new output (if any). Quote Link to comment Share on other sites More sharing options...
Sparrow Posted July 31, 2008 Author Share Posted July 31, 2008 Thank you very much for the quick replies . Okay now I get the message: Unknown column 'signup_date' in 'order clause'. I guess this has to day with that very same line. I'm pretty sure it thinks sign_up date is a column. It's not though. Sing_up date is a row. How can I make it read sign_up date as a row? Quote Link to comment Share on other sites More sharing options...
Sparrow Posted July 31, 2008 Author Share Posted July 31, 2008 Never mind ignore my last post. Singup_date is a column. However I get this error: Unknown column 'signup_date' in 'order clause'. Any Idea why? Quote Link to comment Share on other sites More sharing options...
DarkWater Posted July 31, 2008 Share Posted July 31, 2008 Did you accidentally enter singup_date instead of signup_date? Quote Link to comment Share on other sites More sharing options...
Sparrow Posted July 31, 2008 Author Share Posted July 31, 2008 No I decided to order by user_id instead and now the error is gone. Now they are no more errors. However it dosen't seem to be working. If you look on the right side of my homepage at: http://www.unitedairlinesva.com/index9.php where it says "UVA welcomes our newest pilots" there is a table under it that is supposed to display the 10 newest members by user ID. I have six new members that should be displaying there but nothing except for the table headers are displaying. Does anybody know why??? ??? Quote Link to comment Share on other sites More sharing options...
Sparrow Posted July 31, 2008 Author Share Posted July 31, 2008 Okay Now I'm really confused. I tried aplying the same ORDER MySql query to my old website under "hubs" and it works. Now If I copy that exact table and put it into my new website it dosen't work. So Confusing ??? ??? ??? ??? ??? Quote Link to comment Share on other sites More sharing options...
Sparrow Posted August 1, 2008 Author Share Posted August 1, 2008 I did the coding for the table over again and now it works. . I don't know what I did differetly this time that made it work :-\ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.