Jump to content


  • Content Count

  • Joined

  • Last visited

Everything posted by OJB

  1. It appears to be your menu ><ul> <lis><a>HOME</a></lis> <li><a href="http://www.primaryteachingresources.net/teaching%20resources/html/about_us.html">ABOUT US</a></li> <li><a href="http://www.primaryteachingresources.net/teaching%20resources/html/contact.html">CONTACT</a></li> <li><a href="http://www.primaryteachingresources.net/teaching%20resources/html/period_one.html">1º-2º E.P.O</a></li> <li><a href="http://www.primaryteachingresources.net/teaching%20resources/html/per
  2. Unfortunately I put some money on Jade from the UK to win!!! But even more unfortunately I now have the UK and the Norwegian entries stuck in my head!!!!!
  3. This is one of the sexiest sites I have seen hosted by TCH. Nice use of the JQuery library also, clean and simple too. Nice work. Congrats on the award.
  4. You can use the 'IN' clause >UPDATE diesel SET comments='Formerly BLAH BLAH BLAH' WHERE model='NS' AND subdir='1300' AND unit IN('1304', '1308', '1313', '1345', '1374', '1387') If you want to do it truly random though you can 'group by rand()' and then limit. So if you wanted to select 5 random rows from your database you could do the following: >SELECT * FROM diesel ORDER BY RAND() LIMIT 5 for the update command using the IN clause you could do: >UPDATE diesel SET comments = CONCAT(comments, '</a>') WHERE railroad='ns' AND subdir='1300' AND
  5. Glad it worked, Niagara. Feel free to post any more questions or PM me directly. I work with MySQL everyday in a professional capacity so I 'should' be able to help if you have any further questions.
  6. try something like this: >UPDATE diesel SET comments = CONCAT(comments, '</a>') WHERE railroad='ns' AND subdir='1300' What this does is concatenate the current comment and appends </a> to the end of it. Not sure if those where clauses are the correct clauses for your use but it gives the idea of how to do it.
  7. I thought the syntax was: >SELECT REPLACE(comments, 'Formerly', 'Formerly <a href="http://www.domainname.com/cars.phtml?id="></a>') FROM cars That will show whether it will work I guess then the update code would be: >UPDATE cars SET comments = REPLACE(comments, 'Formerly', 'Formerly <a href="http://www.domainname.com/cars.phtml?id="></a>')
  8. Are you wanting to backup your personal files, or your website files?
  9. I use Mozilla Thunderbird as my client both at work and at home and nearly all of my TCH accounts I have now moved to be hosted by GMail - Even my work on my recommendation migrated our mail exchange to GMail. To be honest I don't require or use extensive folders so I can't really help on that front.
  10. I am an IMAP fiend also! Whatever accounts I can IMAP I do...
  11. I know the things you mean, you tend to get them on wordpress or blogger blogs I think. Think its some sort of plugin for the software they bug me too but I think the only way around them is probably disabling javascript in your browser. But loads of sites nowadays rely on javascript.
  12. Is your table structure definitely InnoDB? You need indexes and/or primary keys set on the table before the relation view option will appear.
  13. Yes Make sure you have set up the necessary indexes on the tables to enable the foreign key Then under the structure view of your table click on: "relation view" just above where you add new fields. You can then create the required foreign keys for the table.
  14. There is no such thing as xeight and xidth as far as I know. You say you changed them to width and height and it did change the layout, how about if you removed them completely? If you remove them and the layout does not change then they are invalid properties and aren't doing anything. The reason changing them to width and height would change the layout is because then you are applying valid width and height properties to an image without any width and height currently set.
  15. What forum software are you using?
  16. >RewriteRule ^spinland.(.*)$ http://www.spinland.$1 [R=301,L] Not sure if that would work??? I am no modrewrite expert by any means. I am actually interested in finding out the answer to this because I want to learn more about apache modrewrite.. I have a feeling a RewriteCond would be required
  17. Other than what Thomas mentioned it looks good for me in Firefox. There are however issues with other browsers: IE6 - The coloured blocks at the top are not sitting next to eachother, they are sitting below eachother. I don't think IE6 supports min-width property - not too sure on that actually. There is also a massive load of space at the bottom of the page. Google Chrome, IE7, Opera and Safari for Windows all have the massive space at the bottom of the page too. Opera also appears to have double thickness borders between your columns. I would recommend using the We
  18. There are still people out there who use 800x600 screen resolutions, but there aren't many to be honest - I think you can find this out from google analytics of your site (if you have that) I tend to work towards 1024x768 nowadays and if I am using a fixed with I tend to aim for around 900px width with margin left and right set to 'auto'. Therefore people will smaller screen resolutions won't have TOO much scrolling to do, and those with higher resolutions will have space either side of the main block of content and it will still look OK. If you are using Firefox, get hold of WebDev
  19. No problem, Sam. Good luck with it and feel free to ask anything else
  20. Hello, OK I think I understand what you were trying to do now. At the top of your PHP file just under the <?php can you paste this line of code: >error_reporting(E_ALL); This will print any errors that occur during the script in the browser as you test the script. I still think there is an error in the logic... I would change your for loop to this: > for($i=0; $i<10; $i++) { if($rowcount > $i) { echo('filename: '.$properties[$i]['filename'].'<br />'); } else { //do something else } } The only thing I have changed is:
  21. The first thing I notice is the for loop. You are first starting from element 1 in the array ($i = 1) but PHP arrays start from 0. So change that to $i = 0; Secondly you are looping through the data 9 times but you should be looping through while $i is LESS than $rowcount. So change that to $i <$rowcount; Then inside the loop you are checking to see if $rowcount is LESS that or equal to $i. I don't get what you are trying to do, surely you would want it the other way around otherwise the data you are seeking in the array will not exist. Personally I would change your for-loop
  22. OJB

    Css Resize

    The only 'good' way to resize images is using a library such as the built in PHP GD library, but that is alot of work just to have an adaptable layout. As bruce says you can set font sizes to be relative too for instance: font-size: 10%; To be honest this sort of layout will usually cause more issues than benefits. I strongly suggest something with either a min-width/min-height or something fixed width because it means you won't have to keep messing about with percentages to ensure it looks fine on all resolutions in all browsers.
  23. OJB

    Css Resize

    The reason this has happened is you are using relative sizes in your CSS, not absolute.... i.e. you are using percentages of the page width and not fixed widths etc. I can understand why you would do this because you want it to expand/contract to the size of the window. The problem is that the font size and images you have used will not shrink, so whilst the elements around them are shrinking the text and the images are not, hence you get a mangled effect when you are on smaller window resolutions. My suggestion would be either: 1) Create a fixed width design that is the same size
  24. Surely though you are adding checks in to check the $_SERVER['HTTP_REFERER'] value in the PHP file to ensure they are coming from a link and not a direct entry in the address bar. I can't really think of a safe way of doing it without checking. I mean there are ways around HTTP_REFERER anyway as I stated so I would personally recommend spending the time to check if that contact belongs to that user. Just an example of how your method could be circumnavigated is using the web developers 'firebug' plugin for firefox. I could log in as user A from Company A, then firebug the page (editing
  25. To be honest you should never rely on the HTTP_REFERRER header because it can be blocked/spoofed and some browsers do not even send it. Am I right in assuming you are trying to stop users directly accessing a page and rather have them either POST to it or be forwarded there by the script? Maybe if you could explain exactly what you are trying to do I can help think of an alternative more secure way of doing this.
  • Create New...