Parinay Bansal wrote: $sth = $dbh->prepare("insert into loginout values ($ref->{'CARD_ID'}, '$name' , now(), NULL"); It is missing a closing paren. Could be something else wrong too. As a note in my experience it has been considered a best practice to explicitly name fields. The advantage to that is that it allows the database itself to be changed without impacting code. So rather than insert into mytable values(x,y) use insert into mytable(col1, col2) values(x,y)

Is this still open? It was posted a while ago. If so, to get started, what are some of the other data points? 1. does "You're connected ...\n"; print? 2. have you tried to insert a print statement before the chomp to see what is in $_; 3. have you tried to put something in $_ to see if the error is suppressed. 4. is there anything in $ref before the print of its fields? 5. does a visual inspection of the MySQL database with your database admin tools show that row should exist? 6. what about some logic to catch this before it croaks? 5. have you tried the Perl debugger with -d on the script. As you know it has watch and break features. If it is web app you may still get enough from running it in console mode. dpminusa "Coding for fun and profit ... mostly fun"

thank you gentlemen i was missing out on the part "extern SCard SCManager" replaced with "extern SCard *SCManager" such a fool i have been yes sir thank you for your advice, i really must go back to my c++ basics. It appears that i have missed out on very basic and important lessons which i sould have taken before starting to develop a full fledged application i will surely do that from now on. but yes thanks to you, now my code runs with no error. i will not forget to get back with any other problems i face in the future.