Delete MySQL variable

[ktsugihara]

Hello All!

 

I have a problem... I am running these 2 queries:

 

SELECT id INTO @id FROM table WHERE name = 'name';

INSERT INTO table2 (val1, val2, val3, val4) VALUES (@id, 'name', 'email', 'time');

 

This is all in a PHP app (to recover a password). The problem is if the ID does not exist for the name, the INSERT statement will use the ID of the previous user, resetting the wrong password.

 

Any idea how I can unset the @id var? I've been looking but have yet to find it.

 

Thanks!

[ktsugihara]

Resolved!

 

 

SET @id = null;