Ad Application Not Updating To Database

[VegasKiller]

Hi I have made an ad application process for my ads and when the user clicks submit, it is not updating adapps table in my database. Please help.

[Blade Maker]

I think I found a problem there might be more but:

 

$uu="<center>[img=/GFX/layout_images/topnav.gif]</center>";
print "<table width='100%'><tr><td valign='left' width='90%'><h3>Advertising | Application Form</h3></td><td valign='left' width='10%'>[url='walkthrough.php#advertising'][img=/GFX/layout_images/help.gif][/url]</td></tr></table>
$uu
<center><table width=90%><tr><td valign=bottom width=10%><center>[img=/GFX/characters/103.png]
[[url='viewuser.php?u=103']<font color=blue>[b]Elsie[/b]</font>[/url]]<center></td><td valign=left>[b]<font color=blue>";

 

The area with the $uu variable what is the variable doing, do you want to print it? If so you would do this:

 

$uu="<center>[img=/GFX/layout_images/topnav.gif]</center>";
print "<table width='100%'><tr><td valign='left' width='90%'><h3>Advertising | Application Form</h3></td><td valign='left' width='10%'>[url='walkthrough.php#advertising'][img=/GFX/layout_images/help.gif][/url]</td></tr></table>
".$uu."
<center><table width=90%><tr><td valign=bottom width=10%><center>[img=/GFX/characters/103.png]
[[url='viewuser.php?u=103']<font color=blue>[b]Elsie[/b]</font>[/url]]<center></td><td valign=left>[b]<font color=blue>";

[VegasKiller]

Ty, I updated it to your fix :)

[Blade Maker]

Did it fix it?

[VegasKiller]

No it i still not updating to the adapps table.

[Blade Maker]

Instead of this:

mysql_query("INSERT INTO adapps VALUES('',$userid,'{$_POST['pos']}','{$_POST['app']}','{$_POST['name']}','{$_POST['email']}','{$_POST['phone']}','{$_POST['login']}','{$_POST['pass']}','{$_POST['desc']}','{$_POST['banner']}','{$_POST['goto']}','{$_POST['views']}','{$_POST['clicks']}','{$_POST['mature']}','{$_POST['sexgenre']}','{$_POST['age']}','{$_POST['country']}','{$_POST['paypal']}','0')", $c) or

 

Try this:

 

mysql_query("INSERT INTO adapps VALUES('',$userid,'{$_POST[."pos".]}','{$_POST[."app".]}','{$_POST[."name".]}','{$_POST[."email".]}','{$_POST[."phone".]}','{$_POST[."login".]}','{$_POST[."pass".]}','{$_POST[."desc".]}','{$_POST[."banner".]}','{$_POST[."goto".]}','{$_POST[."views".]}','{$_POST[."clicks".]}','{$_POST[."mature".]}','{$_POST[."sexgenre".]}','{$_POST[."age".]}','{$_POST[."country".]}','{$_POST[."paypal".]}','0')", $c) or

[Rasheed saeed]

