chrisfreelance

Sogo7, I really appreciate your help with this problem. I'm slowly but surely becoming more comfortable with PHP because of this. I'm finally able to parse some information from last.fm's xml document. The only problem that I face now is I can't use distance or location parameters with artist.getEvents, only get.getEvents. How would I go about limiting this data to, for instance, Belfast? I understand it'll probably take someone with Last.fm experience to answer this question for me. Kudos to anyone that can help me with this. Chris.

Thanks for this, it's really appreciated - a gentle nudge in the right direction should get me started. It's part of my final major project for uni so I'm learning as I go along.

I'm slowly moving down the forums here. Anyone able to help me? Sorry for the bump.

Hello all. Hopefully someone can point me in the right direction here. I want to create a basic search field that searches XML data on another server via an API. More specifically what I want to do is have a user type in a specific artist or band that searches last.fm's geo.getEvents API. What's the best way to go around this? Is PHP the best language to use? I've searched a fair few tutorials online but none seem to fit this request. Many thanks for anyone that can give me a clue on this.

That's exactly what the problem was. I changed the ODBC connector in the control panel. Rookie mistake, but I got there after losing much of my hair anyway. Thanks.

Anyone have any ideas? I'm sure this is much simpler than I am making it out to be. Chris.

Jock, again, many thanks for you help. Unfortunately a more serious problem has emerged and it's very difficult as I generally don't work with databases etc. In the control panel I changed the mysql4 password, thinking that I would then be able to access databases that I was locked out from - but I can't. That's not the problem though. The problem now is that whenever I click on, for instance, race results - which would list results based on the database, an error appears. The error that appears is a custom page that the previous person designed, but on checking the error e-mail that's automatically sent, I get this message... =========================================================== Error: -///- March 25, 2011 08:28:37 AM Diagnostics: -///- Error Executing Database Query. [Macromedia][sequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'club_results'. Make sure it exists and that its name is spelled correctly. The error occurred on line 59. Browser -///- Mozilla/5.0 (iPod; U; CPU iPhone OS 3_1_2 like Mac OS X; en-us) AppleWebKit/528.18 (KHTML, like Gecko) Mobile/7D11 RemoteAddress -///- 86.157.1.154 HTTPReferer -///- wwwdotpigeonnetworkdotcom/ Template -///- /admin/clubs/index.cfm QueryString -///- ==================== As I said, the only thing that I believe I've changed is the password. It should be able to find 'club_results' with no issues. I've tried uploading older copies of the page etc and nothing has worked. :-( If anyone can help me with this, a beer will be coming your way. Chris.

Thanks for your reply Jock. Unfortunately, I'm none the wiser. :-/ I've pasted some of the code from res_ind_10.cfm below in case that might help. <cfquery name="GetR" datasource="pnet"> SELECT club_results.ClubName, club_results.DateEnter, club_results.ID, club_results.OB, club_results.Mem1, club_results.Mem2, club_results.Mem3, club_results.pos, club_results.Vel1, club_results.Vel2 FROM club_results WHERE ob='Y' ORDER BY"DateEnter"DESC </cfquery> <cfquery name="GetRy" datasource="pnet"> SELECT club_results.ClubName, club_results.DateEnter, club_results.ID, club_results.OB, club_results.Mem1, club_results.Mem2, club_results.Mem3, club_results.pos, club_results.Vel1, club_results.Vel2 FROM club_results WHERE yb='Y' ORDER BY"DateEnter"DESC </cfquery> <cfquery name="qVerify" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine, Clubs.Section, Clubs.Photo FROM Clubs WHERE Clubs.FedCombine= 'Nipa' ORDER BY"ClubName"ASC </cfquery> <cfquery name="EDC" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine FROM Clubs WHERE Clubs.FedCombine= 'East Down Combine' ORDER BY"ClubName"ASC </cfquery> <cfquery name="UF" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine FROM Clubs WHERE Clubs.FedCombine= 'Ulster Federation' ORDER BY"ClubName"ASC </cfquery> <cfquery name="MF" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine FROM Clubs WHERE Clubs.FedCombine= 'Munster Federation' ORDER BY"ClubName"ASC </cfquery> <cfquery name="LF" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine FROM Clubs WHERE Clubs.FedCombine= 'Lanarkshire Federation' ORDER BY"ClubName"ASC </cfquery> <cfquery name="ECFD" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine FROM Clubs WHERE Clubs.FedCombine= 'East Coast Fed Dublin' ORDER BY"ClubName"ASC </cfquery> <cfquery name="ISRF" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine FROM Clubs WHERE FedCombine= 'Irish South Road Fed' ORDER BY"ClubName"ASC </cfquery> <cfquery name='ClubWinsO' datasource='Pnet'> SELECT COUNT(Mem1) as total, Mem1 FROM club_results GROUP BY Mem1 ORDER BY count(mem1)DESC </cfquery> <cfquery name='ClubWinsY' datasource='Pnet'> SELECT COUNT(Mem1) as total, Mem1 FROM club_results WHERE YB='Y' GROUP BY Mem1 ORDER BY count(mem1)DESC </cfquery> <cfquery name="fife" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine FROM Clubs WHERE Clubs.FedCombine= 'Fife Federation' ORDER BY"ClubName"ASC </cfquery> <cfquery name="Solway" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine FROM Clubs WHERE Clubs.FedCombine= 'Solway Fed' ORDER BY"ClubName"ASC </cfquery> <cfquery name="Cumbria" datasource="pnet"> SELECT Clubs.ID,Clubs.ClubName, Clubs.FedCombine FROM Clubs WHERE Clubs.FedCombine= 'West Cumbria Fed' ORDER BY"ClubName"ASC </cfquery> Thanks again.

