dcsimg
www.webdeveloper.com

Search:

Type: Posts; User: evenstar7139

Page 1 of 15 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    16
    Views
    12,893

    Not to be rude or anything but I thought I'd...

    Not to be rude or anything but I thought I'd point out that I posted this 6 years ago and long since figured it out. :) Just thought I'd let you know in case you thought I still needed help or...
  2. Replies
    197
    Views
    42,346

    I've been hearing scary things about websites...

    I've been hearing scary things about websites getting hacked and the owners being liable for lots of damages. The site I've been working on doesn't store credit card numbers or social security...
  3. Replies
    197
    Views
    42,346

    I recently learned that it's far superior to hash...

    I recently learned that it's far superior to hash a password with crypt() than it is with md5(). So, I want to make the switch. However, there seems to be debate on just how to use crypt. What...
  4. Replies
    197
    Views
    42,346

    #1 Has PHP's implementation of regular...

    #1 Has PHP's implementation of regular expressions changed since 2007?

    #2 I know somebody who is learning to do regular expressions with preg_match(). I would like to link her to a tutorial that...
  5. Replies
    197
    Views
    42,346

    #1 Will every page have to send that query? #2...

    #1 Will every page have to send that query?

    #2 I'm torn on whether to use prepared statements or not. Some people tell me they can't live without them, others tell me they hate them because...
  6. Replies
    197
    Views
    42,346

    New questions: #1 I heard that MySQL's charset...

    New questions:

    #1 I heard that MySQL's charset is important when using mysqli::real_escape_string(); What charset should I be using if my site is all in English? UTF-8?

    #2 Also, PHPMyAdmin is...
  7. Replies
    197
    Views
    42,346

    Oh, ok, so he's using that shorthand if statement...

    Oh, ok, so he's using that shorthand if statement right after the assignment operator for $temp. Cool. I've never seen anybody do that.

    Learning new things about PHP is fun :) Thanks :)
  8. Replies
    197
    Views
    42,346

    I will check out Git, then. Anyway, new...

    I will check out Git, then.

    Anyway, new question:

    I ran across something that I've never seen before. It's on line 4. How does that code work? Is it similar to when I do return ($a < $b) ?...
  9. Replies
    21
    Views
    5,891

    Nevermind what I had typed in this reply before...

    Nevermind what I had typed in this reply before (If you saw it before I edited). I got the last little nuances working. You did the hard part, though.

    I am very happy right now :) :) :) :) :)...
  10. Replies
    21
    Views
    5,891

    message_threads table: -- phpMyAdmin SQL Dump...

    message_threads table:

    -- phpMyAdmin SQL Dump
    -- version 3.4.11.1
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Mar 13, 2013 at 05:35 AM
    -- Server version: 5.5.30...
  11. Multiply Column by 1.0003 and then round result up to nearest whole number.

    UPDATE `accounts` SET `bank_balance` = `bank_balance` + ceiling(`bank_balance` * 1.0003) WHERE `user_id` = 1

    This is supposed to multiply the bank balance by 1.0003 and then always round the...
  12. Replies
    21
    Views
    5,891

    Anybody know what to do?

    Anybody know what to do?
  13. Replies
    1
    Views
    943

    Is this significantly faster?

    Say I could use either of these two queries:

    SELECT `name`, `age` FROM `people` WHERE `person_id` = '1';

    vs

    SELECT `name`, `age`, `address`, `email` FROM `people` WHERE `person_id` = '1';
    ...
  14. Replies
    21
    Views
    5,891

    I still cannot get this query to work. Is it...

    I still cannot get this query to work. Is it better to just use a PHP foreach() and send multiple queries?

    Something like this:


    $query = $this->db->query("SELECT `thread_id`, `title` FROM...
  15. Replies
    21
    Views
    5,891

    Additional information: On the line next to...

    Additional information:

    On the line next to last, I changed it to this: b.timestamp = (SELECT MAX(timestamp) FROM furrymail_messages WHERE a.thread_id = b.thread_id)

    and then it just pulls up...
  16. Replies
    21
    Views
    5,891

    *scratches head* I sent messages in between my...

    *scratches head* I sent messages in between my main account and my tester account. On my main it's correctly showing one listing per thread. On my tester it's showing one listing per reply. Here,...
  17. Replies
    21
    Views
    5,891

    I tried that. Then it only brings up one thread,...

    I tried that. Then it only brings up one thread, regardless of how many there are. I want it to bring up all the threads, just one reply per thread. Does that make sense?

    (Looking at the timestamp...
  18. Replies
    21
    Views
    5,891

    I changed the structure of the tables so...

    I changed the structure of the tables so message_threads only houses information about the thread and every message goes in message_messages. I also changed my query a lot and it's not working like I...
  19. Replies
    21
    Views
    5,891

    Okay, I have the following now. I have two...

    Okay, I have the following now. I have two problems:

    #1 For "`timestamp` > 1358748798" I want it to look at each timestamp for each message reply that is retrieved, and if there are none, look at...
  20. Replies
    21
    Views
    5,891

    I tried to do a join in the subquery and MySQL...

    I tried to do a join in the subquery and MySQL said "Operand should contain 1 column(s)". I guess you can't do joins in subqueries?

    This was the code:


    $query = $this->db->query("
    SELECT
    ...
  21. Replies
    21
    Views
    5,891

    Adding that comma in fixed it. That's great. Now...

    Adding that comma in fixed it. That's great. Now I'm wondering:

    #1 If no replies are found, is there a way to have the subquery return the sender_id for the thread? (The whole idea is it returns...
  22. Replies
    21
    Views
    5,891

    I tried to run that query and I got this: ...

    I tried to run that query and I got this:



    Edit, I think my MySQL version is 5.5.29-log
  23. Any way to get auto_increment number immediately after creating a row?

    Edit: Nevermind. I figured this out.
  24. Replies
    21
    Views
    5,891

    Need Help Joining these Queries

    I am trying to construct a query that deals with threads and replies.

    It involves two tables: one for private message threads, the other for private message replies. When a user first messages...
  25. Yeah, I am. I just didn't want to paste the whole...

    Yeah, I am. I just didn't want to paste the whole HTML page. It's got this one: <!DOCTYPE html>
Results 1 to 25 of 357
Page 1 of 15 1 2 3 4
HTML5 Development Center



Recent Articles