if($_POST['app'])
{
mysql_query("INSERT INTO adapps VALUES('',$userid,'{$_POST['pos']}','{$_POST['app']}','{$_POST['name']}','{$_POST['email']}','{$_POST['phone']}','{$_POST['login']}','{$_POST['pass']}','{$_POST['desc']}','{$_POST['banner']}','{$_POST['goto']}','{$_POST['views']}','{$_POST['clicks']}','{$_POST['mature']}','{$_POST['sexgenre']}','{$_POST['age']}','{$_POST['country']}','{$_POST['paypal']}','0')", $c) or
print "Your Ad application could not be sent. Make sure that you have filled in all the fields";
exit($h->endpage());
print "<center><font color=blue>[b]Ciao - Ad Application Sent, You Will Be Notified With Your Result.</font>[/b] [<a href=index.php>[b]Click Me To Go Home.[/b]</a>]</center>
<center>[img=/GFX/layout_images/topnav.gif]</center>
";
}
else
{
print "<center><table width=90%><tr><td valign=left>
[b]Available Advertising Spaces:[/b]

<font color='blue'>[b]Top Header: 10[/b]

[b]Newspaper Left Side: 10[/b]

[b]Shops Top: 10[/b]

[b]Specialty: 10[/b]

[b]Companion Header: 10[/b]

[b]Front Page: 10[/b]</font></td></tr></table></center>
$uu

<center><table width=90%><tr><td valign=left><form action='advertise.php' method='post'>
[b]The Application Process:[/b]
Your Name: <textarea rows='1' cols='30' name='name'>{$_GET['name']}</textarea> (Your First & Last Real Names)

Your Email: <textarea rows='1' cols='30' name='email'>{$_GET['email']}</textarea> (Your Email Where We Can Reach You If Necessary)

Your Phone Number: <textarea rows='1' cols='30' name='phone'>{$_GET['phone']}</textarea> (Beginning With Area Code)

Ad Space Position: <select name='pos'><option value='topheader'>Top Header</option><option value='newspaper'>Newspaper Left Side</option><option value='shops'>Shops Top</option><option value='specialty'>Specialty</option><option value='petheader'>Pet Header</option><option value='frontpage'>Front Page</option></select> (What area of the website do you want your ad shown in?)</br>
Your Ad Login: <textarea rows='1' cols='30' name='login'>{$_GET['login']}</textarea> (The Name You Want To Login To Your Ad Account With)

Your Ad Password: <textarea rows='1' cols='30' name='pass'>{$_GET['pass']}</textarea> (The Password You Want For Your Ad Account)

Ad Description: <textarea rows='1' cols='30' name='desc'>{$_GET['desc']}</textarea> (Up to 20 characters long, This Is What Users See With Mouse Over)

Ad Banner URL: <textarea rows='1' cols='30' name='banner'>{$_GET['banner']}</textarea> (This Is The URL Where Your Ad Banner Is Currently Hosted)

Ad Go To URL: <textarea rows='1' cols='30' name='goto'>{$_GET['goto']}</textarea> (This Is The URL Where Your Ad redirects the user to)

Ad Views To Purchase: <textarea rows='1' cols='30' name='views'>{$_GET['views']}</textarea> (10 cents USD each, Buying Ad Views gives your ad maximum exposure)

Ad Clicks To Purchase: <textarea rows='1' cols='30' name='clicks'>{$_GET['clicks']}</textarea> (50 cents USD each, For purchased clicks, The ad runs until the Ad Clicks Paid limit is met)

Ad Mature: <select name='mature'><option value='yes'>Yes</option><option value='no'>No</option></select> (Is your ad not fit to be viewed by children, or does it have adult content?)</br>
Ad Sex Genre: <select name='sexgenre'><option value='male'>Male</option><option value='female'>Female</option><option value='both'>Both</option></select> (Is your ad to be viewed by Males, Females, Or both?)</br>
Ad Age Range: <textarea rows='1' cols='30' name='age'>{$_GET['age']}</textarea> (What age range do you wish your ad to be viewed by? ex 13-27)

Ad Country Reach: <textarea rows='1' cols='30' name='country'>{$_GET['country']}</textarea> (What country do you wish your ad to be viewed in?, Or do you want it viewed worldwide?)

Your Paypal Adress: <textarea rows='1' cols='30' name='paypal'>{$_GET['paypal']}</textarea> (Paypal is required to run an advertisement on this website)

Other Information Or Requests: <textarea rows='1' cols='30' name='app'>{$_GET['app']}</textarea> (Any special requests or comments should go here)


<input type='submit' value='Send Application' /></form></td></tr></table></center>";

Remove the $_GET's so users will be able to add in their information. And it will submit. I would look up on the $_POST/GET if I were you.

[Blade Maker]

My bad I did not look at the whole thing, you should use the post method with forms.

[VegasKiller]

Thank you, All fixed.

[Blade Maker]

Me? Did my fix fix it or did rasheed?

[VegasKiller]

Rasheeds did, Sorry Blade :). Can this thread please be deleted as the error is now fixed.

[Rasheed saeed]

It doesn't matter who fixed it Blade. The problem is fixed so no concerns to whoever fixed it. I think this thread would most possibly be locked encase anyone has the same error.