trq

This is pretty standard practice so I would say yes, it's fine.

Where is the code you are having trouble with?

You do your sorting in your query. This has nothing to do with php. SELECT fld FROM tbl ORDER BY some_fld;

I would suggest you misunderstood the tutorial or it was poorly written. You cannot insert a string into an integer type field.

You posted your question in the "PHP Applications" board. Hence, you need to tell people what application it is your working with so that people who have worked with said application can offer to help.

I meant what protocol is the server? Web sockets are implemented using HTTP. Sorry, I don't really collect links but you should be able to find something on Google. You would probably be better implementing this in a language more specific to the task though. JavaScripts Node.js comes to mind, it's perfect for such things.

Sorry, i didn't notice your example was an INSERT query. Most people don't use that syntax for an insert. Anyway, It's not called "auto increment" for nothing.

What sort of server? In general, the server will lock unless it is written to accept multiple connections/requests.

This topic has been moved to Other Libraries and Frameworks. http://www.phpfreaks.com/forums/index.php?topic=350480.0

As I said, you only need to update the fields you actually want to update. Trying to set an auto incrementing field to an empty string "" will only cause an error.

You need to check it is null within the template where the actual data is displayed.

Your not inserting any data so there is nothing to escape. And no, just update the columns you wish to update.

UML isn't really tied to a particular language.

Nope. I'm currently at work and haven't really got the time to look at the links provided. I guess I'll check it out when I get home. You forget that I live in Aus. there's not much that happens in the U.S that I'm interested in.

You might want to let us know what application it is your actually using.

I have no idea what you guys are talking about.

Why don't you tell us what the error message is instead of having us play guess?

Having database columns such as col_1, col_2, col_3 etc etc wreaks of poor design. I would start there. Google some tutorials on "Database Normalisation" because as it stands your database design is terrible and your code won't make it any better.

That will get you banned. I suggest you contact your host and ask them if you have shell access.

The script is encoded, you will need to contact the vendor.

This topic has been moved to Application Design. http://www.phpfreaks.com/forums/index.php?topic=350418.0

This topic has been moved to Ajax Help. http://www.phpfreaks.com/forums/index.php?topic=350408.0

Shell access button? You generally access the shell via an ssh client. You may however have some web based shell emulator that will suffice (this sounds like what your looking at). Login via that and execute the appropriate commands.

You need shell access to be able to do this. Either that, or create the database locally, then make a dump of that. You should have some method of importing a database from a dump available through your control panel.

There are lots of different ways of doing it and lots of tutorials on the subject. Why dont you google for some Ajax tutorials or have a look at jQuery's Ajax documentation and come back when you have a more specific issue?