New Row in VB3 DB
 

Hello,
I am currently working on a hack in which the user has "points". I have written everything out involving the points on a seperate DB and have it working fine. Now I would like to insert a "point" row in for each of my current users and have it work for future users.

Could anyone help me with how I would do this?

-Mike

P.S. I do have phpmyadmin.

[sql]
ALTER TABLE user ADD point INT NOT NULL
[/sql]

Now I'm just having trouble selecting the points row.
What do I need to change to my query to read the value of points?

Thanks!
-Mike

Try

Worked perfectly.

Best Regards,
-Mike

Im having trouble writing to a specific user. Any idea on how I would write the points to the database by userid?

I've been trying to use LIMIT but have been unsuccessful.

Thanks,
-Mike

[SQL]
UPDATE dev_user SET point=1234 WHERE userid=4321
[/SQL]

Of course the numbers must be replaced with the actual values ;)
If you just want to increase/decrase the points use SET point=point+value.

Thank you!

I'm having trouble getting the users point total to display in the postbit. Could you help me with this?

I was thinking I would add into showthread a way to query the DB using each post's information.

$query = 'SELECT dev_user FROM points WHERE username=post[musername]';

Im not very familar with the way VB does queries and am having trouble understanding it.

-Mike