Jump to content

Retrieving data from the database problem

djbaze

By djbaze
in Regex Help

Recommended Posts

djbaze Newbie

djbaze

Posted
Posted

Hello Everybody,

I have a problem with my php code, where I'm trying to retrieve some data from a MYSQL Database.

I don't know why it doens't work, I have another script where I use the same trick, and there it works perfect!

Here the code of the not working page:

<?php
/* Here i set the value that will be if you havent set a value jet. */
$airline = ''; 
$aircraft  = '';
/* Here i check if one of the values have been set and then sets the value to what the value have been set too */
if(isset($_GET["airline"])) $airline=$_GET["airline"];
if(isset($_GET["aircraft"])) $aircraft=$_GET["aircraft"];


/* Lets do the queries! */

$db_host = 'localhost';
$db_user = 'xxx';
$db_pwd  = 'xxxx';

$database = 'ricardoaircrash';
$table = 'content';

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

$query="SELECT * FROM content WHERE airline='$airline'";
$query2="SELECT * FROM content WHERE aircraft='$aircraft'";
$result=mysql_query($query);
$result2=mysql_query($query2);

if (!airline) {
$num=mysql_numrows($result2); } else {
$num=mysql_numrows($result); }
?>

<?php
$i=0;
while ($i < $num) {

// here I check wherever you searched on a aircraft or airline..
if (!$aircraft){
$f1=mysql_result($result,$i,"airline");
$f2=mysql_result($result,$i,"aircraft");
$f5=mysql_result($result,$i,"crashdate");
$f3=mysql_result($result,$i,"content");
$f4=mysql_result($result,$i,"image");}
else {
$f1=mysql_result($result2,$i,"airline");
$f2=mysql_result($result2,$i,"aircraft");
$f5=mysql_result($result2,$i,"crashdate");
$f3=mysql_result($result2,$i,"content");
$f4=mysql_result($result2,$i,"image");
}



// and then I echo the value's..
?>

<div align="center"><?php echo $f1; ?> <?php echo $f2; ?>  <?php echo $f5; ?><br><?php echo $f3; ?><br><br><?php echo $f4; ?><br></div>
<?php
$i++; }
?>

 

The thing is, when I search on a Airline, the script does his job, but when I search on a Aircraft, nothing happends...

 

Then the code that does work (i'm sorry, this is with some tables, and im sorry, but no comments......):

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<!-- saved from url=(0014)about:internet -->
  <title>Aviation & Flight Simulator - History of Aviation</title>


  <meta content="text/html; charset=utf-8" http-equiv="Content-Type" />

  <style type="text/css">td img {display: block;}</style>
  <link rel="stylesheet" href="style.css" type="text/css" />

  <script type="text/javascript" src="timeFormat.js"></script>
  <script type="text/javascript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_nbGroup(event, grpName) { //v6.0
var i,img,nbArr,args=MM_nbGroup.arguments;
if (event == "init" && args.length > 2) {
if ((img = MM_findObj(args[2])) != null && !img.MM_init) {
img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src;
if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new Array();
nbArr[nbArr.length] = img;
for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = img.MM_dn = args[i+1];
nbArr[nbArr.length] = img;
} }
} else if (event == "over") {
document.MM_nbOver = nbArr = new Array();
for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) != null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = (img.MM_dn && args[i+2]) ? args[i+2] : ((args[i+1])? args[i+1] : img.MM_up);
nbArr[nbArr.length] = img;
}
} else if (event == "out" ) {
for (i=0; i < document.MM_nbOver.length; i++) {
img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn : img.MM_up; }
} else if (event == "down") {
nbArr = document[grpName];
if (nbArr)
for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up; img.MM_dn = 0; }
document[grpName] = nbArr = new Array();
for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = img.MM_dn = (args[i+1])? args[i+1] : img.MM_up;
nbArr[nbArr.length] = img;
} }
}
//-->
  </script>  <link rel="stylesheet" type="text/css" href="chrometheme/chromestyle.css" />

<script type="text/javascript" src="chromejs/chrome.js"></script>

</head>



<body onload="show_clock();MM_preloadImages('images/Home-Clicked.jpg','images/Home-Rollover.jpg','images/HistoryofFS-Clicked.jpg','images/HistoryofFS-Rollover.jpg','images/HisAV-Original.jpg','images/HisAV-Rollover.jpg','images/Planes-Clicked.jpg','images/Planes-Rollover.jpg')" style="background-color: rgb(255, 255, 255);">

<div align="center">
<div style="width:800px">
<div style="text-align: center;"><div class="chromestyle" id="chromemenu">
<ul>
<li><a href="#">Home</a></li>
<li><a href="#" rel="dropmenu1">History of FS</a></li>
<li><a href="#" rel="dropmenu2">History of Aviation</a></li>
<li><a href="#" rel="dropmenu3">Planes</a></li>	
</ul>
</div>

<!--1st drop down menu -->                                                   
<div id="dropmenu1" class="dropmenudiv">
<a href="hisfs/history.htm">History</a>
<a href="hisfs/difver.htm">Different Version</a>
<a href="hisfs/img.htm">Image Gallery</a>
</div>


<!--2nd drop down menu -->                                                
<div id="dropmenu2" class="dropmenudiv" style="width: 150px;">
<a href="hisav/wb.htm">Wright Brothers</a>
<a href="hisav/klm.htm">KLM</a>
<a href="hisav/fokker.htm">Fokker</a>
</div>

