Guardian2006 Posted September 16, 2006 Share Posted September 16, 2006 I have searched the forums but have not found anything specific which relates to my problem.I am fairly new to PHP/mySQL but have managed to get pretty far into the development of a script for stopping spam but now I'm stumped.Although my script has its own tables, I need to update another table which has a 'list' field already populated with data.My attempts so far have removed the existing data instead of appending the new data to the bottom of the list.Assuming the table is named 'blocked' and the field is name 'refer' could anyone help me out?I'm using a php form to set the post vars but I'm guessing I need to retrieve the data in the list field, put it into an array, append my data to the array and then do the field update but having an idea of what to do and actually doing it has me stumped.Oh, the data is a list of domains in the format 'domainname.com' Quote Link to comment Share on other sites More sharing options...
fenway Posted September 16, 2006 Share Posted September 16, 2006 Why are you appending to a "list" field? Sounds like you should have multiple records. Quote Link to comment Share on other sites More sharing options...
Guardian2006 Posted September 17, 2006 Author Share Posted September 17, 2006 Thanks for taking the time to reply - seems I have made a mistake in my assumption of the field type.The field NAME is 'list' whilst the field TYPE is actually 'longtext'.I'm not able to change this structure as it belongs to a third party script that is designed to detect hacking attempts in a content management system and would break it.The author is using this field to store a list of bannen domains (seperated by carriage returns) - the view for the field in phpmyadmin shows something like this [quote]121hr.com1st-call.net1stcool.com5000n.com69-xxx.com9irl.com9uy.coma-day-at-the-party.comaccessthepeace.com[/quote]and I just cannot figure out how to add additional domains to this list with them all being contained within the one field.My own script is designed to detect bad referers and I thought I may as well incorporate the two by adding bad referer domains to this other table as an added way to block the domain from accessing the site. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 17, 2006 Share Posted September 17, 2006 I see... well, you just need to CONCAT() the new domain on. Quote Link to comment Share on other sites More sharing options...
Guardian2006 Posted September 18, 2006 Author Share Posted September 18, 2006 I really appreciate you taking the time out to respond. I have to apologise for my lateness in replying as I was obsrobed by the issue at hand.Thanks a bunch, that is exactly what I needed and I have used it to resolve my problem. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.