[RESOLVED] Page will not generate :(

[Mercenary]

I'm transferring everything in my site to a database, I got the database set up and I can sort through the data, and I have no problem viewing the files in the database, but when I try to select just ONE item from there and display it on a page, it wont work.

Here is my code:

<table border="2" cellspacing="2" cellpadding="2">
<?
$username="backbrea_testing";
$password="pass";
$database="backbrea_test";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM gameTEST2 WHERE id='$item'";
$result=mysql_query($query);
$num=mysql_numrows($result);

if ($num==0) {
echo "The game you are trying to access does not exist";
} else {
$i=0
while ($i<$num){
$gameName=mysql_result($result,$i,"gameName");
$category=mysql_result($result,$i,"category");
$shortDesc=mysql_result($result,$i,"shortDesc");
$longDesc=mysql_result($result,$i,"longDesc");
$width=mysql_result($result,$i,"width");
$height=mysql_result($result,$i,"height");
$image=mysql_result($result,$i,"image");
$file=mysql_result($result,$i,"file");
?>
<tr>
<tr>
 <td><font face="Arial, Helvetica, sans-serif"><? echo $gameName; ?></font></td>
 </tr>
 <tr>
 <td align="center" border="2" height="$height" width="$width">
 <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=$width HEIGHT=$height>
 <PARAM NAME=movie VALUE=\"$file">
 <PARAM NAME=quality VALUE=high>
 <PARAM NAME=menu VALUE=false>
 <EMBED src=\"$file" quality=high WIDTH=$width HEIGHT=$height TYPE=\"application/x-shockwave-flash\" PLUGINSPAGE=\"http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\" menu=\"false\"></EMBED>
 </OBJECT>
 </td>
 </tr>
 <tr>
  <td><font face="Arial, Helvetica, sans-serif"><? echo $category; ?></font></td>
  </tr>
  <tr>
  <td><font face="Arial, Helvetica, sans-serif"><? echo $longDesc; ?></font></td>
  </tr>
  <td><font face="Arial, Helvetica, sans-serif"><a href="<? echo $file; ?>"><? echo $file; ?></a></font></td>
</tr>
<?
$i++
}
}
echo "</table>";
?>

I made sure all the variables match, but it just wont show anything.

here is the link to the "items" in the DB, they are just a bunch of fake things i threw in there for testing, but they show up fine on the list. If you click on the image, it's suppose to take you to the page where you can actually see the file, and The code I posted above is what the page is made out of, it wont work.
http://www.backbreakergames.com/testSite/display2.php

Any help will be appreciated! Thanks 🙂

[NogDog]

Lines 15 and 50 are missing terminal semi-colons, so right now the page won't even parse. (You might want to look into using an editor with built-in syntax checking, such as Komodo Edit, NetBeans, Notepad++, etc.; as it can be a big time-saver.)

[dagon]

change

mysql_connect(localhost,$username,$password);

(its exiting on the line after this)
to

mysql_connect(localhost,$username,$password) or die('Not connected : ' . mysql_error());

[Mercenary]

I made the changes, and It still wont find the "game". It connects to the DB just fine, but the query for the DB doesn't return any results.

[djjjozsi]

$item is undefined variable.

if its empty, then your select wanted to select where the id is empty (this could never happens)

and mysql_numrows is not a valid function to get the number of your results...

[Mercenary]

$item is defined in the URL as a number when you call for the script

[djjjozsi]

no, its not. you reach the vars from the link with $_GET array.

[Mercenary]

Oh..so I just have to define it with a "Get" before using it in the script?
Sorry, I just started learning about php like 2 days ago, I've coded Action Script in flash a lot so I can understand how some of it works, but there are things in here that are quiet different.

would it just be

$item = $_GET["$item"];

[djjjozsi]

<?php
$item = $_GET["item"]
?>

But nowdays the concept is you should not use a variable which has not set.

if(isset($_GET["item"]))
{
// do something you want to do with the variable
// select and display record
}

[Mercenary]

sweet! It works! Thanks so much! The only problem I have now is that the SWF file isn't showing up, but that should be an easy fix.

[Mercenary]

yup, fixed! Thanks 🙂

[djjjozsi]

Don't forget to set this thread as resolved if you think you got the answer, please.