[SOLVED] New Site PHP Help... Please help, deadline is coming up.

[daveoffy]

I have started making a website and ran into some PHP problems.

 

I have:

mysql_query("UPDATE members SET price = '0'

WHERE member_id = '1'");

 

I need to change the member id from 1 to the member id to whoever is logged in.

 

Can anyone help me?

[peranha]

Store their member id in a variable and use that in the sql query.

 

UPDATE members SET price = '0' WHERE member_id = '$membid'

[daveoffy]

How will I set it in a variable. I made it $SESSION['SESS_MEMBER_ID']

 

will i do $membid = $SESSION['SESS_MEMBER_ID'];  ?

[Mchl]

Yes, or:

mysql_query("UPDATE members SET price = '0'
WHERE member_id = '{$_SESSION['SESS_MEMBER_ID']}'");

[daveoffy]

Yes, or:

mysql_query("UPDATE members SET price = '0'
WHERE member_id = '{$_SESSION['SESS_MEMBER_ID']}'");

Thank you so much. This worked great!!!