[SOLVED] Mysql select query

[Thomisback]

Never mind got it working

[uniflare]

erm, what was the problem and what was the solution? (could help someone else )

[Thomisback]

I had a MySQL query:

 

      $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup` FROM `gebruikers` WHERE `login`='{$_SESSION['login']}' AND gamename='$prefix'");

 

It did not work because I put

gamename='$prefix'

at the end, it should have been like this:

 

      $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup` FROM `gebruikers` WHERE gamename='$prefix' AND gamename='$prefix' AND `login`='{$_SESSION['login']}'");