Recent content by philclare

Hi, I am using fsockopen to retrieve an HTML page that has been compressed, but when I try and decompress the string I get the following error : Warning: gzuncompress() [function.gzuncompress]: data error I found a bug report on the PHP pages at sourceforge that said it was something to do...

Hi, I am trying to load an XML file from a mapped network drive (w in this instance) but the MSXML component is reporting that the "system cannot locate the specified file". Any ideas? Thanks Phil Clare Hope this helps, Phil Clare http://www.trinipoint.co.uk

Well as it turns out my columns are in order so I can gut the lowest by using COALESCE (since that returns the first value that isn't null) Thanks anyway Hope this helps, Phil Clare http://www.trinipoint.co.uk

Hi, Is there any way to select the minimum value in a set of columns in a single row. eg. I have a table with 6 numeric fields, some of which may be null, and I want to find the lowest number in these fields for each row... I can find the first number by using COALESCE but not the lowest Any...

Well, the file is a list of SQL statements but I can't do an import in phpmyadmin or anything because the upload times out due to my ISP, the script is only for me to use and will be in a password protected folder so I don't have to worry about other people using it. I think the record counter...

Hi, I have a file consisting of a number of lines of text, I want to read the file in order and execute some code based on the content of each line. My problem is that I only want to access each line once and because of the size of the file, my script times out, so only gets so far down the...

Is there anyway that I can get the number of rows that a query would have returned if I hadn't used the LIMIT clause? I have a database with 6000 records and when I execute a query I want to page the results, but also need to know how many results there are altogether so that I can work out how...

You are missing some bits of your SQL: # setup SQL statement $sql = " INSERT INTO " . $_POST['dropdownselection'] . " "; $sql .= " (PART_NUMBER, MACHINE, NEED_DATE, NOTES)VALUES "; $sql .= " '$PART_NUMBER','$MACHINE','$NEED_DATE','$NOTES') "; should...

in your select query do SELECT * FROM newstable ORDER BY newsdate LIMIT 10 Hope this helps, Phil Clare http://www.trinipoint.co.uk

You might need to wrap your regexes in delimiters i.e. change them to: $string2 = preg_replace("/\n(.)/e", strtoupper('\\1'),$string2); $string = preg_replace("/\b(.)/e", strtoupper('\\1'),$string); Hope this helps, Phil Clare http://www.trinipoint.co.uk

sorry, just noticed that they are timestamps and the first one is automatically updated... sorry to waste time, thanks for the response sleipnir I guess that is where you were going!

I have a table in my mySQL database consisting of a number of fields including two date fields. In a page I perform an update changing the value of one field, however the update also changes the value of the first date field to NOW() (i.e. today's date). It doesn't however update the second...

string("0",3) creates a string of 3 zeroes... simply concatenate that onto the beginning of the string Hope this helps, Phil Clare http://www.trinipoint.co.uk

response.write &quot;<title>mytitle</title>&quot; Hope this helps, Phil Clare http://www.trinipoint.co.uk

Hi Paul I dunno, try changing it to this (remove all the jscript) <a href=&quot;KBUpdate.asp?KBID=<%response.write(iEdit)%>&Delete=y&quot; target=&quot;DELETE&quot;><img src=del.gif title=&quot;Click to delete entry&quot;></a> The only problem with this is that you won't be able to switch off...