Hi all, Apologies in advance if this is a question with a very obvious answer. The previous person who designed a website database based on ColdFusion has up and left and the owner has not heard from him for a while. I've been asked to take over on a few aspects, mainly design and setting up a CMS for him for basic editing. I've also been asked to look at this ColdFusion database. I've never used ColdFusion before. Essentially what I need to do is create a new database which displays results for this year, how do I do this? Do I need access to MySQL? To give you an example, here's the results page, fully populated with peoples information. wwwdotpigeonnetwork.com/admin/clubs/index.cfm I need this to be blank, so that people can start from scratch for this year. Any ideas? I have very limited access to certain features, i.e. MySQL as previous person would have set this up etc. Any help would be much appreciated, Many thanks. Chris.

Thanks for getting back to me mrchristoph. I understand what you're saying, but unfortunately that would result in the main background image being repeated and it can look quite unsightly at higher resolutions. Just to reiterate this is purely needed to get rid of that black void to the right so rather than just repeating the whole background image, I take a slice of that image of about 5px, and repeat that on the x axis. As I suggested above, Is anyone else familiar with this technique? Please let me know if I'm not being clear enough. Thanks, Chris.

Hello everyone. I'm currently designing a website that has a single background image defined within my css. body {background:url(images/bg_image.jpg) no-repeat #040303; } This serves me well at certain resolutions. My problem is though, at higher resolutions, a black void will begin to appear to the right (See image attachment). One technique that I've previously used is to create a 5 pixel wide repeating image based on the the background image, and it's worked perfectly, but the way I've written the CSS this time around doesn't seem to allow that? Does anyone have any suggestions? I'd really appreciate any help towards this. Thank you, Chris.

Hello all, I've recently started a placement job for my third year at University. I've had the opportunity to speak to some people and one of their main requests is a new, more efficient replacement for their old referral system. Essentialy, in simple terms, it's almost like a large contact form with different relevant sections to each department. Rather than sending ALL the information to EVERY department, they would like to be able to choose particular entered information to go to a specific departmart. For example, A students financial information to the finance department and so on. As it stands at this minute I believe that this is all done manually. On clicking submit there would need to be some sort of confimation then the ability to go back to the form. I will over the next few days gather more information on the actual project, but I've only been here for a few days. I've recommended PHP as the language of choice for this on the basis that I have some limited PHP knowledge and would be happy to help them with this. I'm essentially trying to use all my resources and people who I know to gather as much information as possible. Could someone point me in the general direction of how to do this? Has anyone ever had a similar project that they can share some information with me on? I appreciate any help with this. Many thanks, Chris.

Thanks for you help Mr. Brightside. Seems very logical but it doesn't appear to be working for me. Do I need to enter <?php include('featuread.php'); ?> into a corresponding .php file or .html file? Do I need to create something within an html file so that the PHP shows correctly though within a browser? I think I'm about to pass this one on, seems to be too much of a head-scratcher.

Hello all. I'm trying to help a friend of mine with their website but I don't have a great deal of skill when it comes to PHP. Essentially what he wants is to have a featured ads section consistently throughout his website. For example, if you look at the link below, you can clearly see a dedicated featured ads section at the top. http://www.ni-ads.com/index.php When you click on the below like, a sub category, you'll see that there is no featured ad section at the top. http://www.ni-ads.com/index.php?cat=37 How easy is this to amend? He's using ionCube but there is apparently no option to add this feature? Many thanks for any help!

Thanks for that. I too will use that until my Php gets better.