Ok, so it seems it's the server setup. I've tested the same pages on one of our own servers and it's working fine with special characters.

Thanks again to all of you that posted.

Hi guys

Thanks for all the input. My suspicions lie with the hosting company. We've had numerous issues before and the problem was always something that they hadn't setup correctly.

I'm going...

Am I the first person in MySQL's entire life to need this sort of thing? o.O
Surely someone before me has run into this problem. I thought utf8_unicode_ci would do the trick or utf8_general_ci but...

I have a database that needs to hold names of people from all around the world. Some names have special characters in them such as é and ¢

Is there a character set I can use that will accept any...

Thanks for that but there seems to be one problem...the 'illegal' characters are only detected if they are the first or last letter. If it's anywhere between valid characters it goes undetected. Is...

Hi all

I've been trying to find a regular expression that checks if input contains any of the following characters only:

`~!@#$%^&*()-=+\|/?.>,<;:'"[{]}

I want to allow users to input any...

Thanks for your reply sknake. I found what my issue was. My firewall went haywire and wasn't letting any connections on port 21 through.

Hi guys/gals

I'm having the most frustrating time trying to connect to FTP servers in order to upload files. I try to connect to a number of different FTP servers and cannot connect to any of...

I solved my problem by using the following:

WHERE ref BETWEEN 1 AND 50

As the title says, I'd like to select a certain number of rows from a table starting from a specified row.

So for example, I have a table with 250 rows and the rows are numbered incrementally...

Hi cgyrob

Thanks for the response. My original statement is actually correct. I was being blonde and didn't change a class variable on my display page which was causing the issues.

Atli, you are king. Thanks for those first two links. Just what I was looking for.

As the title suggests, I'm having trouble sorting the results of a union statement. I'm trying to sort the results by date descending and it's coming out ascending.


(SELECT a, b, c, d, e, f,...

I think everyone is misunderstanding what I'm after. I'm looking for a resource that explains the ins and outs of the http protocol related to uploads.

I don't need a work around on how to upload...

Php.ini controls the file upload size via 'upload_max_filesize'.

The http protocol only allows one connection for uploads (this is about all I know). Trying to upload multiple files using multiple...

Hi everyone

I've been googling my time away trying to find a resource that explains how many php uploads http can handle at once and any extra info on the process and limitations etc. Does anyone...

Ok, so it seems it was the MIME types in the end.

For future reference, is there any other way to find out the MIME type of a file (other than checking the file extension based on the name)?

Yes, file permission and upload size are not the issue. The server hasn't got error messaging turned on. I'll see if I can get that sorted out. I haven't echo'd the mime type to see if there's...

Hi all

I have some functionality that allows the upload of files such as MS word docs, zips etc. It works fine on my pc and another test machine but doesn't seem to work on two other machines I've...

Hi all

A clients website has been and I'm trying to figure out how this could have happened.

Any ideas how HTML/framer could have been placed on the server and how to remove it? I've found lots...

I managed to solve my problem by placing a 1x1 transparent give inside the <a> tag and setting its width and height to the size I needed.

Hi guys and gals

I have an image of a map. The map has different areas on it that when someone mouseover's an area a tooltip pops up giving a small description.

Now I've gone about doing this...

LOL...I could kick myself right now. This is one of those situations where a simple character messes you around completely. Thanks a lot kkeith29.

Problem Solved!!!!!!!!!

Hi samarudge

I've checked my $row[1] variable using a while loop and all the values from the database are coming through. For some reason it just won't work with an array. It's really confusing...

I found this a month or two ago:

addcslashes($id, "\x00\n\r\'\x1a\x3c\x3e\x25");


Can't remember what it prevents from being entered. Just recall that it was pretty secure when it comes to...

Hi all

I'm having a strange array problem. I'm pulling variables from a database and putting the values in arrays. One set of values are pure numbers. This array works fine. My second set of...

Yes you did....reputation added ;)

I retract my earlier statement.....it is in fact working.....thanks Menster for your input ;)

Hi Menster

Thanks but my code still gives all my menu items the class of "currentNavSub". I'm not sure if this is because all links are the same page or if "?type=x" is irrelevant. Not quite sure...

Hi everyone

I have a menu that I'm creating dynamically with links that have query strings on the end of them. Basically I want the menu item, that's related to the page the user is on, to be in a...

Hi Airshow, thanks for your reply. Your solution would have been my choice if my list was static. However this isn't the case.

I know there's a way in CSS to point to a specific li. Take the...

Hi there

I've been trying to find out how to point to a specific li in a list but no matter what search term I use in google I cant find what I'm looking for.

Basically I want to point to a...

Thanks a lot kireol ;)

Hi emarshah

I'm looking for a php development framework (found the right term :D ). WAMP is a server enviroment. Thanks for your response though.

@goldy

Hi, is there any reason you need to have the 2 values from form1 and form2 calculate into the text box in form3 before you go to the next page?

If not, then put the text box from form1...

Hi all

I'm not even sure if development environment is the right term but I'm looking to find out what the best or most popular development environment to use is? I've herd of CAKE and was told...

Ok, seems I've managed to sort my problem.

Adding "DESC LIMIT 1,1" to the end of my MySQL query selects the second last row in the table.

I did some fiddling with this and it seems that adding...

Hi all

I've been trying to find a way of doing this and have come up dry. Is this possible? If so could someone tell me how to go about this?

Much appreciated
Venom Rush

Thanks davidn. I managed to sort out my problem with a join though. But I'll definitely keep your method in mind the next time I run into something similar. ;)

@ cwarn23
Thanks for the help. Much...

Hmmm, I've tried joining the two tables with a normal join, left join and a right join but they all come back with the error of "Column 'code' in field list is ambiguous"

I think this may be...