I want to make a profile page for my players but i dont know how can i make this command to work
so:
Code: Select all
SELECT * from characters WHERE name(SELECT login from accounts where login='$login');
So....
I want something like this [ if someone know of corse]
I want to select all of the character for the account "kilimangearo" for exemple.
the function is this:
Code: Select all
<?php
$conn = mysql_connect("localhost","root","password");
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("adb", $conn);
$result = mysql_query("SELECT * from characters WHERE name(SELECT login from accounts where login='$login')");
while($row = mysql_fetch_array($result))
{
echo $row['acct'];
}
mysql_close($conn);
?>
EDIT:
I found out
Code: Select all
<?php
$conn = mysql_connect("localhost","root","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("adb", $conn);
$result = mysql_query("SELECT name FROM characters, accounts WHERE accounts.login ='$login' AND accounts.acct = characters.acct ORDER BY name");
while($row = mysql_fetch_array($result))
{
echo $row['name'];
}
mysql_close($conn);
?>
EDIT2:
Okay but now, i don't know how to separte the results:
Code: Select all
AsdgasdfBazGasdTesgzxcvTrollwar
Code: Select all
Asdgasdf
Baz
Gasd
Tesgzxcv
Trollwar