Recent content by sylve

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...

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...

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...

The field to add to your table should be a date type. 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...

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...

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...

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

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...

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!

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...

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]...

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...

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...

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...

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 ...