Page 1 of 1

Create a recordset in memory for usage in select statement

Posted: Sat May 24, 2008 12:04 am
by terryvanduzee
Hello

I have a table in a form.
I have 2 fields I want displayed in this table, but I want each field from the table to be displayed in a separate cell on the table (Im using mysql).
Then, once the end user types a response into a cell, it checks a 3rd field in the table to verify the value they typed is correct.

I have a series of images on the server with links to them in a field of the DB. Then, I ask a question about the image. If the end user answers correctly, it will allow information in the rest of the form to be submitted to the DB.

The reason I am doing this is because I cannot seem to figure out how to use "captcha" in my existing form (Im not well versed in php).

Any help would be appreciated.
It needs to go here:
field names: ID, image,question
dbname: pictures
tablename: images

Code: Select all

 
<tr>
    <td>the question here</td><td>the image here</td><td> a field to type there response here</td>
</tr>
 
Based on what is typed in the 3rd cell above, php should check the value of the field "answer" from the same table. If it is correct, it allows the submit to the db, otherwise it displays an error.

As it sits now, the submit works fine, but there is not protection against spam bots (I had to take my site down because I was being hammered by about 10,000/wk into 3 tables).

Thank you
Terry

Re: Create a recordset in memory for usage in select statement

Posted: Sat May 24, 2008 1:28 pm
by califdon
You have asked a question that requires a rather detailed answer and would probably not be usable for you, if you aren't well versed in PHP. I would urge you to learn how to use Captcha or similar technique, rather than try to program your own version of the same thing. It will be easier for you, really.