Search results for query: *

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...

try <a href=&quot;javascript:window.open('KBUpdate.asp?KBID=<%response.write(iEdit)%>&Delete=y','DELETE','toolbar=no,statusbar=no,scrollbar=no')&quot;><img src=del.gif title=&quot;Click to delete entry&quot;></a> Hope this helps, Phil Clare http://www.trinipoint.co.uk

Hi Patrick, Unfortunately if a disabled field is disabled the data does not get submitted as part of the form. If you don't want the user to see it try using a hidden field (type=&quot;hidden&quot;) or if you do want them to see it, use a label and a hidden field to the same effect. Thanks...

Hi, try reinstalling the nt option pack to reinstall pws Hope this helps, Phil Clare http://www.trinipoint.co.uk

Hi, There are a couple of things wrong here: firstly, you need to check whether your form method is POST or GET (it's usually post but your code seems to be assuming a GET method) if it using POST then you need to change request.querystring to request.form whenever you use it to access a form...

Hi, that's not possible I'm afraid, it depends entirely upon the software that the email is being read in. As far as I know what you are trying to do is impossible Thanks Hope this helps, Phil Clare http://www.trinipoint.co.uk