[count number of updates]

will check it tomorrow.  But thanks!  Took a quick look and it seems to simplify the process.

Enjoy the weekend.

[changing file extention to PHP]

I have a form that was written and works well as an HTML file.  Now I've learned a little (tip of the iceberg, i'm sure) and want to place password protection BEFORE it.  To the best of my knowledge, this will require SESSIONS and turning my form into a PHP file.  (I assume LOTS of reading is ahead of me... LOL)

 

Can I simply change the extension to a PHP, add the <? tags > and just keep the HTML in place?

Or do I need to make it PHP and ECHO every line of code?

Or is there another way?

 

And while on the subject, does a PHP file require anything before publishing, the way an HTML requires the

<!DOCTYPE> information?

[count number of updates]

Hey Pik!  Haven't had a chance to plug it in.  It'll have to wait til another day, but I wanted to see if I was on the rigth track.  What do YOU think of it?

[count number of updates]

Isn't that what I did.

Are you trying to be a wiseguy and waste my time, or do you have an actual solution to suggest to improve my code?  If so, please POST IT!

[Only ID and Date is writing to MySql]

Does out of date mean the code will NOT work??

 

They do have a friendly look and easy to follow instructions (even if they are WRONG... LOL)

What sites DO you RECOMMEND as a learning tool? 

[count number of updates]

How would i code if I wanted to do as you suggested and;

                just increment by 1 every time an update occurs.

[count number of updates]

But then how do you get them to increment?

[count number of updates]

Don't know how to do what you suggested, so I went with what I could think of.. LOL

[count number of updates]

I got to thinking late last night (which generally leads to trouble), so please be gentle if some educating is in order, as I suppose I will touch a few related issues.

 

As I develop my database, I will include two seperate columns.  One for the time/date that an order was placed.

A second for the time/date that an order is updated (unless there's a better way, please inform me).

 

I pressume that if a record is updated several times, it will continually overwrite the time/date to the point that I will only see the latest update.  Now I was wondering if I could create a third column to keep count of the number of times a record had been updated, so if it were altered 16 times, I would know when the last update occurred, and have the count number also.

 

Will something like this coding work?

 

SELECT updates FROM myTable WHERE id="$id"

$updates =n

if n<1, n=1

}else{ n++

 

[a question of TIME]

Well, i plugged in a TIME charachter that's NEW to 5.1 and it did NOT work.  The one for 4.1 did okay though, so, being as I'm too lazy to check the server info, I'm gonna say it's 4.1

 

Meanwhile, I know the server and DB is on California time. 

 

Gosh, I'll have to dig up the code I once wrote that simply added 3 hours to the time (unless someone has it handy).  If I remember correctly, I had to add it in a multiple of seconds or minutes (like 3 x 60x 60).  Oh well, I have BIGGER issues with the damn database... LOL.

[Only ID and Date is writing to MySql]

I see what mikosiko is saying.

Your DATE is being GIVEN on the same page.  So date and ID (which I assume is automated by the table) are sort of a guarantee.  If you're putting data in for the other fields from a form, you need to MATCH the 'name' in the form with the 'name' in this script so that it can be put into the table (make sense).

Backtrack your steps, and make sure the form ACTION is naming THIS FILE with EXTENSION.

[Only ID and Date is writing to MySql]

I recognize the code (i was on that website TOO).

And what I got needed to be tinkered with before it would work.  Try re-reading the webpages before it to make sure any files or code that was used in a tutorial PRIOR to this one, are written properly and in your pocession.

 

Check to make sure all the file names and field names follow the same structure.  Good luck!

[DB does NOT record data]

And why would someone want the redundancy of the statement the way I had originally copied it?

[DB does NOT record data]

But what's the benefit of having it versus not using anything??

[DB does NOT record data]

I'm stillnot exactly sure that I understand EXACTLY what that first line is COMMANDING.

(as a newbie, some code just ends up in my script because a resource SAID it SHOULD be there, and NOT because i FULLY understand WHY i would WANT it there)

[Is there a limit to columns?]

Why do you say that?

 

And if you READ the ABOVE comments, this is just basic information!

[Is there a limit to columns?]

Read the link, thanks!

 

Is there a way to confirm a table or row SIZE so that this is known BEFORE adding additional columns or running into trouble?

[message AFTER the UPDATE]

Never used AJAX (except in the sink!)

 

It's not THAT important, was just thinking out loud.

 

There's probably something burried in my Javascripting that'd do it too, but I'm trying to learn/experiment with PHP and database usage.

[Is there a limit to columns?]

So what happens if you go over? 

Does it just drop the last 115 columns  (200 intended -85 suggested max)?

Is there some sort of warning message triggered when the table is created (or surpassing the limits)?

[a question of TIME]

OK, so I thought it was as simple as just slapping it in there and having it echo the time on my page.

 

So I tried:

date_default_timezone_set('America/New_York');

$date = date('Y-m-d H:m');

echo "It is now $date";

 

and got the same error as above: Fatal error: Call to undefined function: date_default_timezone_set()

 

but when I took out the top line: date_default_timezone_set('America/New_York');

I got a time posting, but it is Californian.

 

I suppose there are two different things I have in mind.  Fist, just to have the time display as an ECHO message.

Second, if I can get it to run, I would add it to my table so I could get the NYtime that a record was added.

 

[a question of TIME]

Even the code from David provided me with:

Fatal error: Call to undefined function: date_default_timezone_get()

[a question of TIME]

code you've written:

 

echo "it is now $date_default_timezone_set('America/New_York')";  $NOW()

 

comprehensive explanation of the problem:

 

It won't provide the time.

 

[a question of TIME]

Thanks DAVID.

 

So there really is no way to just stick NY time into a database?  Or does this set the timezone perminently?

 

 

[a question of TIME]

Plenty of times, and it JUSt won't function for me.

 

 

[a question of TIME]

see above... need proper syntax