Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Please help with voucher system!

Author  Topic 

rogerrr93
Starting Member

1 Post

Posted - 2010-12-13 : 17:59:31
Hello,

i am working on a very advanced system, and it needs some SQL components. Me myself isnt very speciallised in SQL, i do know some other coding like C#, AJAX, PHP, HTML, but too little about SQL. The project comes with all these coding skills.
Now i want to ask if someone could please help me!

I need a PHP based code that if visitors come to a page that occurs after payment they automatically get a voucher (max 8 digits) they can redeem elsewhere on the site (allready got the redeem part running) but the voucher creation script has to write 3 values in a table called 'vouchers' the values are the voucher code itself, the type, wich is a string (like 'credits') and the numeric value of what the voucher is worth (like '20'). after creating/writing the voucher into the SQL it also has to display the code on a page. Does someone have a script that works like this? I spend hours looking for it on Google, but i didn`t find anything, if i did i wouldnt have posted this. If you like i will even give credit to you.

Also forgive me for my english if i made mistakes, but im from Holland ;)

Rogier

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-13 : 18:40:55
Are you using Microsoft SQL Server or MySql as your rdbms? Php people typically use MySql. SQLTeam.com is for Microsoft SQL Server, hence asking the question.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -