Getting a DB Query error

gsurface

Hi,
I am not a coder per say, but can understand the logic to some extent (I have some prior C++ coding knowledge so I can relate a bit). I am getting a 'DB query error' when I try to use this script. It was working fine before, then all of a sudden, it just started giving me this error. You can try it yourself at this URL http://www.flexdeals.net/deals/affiliate.php, try to add an link, and you will get an error. I see the code that is producing this error in affiliates.php, it reads:

$url = str_replace("%%".$type."%%", $sku, $vurl);

$result = mysql_query("INSERT INTO `affiliate` (url) VALUES('".$url."')");
if (!$result) die("DB query error");
else {
	$jumpurl = "http://www.flexdeals.net/deals/jump.php?m=".mysql_insert_id();
	echo "Added url:<br /><a href=\"$url\">$url</a><br />for:<br /><a href=\"$jumpurl\">$jumpurl</a><br />\r\n";
}

Could it have something to do with the database? Maybe the size of the database or something? Thanks in advanced for any help.

jjfletch

    $result = mysql_query("INSERT INTO `affiliate` (url) VALUES('".$url."')");

supposed to be this:

    $result = mysql_query("INSERT INTO affiliate (url) VALUES('".$url."')");

gsurface

Nope. I changed it to that and nothing happened. I also notices another php line which may be brining up the problem. This part is part of another php file, it reads:

$m = $_GET['m'];

if (!$m || !is_numeric($m)) exit;

if (!mysql_connect($dbhost, $dbuser, $dbpass)) die("DB connect error");
if (!mysql_select_db($dbname)) die("DB select error");

$result = mysql_query("SELECT code,url,hits FROM `affiliate` WHERE code=".$m);
if (!$result) die("DB query error");

SargeZT

Change it to:

$m = $_GET['m'];
if (!$m || !is_numeric($m)) exit;
if (!mysql_connect($dbhost, $dbuser, $dbpass)) die("DB connect error");
if (!mysql_select_db($dbname)) die("DB select error");
$result = mysql_query("SELECT code,url,hits FROM `affiliate` WHERE code=".$m) or die(mysql_error());

And post the results back here.

gsurface

I get the following error:

DB query error: 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 ''affiliate' (url) VALUES('http://images.amazon.com/images/P/B00

SargeZT

Take the single quotes out from around affiliate, and post the new error.

gsurface

SargeZT wrote:
Take the single quotes out from around affiliate, and post the new error.

This is what I got. I suspected it was that. It is adding the same ID number instead of incrementing:
DB query error: Duplicate entry '127' for key 1

Weedpacket

That's because you're using a tinyint for your ID type, and tinyints only go up to 127 (that's why they're called "tiny"). An ordinary int would go up to two billion or so.