Search:

The function UNIX_TIMESTAMP converts a timestamp to an integer. I think you would want FROM_UNIXTIME() for selecting the data. FROM_UNIXTIME() converts from an integer to a timestamp.

"SELECT...

You could also accomplish your goal by removing the foreign key relation.

Like the other posts, I don't know your database schema nor your application logic. It is entirely possible that someone...

Unfortunately, you have to worry about the character set of everything that touches the data. That includes character sets of the database and of your server. Computers are filled with helpful...

You can use variables in the file name. Since you are using full quotes, you could just create the user name by putting a user id, eg. $uid, in the file name as "app$uid.html". Personally, I prefer...

Replace the "or die()" structure with an "if () else ()" structure. You can then put header() statements in the if then structure. The following structure puts an error entry in a .txt file,...

My guess is that the problem has something to do with curly quotes. Different character sets and code pages use different characters for curly quotes.

What was the source of the data? and what is...

The updating is generally done by a default trigger called: CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP . It is possible to remove or control the behavior of triggers.

Triggers are pretty nice...

Image verifications schemes violate the principles of accessiblity.

I can see having just one verification image on a registration page. Putting an image verification on every page is a real big...

Max(), Min(), Sum(), Count(*), etc. are group functions. They go in a select part of a statement. A group function essentially rolls up long table into a single row.

A good statement might be:

...

The quotes seem freaky to me. I am assuming that you want something that prints "King" if $_SESSION['my_array'][2] is "M". I would write such a line as:


<?php
if...

The query looks good to me.

The is a spurious comma in the opening part of the query "SELECT code, FROM". You probably put that in when you added the post. I tried the query on MySQL and it...

I find this subject interesting as I am currently writing an upgrade where I am doing the reverse of the suggestion. My sites had the design where I would enter new user data in a table with a status...

You were very close. You had too many quotes in the SQL string.


mysql_query("UPDATE tablename
SET fieldinmysql='$textboxone $textboxtwo'
WHERE blah...");

A SQL query is just a string of...

You might try giving the columns name an alias in the SQL string. Let's assume the column in question is called mycol, and your tables are called First_Table and Second_Table. You could write the...

Yes. It is possible.

The amateurish way to do this is to carry the data from one form to the next in hidden fields. If everything goes well, when you get to the ninth page all of the data will be...

I probably misunderstood your question. My take on your question is that you want the browser to popup a file download box when a person clicks a link to a link. If you go to the page Ryan Hiller...

I looks like you have the padding for the cell defined in both the cellpadding attribute for the table and in the style for the TDs. If you are using style sheets, you probably should nix the...

It looks to me like the problems are related to data types. '1' is not the same thing as 1. '1' is a string with chr(49). 1 is the number one.

'1001' is a string of characters...

The ternary operator is also really good for setting the checked flag. The ternary operator has form:

$x = (condition)? 'val1' : 'val2';

x will be val1 or val2 depending on the condition

...