PHP - Function SELECT create_time FROM db

[ReFresh 3151]

Hi guys,

I have problem with select column from database. I need to add to web a function which show create_time of account in user panel. I tried this but it didn't work:

$selectTime = "SELECT create_time FROM account.account WHERE id=2";

I got this error: mysql table is empty

Can someone help me with that?

Thanks for answers!

Regards,

ReFresh

[metin2team 817]

rather than adding a new query you should add create_time to the login query
 with that you'll get the create_time without have to add a new query.

 

[ReFresh 3151]

3 minutes ago, metin2team said:

rather than adding a new query you should add create_time to the login query
 with that you'll get the create_time without have to add a new query.

 

Can you show me an example?

[metin2team 817]

you should add your login query or the login.php file.

showing an example won't help if you don't have any good background in PHP.

$mysql->query("SELECT id, login, email, create_time FROM account.account WHERE id='x'");

 

[ReFresh 3151]

35 minutes ago, metin2team said:

you should add your login query or the login.php file.

showing an example won't help if you don't have any good background in PHP.

$mysql->query("SELECT id, login, email, create_time FROM account.account WHERE id='x'");

 

I tried this, but it still says: query was empty

$sqlSelect = "SELECT id, login, email, create_time FROM account.account WHERE id='".$_SESSION['user_id']."'";

$account = mysql_query($sqlSelect);

[Deliris 534]

Man, in account.account do you have any account with '2' id ?

[ReFresh 3151]

19 minutes ago, Wahmon said:

Man, in account.account do you have any account with '2' id ?

Yes, I have account with id 2

[Deliris 534]

3 hours ago, ReFresh said:

Yes, I have account with id 2

Then send me a PM and i'll try to help you.