www.webdeveloper.com

Search:

Type: Posts; User: yintercept

Search: Search took 0.03 seconds.

  1. Replies
    9
    Views
    1,393

    From_unixtime()

    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...
  2. Replies
    3
    Views
    624

    You could also accomplish your goal by removing...

    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...
  3. Replies
    4
    Views
    1,075

    Unfortunately, you have to worry about the...

    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...
  4. Replies
    6
    Views
    794

    You can use variables in the file name. Since you...

    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...
  5. Replies
    1
    Views
    682

    Replace the "or die()" structure with an "if ()...

    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,...
  6. Replies
    4
    Views
    1,075

    My guess is that the problem has something to do...

    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...
  7. The updating is generally done by a default...

    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...
  8. Replies
    7
    Views
    778

    Image verifications schemes violate the...

    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...
  9. Replies
    1
    Views
    623

    Max(), Min(), Sum(), Count(*), etc. are group...

    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:

    ...
  10. The quotes seem freaky to me. I am assuming that...

    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...
  11. Replies
    1
    Views
    1,157

    The query looks good to me. The is a spurious...

    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...
  12. Replies
    7
    Views
    778

    Temp Tables for Anonymous Input

    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...
  13. Replies
    2
    Views
    570

    Watch the Quotes

    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...
  14. Replies
    3
    Views
    876

    You might try giving the columns name an alias in...

    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...
  15. Replies
    6
    Views
    600

    Yes. It is possible. The amateurish way to do...

    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...
  16. Replies
    4
    Views
    836

    I probably misunderstood your question. My take...

    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...
  17. Replies
    6
    Views
    973

    I looks like you have the padding for the cell...

    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...
  18. Replies
    7
    Views
    992

    It looks to me like the problems are related to...

    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...
  19. Replies
    23
    Views
    48,726

    The ternary operator is also really good for...

    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

    ...
Results 1 to 19 of 19
HTML5 Development Center



Recent Articles