Hey all,

I have produced this mysql_query which updates all the specified fields. Only problem is that mysql throws up a problem. Does anybody see one?


<?php

if ($error==NULL) 

{

mysql_query("	update classifieds SET

			title			=	'$title',
			guitar 			=	'$guitar',
			price			=	'$price',
			condition 		=	'$condition',
			tremlo 			=	'$tremlo',
			yearmade 		=	'$yearmade',
			serialno 		=	'$serialno',
			countryorigin 	=	'$countryorigin',
			originalparts	=	'$originalparts',
			necktype		=	'$necktype',
			description 	=	'$description',
			postageprice 	=	'$postageprice',
			postageservice 	=	'$postageservice',
			postalinsurance =	'$postalinsurance',
			collection		=	'$collection',
			userid			=	'$userid',
			link1 			=	'$link1',
			link2			=	'$link2',
			link3			=	'$link3',
			link4			=	'$link4'

			where id='$id' ") 

			or print ( mysql_error() );

}

?>

    if so then please mark it as resolved

      and i'd still like to know what error you were getting and how you fixed it. might be nice for people with the same problem to be able to search the forums (like that'll ever happen) and find this post....

        Write a Reply...