minapre999

whoops - I meant rawurlencode()

I figured out the problem - you need to call htmlspecialchars() before putting the filename as a value into the Select.

I have a PHP script on my clients site that lists the files in a directory in a HTML Select Form. Sometimes the file names need to have UTF8 characters in them. The filename can be read normally using readdir() (I need to utf8_encode() the name to have it appear as it should in the web page). However, I get a "The requested URL myurl.html was not found on this server" message when trying to load the file, which is the submit action of choosing an item from the HTML Select Form. The error arises regardless whether the file name has utf8_decode() applied to or is in the UTF8 encoding. The Form has accept-charset='utf-8' in the tag. If anyone has experience using PHP with utf8 encoding, help is greatefully accepted.

Hi Airjunkie I haven't used a lot of the mysql functions, but have had a look at the mysql manual, which says RAND() returns a random floating-point value in the range from 0 to 1.0. You need to make sure that there is a row in the database for media_id, which appears unlikely for the statment "media_id = RAND()". maybe replace the where clause with "media_id = (SELECT media_id FROM media_info order by RAND() limit 3 )" might work? Peter

I went through this process not long ago, and came across a package called Trouble Ticket Express (www.troubleticketexpress.com). It is no frills, but works great, and can be upgraded to a (commercial) more complex version if required in the future. You can see an example on TCH server at my (site) Peter