Need some display help

fewchurpro · February 28, 2006

Sorry Im pretty noobish and have been beating myself pretty hard on my issue, including going thru books and all the php/mysql pages. So here is what Im tryin to accomplish.

I run a gaming site, and have been putting weapons, armor, etc into a database. What im trying to accomplish is when they go to the page for like say weapons they get a menu of the items. I have started one and got the menu part to work at [a href=\"http://osa.guild-studio.com/index2.php\" target=\"_blank\"]http://osa.guild-studio.com/index2.php[/a]

I tried using some help from one of the books I purchased on php a while back on how to make the individual item show up when you click on the name but thus far, ive been completely unsuccessful. I'll copy and paste the files I've been butchering up here and hopefully someone can help me out. (UN and PW intentionally not there for this)

NOTE: I am in no way needing people to log-in, edit, modify, change, add, delete or anything, this is strictly for VIEWING only.

Files:

index.php

[code]<?
mysql_connect("localhost", "*******", "*****");
mysql_select_db("guild_xmltestingdb") or die( "Unable to select database");
$query="SELECT * FROM ds_weaponshib";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<center>Database Output</center> ";

?>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th>Weapon</th>
</tr>

<?
$i=0;
while ($i < $num) {
$wep_id=mysql_result($result,$i,"wep_id");
$Itemname=mysql_result($result,$i,"Itemname");
?>

<tr>
<td><a href="show_weapon.php?wep_id=$wep_id\"><? echo "$Itemname"; ?></a></td>
</tr>
<?
++$i;
}
echo "</table>";

?>[/code]

And the file to show the item

show_weapon.php

[code]<?

$db_name = "guild_xmltestingdb";
$table_name = "ds_weaponshib";

$connection = @mysql_connect("localhost", "****", "****") or die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$chk_id = "SELECT id FROM $table_name WHERE wep_id = \"$wep_id\"";
$chk_id_res = @mysql_query($chk_id,$connection) or die("Couldn't execute query.");
$chk_id_num = mysql_num_rows($chk_id_res);

{

 $sql = "SELECT wep_id, Itemname, Quality, Level, DPS, Speed, Bonus, Dam_type, Location, Offhand, s1_effect, s1_amount, s2_effect, s2_amount, s3_effect, s3_amount, s4_effect, s4_amount, s5_effect, s5_amount, s6_effect, s6_amount
 FROM $table_name
 WHERE wep_id = \"$wep_id\"
 ";

 $result = @mysql_query($sql,$connection) or die("Couldn't execute query.");

 while ($row = mysql_fetch_array($result)) {
 $wep_id = $row['wep_id'];
 $Itemname = $row['Itemname'];
 $Quality = $row['Quality'];
 $Level = $row['Level'];
 $DPS = $row['DPS'];
 $Speed = $row['Speed'];
 $Bonus = $row['Bonus'];
 $Dam_type = $row['Dam_type'];
 $Location = $row['Location'];
 $Offhand = $row['Offhand'];
 $s1_effect = $row['s1_effect'];
 $s1_amount = $row['s1_amount'];
 $s2_effect = $row['s2_effect'];
 $s2_amount = $row['s2_amount'];
 $s3_effect = $row['s3_effect'];
 $s3_amount = $row['s3_amount'];
 $s4_effect = $row['s4_effect'];
 $s4_amount = $row['s4_amount'];
 $s5_effect = $row['s5_effect'];
 $s5_amount = $row['s5_amount'];
 $s6_effect = $row['s6_effect'];
 $s6_amount = $row['s6_amount'];

 }

}

?>

<HTML>
<HEAD>
<TITLE>My Weapon Management System: Read-Only Contact Details</TITLE>
</HEAD>
<BODY>

<h1>My Weapon Management System</h1>
<h2>DS Hibernia Weapon Details for <? echo "$Itemname"; ?></h2>

Weapon: 
<? echo "$Itemname"; ?> 
<?
 echo "Quality: $Quality ";
 echo "Level: $Level ";
 echo "DPS: $DPS ";
 echo "Speed: $Speed ";
 echo "Bonus: $Bonus ";
 echo "Type: $Dam_type ";
 echo "Hand: $Location ";
 echo "LH Usable: $Offhand ";
 echo "Slot 1: $s1_amount $s1_effect ";
 echo "Slot 2: $s2_amount $s2_effect ";
 echo "Slot 3: $s3_amount $s3_effect ";
 echo "Slot 4: $s4_amount $s4_effect ";
 echo "Slot 5: $s5_amount $s5_effect ";
 echo "Slot 6: $s6_amount $s6_effect ";
?>

</BODY>
</HTML>
[/code]

Its probably very messy, again im pretty new and have been trying hard to get it right.

fenway · March 1, 2006

I don't really understand why you don't put the ouput in the while loop (which should be an if, btw, since you're searching by UID). That way, you can skip all those variable assignments and just do the output straight.

fewchurpro · March 1, 2006

[!--quoteo(post=350456:date=Feb 28 2006, 05:32 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Feb 28 2006, 05:32 PM) [snapback]350456[/snapback][/div][div class=\'quotemain\'][!--quotec--]
I don't really understand why you don't put the ouput in the while loop (which should be an if, btw, since you're searching by UID). That way, you can skip all those variable assignments and just do the output straight.
[/quote]

Mostly because Im new and dont really know any better. My poor eyes are burned out trying to sort thru this and looking up info to help me do this. Im pretty lost now. :(

fewchurpro · March 1, 2006

What can I do with what I have there? Or do I need to just scrap the whole project and start at ground zero?

wickning1 · March 1, 2006

<a href="show_weapon.php?wep_id=$wep_id\"><? echo "$Itemname"; ?></a>

You are in HTML mode when you call $wep_id. Do this instead:
<a href="show_weapon.php?wep_id=<? echo "$wep_id\"> $Itemname"; ?></a>

fewchurpro · March 1, 2006

[!--quoteo(post=350517:date=Feb 28 2006, 09:31 PM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Feb 28 2006, 09:31 PM) [snapback]350517[/snapback][/div][div class=\'quotemain\'][!--quotec--]
<a href="show_weapon.php?wep_id=$wep_id\"><? echo "$Itemname"; ?></a>

You are in HTML mode when you call $wep_id. Do this instead:
<a href="show_weapon.php?wep_id=<? echo "$wep_id\"> $Itemname"; ?></a>
[/quote]

That worked. Thank you so much for the help.

/bows

Sign In

Need some display help

Recommended Posts

fewchurpro

Link to comment

Share on other sites

fenway

Link to comment

Share on other sites

fewchurpro

Link to comment

Share on other sites

fewchurpro

Link to comment

Share on other sites

wickning1

Link to comment

Share on other sites

fewchurpro

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information