Fetching data from a database about the currently logged-in user

Databases
1

Long title XD

I have a table containing information about the users (username etc…). How can I extract the content of a field, based on the user that is logged in, and use it in a SQL query?

Example that I’m inventing right now: the user A logs in and I want to show him a list of all the other users that are older than him (of course there is an “age” field in every table entry).

How can I do this?

2

Thanks for your help :slight_smile:

Anyway, while I was reading, the solution came up to my mind :smiley:

3

http://dev.mysql.com/doc/refman/5.1/en/select.html

Or you could google for ‘mysql tutorials’, or ‘php mysql tutorials’ if your question is how to do such extractions with php. :slight_smile:

4

My question would be more like “Can I have a PHP command inside a SQL query?” :smiley:

(Grazie :slight_smile: )

5

You can construct and run a query using PHP. Take a look at the manuel and see what method you want to use.

For example:

There are loads of examples there too.