Jump to content

Matpatnik

Members
  • Posts

    227
  • Joined

  • Last visited

About Matpatnik

  • Birthday 06/26/1979

Previous Fields

  • Languages
    HTML, CSS, PHP

Contact Methods

  • Website URL
    http://www.matpatnik.com/
  • ICQ
    0

Profile Information

  • Location
    Mtl
  • Interests
    Learning as much as possible every single thing

Recent Profile Visitors

5,930 profile views

Matpatnik's Achievements

Member

Member (2/7)

1

Reputation

  1. Hi guys, I came with a problem and can't find the solution. I looked on internet everywhere I could and here is the closest I found but still not right. The problem here is it cut the last part of the my longest table. The 2 tables doesn't have the same rows number but I need them all and I only need 1 category to be shown. So I need the 2 tables be glued together side by side filtered by category ( both table share the same categories ) with no missing data (of that category) So far this is what I got. I tried to join but it keep duplicating rows so instead of getting 200 rows I get like 3k rows. I tried union too and no success. I'm out of inspiration right now. If you can point a right or better path it would be great. Here's my query so far: SELECT t1.`id`, t1.c1, t1.`total`, t2.`id`, t2.c2, t2.`total` FROM ( SELECT @i:=@i+1 AS rowId, `id`, `categories` as c1, `total` FROM extable17, (SELECT @i:=0) a ) AS t1, (SELECT @j:=@j+1 AS rowId, `id`, `categories` AS c2, `total` FROM extable18, (SELECT @j:=0) a ) AS t2 WHERE t1.rowId = t2.rowId;
  2. Hi guys it's been forever I haven't touch code and I ended up with this situation. I have no problem to display the page with IE and FF. I have a div that contain embedded posts from a facebook page that should not exceed 500px by 500px and keep the left of the page. On the right there is an other div a little bit smaller that should float right but for some reason the facebook div seems to clear right only with chrome. I've been trying to wrap it, force my other div, and find a hack but no success. Since every attempt failed I went back to my original code. Your help is appreciated, thx! the address of the page is http://www.matpatnik.com/White-Spiders css: /****************** #desc Style ******************/#desc{ float: right; width:450px; max-width:450px; display:block;}#desc>.innerBox>.contentBox{ height: 484px;} html: <div class="outerBox fb-page" data-href="https://www.facebook.com/WhiteSpiders" data-width="500" data-height="500" data-small-header="true" data-adapt-container-width="true" data-hide-cover="true" data-show-facepile="true" data-show-posts="true"> <div class="fb-xfbml-parse-ignore"> <blockquote cite="https://www.facebook.com/WhiteSpiders"> <a href="https://www.facebook.com/WhiteSpiders">WhiteSpiders</a> </blockquote> </div></div><div id="desc" class="outerBox"><div class="innerBox"><div class="contentBox">
  3. I have created a while ago a page to help me see which font show the best on each browser...http://www.matpatnik.com/index.php?section=cssfontfamilyI will probably add more information later on
  4. :oups: that's what I meant hehe
  5. Dreamweaver is not a WYSIWYG API. it's look like it is but it's not.
  6. If it wasn't of Dreamweaver I probably wouldn't be as far as I am right now. When I first began with HTML in design mode, the program help me a lot to understand how a page should be structured and how to write the code properly. I've looked through the web to find tutorials but I had hard time to understand the whole thing (I learn faster by doing it than reading some explanation about a tag meaning...). Now that I know how to code most of my stuff (we are always learning), I'm always in code mode using the auto-completion to go a little bit faster, text coloration and indent to spot my statement, variables and debug quicker. I'm still using my old MX 2004 and not too impress by the newest one except for the psd support unfortunately
  7. I find this site: http://www.ultra-fluide.com/ressources/css/css-mondrian.htm intersting especialy the 3 links at the bottomWith imagination we can do everything (almost)
  8. Sorry I didn't explain my self correctlyWhat I meant by 5 is I had to delete 5 character at the end of $_SERVER['PHP_SELF'] to delete the .php but I only see 4 character when I echo it!I didn't count the first slash because it was not in the $maxcount variable.Justsomeguy, at first I didn't use the superblobal as parameter in that function and it didn't work, then I decide to try it anyway to see the result and it was working (but I probably change few things at the same time).
  9. you forgot to escape the double quote on the first echo it should look like this:while($row = mysql_fetch_array($result)){echo "<div id=\"news\">#".$row['storynum'] . "<br /> " . $row['headline']."<br />".$row['published']."<br />".$row['story'] . "</div>";echo "<br />";} and <div> tags need to be in between double quote too
  10. Awesome, I'm running php version 5.2 that will be perfect :)Thank you* do you know why in my function I have to subtract 5 instead of 4?
  11. Matpatnik

    custom function

    I just created this function and I want to know if there is a better way of doing it /* erase the / and .php from /apage.php */function page_name($_SERVER) { global $name; $maxcount = strlen($_SERVER['PHP_SELF']) - 5; // I have no idea why 5 there is only 4 character to me, 4 show the dot $name = substr($_SERVER['PHP_SELF'], 1, $maxcount); return $name;} and then I just call the page_name function and echo the $name.Thank you
  12. Matpatnik

    contact form

    at the first sight there is no action in your form
  13. What I thought I could use the function to make the text of the news shorter in an home page but the news contain BBcode in it so it won't be a good idea in this purpose. I will use my second idea to do that then.Thank you
  14. Hi guys,I just find out about the function: substr($VAR, 0, 100). It's a cool function for news but limited to plain text.My problem is that it can mess the code and/or the validation when using it with BBcode and I would like to know if there is a way to keep the text shortned and having a the code in good condition. I've looked on php.net and browsed on google and didn't find anything useful.If there is nothing I can do about it then I will just add a textarea in the news form for the brief presentation of the news.Thank you for your idea
×
×
  • Create New...