efficacious

I would love to do this for you mikosiko but like I said it is wrapped up within an entire database object, even if I showed you the code where the SQL is compiled for the query you wouldn't have any clue what was going on. I would have to basically show you two full objects and a bunch of other crap... However your bit about error reporting got me thinking ... Why not check the error log just in case the error didn't get output to the error catch. I figured out the problem... I was missing a ">" character when I was calling the link method to the DB. How fricken stupid is that.. honestly it should have thrown up a syntax error but it didn't. mysql_error didn't even report that the connection wasn't being established... SOAFB. Thanks for the help... (such a stupid issue lol)

OK so I did a test, I copied this generated SQL and pasted it into PHP my ADMIN and it works just fine... so there is nothing wrong with the SQL why does it not execute? I have a DB access object that i wrote.. It probably fires off 20 or 30 some queries through this exact same method yet for some reason this ONE query doesn't run.. I just don't get. None of the column names are wrong.. none of the values are already in the DB, mysql_error reports no errors and affected rows says 0. I double checked and checked and rechecked and checked again to see if there was some issue stopping the query from being run or something along those lines and no such thing. The SQL statement gets sent to the DB and the DB puts up its middle finger.

Hi all, I am having some trouble getting a query to run and I was hoping someone might be able to point out why. Here is the SQL: UPDATE `myTable` SET `myColumn`='SomeText' WHERE ID='15' thanks Every time I run it, it just returns as 0 rows affected.. and surely enough checking the DB shows that nothing has happened.

could you just run two queries?

the only error showing up in the logs is : Premature end of script headers: faction.php I did some searching on the error and found that its about as descriptive as "Internal Server Error". This one has me pulling my hair out a bit... there are 4 other pages and each of those pages works just fine.. I compared my two pages with the other pages and I'm not doing anything special in my pages thats not being done in the others... at least nothing that I can see.

it should do exactly what your wanting.. time Returns the current time measured in the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT). if you are changing the default time zone before using the date() function then it should be fine. did you test it?

or...... you could use javascript to load a hidden Iframe and pass your vars to the iframe behind the scenes via _GET if not sensitive data... or just encrypt it first for what your talking about tho you are probably better off with ajax.. its really not that difficult. if you already know javascript.

np i am always up for a reg challenge.. the more you do the better you get glad its working for you

I still don't understand what CGI is sposed to mean, because every explanation i've come across just claims that basically any serverside programming is a CGI.

<?php $Pattern = '/^[a-z0-9]{8,12}$/'; ?>

i read somewhere during my searches on google for internal server errors (500 error) could show blank displays or the 500error

lol i virtually have this same issue right now... haha cept i'm not in control of the erroneous server

i will i always forget that and assume the server already has it on... I leave it on , on my server but its not a production server so..

try using just a time stamp of secs and then converting the time just before you output to the display forcing PHP to handle the conversion. $MyTimeStamp = time(); $UserTimeZone = "America/Denver"; date_default_timezone_set($UserTimeZone); $Time_Day = Date("H:i:s Y-m-d", $MyTimeStamp); echo($Time_Day); i actually just had done something like this.. where I needed the time to be changed based on the clients timezone.. so I had to write a Javascript function to find that timezone automatically and pass it to PHP incognito style.

i would love to unfortunately it isn't my server. The application works flawlessly on my server. when i next speak with the owner of the server i will instruct him to do so but until then I'd like to exhaust any other possibilities.