vimixx
-
Posts
2 -
Joined
-
Last visited
Never
vimixx's Achievements
Newbie (1/5)
0
Reputation
-
Problem solved by myself:- All I did was put ` this little apostrohes in between like this:- mysql_db_query($db, "INSERT INTO udBXchange (`url`,`mail`,`burl`,`title`,`out`,`ini`,`ok`) VALUES ('".$url."', '".$email."', '".$burl."', '".$title."', 0, 0, 'no')") or exit(mysql_error());
-
I have a website called vimixx.net. And I'm using an affiliates script called Uddabannerxchange. And basically, people who want to affiliate with me, can fill out a form, below the already listed affiliates and their buttons. Everytime they apply, the form takes down their website address, image path to their banner, and their email address and they are issued a URL which stores the amount of traffic coming from their site and mine, all these are stored in the mysql database. Now, my webhost, not so long ago, updated the SQL version to 5 or 6 and ever since then, when I've tried using the form, I get this displayed on the page:- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out , ini , ok) VALUES ('http://', 'No Email', 'Undefined', 'No Title', 0, 0, 'n' at line 1 The script contains 5 php pages, the admin page, affin.php, affout.php, index.php (which the form is stored and affiliates are displayed) and data.php. The index.php is the problem and here's the php code for it:- <title>Vimix Designs - Thank you for your affiliation!</title> <LINK REL="shortcut icon" HREF="favicon.ICO"> <link rel="stylesheet" href="stylev9.css" type="text/css"> <script src="noclick.js"></script> <body> <? /* http://www.udda.net webmaster@udda.net Copyright udda.net You are most welcome to add a link to my site. Thanks / Rikard at udda.net */ $url = $_POST['url']; $title = $_POST['title']; $email = $_POST['email']; $burl = $_POST['burl']; include("data.php"); mysql_connect ($dbhost,$dbuser,$dbpass); mysql_select_db ($db); if ($_GET['create'] == "aff") { $url = $_POST['url']; $title = $_POST['title']; $email = $_POST['email']; $burl = $_POST['burl']; if ($url == ""){ $url = "http://";} if ($title == ""){ $title = "No Title";} if ($email == ""){ $email = "No Email";} if ($burl == ""){ $burl = "Undefined";} $sql = "SELECT COUNT(*) FROM udBXchange WHERE title = '".$title."' AND url = '".$url."'"; $result = mysql_query($sql); $antal = mysql_result($result, 0); if ($antal == 0){ mysql_db_query($db, "INSERT INTO udBXchange (url , mail , burl , title , out , ini , ok) VALUES ('".$url."', '".$email."', '".$burl."', '".$title."', 0, 0, 'no')") or exit(mysql_error()); } ?> <strong><font size=2><img src="imgs/09_n1.gif" width="8" height="10"> Linkage</font></strong><br> Thank you for affiliating with us. Once checked and verified, we shall display your affiliation button on our affiliates page. <br> <br> <br> <font size="1"><strong>Title of your site is:</strong> <a target="_blank" href="<?=$url;?>"><? echo $title; ?></a><br> <? $sql = "SELECT id FROM udBXchange WHERE title = '".$title."' AND url = '".$url."'"; $result = mysql_query($sql); ?> <br> <strong>You must use this to link me with:<br> </strong>(click 'Hightlight code' and select copy in your browser) <br> </font> <? $link = mysql_fetch_array ($result); ?> <form name="copy"> <div align="center"> <textarea style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;' name="txt" rows="3" cols="50" wrap="VIRTUAL"><? echo $homepage;?>affin.php?id=<? echo $link['id']; ?></textarea> <br> <input style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/ value="Highlight code" src="..images/highlightall.gif" border="0" onclick="javascript:this.form.txt.focus();this.form.txt.select();" type="button"> </div> </form> <div align="center"><br> <br> <? }else { $sql = "SELECT * FROM udBXchange WHERE ok = 'yes' ORDER BY title ASC"; $result = mysql_query($sql); while ($links = mysql_fetch_array($result)){ ?> <a title="<?=$links['title'];?>" target="_blank" href="<?=$homepage;?>affout.php?id=<?=$links['id'];?>"><img border="0" src="<?=$links['burl'];?>" width="88" height="31" title="<? echo $links['title']; ?> - Clicks: <? echo $links['ini']; ?>" class="gradualshine1" onMouseover="slowhigh(this)" onMouseout="slowlow(this)" style='BORDER-RIGHT: #232528 1px solid; BORDER-TOP: #232528 1px solid; font-size: 9px; BORDER-LEFT: #232528 1px solid; BORDER-BOTTOM: #232528 1px solid; color: #232528;'></a> <? }?> <? }?> <br> <BR> <form action="affspage.php?create=aff" method="post"> <div align="center"><span class="style3"><font color=white>Your Website address:</font><br> <input name="url" type="text" value="http://" size="35" maxlength="60" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/> <br> <font color=white>Path to 88x31 button:</font><br> <input name="burl" type="text" value="http://" size="35" maxlength="60" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/> <br> <font color=white>Name of your website:</font><br> <input name="title" type="text" size="35" maxlength="30" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/> <br> <font color=white>Your E-mail:</font><br> <input name="email" type="text" size="35" maxlength="30" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/> <br> <input type="submit" value="Apply!" style='BORDER-RIGHT: #4977BC 1px solid; BORDER-TOP: #4977BC 1px solid; font-size: 10px; BORDER-LEFT: #4977BC 1px solid; BORDER-BOTTOM: #4977BC 1px solid; color: #ffffff; font-family: tahoma; BACKGROUND-COLOR: #000000;'/> </span></div> </form> </div> </body> If anybody could me with this problem, as I have already tried contacting the author of this script udda.net and he couldn't give a toss about it, I'd be really grateful. Thanks.