[RESOLVED] Script Idea / Would it be possible?

[quiksilver]

Hey all. I am looking to create a php script that will allow me to edit and add members to my gaming teams roster.

Lets say you fill out a file that has a form in it with all kinds of different things about a member lets call it submit.php

when you hit the submit button it posts to a database. you then have a table that comes up w/ something like this:

Member # Member Name#

1 Quiksilver (edit) (delete)
2 Zero (edit) (delete)
3 KingKong (edit) (delete)

and so on.

then when a member goes to say members.php?id=1 then it will being up quiksilver profile or if they go to members.php?id=2 they go to zeros profle.

when you click on the "edit" link it will bring up the information in the form already filled out w/ the members info in it. You can just edit the information and click submit and it will edit the info in the MySQL DB.

When you click on the "delete" link it will drop the member from the database. (It wont replace the member # ... so if I where to delte quiksilver, zero would not drop down to #1 he would still stay #2 so the links dont change.

here is an example profile:

http://dev.ax51.com/members/quiksilver.php

does anyone know if this would be possible? and if so how would u go about doing it?

[Installer]

Just start coding it. Set up the database first and go from there, with test data and code. It's a good, solid plan and standard stuff.

[quiksilver]

Alright i have a database.

CREATE TABLE `members`  (
    `id` int(11) NOT NULL auto_increment,
    `name` varchar(255) NOT NULL default '',
    `age` varchar(22) NOT NULL default '',
    `sex` varchar(22) NOT NULL default '',
    `country` varchar(22) NOT NULL default '',
    `status` varchar(22) NOT NULL default '',
    `game` varchar(22) NOT NULL default '',
    `website` varchar(22) NOT NULL default '',
    `xfire` varchar(22) NOT NULL default '',
    `biography` text NOT NULL,
    `manufacturer` varchar(22) NOT NULL default '',
    `os` varchar(22) NOT NULL default '',
    `cpu` varchar(22) NOT NULL default '',
    `memory` varchar(22) NOT NULL default '',
    `harddrive` varchar(22) NOT NULL default '',
    `videocard` varchar(22) NOT NULL default '',
    `soundcard` varchar(22) NOT NULL default '',
    `monitor` varchar(22) NOT NULL default '',
    `mouse` varchar(22) NOT NULL default '',
    `mousepad` varchar(22) NOT NULL default '',
    `keyboard` varchar(22) NOT NULL default '',

PRIMARY KEY (`id`)
)   TYPE=MyISAM AUTO_INCREMENT=1;

I am new to PHP. How would i code the submit.php. So that every new entry is assigned a new page such as members.php?id=2.

right now if i where to code it how it is the infomration would just keep getting posted on one page?

[Houdini]

First let me see if I get this right. You want to create a page that will be accessed by typing a key value pair into the url like members.php?id=10 then it will show the profile of whoever member 10 is on that page...right? Then this user can edit member 10's information and if they want delete that member from the database? Well what if one member gets mad and deletes everybody, or they write some really crappy stuff about all the member that they don't like?

[quiksilver]

I would have the submit.php in an admin section of the site so only the administrator can add and edit info about members. members will not be able to edit information. when you click submit.php then a new page will be created ie: members.php?id=10. when a user goes to that page they can view something like:

http://dev.ax51.com/members/quiksilver.php.

only where you see $age and $xfire ... etc. it will be pulling the information off the database.

the submit.php would look like this:
http://dev.ax51.com/members/submit.php

[Houdini]

Well then make a single submit.php or edituser.php page that you send the desired user if throught the URL like submit.php?id=1 or edituser.php?id=4 then use $GET['id'] to retrieve the desired user and use a

$id=$_GET['id'];
$query="SELECT desiredcolumnname(s) FROM table WHERE id='$id'";
//do something with the data from the table

[quiksilver]

i am not sure i know what you mean...

"that you send the desired user if throught the URL like submit.php?id=1 or edituser.php?id=4"

[Houdini]

What I mean is that you are sending a query through the URL to a page that will process the query. So to do this let us take a user with id 3. So we access the processing page by typing submit.php?id=3 which will send the key of id with a value of 3 to the processing page (submit.php) and submit php will then GET this information using the $GET predefined array. $GET['id'] will produce a value of 3 which was sent in the URL string of submit.php?id=3. Then You could lookup the id in the database and then do whatever you want to with it.

[thorpe]

Oh...c'mon. The biggest part of learning to program is learning to think a problem through, if you can't you'll never get anywhere.

Do you really want us to write this for you every step of the way?

You might start by reading this. This will give you a good grounding in php (and programming) concepts, from there, the solution to your problem will become clear.

Sorry, if I sound a little harsh, but there's only so many things we can help with. This sort of thing is what tutorials and books are for, were more help when you have a specific problem.

[quiksilver]

So far this is what i have put into my members.php. I got the submit.php to work right now i am not sure why this wont pull out info to the page.

 <?php
include("dbconnect.php");//include the file to connect to the database
$getmembers = mysql_query("SELECT * FROM members ORDER BY id DESC");//query the database for all of the news

while($r=mysql_fetch_array($getmembers)){//while there are rows in the table
extract($r);//remove the $r so its just $variable
?>


<style type="text/css">
<!--
.style1 {color: #FFFFFF}
.style2 {	color: #FF0000;
	font-weight: bold;
}
.style3 {color: #FF0000}
.style4 {color: #000000}
.style5 {color: #000000; font-weight: bold; }
-->
</style>
<?php
echo("<table width="494" border="0" cellpadding="0" cellspacing="0" background="../clan/images/contentbg45.gif">
  <tr>
    <td width="3" valign="middle" bgcolor="#000000"></td>
    <td width="366" height="28" valign="middle" bgcolor="#000000"><div align="right" class="style1">
      <div align="left"><strong>Quiksilver</strong></div>
    </div></td>
    <td width="122" valign="middle" bgcolor="#000000"></td>
    <td width="3" valign="middle" bgcolor="#000000"></td>
  </tr>
</table>
<table width="494" border="0" cellpadding="0" cellspacing="0" background="images/contentg56.gif">
  <tr>
    <td width="16"></td>
    <td width="161" height="25"><div align="center" class="style2">
      <div align="left" class="style4">User Information:</div>
    </div></td>
    <td width="290"></td>
    <td width="27"></td>
  </tr>
  <tr>
    <td></td>
    <td height="25"><div align="left" class="style3">Name:</div></td>
    <td><div align="left">   $name

</div></td>
<td></td>
  </tr>
  <tr>
    <td></td>
    <td height="25"><span class="style3">Age: </span></td>
    <td><div align="left">  $age 
    </div></td>
    <td></td>
  </tr>
  <tr>
    <td></td>
    <td height="25"><span class="style3">Sex:</span></td>
    <td><div align="left">  $sex </div></td>
    <td></td>
  </tr>
  <tr>
    <td></td>
    <td height="25"><span class="style3">Country:</span></td>
    <td><div align="left">  $country</div></td>
    <td></td>
  </tr>
  <tr>
    <td></td>
    <td height="25"><span class="style3">Status:</span></td>
    <td><div align="left">  $status </div></td>
    <td></td>
  </tr>
  <tr>
    <td></td>
    <td height="25"><span class="style3">Game:</span></td>
    <td><div align="left">  $game  </div></td>
    <td></td>
  </tr>
  <tr>
    <td></td>
    <td height="25"><span class="style2"><span class="style4">Contact Information:</span></span></td>
    <td></td>
    <td></td>
  </tr>
  <tr>
    <td></td>
    <td height="25"><span class="style3">Website:</span></td>
    <td><div align="left">   <a href="$website">$website</a>;  </div></td>
    <td></td>
  </tr>
  <tr>
    <td></td>
    <td height="25"><span class="style3">Xfire Name: </span></td>
    <td><div align="left">   $xfire  </div></td>
    <td></td>
  </tr>
</table>
  <table width="494" border="0" cellpadding="0" cellspacing="0" background="../images/contentbg45.gif">
      <tr>
        <td width="14"></td>
        <td width="453"><span class="style5">Biography: </span></td>
        <td width="27"></td>
      </tr>
      <tr>
        <td></td>
        <td>    $biography    </td>
        <td></td>
      </tr>
</table>
<table width="494" border="0" cellpadding="0" cellspacing="0" background="images/contentg56.gif">
  <tr>
    <td width="16"></td>
    <td width="161" height="25"><div align="center" class="style2">
      <div align="left" class="style4">Computer Specifications: </div>
    </div></td>
    <td width="290"></td>
    <td width="27"></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><div align="left" class="style3">Manufacturer:</div></td>
    <td><div align="left">
      <div align="left">   $manufacturer </div>
    </div></td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">OS:</span></td>
    <td><div align="left">   $os  </div></td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">CPU:</span></td>
    <td><div align="left">   $cpu  </div></td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Memory:</span></td>
    <td><div align="left">   $memory</div></td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">HardDrive:</span></td>
    <td><div align="left">   $harddrive  </div></td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Video Card:</span></td>
    <td><div align="left">   $videocard   </div></td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Sound Card : </span></td>
    <td>   $soundcard   </td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Headphones:</span></td>
    <td><div align="left">
      <div align="left">   $headphones   </div>
    </div></td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Monitor:</span></td>
    <td><div align="left">   $monitor  </div></td>
    <td></td>
  </tr>
  <tr>
<td><span class="style3"></span></td>
    <td height="25"><span class="style3">Mouse:</span></td>
    <td>   $mouse</td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Mousepad:</span></td>
    <td>   $mousepad   </td>
    <td></td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Keyboard:</span></td>
    <td>   $keyboard   </td>
    <td></td>
  </tr>
</table>
    <table width="494" border="0" cellpadding="0" cellspacing="0" background="../clan/images/contentbg45.gif">
      <tr>
        <td width="3" valign="middle" bgcolor="#000000"></td>
        <td width="366" height="15" valign="middle" bgcolor="#000000"></td>
        <td width="122" valign="middle" bgcolor="#000000"></td>
        <td width="3" valign="middle" bgcolor="#000000"></td>
      </tr>
    </table>
	<br />
	<div align="center"><a href=http://profile.xfire.com/quiksilver16><img src=http://miniprofile.xfire.com/bg/bg/type/0/quiksilver16.png width=440 height=111></a><br />
	  <br />
      <br />
</div>");

}
?>

[quiksilver]

I get the following error when i view the quiksilver.php which i am trying to post the data in from the db.

Parse error: syntax error, unexpected T_LNUMBER in /home/ax51/public_html/dev/members/quiksilver.php on line 15

[Houdini]

Show the few lines just before and including line 15. also in the code above there are already problems namely starting here.

<?php 
echo("<table width="494" border="0" cellpadding="0" cellspacing="0" background="../clan/images/contentbg45.gif"> 
  <tr> 
    <td width="3" valign="middle" bgcolor="#000000"></td> 
//more plain HTML till the
?>

[quiksilver]

alright nevermind that i was trying all kinds of different things untell one worked lol.

i made it so when you fill out submit.php it posts to a mysql database.
then when you visit quiksilver.php the information you submited to the database apears in the correct spots.

here is the quiksilver.php code.

<?php
include("dbconnect.php");//include the file to connect to the database
$getmembers = mysql_query("SELECT * FROM members ORDER BY id DESC");//query the database for all of the news

while($r=mysql_fetch_array($getmembers)){//while there are rows in the table
extract($r);//remove the $r so its just $variable


}
?>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
.style2 {	color: #FF0000;
	font-weight: bold;
}
.style3 {color: #FF0000}
.style4 {color: #000000}
.style5 {color: #000000; font-weight: bold; }
-->
</style>
<table width="494" border="0" cellpadding="0" cellspacing="0" background="../clan/images/contentbg45.gif">
  <tr>
    <td width="3" valign="middle" bgcolor="#000000"></td>
    <td width="366" height="28" valign="middle" bgcolor="#000000"><div align="right" class="style1">
      <div align="left"><strong>Quiksilver</strong></div>
    </div></td>
    <td width="122" valign="middle" bgcolor="#000000">&nbsp;</td>
    <td width="3" valign="middle" bgcolor="#000000">&nbsp;</td>
  </tr>
</table>
<table width="494" border="0" cellpadding="0" cellspacing="0" background="images/contentg56.gif">
  <tr>
    <td width="16">&nbsp;</td>
    <td width="161" height="25"><div align="center" class="style2">
      <div align="left" class="style4">User Information:</div>
    </div></td>
    <td width="290">&nbsp;</td>
    <td width="27">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><div align="left" class="style3">Name:</div></td>
    <td><div align="left"> <?php echo("$name"); ?>

</div></td>
<td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Age: </span></td>
    <td><div align="left"><?php echo("$age");  ?>
    </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Sex:</span></td>
    <td><div align="left"><?php echo("$sex");  ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Country:</span></td>
    <td><div align="left"><?php echo("$country");  ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Status:</span></td>
    <td><div align="left"><?php echo("$status"); ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Game:</span></td>
    <td><div align="left"><?php echo("$game");  ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style2"><span class="style4">Contact Information:</span></span></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Website:</span></td>
    <td><div align="left"> <?php echo("$website");  ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Xfire Name: </span></td>
    <td><div align="left"> <?php echo("$xfire");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
</table>
  <table width="494" border="0" cellpadding="0" cellspacing="0" background="../images/contentbg45.gif">
      <tr>
        <td width="14">&nbsp;</td>
        <td width="453"><span class="style5">Biography: </span></td>
        <td width="27">&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>  <?php echo("$biography");  ?>  </td>
        <td>&nbsp;</td>
      </tr>
</table>
<table width="494" border="0" cellpadding="0" cellspacing="0" background="images/contentg56.gif">
  <tr>
    <td width="16">&nbsp;</td>
    <td width="161" height="25"><div align="center" class="style2">
      <div align="left" class="style4">Computer Specifications: </div>
    </div></td>
    <td width="290">&nbsp;</td>
    <td width="27">&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><div align="left" class="style3">Manufacturer:</div></td>
    <td><div align="left">
      <div align="left"> <?php echo("$manufacturer");  ?> </div>
    </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">OS:</span></td>
    <td><div align="left"> <?php echo("$os");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">CPU:</span></td>
    <td><div align="left"> <?php echo("$cpu");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Memory:</span></td>
    <td><div align="left"> <?php echo("$memory");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">HardDrive:</span></td>
    <td><div align="left"> <?php echo("$harddrive");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Video Card:</span></td>
    <td><div align="left"> <?php echo("$videocard");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Sound Card : </span></td>
    <td> <?php echo("$soundcard");  ?> </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Headphones:</span></td>
    <td><div align="left">
      <div align="left"> <?php echo("$headphones");  ?> </div>
    </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Monitor:</span></td>
    <td><div align="left"> <?php echo("$monitor");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Mouse:</span></td>
    <td> <?php echo("$mouse");  ?> </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Mousepad:</span></td>
    <td> <?php echo("$mousepad");  ?> </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Keyboard:</span></td>
    <td> <?php echo("$keyboard");  ?> </td>
    <td>&nbsp;</td>
  </tr>
</table>
    <table width="494" border="0" cellpadding="0" cellspacing="0" background="../clan/images/contentbg45.gif">
      <tr>
        <td width="3" valign="middle" bgcolor="#000000"></td>
        <td width="366" height="15" valign="middle" bgcolor="#000000">&nbsp;</td>
        <td width="122" valign="middle" bgcolor="#000000">&nbsp;</td>
        <td width="3" valign="middle" bgcolor="#000000">&nbsp;</td>
      </tr>
    </table>
	<br />
	<div align="center"><a href=http://profile.xfire.com/quiksilver16><img src=http://miniprofile.xfire.com/bg/bg/type/0/quiksilver16.png width=440 height=111></a><br />
	  <br />
      <br />
</div>

you can test it out for your self if you would like
http://dev.ax51.com/members/submit.php

http://dev.ax51.com/members/quiksilver.php

is there any tutorial that you know of that i can read about how submiting members.php?id=2 works??

[dmacman1962]

[edit] You did essentially the same thing and posted seconds before my post[/edit]

You have this...

<?php
echo("<table.......

just do

<?php
echo "(";
?>
<table...... as normal HTML to the end

then close the php like this...

</div>
<?php
echo ")";

}
?>

I found it a lot easier to break my code apart like this, than try to escape all the HTML correctly.

Don

[quiksilver]

With the way you have could i have just put in $age
$name etc... w/ out having to do <?php echo("$age") ?>

[quiksilver]

alright. i am now trying to make it so that if you go to quiksilver.php?id=2 that it will show the persons info who was givin id# 2. here is the code that i have so far.

<?php
include("dbconnect.php");//include the file to connect to the database
$getmembers = mysql_query("SELECT * FROM members ORDER BY id DESC");//query the database for all of the news

while($r=mysql_fetch_array($getmembers)){//while there are rows in the table
extract($r);//remove the $r so its just $variable

$id=$_GET['id'];
$query="SELECT name, age, sex, country, status, game, website, xfire, biography, manufacturer, os, cpu, memory, harddrive, videocard, soundcard, headphones, monitor, mouse, mousepad, keyboard FROM members WHERE id='$id'";
//do something with the data from the table 
}
?>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
.style2 {	color: #FF0000;
	font-weight: bold;
}
.style3 {color: #FF0000}
.style4 {color: #000000}
.style5 {color: #000000; font-weight: bold; }
-->
</style>
<table width="494" border="0" cellpadding="0" cellspacing="0" background="../clan/images/contentbg45.gif">
  <tr>
    <td width="3" valign="middle" bgcolor="#000000"></td>
    <td width="366" height="28" valign="middle" bgcolor="#000000"><div align="right" class="style1">
      <div align="left"><strong>Quiksilver</strong></div>
    </div></td>
    <td width="122" valign="middle" bgcolor="#000000">&nbsp;</td>
    <td width="3" valign="middle" bgcolor="#000000">&nbsp;</td>
  </tr>
</table>
<table width="494" border="0" cellpadding="0" cellspacing="0" background="images/contentg56.gif">
  <tr>
    <td width="16">&nbsp;</td>
    <td width="161" height="25"><div align="center" class="style2">
      <div align="left" class="style4">User Information:</div>
    </div></td>
    <td width="290">&nbsp;</td>
    <td width="27">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><div align="left" class="style3">Name:</div></td>
    <td><div align="left"> <?php echo("$name"); ?>

</div></td>
<td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Age: </span></td>
    <td><div align="left"><?php echo("$age");  ?>
    </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Sex:</span></td>
    <td><div align="left"><?php echo("$sex");  ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Country:</span></td>
    <td><div align="left"><?php echo("$country");  ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Status:</span></td>
    <td><div align="left"><?php echo("$status"); ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Game:</span></td>
    <td><div align="left"><?php echo("$game");  ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style2"><span class="style4">Contact Information:</span></span></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Website:</span></td>
    <td><div align="left"> <?php echo("$website");  ?></div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="25"><span class="style3">Xfire Name: </span></td>
    <td><div align="left"> <?php echo("$xfire");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
</table>
  <table width="494" border="0" cellpadding="0" cellspacing="0" background="../images/contentbg45.gif">
      <tr>
        <td width="14">&nbsp;</td>
        <td width="453"><span class="style5">Biography: </span></td>
        <td width="27">&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>  <?php echo("$biography");  ?>  </td>
        <td>&nbsp;</td>
      </tr>
</table>
<table width="494" border="0" cellpadding="0" cellspacing="0" background="images/contentg56.gif">
  <tr>
    <td width="16">&nbsp;</td>
    <td width="161" height="25"><div align="center" class="style2">
      <div align="left" class="style4">Computer Specifications: </div>
    </div></td>
    <td width="290">&nbsp;</td>
    <td width="27">&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><div align="left" class="style3">Manufacturer:</div></td>
    <td><div align="left">
      <div align="left"> <?php echo("$manufacturer");  ?> </div>
    </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">OS:</span></td>
    <td><div align="left"> <?php echo("$os");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">CPU:</span></td>
    <td><div align="left"> <?php echo("$cpu");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Memory:</span></td>
    <td><div align="left"> <?php echo("$memory");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">HardDrive:</span></td>
    <td><div align="left"> <?php echo("$harddrive");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Video Card:</span></td>
    <td><div align="left"> <?php echo("$videocard");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Sound Card : </span></td>
    <td> <?php echo("$soundcard");  ?> </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Headphones:</span></td>
    <td><div align="left">
      <div align="left"> <?php echo("$headphones");  ?> </div>
    </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Monitor:</span></td>
    <td><div align="left"> <?php echo("$monitor");  ?> </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Mouse:</span></td>
    <td> <?php echo("$mouse");  ?> </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Mousepad:</span></td>
    <td> <?php echo("$mousepad");  ?> </td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style3"></span></td>
    <td height="25"><span class="style3">Keyboard:</span></td>
    <td> <?php echo("$keyboard");  ?> </td>
    <td>&nbsp;</td>
  </tr>
</table>
    <table width="494" border="0" cellpadding="0" cellspacing="0" background="../clan/images/contentbg45.gif">
      <tr>
        <td width="3" valign="middle" bgcolor="#000000"></td>
        <td width="366" height="15" valign="middle" bgcolor="#000000">&nbsp;</td>
        <td width="122" valign="middle" bgcolor="#000000">&nbsp;</td>
        <td width="3" valign="middle" bgcolor="#000000">&nbsp;</td>
      </tr>
    </table>
	<br />
	<div align="center"><a href=http://profile.xfire.com/<?php echo("$xfire");  ?>><img src=http://miniprofile.xfire.com/bg/bg/type/0/<?php echo("$xfire");  ?>.png width=440 height=111></a><br />
	  <br />
      <br />
</div> 

[ClarkF1]

what's the problem???

[quiksilver]

When i go to quiksilver.php?id=2 it still shows id 1 info.

[quiksilver]

hmmm... does anyone understand what i am trying to do? i am def not the best communicator. I dont think it could be that difficult to do but i cant seem to figure it out.

[ClarkF1]

You have a second query called $query but you haven't actually queried the database using mysql_query($query)........

This would provide the results and then you could display the appropriate results.