[SOLVED] MySQL Help in pulling User ID

[jameson9]

Hello,

 

Could someone please help me? I want to get the UserID (UID) from the users table and then put it together with a CourseID (CID) into a table called enrollment.

 

I know it's wrong (because it is not working), and I think there may be an array involved, but could someone correct my syntax for me? This is what I have so far:

 

$ID = mysql_query("SELECT UID FROM users WHERE username=$username");

 

mysql_query("INSERT INTO enrollment (UID, CID) VALUES('$row','$course')");

[artacus]

mysql_query only gives you a result set. You need to use mysql_fetch_assoc() or something similar to get the info out of that result set.

 

Conversely, you could just write it into 1 query.

INSERT INTO enrollment (UID, CID) 
SELECT UID, '$course' FROM users WHERE username = '$username'

[jameson9]

Cool,

 

Yeah i used

 

$row = mysql_fetch_row($result);

 

and it worked. Thanks!