Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sylve
  • Order by date
  1. sylve

    playing Movies ****.HR.HDTV.AC3.5.1.XviD-442.avi files

    I have downloaded Smallville.S05E01.Arrival.HR.HDTV.AC3.5.1.XviD-442.avi from a bittorrent and it doesnt want to play on quicktime or VLC. I've missed the show on TV. Since upgrading to OS 10.4 I've been having trouble playing xvid.fov.avi files, and downloading codecs. What kind of codec...
  2. sylve

    I need a CPU Heat monitor

    Well i don't know about graphite. How odd... at some point, the cpu fan stopped. At another it wasnt spinning fast enough and making loud noises (from what i could tell by my naked eye). This evening, it seemed fine! Replacement was only 20$ so i decided to have it replaced anyways. It's a...
  3. sylve

    I need a CPU Heat monitor

    I'm not a hardware sort of girl but my fan was making loud noises and today i had no noise at all... And pc suddenly rebooted. I looked and fan SEEMS to be working. I can't find in the bios a place to see the fan's speed or the heat. Is there a applet, as small and efficient as possible...
  4. sylve

    help with field type & simple query

    ...The basic SQL query that would do that is: alter table [yourTable] ADD [fieldName] DATE; There are a lot of ways to do the select query! I suggest you use DAYOFYEAR() to compare the date. SELECT * FROM yourTable WHERE DAYOFYEAR(birthday) BETWEEN DAYOFYEAR(NOW()) AND DAYOFYEAR(NOW())+7;
  5. sylve

    Making SQL Diagrams

    I'm using MySQL and I was requested a simple diagram to illustrate links between the tables. I only have 2 sets of about 7 tables each. I dont need reverse engineering or anything. Does anybody have a free, easy to get and simple program to suggest? I'm almost considering using ppt here...
    • sylve
    • Thread
    • Replies: 0
    • Forum: MySQL
  6. sylve

    Show Correct SQL Criteria based on User Selection

    I'm not if i can answer this correctly because there is some info missing. You have 4 tables: injury, products, products_to_injury and image. Forgetting image for now, products_to_injury links the two others together. BUT can a product have more then one injury and can a injury apply to more...
  7. sylve

    I E won't connect

    Have you tried deleting all dialup connections in Internet Options and running the Setup under the "Connections" tab?
  8. sylve

    Sympatico incoming mail server

    Alright i'm guessing you are using Outlook Express and that you aren't getting any error message. You seem to be on the msn server meaning you should use pophm.sympatico.ca That's not all. In the account properties window, go to the advance tab. Check off the "This server requires a secure...
  9. sylve

    Get part of string

    use strpos() to find out if 2568 occurs in your string. It'll return the position of the first character. It will return false if 2568 isnt there. $result = strpos($yourString, '2568'); preg_match() and strstr() are your alternate choices. Good luck!
  10. sylve

    Passing arrays from php

    Thank you so much both of you! Code seems much clearer now. Here was my solution: echo "<script type=\"text/javascript\" language=\"Javascript\">\n<!--"; echo "\nfunction update_list(myform,program)\n{\n"; echo "var array_list = new Array();\n\n"; //php: transfer array from...
  11. sylve

    Passing arrays from php

    I have two select objects. When the first changes, i would like to write a procedure that updates the options in the second. The data is stored in a multidimentionnal array generated by php. The output looks something like this: Array ( [Fruits] => Array ( [0] => Apples [1] => Bananas [2]...
  12. sylve

    Sales Totals By Day. By month worked, why not day?

    You are referencing the same table twice, is that normal? From what i can tell, your GROUP BY is not the issue, it's the whole SELECT that could be confused. SELECT DAY(order_Payment_Date), COUNT(order_ID) as totalorders, SUM(order_total) as sumtotal FROM nwcs_orders WHERE...
  13. sylve

    most used variable naming convention

    What you are using sounds like the hungarian notation. You put a prefix to the variable to describe it's type. This convention is from Microsoft. A lot of people discourage this convention for many reasons, read about it here: http://ootips.org/hungarian-notation.html For php, I mostly just...
  14. sylve

    MySQL sort of max select

    If you want to make your life easier, put a alias for group fields (just like you did for your topics table). Azza's maxdate is just that: select a.topic_id, a.topic_header, max(messsages.message_date) as maxdate from topics a left outer join messages(a.topic_id=messages.topic_id) group by...
  15. sylve

    Gathering Data Without 'Re-Querying'

    products as p LEFT JOIN manufacturers as m USING manufacturer_id LEFT JOIN associates 2 tables. It will take ALL info in products table even if there is no correspondance in the manufacturers table. Joins are really useful, you can go to this site for more info ...
  16. sylve

    CSS &lt;UL&gt; and &lt;LI&gt; bullets

    Nevermind, i got it to work! Thank you very much for the help and consideration :)
  17. sylve

    CSS &lt;UL&gt; and &lt;LI&gt; bullets

    Thank you Vragabond, that site is very helpful! Alright so i get that the css is declaring about 3 classes: mktree->liOpen->bullet Here is the part that confuses me, if i check out the source of the example code, he never applies the bullet class. It's like it applies it by default. Here is...
  18. sylve

    CSS &lt;UL&gt; and &lt;LI&gt; bullets

    I've never used css before so I am trying to work the example given at http://www.mattkruse.com/javascript/mktree/index.html I'm having trouble replacing the bullets by images. It catches the mktree class but seems to ignore anything with .bullet This line works fine, i can set bullet...
  19. sylve

    Problems with LIKE statement

    Using mysql db, your query look like this in php: $query = "SELECT product_name FROM products WHERE $searchitem LIKE '%$product_name%' ORDER BY end_time"; remove the '' near $searchitem but add them for $productname. Tell us if it works!
  20. sylve

    Paragraph Mark

    I haven't tested it but can you simply search for the paragraph mark or replace it by a space or blank? replace(mystring,chr(13),"")

Part and Inventory Search

Back
Top