webForumDet fria alternativet

PHP eller vad gör felet?

2 svar · 239 visningar · startad av Putte_sky

Putte_skyMedlem sedan juli 20049 inlägg
#1

Hej!
Jag har gjort profiler åt mina medlemmar men ibland kommer fel profil upp..

Här är koden:

Pilots:

<?php
include "include.php";
?>
<head>
<script language="JavaScript"> 
<!-- Begin 
function popUp(id) { 
props=window.open('profile.php?profile='+id, 'poppage', 'toolbars=0, scrollbars=0, location=0, statusbars=0, menubars=0, resizable=0, width=400, height=300 left = 100, top = 100'); 
} 
// End --> 
</script>
<title>Skyways VA</title></head>
<html>
<body BGCOLOR="#FFFFFF" LEFTMARGIN="0" TOPMARGIN="0" MARGINWIDTH="0" MARGINHEIGHT="0" onLoad="" LINK="#CE1141" VLINK="#CE1141" ALINK="#CE1141">
<table width="685" border="0" height="399">
  <tr> 
    <td valign="top"  class="table1" height="2"><b>Pilots</b><br>
      <br>
      Click on the pilot name and a profile will popup for the pilot, Make sure 
      that you don't use any popup blocking programs.<br>
      <table width="679" border="0" cellspacing="1" cellpadding="1">
        <tr> 
          <td width="55" class="table1"><b>ID:</b></td>
          <td class="table1" width="161"><b>Pilot name:</b></td>
          <td width="67" class="table1"><b>Vatsim:</b></td>
          <td width="81" class="table1"><b>Year of birth:</b></td>
          <td width="179" class="table1"><b>Certrificated aircraft:</b></td>
          <td width="117" class="table1">&nbsp;</td>
        </tr>
        <?php
  $find = mysql_query("SELECT * FROM pilots ORDER BY id ASC");
  while($row = mysql_fetch_array($find)) { ?>
        <tr> 
          <td width="55" class="table1">SKX<? echo $row['id']; ?>
          </td>
          <td class="table1" width="161">&nbsp; 
            <? echo "<a href=\"\" onClick=\"popUp($row[id]); return false;\">".$row['firstname']." ".$row['lastname']."</a>"; ?>
          </td>
          <td width="67" class="table1">&nbsp; 
            <? echo $row['vatsim_id']; ?>
          </td>
          <td width="81" class="table1">&nbsp; 
            <? echo $row['age']; ?>
          </td>
          <td width="179" class="table1">&nbsp; 
            <? echo $row['aircraft_type']; ?>
          </td>
          <td width="117" class="table1"><a href="mailto:<? echo $row['email']; ?>"><font color="#CE1141">Contact</font></a></td>
        </tr>
        <? } ?>
      </table>
    </td>
  </tr>
</table>
</body>
</html>

Profile:

<? include "include.php"; ?>
<html>
<head>
<title>Profile</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<?php
  $find = mysql_query("SELECT * FROM pilots WHERE id = '$_GET[profile]'");
  while($row = mysql_fetch_array($find)) { ?>
<body bgcolor="#FFFFFF" text="#000000">
<font size="+1"><b><font face="Arial, Helvetica, sans-serif" color="#CE1141">Pilot 
profile for SKX<? echo $row['id']; ?>
</font> </b></font><br>
<br>
<table width="409" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="180" class="table1"><b>Name:</b></td>
    <td width="213" class="table1"> 
      <? echo $row['firstname']; ?>
      <? echo $row['lastname']; ?>
    </td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b>Email:</b></td>
    <td width="213" class="table1"> 
      <? echo $row['email']; ?>
    </td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b>Hours:</b></td>
    <td width="213" class="table1"> 
      <? echo $row['hours']; ?>
      , 
      <? echo $row['min']; ?>
    </td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b>Year of birth:</b></td>
    <td width="213" class="table1"> 
      <? echo $row['age']; ?>
    </td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b>Certrificated aircraft:</b></td>
    <td width="213" class="table1"> 
      <? echo $row['aircraft_type']; ?>
    </td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b>Vatsim:</b></td>
    <td width="213" class="table1"> 
      <? echo $row['vatsim_id']; ?>
    </td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b></b></td>
    <td width="213" class="table1">&nbsp;</td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b>MSN:</b></td>
    <td width="213" class="table1"> 
      <? echo $row['msn']; ?>
    </td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b>ICQ:</b></td>
    <td width="213" class="table1"> 
      <? echo $row['icq']; ?>
    </td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b></b></td>
    <td width="213" class="table1">&nbsp;</td>
  </tr>
  <tr> 
    <td width="180" class="table1"><b>Short info about the pilot:</b></td>
    <td width="213" class="table1">&nbsp;</td>
  </tr>
  <tr> 
    <td colspan="2" class="table1" height="2"> 
      <table width="254" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="254"  class="table1"> 
            <? echo $row['comment']; ?>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<? } ?>
<br>
<table width="368" border="0" cellpadding="0" cellspacing="0" height="18">
  <tr>
    <td class="table1" width="397"> 
      <div align="center"><b><a href="javascript:window.close()"><font color="#CE1141">Close 
        window</font></a></b></div>
    </td>
  </tr>
</table>
</body>
</html>

Snälla någon hjälp. :)

PeeerMedlem sedan mars 20025 907 inlägg
#2

Vad händer om du byter ut

$find = mysql_query("SELECT * FROM pilots WHERE id = '$_GET[profile]'");

mot

$find = mysql_query("SELECT * FROM pilots WHERE id = '" . $_GET['profile'] . "'");
Putte_skyMedlem sedan juli 20049 inlägg
#3

Redan fixat det... :)
Var i popup länken felet låg... ;)

Tack iaf. :bire

128 ms totalt · 3 externa anrop · v20260731065814-full.0e50b1ef
0 ms — hämta forumlista (cache)
0 ms — hämta statistik (cache)
125 ms — hämta tråd, inlägg och bilagor (db)