[SOLVED] selecting data from mysql using php

[Jiraiya]

i need to select and retrieve certain variables from 2 different tables in the same database then be able to run my math php script and then update those variables so my question is can someone show me how to select these variables so I can run my math script? 

[revraz]

http://www.tizag.com/mysqlTutorial/mysqlselect.php

[Jiraiya]

ok thanks for the link it helped. how do i select like one or two variables not all of them ?

[revraz]

I assume you mean fields.

 

SELECT fieldone, fieldtwo FROM table

[Jiraiya]

what would i do if i only want to retrieve data that belongs to the user who is logged in only?

[revraz]

You'll need to use logic to determine that user, like sessions.

 

Then you can do

 

SELECT field FROM table WHERE userid = '$id'

 

And $id would be their user id in your DB.