Topic: [SOLVED] form help.

[webmaster1]

I'm always pedantic when it comes to databases. Just create your new table from scratch using the first bit of SQL code I gave you rather than changing the name of the current table. The only thing that needs changing is the destined database and the desired table name.

I think your date column is set as date rather than datetime. It needs the time as well to order correctly.

Check mine here:

http://www.joycepromotions.com/output.php

[dropfaith]

it should sort by date newest to oldest with my code already

order by date desc would do that

[webmaster1]

If the time looks off in my output.php page its because we're four hours ahead in Ireland. Yours should show differently.

[Birdmansplace]

Alright guys.  Thanks alot.   saved me hours and hours of personal head beatings.  I will leave the test folder and this info here for others to see.  And i will export the .sql file.
 
check it out:
form:http://birdmansplace.myftp.org/test/form.php                            output:http://birdmansplace.myftp.org/test/output.php

Download: http://birdmansplace.myftp.org/test/form.zip

[dropfaith]

np ive been thru the days of head beatings on lawrenceguide.org like hundreds of them i didnt know php at all before that project and ended up with a user driven site with all dynamic content and ratings scripts over like 2 months or so

[webmaster1]

Good man!

Three final things:

1) Your link to output.php should not be at the end of your form. It should only show after submit where it says 'Thank you username'

After this line in form.php:

Code: [Select]

echo "Thank you $username !";
paste

Code: [Select]

echo "<a href='www.yoursite.com'>somelink</a>";
Do not use double quotations in the <a> tag.

2) At a later stage try editing the code I suggested earlier. As it stands users are allowed to enter non-numeric values into your amount text box.


3) When your happy with everything don't forget to close this thread (mark as solved at bottom of page).

Glad to help, later! 

[webmaster1]

np ive been thru the days of head beatings on lawrenceguide.org like hundreds of them i didnt know php at all before that project and ended up with a user driven site with all dynamic content and ratings scripts over like 2 months or so

Mmm, I'm going to try Allisons Supreme Chocolate Chip Cookies recipe. 

[dropfaith]

haha they are pretty damn good i havent had time to add more content i need to get a bunch up to demonstat it in launched mode but its a pain tp type out recipes shows stories and all that movie reviews blah

i need more projects then this haha

[Birdmansplace]

Alright guys.  Thanks alot.   saved me hours and hours of personal head beatings.  I will leave the test folder and this info here for others to see.  And i will export the .sql file.
 
check it out:
form:http://birdmansplace.myftp.org/test/form.php                            output:http://birdmansplace.myftp.org/test/output.php

Download: http://birdmansplace.myftp.org/test/form.zip

Everything is current. Injoy