A Total Query Newb! Php MySQL Query

f1del1ty

ok, so I'm working on a profile for myself for my clan. We run a CS server with WC3 FT installed. IT uses XP, which is saved to a MySQL table. What I want to accomplish is to get the XP for myself for a certain race, and put the XP that I have in a table across from my Race. Here's the link so you can see the setup of the page:

http://www.teamoxi.ath.cx/f1del1ty.php

I've gotten this far, I know the query. It's :

SELECT xp
FROM war3users
WHERE playername='f1del1ty.oXi^Deagle' AND race = '1'

And it's worked in MySQL CC, but I just don't know how to code it in php and on my site. Any help would be appreciated. I know you all are busy and everything, but thanks anyways for whatever you guys say!

Shrike

It's really no more complicated that what you have.

$qry = "
 SELECT xp 
 FROM `war3users` 
 WHERE playername='f1del1ty.oXi^Deagle' AND race = '1' 
";
$result = mysql_query($qry);
$data = mysql_fetch_assoc($result);
// $data will contain a row returned from the database, if the query was successful
// To fetch multiple rows you need to use a while:
while($data = mysql_fetch_assoc($result))
{
  // Do something with each row
}

f1del1ty

Well since I've been trying to figure this out I posted that question on a couple different forums. I finally got my answer a bit before yours. Here's what I had.

<?php
$conn=mysql_connect('localhost', 'amxuser', '******') or die('could not connect'); //establish connection
$query = "SELECT playername, xp, race, skill1, skill2, skill3, skill4 FROM amx.war3users WHERE playername='f1del1ty.oXi' AND race='1'"; 
$results = @mysql_query($query); 
$result = mysql_fetch_array($results); // grabs the row and chops it up into an array where the 
//column names from your MySQL table are the array keys 

$playername = $result['playername']; // the word inside the brackets is the exact name of your MySQL column 
$xp = $result['xp']; 
$race = $result['race']; 
$skill1 = $result['skill1']; 
$skill2 = $result['skill2'];
$skill3 = $result['skill3'];
$skill4 = $result['skill4'];

echo '<table width="30%" border="0"><tr>';
echo '<td align="left"><b>Race:</b> Undead Scourge</td>';
echo '<td align="right"><b>XP:</b> ' .$xp .'</td></tr>';
echo '</table>'; 
?>

But what I'm trying to do now is allow players to see how much XP they have for each race....and I'm using a form to do so. the website: http://www.teamoxi.ath.cx/xp.php

the code:

<h3><u>Search By Player Name</u></h3>
<form method="post" action="getxp.php">
Player Name (What your last known name was):<br /><input name="name" type="text" size="30" maxlength="40" /><br />
<input type="submit" value="Send" />&nbsp;<input type="reset" value="Reset" />
<br>
<br>
<br>
OR
<br>
<br>
<h3><u>Search By STEAM ID</u></h3>
<form method="post" action="getxp.php">
Player ID (STEAM_*:***** Format):<br /><input name="id" type="text" size="30" maxlength="40" /><br />
<input type="submit" value="Send" />&nbsp;<input type="reset" value="Reset" />

What I'm trying to do is make them so that if they use one or the other, they get the same output. And I don't know how to query that kind of stuff...so I'm at a roadblock for now.