Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by Err

  1. Make your table a fixed height: 300px height or whatever you want the max to be. Inside your table add a <div> with an overflow of auto and a height of the max size you want. If anything goes outside the 300px (in my example) then scroll bars will appear. What does the trick is the <div> and the overflow: auto;, overflow doesn't work quite right on <td> so you're better off using a div. <table style="height:300px;"> <tr> <td> <div style="overflow:auto; height:300px;">YOUR CONTENT HERE</div> </td> </tr></table>
  2. http://w3schools.invisionzone.com/index.php?showtopic=42903
  3. Try: [...] ORDER BY profit DESCOr: [...] ORDER BY SUM(profit) DESCORDER BY does ascending (ASC) by default.
  4. Ah, that's helpful. There seems to be acronyms like these popping up everywhere and I lose track.
  5. Took about a minute to make this, you can use this as reference, but this is pretty much what you need: $sql ="SELECT acct_lastlogin_time FROM $db WHERE uid = '".$q."'";$qry = mysql_query($sql);$result = mysql_fetch_array($qry);echo date('j F Y, H:i:s', $result['acct_lastlogin_time']);
  6. Some web servers remove/never install phpMyAdmin because there are some script kiddies out there that check for it and try to use un/known vulnerabilities to get access to the database.
  7. I need debuggers/testers. I tested this using PHP 5.3.5 and MySQL 5.5.8. I need to find to know how well this program works outside my testing environment which is where you guys come in. I would really appreciate some feedback. ShowMyDB is basically a very light-weight version of phpMyAdmin (I use none of their code). I created this for those times when I have no access to a database manager like phpMyAdmin. ShowMyDB has very basic, but useful functions for managing databases without installing complex database managers. ShowMyDB can be easily dragged and dropped into any directory and only creates a single configuration file that it references. It has a login feature to keep unwanted people from accessing it. Best of all, you can change the file name of ShowMyDB to anything and it will work just fine. Doing this prevents unwanted people from guessing if you have it installed on your web server. Known Issues: Has problems saving special characters when using the Insert tab.You can download it here:http://showmydb.dyndns.org/index.php?p=download Note: I got the approval of a moderator to post my project here.
  8. Err

    color of text

    Glad it worked.
  9. It doesn't seem like you're doing anything wrong. If you created a new directory called "FAQ" with another index page and you're linking to it from the parent directory then nothing is wrong. It's doing what it's suppose to do. Now if you want it to be: www.home.com/FAQ/index.html then you will have to add "/FAQ/index.html" to your links.
  10. Err

    color of text

    Google Chrome (a browser in case you don't know) has a built-in "element inspector". With that browser you can right-click on the webpage at exactly the spot you want to target and click on Inspect Element. A box will popup in the bottom with all the code laid out. On the right are the styles (or CSS) and is currently being applied to the HTML element selected. You can actually edit the values around and they will change on the webpage (and I should note that this will not keep the changes you make), you can use this method to track down the style that you need to change on the real CSS.
  11. Err

    sorting arrays

    It seems like that you're creating a new array every time instead of having everything in one array. Sorting will only work if you have all you data within an array.
  12. Yes. I've made sure of that.
  13. You're talking about positioning your forms? If so, you can use a table (recommend for beginners, in my opinion for ease) so that you can position your forms correctly. <table> <tr> <td>Name:</td> <td><input type="text" value="" /></td> </tr> <tr> <td>Message:</td> <td><textarea cols="30" rows="20"></textarea></td> </tr></table>
  14. You can't replace <table> with <div>... I mean, you can, but that's not correct. It's: <div> <table> <tr> <td></td> </tr> </table></div>
  15. Err

    MySQL Update... Limit

    Thanks for your help. I managed to do this by using the WHERE clause and using the data in the record to act as a reference point, then I just used LIMIT 1 so in cause there are doubles, it only updates one record.
  16. Yes, both. In fact, I originally started with those two but I've been at this for so long that I forgot to mention it.
  17. I'm dealing with a replacement character inside a database... and it's fine if it stays there but I'm trying to edit it. My form displays the character as a diamond shape with a question mark in it (�). So I submit the form, I compare the data between the one on the form to the on in the data to see if it has changed. The problem here is that when I submit the form it turns the replacement character into & #65533; which is the html entity equivalent so when this happens it fails the comparison and the code thinks the string has changed-- which it has, but not really. I've tried to employ different methods of either turning the replacement character into the html entity equivalent from the database when it's being compared --it starts to turn another seemingly normal characters into other replacement character html entities equivalent (through no fault of my own)-- and turning the html entities into the replacement character --which doesn't work-- but they both fail. My questions is: How can I keep the character from turning into an html entity?
  18. Yes. Let the content of the website do the work but also use the <meta> tags for descriptions and keywords. Even though a lot of search engines have stopped using meta for ranking, having a description will show up as the small text below search result.
  19. That's kind of shady... to hide things on the site for SEO (here is why). Google offers up ways to index your entire site. Also, you should use things like meta tags for keywords and descriptions. But if you want to ignore all that... encase all your headers and text you want to hide in a <div> and give it a display of none: <div style="display:none;"> YOUR STUFF HERE </div>
  20. You are echoing $bck between <div> and </div>. You need to put $bck inside your <div> tag.Instead of: <div id="div"> Replace with this: <div<?php echo $bck; ?>>
  21. Yes. You can do this by using the $i variable. Since it is incremental by one with each loop, you can change every other color on a div. All you have to do is check if $i is even or odd. If even, do this style, if odd, do this other style. if ($i % 2 == 0) { $bck = " style=\"background:yellow;\"";else { $bck = " style=\"background:gray;\"";} Or a more compact way to do the same thing as above: $bck = ($i % 2 == 0 ) ? " style=\"background:yellow;\"" : " style=\"background: gray;\""; Then just add $bck inside your div.
  22. Besides using JavaScript (which can be easily disabled) the only method to repeat your website layout onto different pages would be to put them in separate files, and include them (by using PHP or another server-side programming language). There is also a different method in which you include the content you want to add into the layout page but that's a bit more complex. This is a basic example using PHP: <?php include('header.php'); ?>YOUR CONTENT HERE<?php include('footer.php'); ?> What is confusing about the <param> tag? There are a bunch of sites that explain it's basic usage, here is one:http://www.htmlcodet...ets/_PARAM.html
  23. Replace <meta charset="UTF-8" /> with <meta http-equiv="content-type" content="text/html; charset="utf-8" /> then try to validate again.
  24. I think a really good first step would be to put all your html between the <body> and </body> tags.
  • Create New...