<!--3rd drop down menu -->                                                   
<div id="dropmenu3" class="dropmenudiv" style="width: 150px;">
<a href="plns/boeing.htm">Boeing</a>
<a href="plns/airbus.htm">Airbus</a>
<a href="plns/img.htm">Image Gallery</a>
</div></div>


<script type="text/javascript">

cssdropdown.startchrome("chromemenu")

</script></div>

<table align="center" border="0" cellpadding="0" cellspacing="0" width="800">

<!-- fwtable fwsrc="Slicesuiteindelijk.png" fwpage="Page 1" fwbase="Slicesuiteindelijk.jpg" fwstyle="Dreamweaver" fwdocid = "1933032323" fwnested="0" -->
  <tbody>

    <tr>

      <td><img src="images/spacer.gif" alt="" border="0" height="1" width="40" /></td>

      <td><img src="images/spacer.gif" alt="" border="0" height="1" width="720" /></td>

      <td><img src="images/spacer.gif" alt="" border="0" height="1" width="40" /></td>

      <td><img src="images/spacer.gif" alt="" border="0" height="1" width="1" /></td>

    </tr>

    <tr>

      <td rowspan="7" background="images/Overflowleft.jpg" id="Overflowleft" alt="" border="0" height="600" width="40" /></td>

      <td colspan="2"><img name="Slicesuiteindelijk_r1_c2" src="images/Slicesuiteindelijk_r1_c2.jpg" id="Slicesuiteindelijk_r1_c2" alt="" border="0" height="1" width="760" /></td>

      <td><img src="images/spacer.gif" alt="" border="0" height="1" width="1" /></td>

    </tr>

    <tr>

      <td border="0" id="Header" alt="" background="images/Header.jpg" height="160" width="720">
      </td>

      <td rowspan="6" background="images/Overflowright.jpg" id="Overflowright" alt="" border="0" height="599" width="40" /></td>

      <td><img src="images/spacer.gif" alt="" border="0" height="160" width="1" /></td>

    </tr>

    <tr>
<div align="center"></div>
      <td border="0" id="Navbar" alt="" background="images/Navbar.jpg" height="42" width="720">
      	</div>
      </td>

      <td><img src="images/spacer.gif" alt="" border="0" height="42" width="1" /></td>

    </tr>

    <tr>

      <td border="0" id="TimeandText" alt="" background="images/TimeandText.jpg" height="25" width="720">
      <script language="javascript" src="liveclock.js">
<marquee direction="left" loop="50" width="65%">Welcome
on the Aviation & Flight Simulator Site</marquee>
      </script></td>

      <td><img src="images/spacer.gif" alt="" border="0" height="25" width="1" /></td>

    </tr>

    <tr>

      <td rowspan="2" border="0" id="Text" alt="" background="images/Text.jpg" height="349" width="720" valign="top">
<?php
/* Here i set the value that will be if you havnt clicked a on a link. */
$brand = ''; 
$type  = '';
/* Here i tjek if one of the links have been clicked and then sets the value to what the link have been set too */
if(isset($_GET["brand"])) $brand=$_GET["brand"];
if(isset($_GET["type"])) $type=$_GET["type"];


/* Lets do the queries! */

$db_host = 'localhost';
$db_user = 'xxx';
$db_pwd  = 'xxxxx';

$database = 'cms';
$table = 'content';

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

$query="SELECT * FROM content WHERE titel='$brand'";
$query2="SELECT * FROM content WHERE type='$type'";
$query3="SELECT * FROM content WHERE titel='$brand' AND type='$type'";
$result=mysql_query($query);
$result2=mysql_query($query2);
$result3=mysql_query($query3);
$num=mysql_numrows($result);
$num2=mysql_numrows($result2);
$num3=mysql_numrows($result3);
?>

<?php
$i=0;
while ($i < $num) {



if (!$type){
$f1=mysql_result($result,$i,"titel");
$f2=mysql_result($result,$i,"type");
$f3=mysql_result($result,$i,"content");
$f4=mysql_result($result,$i,"image");}
else {
$f1=mysql_result($result3,$i,"titel");
$f2=mysql_result($result3,$i,"type");
$f3=mysql_result($result3,$i,"content");
$f4=mysql_result($result3,$i,"image");
}




?>

<div align="center"><?php echo $f1; ?> <?php echo $f2; ?><br><?php echo $f3; ?><br><br><?php echo $f4; ?><br></div>
<?php
$i++;
}
?>
<div align="center">
<FORM METHOD="LINK" ACTION="planes.htm">
<INPUT TYPE="submit" VALUE="Back to the planes page!">
</FORM></div>
      </td>

      <td><img src="images/spacer.gif" alt="" border="0" height="348" width="1" /></td>

    </tr>

    <tr>

      <td><img src="images/spacer.gif" alt="" border="0" height="1" width="1" /></td>

    </tr>

    <tr>

      <td><img name="Slicesuiteindelijk_r7_c2" src="images/Slicesuiteindelijk_r7_c2.jpg" id="Slicesuiteindelijk_r7_c2" alt="" border="0" height="23" width="720" /></td>

      <td><img src="images/spacer.gif" alt="" border="0" height="23" width="1" /></td>

    </tr>

  </tbody>
</table>

</div>

</body>
</html>

 

 

Can you guys figure this out for me? I'm stuck, I spend the whole day and night on it... :wtf:

Sometimes I think..  :rtfm:

 

DJ Baze

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.