Jump to content

NoSalt

Members
  • Posts

    77
  • Joined

  • Last visited

Everything posted by NoSalt

  1. Hello All I have a MySQL question about multiple OR statements; I guess it could also be about multiple AND statements. Say I have the following statement: SELECT * FROM EVENT_TABLE where EVENT_TYPE_ID = 1 OR EVENT_TYPE_ID = 2 OR EVENT_TYPE_ID = 3 OR EVENT_TYPE_ID = 6 OR EVENT_TYPE_ID = 10 OR EVENT_TYPE_ID = 11 OR EVENT_TYPE_ID = 13 OR EVENT_TYPE_ID = 15 OR EVENT_TYPE_ID = 16 OR EVENT_TYPE_ID = 34; I was hoping that there was a shorter, more efficient way to do this. Maybe like this: SELECT * FROM EVENT_TABLE where EVENT_TYPE_ID = {1 OR 2 OR 3 OR 6 OR 10 OR 11 OR 13 OR 15 OR 16 OR 34}; So far, however, I have had no luck stumbling on the key. Is there a way to do what I want or am I stuck with the "hammer approach"? Thanks for reading and have a good day.
  2. Hello All I'm not sure if this is the correct place to post this, but it seemed the best option out of the other choices on this forum. I have decided that I would start to use Subversion to control my PHP projects (instead of my home-grown version control), and I would like some assistance please. I have never used Subversion before but my co-workers cannot say enough good things about it. I have been doing some reading about how to set-up and use Subversion but I have been confused by some things. Whenever I read a "how to" talk about setting up a repository they always start out in "/home/username". The only problem is that PHP will not run from that location; as we all know, it must run from "/var/www/html". So I guess my question is can I set up a repository in "/var/www/html" instead of my home directory? Also, what about the fact that I already have many PHP projects in the web root? Will SVN overwrite or duplicate any of the code that is already there when I create the new repository? As I am a complete newbie at this, any and all assistance will be appreciated. Thanks, and have a great day.
  3. Thank you
  4. Hello All I would like to do a page footer with CSS but am having difficulty figuring it out. What I have now is: h5.footer {padding: 10px 10px 10px 25px; font-size: 11px; position: absolute; left: 0px; bottom: 0px;} This works great until the page goes beyond "the fold" and then the footer shows up over the main page content. What is the best way to position a footer so that it is always at the bottom-left of the page even if the content goes beyond the fold? Thank you all for reading. Have a good day.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.