ktsugihara

Resolved! SET @id = null;

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!

Alternatively, is there an issue with having a multidimensional array? $foo[a][1]; ? I dont know your exact implementation so I dont know if this would work...

Apparently I had a PHPFreaks account, I just didnt know it But back to phpfreaks i come

Hey so I have my program totally made. to understand what im asking for, i need to tell you what the program is all about... so i have a tablet pc and a scan gun. when people walk into my stock room, they have to sign in with their badge. I have it set up so they can just scan their badge nad then i scan mine saying i let them in. so the scan gun is set up to hit "enter" automatically. so i scan his, it goes to the next screen, and then i go to scan my badge, but i have to select the field. i just want it to automatically select the feild. is that possible?