How to make a user suggestion form

[puT3]

I have a form where user will insert any suggestion that they may have.

I want to know how to make each suggestion appear according to the newest to oldest where the newest is on top and oldest below on the same page. As user click submit button it will appear on the page. It is the same way this site operate when there user post question and other reply, then the it wil display on the same page according to date.

How can i do this? Does it involve javascript?

Im thinking of using iframe in my html/css. Can it work?

[ThatThatGuy]

Are you trying to say. that you want to build something like google suggest

[puT3]

sorry i dont know google suggest..but what im want to do is like this site where when user post a reply, the reply will show on the page..

[puT3]

@puT3
My code is like below:

<%
  Response.Write(Request.Form("txtNama"))
  Response.Write(Request.Form("txtEmail"))
  Response.Write(Request.Form("txtCadangan"))
%>
 
<div id="colTwo">
       <h2>Cadangan Anda</h2>
       <p>Sila isikan cadangan anda.</p>
 
        <form name='cadangan' action='c2.asp' method="post">
        <table>    
 
            <tr><td><p>Nama:</p></td>
                <td><input type='text' name='txtNama' size='40'/></p></td>
            </tr>  
 
            <tr><td><p>Email:</p></td>
                <td><input type='text' name='txtEmail' size='40'/></p></td>
            </tr>   
 
            <tr><td><p>Cadangan:</p></td>
                <td><textarea rows="10" cols="31"             name="txtCadangan"></textarea></p></td>
            </tr>
 
            <tr><td><p></p></td>
                <td><p></p></td>
            </tr>
 
            <tr><td><p></p></td>
                <td><p></p></td>
            </tr>
            <tr><td>&nbsp;</td>
                <td align="center"><input type="submit" value="Hantar" />
                    <input type="reset" value="Batal" /></td>
            </tr>
 
        </table>
        </form>
</div>
 
 

From this code, how can i make sure the earlier suggestion still on the page and it is not being replaced if there is a new suggestion is submit.

[ThatThatGuy]

@puT3
Ok, i got it.
You need to store the suggestion entered by the user in the database.
While, the table in which you'll be storing the data will also contain an autonumber or identity column.

So whenever you addany data to the database it will automatically generate the autonumber for the record.

And by the getting the list of data by order by descending inside the select query you can get the most updated data... in descending order

[puT3]

@ThatThatGuy
ok thanks...

I alread tried but when i click submit the data entered does not appear in the table.

My database:

Table name: Cadangan

ID (Autonumber) PK
Nama
Email
Cadangan
 

While the code in my asp file as below:

<%
 
        var DSN ="C:/Inetpub/wwwroot/TM/Telekom.mdb"
        var Conn = Server.CreateObject("ADODB.Connection");
        Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
        Conn.Open(DSN);
 
        if(Request("Hantar") == "SUBMIT")
        {
 
            var frmNama=Request.Form("txtNama")
            var frmEmail=Request.Form("txtEmail")
            var frmCadangan=Request.Form("txtCadangan")
 
            sql2="INSERT INTO Cadangan(Nama,Email,Cadangan) VALUES ('"+ frmNama+"','"+frmEmail+"','"+frmCadangan+"')";
 
            Conn.Execute(sql2);
            Conn.Close()
            Conn = null
        }
 
            sql ="SELECT * FROM Cadangan"
 
            rs = Server.CreateObject("ADODB.Recordset");
            rs.Open(sql,Conn);
 
            out = "<table>"
            while (!(rs.EOF))
            {
                out += "<tr><td>" + rs("Nama") + "</td><td>" + rs("Email") + "</td></tr>"
                out += "<tr><td>" + rs("Cadangan") + "</td><td></td></tr>"
 
                rs.Movenext();
            }        
            out += "</table>"
 
            rs.Close()
            rs = null
            Conn.Close()
            Conn = null
 
            Response.Write(out);
 
 
%>
 

My form:

Nama:<input type="text' name="txtNama">
E-mail:<input type="text" name="txtEmail>
Alamat:<textarea></textarea>
 

Is there any error it in? because I cannot see it. Please look and correct it if any.

[ThatThatGuy]

@puT3
It won't happen automatically ...
I suggest you should have a gridview or a FormView kind of a control
which will show the posts as per to the most recent one..
update the gridView from database on every postback or when the data is submitted to the database..

or you can do it manually if you want to do this via HTML

[puT3]

hi,
what do you mean by gridview or formview?i dont understand...and if by html how to do it?

does it mean my code above cannot be used?

[puT3]

Thats ok..Forget about...Thamks