[SOLVED] mysql_fetch_array() I did something wrong

[Yeodan]

<?php

$con = mysql_connect("localhost","***","***");
if (!$con) {
die('Could not connect: ' . mysql_error());
}

$account = $_POST["acc"];
$password = $_POST["pass"];

mysql_select_db("players", $con);

$result = mysql_query("SELECT * FROM players WHERE PlayerName=" . $account);
$row = mysql_fetch_array($result);

echo $row['PlayerName'] . " " . $row['PlayerPass'];

?>

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\SuperSecret\PHP\wamp\www\login2.php on line 17

 

What did I miss? I can't find it

[Yesideez]

$result = mysql_query("SELECT * FROM players WHERE PlayerName='" . $account . "'");

[Yesideez]

btw, if those are your database connection details I'd edit your post and remove them

[Yeodan]

btw, if those are your database connection details I'd edit your post and remove them

nah, nothing important

now I get this: Parse error: parse error in D:\SuperSecret\PHP\wamp\www\login2.php on line 16

[lonewolf217]

I think this normally happens when there is a problem with either your DB connection or your SQL query.

 

mysql_select_db("players", $con) or die (mysql_error());

$result = mysql_query("SELECT * FROM players WHERE PlayerName=" . $account) or die (mysql_error());
$row = mysql_fetch_array($result);

[Yeodan]

bah I keep making stupid mistakes now

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\SuperSecret\PHP\wamp\www\login2.php on line 17

[Yeodan]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1

 

hmm

[Yeodan]

I hate php

stupid " and ' and ;

[Yesideez]

Try this...

<?php

$con = mysql_connect("localhost","***","***") or die('Unable to connect: '.mysql_error());
mysql_select_db('players');

$account = $_POST['acc'];
$password = $_POST['pass'];

$result = mysql_query("SELECT * FROM players WHERE PlayerName='".$account."'");
$row = mysql_fetch_array($result);

echo $row['PlayerName'] . " " . $row['PlayerPass'];

?>