[wdvltalk] Mysql Query help!
Hi all... I've not been here for AGES... but I hope many of you trusted clever people are still out there... I need help! ;-p I'm building a shop for a client. I've got 3 tables I'm trying to talk to. products stock categories - Each product can be flagged with any numebr of cateogories using a single field, with csv (12, 52, 101) (it's a T-shirt shop, so the categories are for eg: film, quotes, funny, sports etc) - in the stock table, each product is asigned several stock fields, of each size/gender type. - and the categories are all stored in a seperate table, for admin purposes. What I want to do is to only get a category name from the database, IF one or any of the products are in stock. Here's what I've got so far.. Any MySQL gurus out there? :-( = SELECT categories.displayName, stock.count FROM categories, products, stock WHERE products.styleCategory LIKE '%categories.id%' AND (stock.count != "0" AND stock.size = '4') OR (stock.count != "0" AND stock.size = '5') OR (stock.count != "0" AND stock.size = '6') OR (stock.count != "0" AND stock.size = '7') OR ( stock.count != "0" AND stock.size = '8') OR (stock.count != "0" AND stock.size = '9') AND categories.type = '5' = my table structure if it helps: CREATE TABLE `categories` ( `id` int(11) NOT NULL auto_increment, `shortName` varchar(255) NOT NULL default '', `displayName` varchar(255) NOT NULL default '', `type` int(2) NOT NULL default '0', `active` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=116 ; -- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(11) NOT NULL auto_increment, `productCode` varchar(100) NOT NULL default '', `styleCategory` varchar(255) NOT NULL default '', `title` varchar(255) NOT NULL default '', `desc` mediumtext NOT NULL, `price` decimal(4,2) NOT NULL default '0.00', `salePrice` decimal(4,2) NOT NULL default '0.00', `saleStatus` int(1) NOT NULL default '0', `active` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- -- Table structure for table `stock` -- CREATE TABLE `stock` ( `id` int(7) NOT NULL auto_increment, `productId` int(4) NOT NULL default '0', `size` int(2) NOT NULL default '0', `count` int(5) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1192 ; � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] MySQK query takes 24 seconds!! help me! :-(
Hi there, I've built my first shooping basket.. yey me! (for a t-shirt Co) However the search results page takes ages. the query checks stock levels, and gender (mens, womens etc) and fetches the brand title... it then returns any items that have stock in that gender. The prodcatmatch table is there, as I add a few extra filters on when the user refines their search later.. Anyhoo, here's my query and table structure... I've been using MySQL for a few years now, but never anthing this 'complicated' any advise would help me learn alot!! Tris... SELECT distinct products.id, products.title, brands.title as brandTitle, products.thumb2, products.price, products.salePrice, products.saleStatus FROM products, stock, prodcatmatch, categories as parent, categories as child, brands WHERE parent.gender = '1' AND stock.productId = products.id AND stock.count != "0" AND brands.id = products.brand AND parent.type = '2' AND parent.id = stock.size LIMIT 0,24 -- -- Table structure for table `brands` -- CREATE TABLE `brands` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `logo` varchar(255) NOT NULL default '', `desc` mediumtext NOT NULL, `type` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ; -- -- -- Table structure for table `categories` -- // // Categories holds gender info AND size, so I've used two calls to it in my query. // CREATE TABLE `categories` ( `id` int(11) NOT NULL auto_increment, `shortName` varchar(255) NOT NULL default '', `displayName` varchar(255) NOT NULL default '', `type` int(2) NOT NULL default '0', `gender` int(2) NOT NULL default '0', `active` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=155 ; -- -- -- Table structure for table `prodcatmatch` -- CREATE TABLE `prodcatmatch` ( `id` int(5) NOT NULL auto_increment, `product` int(5) NOT NULL default '0', `category` int(5) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=256 ; -- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(11) NOT NULL auto_increment, `productCode` varchar(100) NOT NULL default '', `color` int(3) NOT NULL default '0', `ethical` int(1) NOT NULL default '0', `bestSeller` int(1) NOT NULL default '0', `whatHot` int(1) NOT NULL default '0', `lastSeen` int(1) NOT NULL default '0', `getLook` int(1) NOT NULL default '0', `isNew` int(1) NOT NULL default '0', `inPress` int(1) NOT NULL default '0', `styleCategory` varchar(255) NOT NULL default '', `title` varchar(255) NOT NULL default '', `desc` mediumtext NOT NULL, `img1` varchar(255) NOT NULL default '', `img2` varchar(255) NOT NULL default '', `img3` varchar(255) NOT NULL default '', `img4` varchar(255) NOT NULL default '', `thumb1` varchar(255) NOT NULL default '', `thumb2` varchar(255) NOT NULL default '', `thumb3` varchar(255) NOT NULL default '', `thumb4` varchar(255) NOT NULL default '', `price` decimal(4,2) NOT NULL default '0.00', `salePrice` decimal(4,2) NOT NULL default '0.00', `saleStatus` int(1) NOT NULL default '0', `active` int(1) NOT NULL default '0', `brand` int(2) NOT NULL default '0', `relatedProd1` int(6) NOT NULL default '0', `relatedProd2` int(6) NOT NULL default '0', `relatedProd3` int(6) NOT NULL default '0', `relatedProd4` int(6) NOT NULL default '0', `relatedProd5` int(6) NOT NULL default '0', `relatedProd6` int(6) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=125 ; -- -- -- Table structure for table `stock` -- CREATE TABLE `stock` ( `id` int(11) NOT NULL auto_increment, `productId` int(4) NOT NULL default '0', `size` int(2) NOT NULL default '0', `count` int(5) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10823 ; � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] MySQK query takes 24 seconds!! help me! :-(
this is awesome.. I've always wanted to learn JOIN(s) I'll take a look cheers!!! On 20/10/06, r937 <[EMAIL PROTECTED]> wrote: three things: 1. your query is incomplete, some join conditions are missing 2. your tables are missing indexes on the join columns 3. LIMIT makes no sense without ORDER BY 1 is most serious, as you will get extraneous and incorrect results (and i suspect this is why you plunked DISTINCT into the query) 2 means your query will run for hours instead of seconds 3 is a logic problem here's your query, written with JOIN syntax (recommended) notice where the join conditions are missing SELECT distinct products.id , products.title , brands.title as brandTitle , products.thumb2 , products.price , products.salePrice , products.saleStatus FROM products inner join stock on stock.productId = products.id and stock.count > 0 inner join prodcatmatch on prodcatmatch.? = ???.? inner join categories as parent on parent.id = stock.size and parent.gender = '1' and parent.type = '2' inner join categories as child on child.? = ???.? inner join brands on brands.id = products.brand order by ?? LIMIT 0,24 rudy http://r937.com/ � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] MySQK query takes 24 seconds!! help me! :-(
Sorry, I spotted it..!! never mind ;-p On 20/10/06, Tris <[EMAIL PROTECTED]> wrote: this is awesome.. I've always wanted to learn JOIN(s) I'll take a look cheers!!! On 20/10/06, r937 <[EMAIL PROTECTED]> wrote: > > three things: > > 1. your query is incomplete, some join conditions are missing > 2. your tables are missing indexes on the join columns > 3. LIMIT makes no sense without ORDER BY > > 1 is most serious, as you will get extraneous and incorrect results > (and i suspect this is why you plunked DISTINCT into the query) > > 2 means your query will run for hours instead of seconds > > 3 is a logic problem > > > here's your query, written with JOIN syntax (recommended) > > notice where the join conditions are missing > > > SELECT distinct >products.id > , products.title > , brands.title as brandTitle > , products.thumb2 > , products.price > , products.salePrice > , products.saleStatus > FROM products > inner > join stock > on stock.productId = products.id >and stock.count > 0 > inner > join prodcatmatch > on prodcatmatch.? = ???.? > inner > join categories as parent > on parent.id = stock.size >and parent.gender = '1' >and parent.type = '2' > inner > join categories as child > on child.? = ???.? > inner > join brands > on brands.id = products.brand > order > by ?? LIMIT 0,24 > > > rudy > http://r937.com/ > > � The WDVL Discussion List from WDVL.COM � > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or > use the web interface http://e-newsletters.internet.com/discussionlists.html/ >Send Your Posts To: wdvltalk@lists.wdvl.com > To change subscription settings, add a password or view the web interface: > http://intm-dl.sparklist.com/read/?forum=wdvltalk > > http://www.wdvl.com ___ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > To unsubscribe via postal mail, please contact us at: > Jupitermedia Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. > � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] MySQK query takes 24 seconds!! help me! :-(
LOL... I've missed you guys!!! I'm learnign...!!! ;-p On 20/10/06, David Precious <[EMAIL PROTECTED]> wrote: Hiya Tris, > Hi there, I've built my first shooping basket.. yey me! Congrats! :) > However the search results page takes ages. > the query checks stock levels, and gender (mens, womens etc) and > fetches the brand title... it then returns any items that have stock > in that gender. > Anyhoo, here's my query and table structure... I've been using MySQL > for a few years now, but never anthing this 'complicated' Yup, that's a pretty hairy query :) Little tip - I find it much easier to read SQL queries by breaking them up a bit... I'd reformat your query to something like: SELECT distinct products.id, products.title, brands.title as brandTitle, products.thumb2, products.price, products.salePrice, products.saleStatus FROM products, stock, prodcatmatch, categories as parent, categories as child, brands WHERE parent.gender = '1' AND stock.productId = products.id AND stock.count != "0" AND brands.id = products.brand AND parent.type = '2' AND parent.id = stock.size LIMIT 0,24 Takes up more space, but is much easier to read. You'll probably want to try adding some indexes to the tables on the columns you're using in the WHERE clauses. MySQL has a useful 'EXPLAIN' command which will tell you how it prepares and runs the query... just give it the query with EXPLAIN before it, so "EXPLAIN SELECT". Here's two examples. This query is efficient, it's going to use an index. The possible_keys column shows the indexes it could have used, and the 'key' column shows the index it chose to use. The 'rows' figure indicates how many rows of the table it will have to look at in order to fulfil this query. In this case, since there's a good index, it only needs to look at one row. mysql> explain select * from Taglines WHERE ID = 3 \G *** 1. row **: id: 1 select_type: SIMPLE table: Taglines type: const possible_keys: PRIMARY,FullIDX key: PRIMARY key_len: 4 ref: const rows: 1 Extra: 1 row in set (0.00 sec) Now, a query which is not efficient - there's no index it can use for this one (there doesn't need to be as I'd never query this table by the tagline field)... notice the 'key' column is NULL, and the 'rows' column now shows that it will have to examine 1033 rows (all the rows in the table) to satisfy this query. mysql> explain select * from Taglines WHERE Tagline = 'foo' \G *** 1. row *** id: 1 select_type: SIMPLE table: Taglines type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1033 Extra: Using where 1 row in set (0.00 sec) The output of that should give you some idea what you can do to improve the situation. Also, when you have spare time you could have a read up on database normalisation... some parts of your table, like: > `img1` varchar(255) NOT NULL default '', > `img2` varchar(255) NOT NULL default '', > `img3` varchar(255) NOT NULL default '', > `img4` varchar(255) NOT NULL default '', > `thumb1` varchar(255) NOT NULL default '', > `thumb2` varchar(255) NOT NULL default '', > `thumb3` varchar(255) NOT NULL default '', > `thumb4` varchar(255) NOT NULL default '', > `relatedProd1` int(6) NOT NULL default '0', > `relatedProd2` int(6) NOT NULL default '0', > `relatedProd3` int(6) NOT NULL default '0', > `relatedProd4` int(6) NOT NULL default '0', > `relatedProd5` int(6) NOT NULL default '0', > `relatedProd6` int(6) NOT NULL default '0', ... could be better done using another table, for example related_products, with one row for each link. Likewise for the images, maybe: CREATE TABLE product_images ( id INT(6) AUTO_INCREMENT PRIMARY KEY, product_id INT(6) NOT NULL, image_title VARCHAR(250), image VARCHAR(250) ); That way you could have arbritary numbers of images per product. Now, wait for Rudy the SQL God to turn up and suggest a 1-line query that does everything you need, and also takes care of the ordering, provisioning and shipping of the tshirts, all whilst defragmenting the hard drive and working out the meaning of life :) Cheers Dave Presh http://www.preshweb.co.uk/ • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newslett
[wdvltalk] MySQL query takes 24 seconds!! help me! :-(
Finally... How can I filter on products... (there's a 1/0 field in the products table, that flags if the product is ethically made.) how can I add a 'WHERE product.ethical = '1'? I tried just before the first inner join, but I got an error... Here's my query: SELECT distinct products.id, products.title, brands.title as brandTitle, products.thumb2, products.price, products.salePrice, products.saleStatus FROM products inner join stock on stock.productId = products.id and stock.count > 0 inner join prodcatmatch on prodcatmatch.product = products.id inner join categories as parent on parent.id = stock.size and parent.gender = '1' and parent.type = '2' inner join categories as child on child.type = '5' inner join brands on brands.id = products.brand order by products.id � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] MySQL query takes 24 seconds!! help me! :-(
how can I add a 'WHERE product.ethical = '1'? by adding it after the FROM clause, just before the ORDER BY clause I tried that, but it caused an error... Here's my query: SELECT distinct products.id, try it without DISTINCT Cause duplicated galore! inner join categories as child on child.type = '5' you realize that every single product will join with ~all~ categories of type 5 this is called a "cross join effect" Yes.. but I've got a filter in place, so it's all good... would you kindly identify every join relationship as to whether it is one-to-many, one-to-one, or many-to-one The wholt thing works great now.. APART from the ethical filter. hit mens on the left.. http://hypedev.co.uk/moretvicar/ You'll see that cetegories is filterable, but ethical is not.. does this help? � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] MySQL query takes 24 seconds!! help me! :-(
I shoudl really learn myself.. let me paly, and if still can;'t get it, I'll be back on Monday.. with more info... Cheers for your help though!!! On 20/10/06, r937 <[EMAIL PROTECTED]> wrote: > I tried that, but it caused an error... then you added it in the wrong place, and unfortunately my crystal ball is not working at the moment, so you will have to post the query >>> try it without DISTINCT > > Cause duplicated galore! which simply shows that your joins are wrong >>> this is called a "cross join effect" > > Yes.. but I've got a filter in place, so it's all good... well, if you like slow queries and clogged bandwidth, sure rudy � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] MySQK query takes 24 seconds!! help me! :-(
Ok, looked closer... Really cool stuff here.. I've changed al my ID fields to INDEX and not Primary Anyhoo... The resutls I'm getting from the new query (see below) are not returning items that ARe in stock and the required gender... I'm investigating.. but if you can spot it, you oculd give me ahint? ;-p === SELECT distinct products.id , products.title , brands.title as brandTitle , products.thumb2 , products.price , products.salePrice , products.saleStatus FROM products inner join stock on stock.productId = products.id and stock.count > 0 inner join prodcatmatch on prodcatmatch.product = products.id inner join categories as parent on parent.id = stock.size and parent.gender = '1' and parent.type = '2' inner join categories as child on child.id = prodcatmatch.category and child.type = '5' inner join brands on brands.id = products.brand order by products.id === On 20/10/06, Tris <[EMAIL PROTECTED]> wrote: this is awesome.. I've always wanted to learn JOIN(s) I'll take a look cheers!!! On 20/10/06, r937 <[EMAIL PROTECTED]> wrote: > > three things: > > 1. your query is incomplete, some join conditions are missing > 2. your tables are missing indexes on the join columns > 3. LIMIT makes no sense without ORDER BY > > 1 is most serious, as you will get extraneous and incorrect results > (and i suspect this is why you plunked DISTINCT into the query) > > 2 means your query will run for hours instead of seconds > > 3 is a logic problem > > > here's your query, written with JOIN syntax (recommended) > > notice where the join conditions are missing > > > SELECT distinct >products.id > , products.title > , brands.title as brandTitle > , products.thumb2 > , products.price > , products.salePrice > , products.saleStatus > FROM products > inner > join stock > on stock.productId = products.id >and stock.count > 0 > inner > join prodcatmatch > on prodcatmatch.? = ???.? > inner > join categories as parent > on parent.id = stock.size >and parent.gender = '1' >and parent.type = '2' > inner > join categories as child > on child.? = ???.? > inner > join brands > on brands.id = products.brand > order > by ?? LIMIT 0,24 > > > rudy > http://r937.com/ > > � The WDVL Discussion List from WDVL.COM � > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or > use the web interface http://e-newsletters.internet.com/discussionlists.html/ >Send Your Posts To: wdvltalk@lists.wdvl.com > To change subscription settings, add a password or view the web interface: > http://intm-dl.sparklist.com/read/?forum=wdvltalk > > http://www.wdvl.com ___ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > To unsubscribe via postal mail, please contact us at: > Jupitermedia Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. > � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] SQL query now taking 1 second...
this makes sense -- prodcatmatch is a many-to-many relationship table that joins products to categories My categories table has several 'types'. 2 = size 3 = Country 5 = category description (fashon tshirt, vneck etc) so I'm having to puick out category AND size so that's why I'm refering to it twice. Perhaps I should have had a size table and a description table etc.. but I thought it'd be quicker to keep them all in one table? would you like my table structure dump again? inner join categories as parent on parent.id = stock.size and parent.gender = '1' and parent.type = '2' this doesn't make sense you're going from product to prodcatmatch to categories, so the join condition here should logically involve a column from the prodcatmatch table being equal to the category id but you're joining a category id to a stock size??? I'm refering to stock size to only show items that are in stock. the category 'Mens small' for exampe is ID 4, so category 4 is in the stock table many times (once per product) there was a condition 'stock.count > 0' but I can't see it on this mail. inner join categories as child on child.id = prodcatmatch.category and child.type = '5' this sort of makes sense, except why are you joining to two different rows of the categories table? See above, I've got one big categories table for all items i can't help you sort this out unless you know why you're doing that inner join brands on brands.id = products.brand that makes sense p.s. would you kindly, please, pretty please, i beg you, trim your replies, and please stop top-posting Don;t mean to. Gmail keeps forcing it! I'll repost each time... that shoudl fix it!??? thanks � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] SQL query now taking 1 second...
Cool...! Would 'GROUP BY' be any different.. responce time wise? Fianlly, I should pioint out that I had to make hte sizes editable and enable the end user to create new sizes. Each T-shirt Manufacturer has different scales, and a Medium in one Company is a large in another stupid really, and it means that every thirt on the site has a back end potential for 60 + sizes... Crazy.. I designed it originally to be a fixed set of sizes... but then the client complained.. Grrr.. Ok, I've done lots and learnt lots more importantly.. I think I may go away and do a few mock sites to test my new skills... CAre to throw a few case studies my way, so I can get to grips with it..? Tris... My categories table has several 'types'. 2 = size 3 = Country 5 = category description (fashon tshirt, vneck etc) so I'm having to puick out category AND size so that's why I'm refering to it twice. Perhaps I should have had a size table and a description table etc.. but I thought it'd be quicker to keep them all in one table? quicker? no;o) by "generalizing" you have simply made the query appear more complex i can understand why using a relationship for sizes (rather than having, say, a varchar(12) column for the size right in the product table), because this forces users, when entering new products, to select only from a given set of valid sizes... ... but a table for descriptions is pretty unusual also, can you see now why i was confused by your use of the aliases "parent" and "child"? you should at least use alias names like "size" and "country" and "description" your query speed will get even better when you take off DISTINCT rudy � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Web login system - best approach
Try this: http://www.freewebmasterhelp.com/tutorials/phpmysql A quick google will rpovide literally 100's of other tutorials... I leant from books myself, but the info is the same... Good luck, and once you get going and have specific questions... we're here for you...!!! Tris... On 06/11/06, Ross Clutterbuck <[EMAIL PROTECTED]> wrote: Greetings and salutations I have a few web projects in the pipeline that will require some form of user log-in to access restricted content. I've done a few projects before that have been successful but I'm unsure if my approach is the the best way of doing things, or if I will be able to actually implement it. Previously, I have an Access database storing the login information which is accessed through ASP. This database is stored in a folder outside of the domain hosting area so you can't physically access it through the website's URL. The ASP script accesses the file through the server's file system using Server.MapPath. This has worked pretty well so far but any projects using this has been deployed on a server that I have physical access to and administration control over, so it's easy for me to upload and maintain files directly through Windows Explorer. My problem now is twofold: firstly, I don't have this sort of access to the server and second it's likely that I have to use PHP and MySQL. I've started playing with MySQL recently for a Flash-fronted CMS project and I'm fairly comfortable with it for the basic uses I have in mind, but I have difficulty getting my head around creating a database - it's a bit odd not having a tangible, MDB-esque file I can just drop into a directory. So in a nutshell, what's the best way of doing a user/password login using PHP/MySQL? TIA MOU Send instant messages to your online friends http://uk.messenger.yahoo.com • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Web login system - best approach
Where are you based..? I've got a few books here, that I learnt from... One in perticular is VERY basic, but it sent me on the fast track to understanding what's what.. I'm in London and will happily sned it to you...? On 06/11/06, Ross Clutterbuck <[EMAIL PROTECTED]> wrote: Thanks Drew and Tris I've googled a number of different approaches prior to posting here - given that there were so many varied approaches I thought I'd shout here too for some advice on real-world applications. I'll go read some of the better-looking Google results and get back to you! MOU Send instant messages to your online friends http://uk.messenger.yahoo.com • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] iPod question
I'd recommend going to watch the south park episode that touches on file shharing and piracy... Makes you think, but then it always does! Tris... :-) Riva Todd Richards wrote: > Yeah, but she said "brother-in-law", so technically it's family right??? > ;-) > > As Ross stated, I'm sure that Apple and many others would be stamping a firm > "NO" on the content of this email. However, I seriously doubt that you are > going to have men in black suits at your door tomorrow morning. You aren't > uploading it via KaZaA for others to download, nor are you selling it to > anyone. A single iPod can be linked to two computers, so that's not an > issue. And as Ross said, a single song bought from the iTunes store can be > linked to 5 computers. > > Ripping a CD via iTunes to store in your music library isn't illegal, as > long as it's yours and you don't intend on distributing it. Heck, I'm glad > that I did since shortly after I took the time to digitize my music I had > over 300 CDs stolen. > > Heck, if push came to shove I would just say that the iPod is your > brother-in-law's, and you are just borrowing it. But that's just me. > > Yes, it's your conscience. I guess mine is already in bed for the night... > > Todd • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Prinitng multiple pages...
Hey all.. I've built a shop.. (woo) In the order management system, my client has asked that when they filter the results (eg, just show todays orders), they want a print all button. all the order info is taken from the database, and I've got a template, but I don't know how to print rages of data fom the databsae... I can simply open up all teh windows, and asign a pronty button to each of them.. but if there's 100+ orders per day, that's a pain in the arse... Anyhoo... any ideas? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Prinitng multiple pages...
css can force page brakes??? cool.. off to google for me... On 10/11/06, David Precious <[EMAIL PROTECTED]> wrote: On Fri, 10 Nov 2006, Tris wrote: > all the order info is taken from the database, and I've got a > template, but I don't know how to print rages of data fom the > databsae... > > I can simply open up all teh windows, and asign a pronty button to > each of them.. but if there's 100+ orders per day, that's a pain in > the arse... I'd imagine you could write a simple script which fetches all the order info onto one HTML page, and use a clever bit of CSS to suggest to the browser where it ought to be putting page breaks? Cheers Dave P • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] SQL - picking out data where duplicates exist...
Hi all.. Latest adventure in SQL is for a client who has a list of offices and locations etc... I've this query: == SELECT company.company_id, company.company_name, company.website, location.location_name, COUNT(location.location_name) AS COUNT_location_name FROM premises INNER JOIN company ON premises.company_id = company.company_id INNER JOIN location ON premises.location_id = location.location_id WHERE premises.status = 1 GROUP BY company.company_id, company.company_name, company.website ORDER BY company.company_name ASC == The out put of which is: Company x - 2 offices Company y - 4 offices Company z - 1 Office BUT the client wants: Company x - 1 Office - London Company x - 1 Office - Paris Company y - 1 Office - London Company y - 2 Office - Paris Company y - 1 Office - Rome Company z - 1 Office - London Can I do this in one query? :-( � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] SQL - picking out data where duplicates exist...
Sadly not? I still get one location name and a counf all the other locations... am I missing something? On 15/11/06, r937 <[EMAIL PROTECTED]> wrote: > Can I do this in one query? yes add location.location_name to the GROUP BY clause ;o) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] SQL - picking out data where duplicates exist...
hmmm, I need to check my data... I'll be back! On 15/11/06, David Precious <[EMAIL PROTECTED]> wrote: On Wed, 15 Nov 2006, Tris wrote: > Sadly not?I still get one location name and a counf all the other locations... > am I missing something? Don't you want to GROUP BY the company name reather than the location name? By definition, grouping by the location name will only return one row per location... Cheers Dave P • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] SQL - picking out data where duplicates exist...
No, it did work.. but my trest data didn't have what I'd described.. Company x only had 4 offices in one city.. so I've added a few fake offices and it filters! Phew!!! cheers... Final Query === SELECT company.company_id, company.company_name, company.website, location.location_name, COUNT(location.location_name) AS COUNT_location_name FROM premises INNER JOIN company ON premises.company_id = company.company_id INNER JOIN location ON premises.location_id = location.location_id WHERE premises.status = 1 GROUP BY company.company_id, company.company_name, company.website, location.location_name ORDER BY company.company_name ASC On 15/11/06, David Precious <[EMAIL PROTECTED]> wrote: On Wed, 15 Nov 2006, r937 wrote: > > Don't you want to GROUP BY the company name reather than the location > > name? By definition, grouping by the location name will only return one > > row per location... > > the GROUP BY should include both Ah, GROUP BY company, location - of course :) • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Form box question
try that... On 15/11/06, Portman <[EMAIL PROTECTED]> wrote: Hi all, Does anyone know how you create a form so that some text appears in the box (for example Name) and when you click in the box, it disappears so that your text can go there? TIA, Riva • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Form box question - RESEND (first one didn't go through)
try that... On 15/11/06, Portman <[EMAIL PROTECTED]> wrote: Hi all, Does anyone know how you create a form so that some text appears in the box (for example Name) and when you click in the box, it disappears so that your text can go there? TIA, Riva • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP date - get last month, and loop to last year..
I've got a date function using: Y-m eg: 2006-11 (for today) I want to get last month (2006-10) etc, and when I hit JAn, loop to 2005-12 .. Is this easy? (I'm displaying competition entries, and previous months entries.. but when I hit Jan, I want Dec to be in the list...) Any ideas? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Stupid vouchers...
sadly not.. but you're trying, and that rocks! The id, is the ID field in the DB of the product item, which in this case, is the voucher.. It did dawn on me that I've got Global varaibles ON.. And that I've got a session name getDelCost elsewhere, which may be intefering, so when I get home, I'm gonna drastically change my naming convention.. Sigh,,, On 22/11/06, Matthew Macdonald-Wallace <[EMAIL PROTECTED]> wrote: Quoting Tris <[EMAIL PROTECTED]>: > Hey all.. > I've been asked to NOT charge delivery on a shopping cart I've built, > if the product purchased is a gift voucher.. > This is cause theyre just gonna mail the user a code... > > BUT.. > if any product in the basket is NOT a voucher, but a voucher is still > in the basket, then we wil charge delivery still... > > Basically, they don't wanna charge their users for delivery when we're > not delivering anything.. > > So, here's my logic.. > > First I get the id's of vouchers, and run it through the loop that > populates the basket page, from the database. > I'm asking if the ID No, is NOT a voucher, then flag the basket as NOT > just vouchers and cahrge delivery, and if any subsequent items are > vouchers, it doesn't matter, as we've already flagged the > isVoucherOnly variable. > === > if > (($rowIsVoucher[id] != "235") || >($rowIsVoucher[id] != "236") || >($rowIsVoucher[id] != "237") || >($rowIsVoucher[id] != "238") || >($rowIsVoucher[id] != "239") || >($rowIsVoucher[id] != "258") || >($rowIsVoucher[id] != "259") || >($rowIsVoucher[id] != "260") || >($rowIsVoucher[id] != "261")) { $isVoucherOnly = false; } > ummm, should "[id]" be "[$id]"... Just a thought... M -- Matthew Macdonald-Wallace [EMAIL PROTECTED] "Sed quis custodiet ipsos custodies?" • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: unknown lmsubst tag argument: '' To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] FCKEditor...
Another query.. I'm on fire today...!!! I'm using FCKeditor.. it rocks! Bt.. I'm creating a view to edit a news article, that was succsussfully created with FCK and my MySql DB.. When I try and load the HTML back into the editor, it's breaking it, cuase of all the extra " in the code.. I've tried to use stripslashes, but nothing.. Has anyone else seen, and resolved this issue with this editor? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Getting corresponding fields from MySql, when using GROUP BY...
MySql, I love it... I'm building an asset management system.. I've got an asset table, with basse info, and a version table, where each susperceeded version of an asset sits. When I do a call to get a list of assets, and the latest version number, I'm having probs.. I can get the last version number, by using MAX(), but how can I tell the query to get the corresponding fields from the SAME row.. I'm currently getting the file name from version one, even though in my DB, I've many versions.. Here's my query.. SELECT asset.id, MAX(assetVersion.id) as assetVersionId, asset.naturalName, assetVersion.fileName, MAX(assetVersion.versionNumber) as versionNumber, assetVersion.status FROM asset, assetVersion WHERE assetVersion.assetId = asset.id group BY id ASC Here's the output.. id, assetVersionId, naturalName, fileName, versionNumber, status 1, 5, Tristans Test Jpg, tris.jpg, 3, 1 2, 4, Santas delivery plan, route.xls, 2, 1 Am i being a tool??? � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Getting corresponding fields from MySql, when using GROUP BY...
Scratch that... my boss has just told me to add an assetVersion field to the master asset table, that way, I we can roll back versions easier.. PhEW!!! On 23/11/06, Tris <[EMAIL PROTECTED]> wrote: MySql, I love it... I'm building an asset management system.. I've got an asset table, with basse info, and a version table, where each susperceeded version of an asset sits. When I do a call to get a list of assets, and the latest version number, I'm having probs.. I can get the last version number, by using MAX(), but how can I tell the query to get the corresponding fields from the SAME row.. I'm currently getting the file name from version one, even though in my DB, I've many versions.. Here's my query.. SELECT asset.id, MAX(assetVersion.id) as assetVersionId, asset.naturalName, assetVersion.fileName, MAX(assetVersion.versionNumber) as versionNumber, assetVersion.status FROM asset, assetVersion WHERE assetVersion.assetId = asset.id group BY id ASC Here's the output.. id, assetVersionId, naturalName, fileName, versionNumber, status 1, 5, Tristans Test Jpg, tris.jpg, 3, 1 2, 4, Santas delivery plan, route.xls, 2, 1 Am i being a tool??? � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Getting corresponding fields from MySql, when using GROUP BY...
Cool.. I've in my head that group by is the same as distinct in the select part of the query.. When I only want results of one type... Is that right? On 23/11/06, r937 <[EMAIL PROTECTED]> wrote: > Am i being a tool??? yes, for you have failed to grasp how GROUP BY works;o) the reason you are getting incorrect results is because there are some columns in your SELECT list which aren't in the GROUP BY this is the so-called "GROUP BY with hidden fields" scenario see http://dev.mysql.com/doc/refman/5.0/en/group-by-hidden-fields.html in any case, you do not want to be using GROUP BY here at all select asset.id , assetVersion.id as assetVersionId , asset.naturalName , assetVersion.fileName , assetVersion.versionNumber as versionNumber , assetVersion.status from asset inner join assetVersion on assetVersion.assetId = asset.id and assetVersion.versionNumber = ( select max(versionNumber) from assetVersion where assetId = asset.id ) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Getting corresponding fields from MySql, when using GROUP BY...
Ooooh... SO is one better than the other, from a speed perpective...? On 23/11/06, r937 <[EMAIL PROTECTED]> wrote: > I've in my head that group by is the same as distinct in the select > part of the query.. > > When I only want results of one type... > Is that right? yes, GROUP BY is the same as DISTINCT... ... but ~only~ if the exact same columns are in the GROUP BY as in the SELECT rudy � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] CSS print.. putting an element at teh bottom of a page...
Um my title kinda says it all... I'm grabbing a bunch of info to put in an invoice, and my client wants to ahve the total and delivery at teh botoom of teh printed page... How can I force a div to the bottom of the page...? � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Stupid vouchers...
I've been told.. ;-p I will I will.. ;-p Sigh, soo tired, AND I just ran out of coffee!!! Fridays eh? On 24/11/06, David Precious <[EMAIL PROTECTED]> wrote: On Wed, 22 Nov 2006, Tris wrote: > It did dawn on me that I've got Global varaibles ON.. If you mean register_globals, I'd *strongly* suggest you turn that off, now. Cheers Dave P • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Paper sizes
http://www.cl.cam.ac.uk/~mgk25/iso-paper.html Wuite useful.. and John, Awesome name, love your movies..! On 24/11/06, John Hughes <[EMAIL PROTECTED]> wrote: A4 is 210mm by 297mm if that's any help. J. -Original Message- From: Portman [mailto:[EMAIL PROTECTED] Sent: 24 November 2006 20:07 To: wdvltalk@lists.wdvl.com Subject: [wdvltalk] Paper sizes Hi all, Can anyone tell me what the dimensions are for legal size paper? Is it 8.5x 11.75"? If so, how is that different than an A4 size paper? Excuse the ignorance. Thanks, Riva . The WDVL Discussion List from WDVL.COM . To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Moral question
If that person signed a legally binding agreement to provide monies over time for an agreed sum of good and or services, then she's obliged to pay. BUT.. If the money in question is under a certain amount, many comapnies write it off.. saying that When I was 19 I signed up for one of those 'buy 5 Cd's now, dirt cheap and then I have to buy many more full price' I got my cheap ones, then move house. They foudn me, passed the debt onto a debt recovery Co, so I left the country, and came back 5 years later... so you can escape them.. that was all 6-7 years since I've been back...!! Um, so ta anwser your question, if she signed, she pays... your not her mother... x On 27/11/06, Portman <[EMAIL PROTECTED]> wrote: Hi all, I work part-time for someone. This person got a membership to a place where you buy something at a great price but have to buy x more in a certain period of time after that. (I am deliberately trying to be vague.) The thing is, my boss wants me to cancel it and they say that she still needs to buy 3 more items. My boss said that she is not paying for anything and wants me to cancel it regardless. She also said I should tell them that she is not paying for anything else. I know that I should call because she asked me to, but she didn't fulfill her obligation. What should I do? TIA, Riva • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Cookie warning...
i've built a shop, and we're getting phantom orders.. i've jsut realisd that poeple with cookes disabled are bypassing certains pages.. so, as a quick fix, can I add coed to al my pages that says 'cookies must be enabled to register with ths site?) Anyone know how t do this quckly and easily.. off to google now.. Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Cookie warning...
nothing... I just added an if (!isset($_COOKIE[user])) { header(go elsewhere); } easy when you're stressed! On 28/11/06, Tris <[EMAIL PROTECTED]> wrote: i've built a shop, and we're getting phantom orders.. i've jsut realisd that poeple with cookes disabled are bypassing certains pages.. so, as a quick fix, can I add coed to al my pages that says 'cookies must be enabled to register with ths site?) Anyone know how t do this quckly and easily.. off to google now.. Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] [OT] remote connections?
Ello... I'm on site this week (I work at home normally) and I'm using remote XP to connect to my home pc to pick up code samples etc, FTPing them to my server, and then picking them up here, in the office.. bt... I'd love to be able to connect to my home, via windows explorer is this possible? I've tried: \\123.123.123.123\myComputerName\shareName\ (I've got several PC's on my home IP) but it doesn't work...? Do I need to open up a specific port on my router at home, or is this just not possible..? It'd just make copying files to theoffice ALOT easier!! ;-p Thoughts? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] pulling one row where it matches in another table, many times... MySQL
I wanna holiday!!! I've an asset table: id name fileSize date and an options table: id name and finally a table to match them up assetPropertyOption: assetId optionId I want to pull all assets that appear in the match table, based on what options I ask for.. I can do it for ONE option, but when I try and do more, it comes up blank.. What I reckon is each option is making a new row in the temp table, confusuig both me and MYSQL.. But I NEED to ba able to say AND and OR alot... HERE's my query: = SELECT asset.id, asset.naturalName, assetVersion.fileName, assetVersion.fileNameThumb, assetVersion.dateCreated, assetVersion.size, max(asset.assetVersionId) FROM assetVersion // The assets have multiple versions, so this jsut get's the latest version INNER JOIN asset on assetVersion.versionNumber = asset.assetVersionId AND assetVersion.assetId = asset.id INNER JOIN assetPropertyOption on assetPropertyOption.assetId = asset.id and assetPropertyOption.optionId = '2' AND ( assetPropertyOption.optionId = '12' OR assetPropertyOption.optionId = '8' ) GROUP BY asset.id ideas? � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL
LOL... funny cause it's true.. he's pretty much saved my arse too any time sthis month.. MUST repay him soon!!! On 04/12/06, Drew Trusz <[EMAIL PROTECTED]> wrote: On 12/4/06, Tris <[EMAIL PROTECTED]> wrote: > I wanna holiday!!! > > I've an asset table: > id > name > fileSize > date > > > and an options table: > id > name > > > and finally a table to match them up assetPropertyOption: > assetId > optionId > > > I want to pull all assets that appear in the match table, based on > what options I ask for.. > I can do it for ONE option, but when I try and do more, it comes up blank.. > > What I reckon is each option is making a new row in the temp table, > confusuig both me and MYSQL.. > > But I NEED to ba able to say AND and OR alot... > > === > > ideas? > Hope rudy gets up early today and is in a good mood? drew • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL
yoda man.. again... So, help me learn ? pretty please... ? I need to say, optionId = 1 AND (4 or 6 or 6) etc... I get how you've redone the latest aset version call, nice one.. I don't understand whats happening at teh bottom of the query.. can you dumb it down for me? Whee do you live? anywhere beerable? On 04/12/06, r937 <[EMAIL PROTECTED]> wrote: select asset.id , asset.naturalName , assetVersion.fileName , assetVersion.fileNameThumb , assetVersion.dateCreated , assetVersion.size , asset.assetVersionId from asset inner join assetVersion on assetVersion.assetId = asset.id on assetVersion.versionNumber = ( select max(versionNumber) from assetVersion where assetId = asset.id ) inner join assetPropertyOption on assetPropertyOption.assetId = asset.id and assetPropertyOption.optionId in ( 2, 8, 12 ) group by asset.id , asset.naturalName , assetVersion.fileName , assetVersion.fileNameThumb , assetVersion.dateCreated , assetVersion.size , asset.assetVersionId having sum(case when assetPropertyOption.optionId = 2 then 1 else 0 end ) = 1 and sum(case when assetPropertyOption.optionId in ( 8, 12 ) then 1 else 0 end ) > 0 donations to my paypal account gratefully accepted ;o) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL
Wow.. kewl!! I'm playing making t all dynamic, and adding some more filters I need. ( i didn't tell you bout all of the options, cause I wanna do it myself...) It's looking GREAT though. One things that frustrates me, is how am I supposed to figure this stuffout on my own without someone in the know to hand hold me :-( Cheers, I'll report back my progress shortly..!!! Tris... On 04/12/06, r937 <[EMAIL PROTECTED]> wrote: > I need to say, optionId = 1 AND (4 or 6 or 6) etc... that's what the HAVING clause does ;o) > I don't understand whats happening at teh bottom of the query.. > can you dumb it down for me? use the ON clause of the join to select only those rows you're interested in -- > and assetPropertyOption.optionId >in ( 2, 8, 12 ) and then, after applying the GROUP BY clause to group the option rows for each asset, use the HAVING clause to count the option rows for each asset according to your specific requirements > having sum(case when assetPropertyOption.optionId = 2 >then 1 else 0 end ) = 1 there must be exactly one option 2 > and sum(case when assetPropertyOption.optionId in ( 8, 12 ) >then 1 else 0 end ) > 0 there must be at least one option which is either 8 or 12 > Whee do you live? anywhere beerable? centre of the universe -- toronto canada ;o) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL
I know I know ;-p So.. I tried to adda region filter, which is in a table jsut liek the option select.. assetRegion: assetId regionId Using this: (but if I search for more than one region, I get nothing, searching for ONE region, I get correct results.. :-( ) It looks the SAME to me!!! WA :-( SELECT asset.id, asset.naturalName, assetVersion.fileName, assetVersion.fileNameThumb, assetVersion.dateCreated, assetVersion.size, asset.assetVersionId, MAX( assetVersion.versionNumber ) FROM asset INNER JOIN assetVersion ON assetVersion.assetId = asset.id AND assetVersion.versionNumber = asset.assetVersionId INNER JOIN assetPropertyOption ON assetPropertyOption.assetId = asset.id AND assetPropertyOption.optionId IN ( 1, 6, 7 ) INNER JOIN assetregion ON assetregion.assetId = asset.id AND assetregion.regionId IN ( 1, 2, 3 ) GROUP BY asset.id, asset.naturalName, assetVersion.fileName, assetVersion.fileNameThumb, assetVersion.dateCreated, assetVersion.size, asset.assetVersionId HAVING sum( CASE WHEN assetPropertyOption.optionId =1 THEN 1 ELSE 0 END ) =1 AND sum( CASE WHEN assetregion.regionId IN ( 1, 2, 3 ) THEN 1 ELSE 0 END ) > 0 AND sum( CASE WHEN assetPropertyOption.optionId IN ( 6, 7 ) THEN 1 ELSE 0 END ) > 0 On 04/12/06, r937 <[EMAIL PROTECTED]> wrote: > One things that frustrates me, is how am I supposed to figure this > stuffout on my own without someone in the know to hand hold me :-( practice, practice, practice! ;o) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL
Ok, So when I put my WHERE clause, just before GROUP BY, it gets an error... What was SELECT 1 all about, I've never seen that before... Trying to tweak! Yoda man still! On 04/12/06, r937 <[EMAIL PROTECTED]> wrote: > I tried to adda region filter, which is in a table jsut liek the > option select.. no, sorry asset-to-assetPropertyOption is one-to-many if you add another join to the query with a ~different~ one-to-many relationship, you will end up with cross join effects (each of three regions will join with each of 3 options, giving 9 result rows for the GROUP BY) i would do it with an EXISTS subquery select ... from ... where exists ( select 1 from assetregion where assetId = asset.id and regionId IN ( 1, 2, 3 ) ) by the way, you've messed up the max version logic again this is wrong -- >SELECT asset.id, asset.naturalName, assetVersion.fileName, > assetVersion.fileNameThumb, assetVersion.dateCreated, > assetVersion.size, asset.assetVersionId, MAX( > assetVersion.versionNumber ) > FROM ... use the subquery in the join as shown in the previous query � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL
And I've got it... (well, it'd be close to say you've got it, but you know ;-p ) I've learnt another little string to the sql bow, cheers again Rudy.. Now if I can just remember it!!! ;-p On 04/12/06, r937 <[EMAIL PROTECTED]> wrote: > Ok, So when I put my WHERE clause, just before GROUP BY, it gets an > error... unfortunately, my crystal ball is down at the moment (it does this often, because it runs on windows) therefore you will have to show me the query oh, and please don't forget to mention what the error was > What was SELECT 1 all about, I've never seen that before... it's an EXISTS subquery -- it can select anything the important part of an EXISTS subquery is that it will evaluate TRUE if the subquery returns at least one row -- but it doesn't matter what that row contains i will routinely write it like this -- ... where exists ( select 937 from ... ) but i refrained from doing so this time because i figured it would confuse you unduly ;o) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] [OT] remote connections?
It'd be nice if it would be both ways... Sometimes my remote machine is slow.. and I'd be happier browsing on the local machine.. (thouhg I'm aware it'll be as fast as the slowest connection) On 05/12/06, Drew Trusz <[EMAIL PROTECTED]> wrote: On 12/1/06, Patrick G. <[EMAIL PROTECTED]> wrote: > Hello Tris, > On Thursday, November 30, 2006, 11:57:06 AM, you wrote: > > T> I'm on site this week (I work at home normally) > T> and I'm using remote XP to connect to my home pc to pick up code > T> samples etc, FTPing them to my server, and then picking them up here, > T> in the office.. > T> bt... > T> I'd love to be able to connect to my home, via windows explorer > T> is this possible? > > By remote XP I am assuming you mean Windows Remote Desktop (?) > If so, have you tried enabling the 'Local' Drives (in the options tab) before connecting? > Then you can drag and drop via Windows Explore on the 'Remote' box. > > -- > Best regards, > Patrick G. > > That's a much, much better solution. All the use I make of Remote at work and never discovered that. Tunnel vision. Ain't this a wonderful list! drew • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] html emails.. grrr..
I'm using 12all.. to mass send some mails out.. my most resent client does not want to send the newsletter out, unless it's pixel perfect to hs designs... He's on a MAC, and we're in the UK, FYI.. I'm explined that different clients and differnt browsers will display the email slightly differently, but not alot of difference.. He just sent a list asking for this image to go up by 2 pixels, and that one left by 3 pixels etc... Am I b eing lazy, or am I right to tell him he's beingtoo anal for an emial that most people won't study in the way he is? Thoughts, before I go back to him...??? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Creating zips in php...
Hi all... I've been taked with creating zip files in PHP, based on user selected files... all good, it ppears that PHP can do this... bt.. the files in question are up to 100Mb each. So the page just loads and loads and loads... Anyone know of a way to stream a newly created zip, as it's created? At least tht way, the user will be given the download prompt early... Any other ideas are welcome...!!! Thoughts? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Link in plain text e-mail
Many clients interpret links that are full 'http://www.site.comn/link.html' etc So just ake sure all links are ful and correct.. you cannot use the tag.. :-( On 11/12/06, Portman <[EMAIL PROTECTED]> wrote: Hi all, How does a person get a link into a plain text e-mail? I am assuming that it was set up probably as a "plain" version of HTML so that it looks like text because a true text e-mail would not have any links in it, correct? Thanks, Riva • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Creating zip files in PHP that are HUGE!
I'm added this cool class to my site: http://www.phpconcept.net/pclzip/index.en.php It all works great, until I try and compile a large zip (80Mb) SO my question(s) are: 1. Anyone uesd tis before on large files 2. would a Linux server have an inbuilt setting that stops it processign internally if there was too much load? 3. Any other ideas for creating large zips on teh fly..?? Tris... (I'm currently trying to create them and email a link) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Adding 15 mins to PHP time...
I'm creating a timer for todays lucky client... They wanna hit start and have a timer on screen across all pages.. No prob doing that in javascript, so I'm gonna create a session called timer with the date value: date("H:i:s"); Giving: 15:42:34 etc.. (the precise users start time) What I need to do is on each page, check the current server time, and if it's 15 mis higher than my session, redirect the user to a thank you page and destroythetimer session.. s... How can I add 15 mins to a date function? (I'm also gonna have to fee different times to the javasript ticker, but that'll be easiy once I kno whow to knock off time from um, well, time :-p ) Thoughts? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Fetching rows 5 above and 5 below a target row...
Hi all... I've been asked to put together a league table thingy for a client. What they want is to show the current users position, relative to the whole board. So, If I'm ranked 356 for example, on my leauge table view, I wanna see me highlighted inthe middle and Ranks 350 - 355 above me, and then 357 - 361 below me. each user in the DB has a score tally, that increments as the user plays the game. (It's a quiz thing). So eg: SELECT userName, score FROM resultsTable WHERE userName = '$myUserName' (and 5 above/below too!) ORDER BY score DESC LIMIT 11 Is this easy, google is making my Monday morning hard... :-( Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Fetching rows 5 above and 5 below a target row...
Wow.. i want to curl up and die.. That's insane! What's more scary is that you probably looksed it for 1 minute and knew what to do.. You're a clever clever man.. Tris... On 18/12/06, r937 <[EMAIL PROTECTED]> wrote: > Is this easy no it is not select userName , score from resultsTable as T where userName = '$myUserName' or ( userName > '$myUserName' and ( select count(*) from resultsTable where userName > '$myUserName' and userName <= T.userName ) <= 5 ) or ( userName < '$myUserName' and ( select count(*) from resultsTable where userName >= T.userName and userName < '$myUserName' ) <= 5 ) order by userName desc rudy http://r937.com/ � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Fetching rows 5 above and 5 below a target row...
Jsut for infos sake, and the fact that Rudys code scares me ;-p Here's what I ended up with... $sqlGetHighScore = "SELECT currentScore, nameFirst, nameLast, userId FROM $tableUsers ORDER BY currentScore DESC"; while($rowGetHighScore = mysql_fetch_array($resultGetHighScore)) { // List ALL results, but only show the first 5 for top scorers if ($count <= 5) { $getHighScores .= "$rowGetHighScore[nameFirst] $rowGetHighScore[nameLast]: $rowGetHighScore[currentScore]\n"; } // Start list of last 5, ready to stop when you reach userId $filterList5 = $filterList4; $filterList4 = $filterList3; $filterList3 = $filterList2; $filterList2 = $filterList1; $filterList1 ="$count - $rowGetHighScore[nameFirst] $rowGetHighScore[nameLast]: $rowGetHighScore[currentScore]\n"; if ($rowGetHighScore[userId] == "$_SESSION[userId]") { $showMyScore = "My Score: $rowGetHighScore[currentScore]"; $masterFilterTop1 = "$count - $rowGetHighScore[nameFirst] $rowGetHighScore[nameLast]: $rowGetHighScore[currentScore]\n"; $masterFilterTop2 = $filterList2; $masterFilterTop3 = $filterList3; $masterFilterTop4 = $filterList4; $masterFilterTop5 = $filterList5; $count2 = 0; } start count of next 5 users... if (($count2 <= 5) && ($count2 != 0)) { $masterFilterBottom .= "$count - $rowGetHighScore[nameFirst] $rowGetHighScore[nameLast]: $rowGetHighScore[currentScore]\n"; } $count++; $count2++; } = this query is used to make 3 seperate areas of data: Your current score the top 5 scorers your place relative to all users... it works great, with me and my 5 testers.. I wonder how it'll hold up to several 1000 users... eek! Tris... On 18/12/06, Cheryl D Wise <[EMAIL PROTECTED]> wrote: Yep, it is scary what someone who is really good can do in a very short time. To paraphrase, "I am awestruck, I bow in admiration." Cheryl D Wise MS MVP FrontPage http://by-expression.com Online instructor led training http://starttoweb.com Now registering for our January 2007 session -Original Message- From: Tris Wow.. i want to curl up and die.. That's insane! What's more scary is that you probably looksed it for 1 minute and knew what to do.. You're a clever clever man.. h you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: unknown lmsubst tag argument: '' To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Flash not 'compiling' on FF...?
I know compiling is not the correct term, but bear with me ;-p I've discovered http://www.maani.us/ and am in love.. I'm using their cahrt generator, with some dynamically generated XML to create it. the flash file looks for an xml file (a php file in reality, but layed out as an SML to the browser), collects the data and formats it all nice and pretty like.. On IE 6 (I've not tested it on other IE's) it displays great and I'm a happy man. But in FF, it times out, as if it's nt happy with the XML. so my Q is: Does Flash and or FF deal with XML ina different way to IE? I'm about to show it to a client and would like to show him the cross browser greatnes... but there isnt any right now :-( Thoughts? � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP >>> ?
Another PHP developer near me, has jsut asked what the PHP function is where you can out put text 'like' this: = ABC My text will interpret $randomVariable into whatever it is set to ABC <<< = I've nop idea, but he's convinced there's something like ths called escape doc?? anyone know what he's on about? � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] PHP issue with creating new instance of a class
Hmmm... I presume that you've got: $p->setContent($content); $p->display(); AFTER all that form-->Email code? You've missed the closing } but I'm sure that's just inthe email... haveyou tried puttingechos at all points, to see where the page is stopping, or is it not loading at all? not much help, but I'll keep thinking... Tris... On 03/01/07, Matthew Macdonald-Wallace <[EMAIL PROTECTED]> wrote: Morning all, Has anyone ever come across an issue in PHP where all the pages except one can create a class properly? My site is sup as follows: class page contains all the information about how to format a page, including a function called "setContent" and another called "display". class newsroom contains a number of functions to display news headlines etc. as part of the display() funtion, the newsHeadline function of newsroom() is called. The content for the page is set using the following code: $p = new page(); $content = "Page text and images etc here."; $p->setContent($content); $p->display(); This works fine for all of my pages apart from one. I have checked the source over and over again of the page that creates the error and the only thing I can see different is that the page with the issue contains a form: require_once("includes/page.class.php"); $p = new page(); /*$cm = $_GET['cm']; if($cm == 1) { // form has been submited, so put the email together and send it to the appropriate // email account. $emailBody = $_POST['custBody']; $from = $_POST['custEmail']; $custTopic = $_POST['custTopic']; switch($custTopic){ case "Sales": $to = "[EMAIL PROTECTED]"; $subject = "Sales Enquiry"; break; case "suppReq": $to = "[EMAIL PROTECTED]"; $subject = "Support Request"; $headers = "x-mail-priority: high"; break; case "infoReq": $to = "[EMAIL PROTECTED]"; $subject = "Information Request"; break; default: $to = "[EMAIL PROTECTED]"; $subject = "Information Request"; break; } $content = "Thank youThank you for getting in contact with us. We will endevour to respond to your email within 12 hours of this message. An email has been sent to you confirming this.Kind regards,The Interactive Networks Team"; mail($to,$subject,$body,"FROM: $from,$headers"); } else {*/ $content = "Contact Us Please complete the form below to contact our team. Your Name: Your Email Address: What would you like to talk to us about? I have a sales Enquiry I have an information request I have a support request Please type your request in the box below and click the \"Contact\" button to continue. Contact Us "; If I do an echo $content, the page displays the normal text fine but without the formatting applied. This is driving me nuts, so if anyone can spot the issue, that would be great, I'm sure it's really simple. Cheers, Matt • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] FF table padding?
http://w03-joshua.exalia.net/BrainPower/ On the above URL in FF, the display table has gaps.. but on IE.. it does not? Can anyone explain why? (I know I know, tables are bad.. though I've never really understood why...) Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] PHP issue with creating new instance of a class
Fatal error: Cannot instantiate non-existent class: newsroom in /usr/local/psa/home/vhosts/wepoweryour.net/httpdocs/includes/page.class.php on line 27 What IS on line 27, or 26? On 03/01/07, Matthew Macdonald-Wallace <[EMAIL PROTECTED]> wrote: Tris, Quoting Tris <[EMAIL PROTECTED]>: > Hmmm... > I presume that you've got: > > $p->setContent($content); > $p->display(); > > AFTER all that form-->Email code? yup. > You've missed the closing } but I'm sure that's just inthe email... yup, along with all other mistakes (s/sup/setup) > haveyou tried puttingechos at all points, to see where the page is > stopping, or is it not loading at all? Fraid so. > not much help, but I'll keep thinking... If it helps, the site is at www.wepoweryour.net This site is nowhere near finished and the template is from www.oswd.org ! :) Cheers, Matt -- Matthew Macdonald-Wallace [EMAIL PROTECTED] "Sed quis custodiet ipsos custodies?" • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] PHP issue with creating new instance of a class
don't be so hard on yourself.. I had an afternoons work wasted cause I was calling an sql statment... named sal.. not sql... could not figure that one out for ages... :-( On 03/01/07, Matthew Macdonald-Wallace <[EMAIL PROTECTED]> wrote: Quoting Tris <[EMAIL PROTECTED]>: > Fatal error: Cannot instantiate non-existent class: newsroom in > /usr/local/psa/home/vhosts/wepoweryour.net/httpdocs/includes/page.class.php > on line 27 > > What IS on line 27, or 26? Never mind. I am, for want of a better phrase, a dick. All the other pages have these lines in them: // include the libraries require_once("includes/site.lib.php"); whereas contact.php had the following: // include the libraries require_once("includes/page.class.php"); if you don't include the classes, it won't find them will it? FFS I am so dense at times... :( Matt > > On 03/01/07, Matthew Macdonald-Wallace <[EMAIL PROTECTED]> wrote: >> Tris, >> >> Quoting Tris <[EMAIL PROTECTED]>: >> >>> Hmmm... >>> I presume that you've got: >>> >>> $p->setContent($content); >>> $p->display(); >>> >>> AFTER all that form-->Email code? >> >> yup. >> >>> You've missed the closing } but I'm sure that's just inthe email... >> >> yup, along with all other mistakes (s/sup/setup) >> >>> haveyou tried puttingechos at all points, to see where the page is >>> stopping, or is it not loading at all? >> >> Fraid so. >> >>> not much help, but I'll keep thinking... >> >> If it helps, the site is at www.wepoweryour.net >> >> This site is nowhere near finished and the template is from >> www.oswd.org ! :) >> >> Cheers, >> >> Matt >> >> -- >> Matthew Macdonald-Wallace >> [EMAIL PROTECTED] >> "Sed quis custodiet ipsos custodies?" >> >> >> >> >> ? The WDVL Discussion List from WDVL.COM ? >> To Join wdvltalk, Send An Email To: >> mailto:[EMAIL PROTECTED] or >> use the web interface >> http://e-newsletters.internet.com/discussionlists.html/ >> Send Your Posts To: wdvltalk@lists.wdvl.com >> To change subscription settings, add a password or view the web interface: >> http://intm-dl.sparklist.com/read/?forum=wdvltalk >> >> http://www.wdvl.com ___ >> >> You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] >> To unsubscribe send a blank email to [EMAIL PROTECTED] >> To unsubscribe via postal mail, please contact us at: >> Jupitermedia Corp. >> Attn: Discussion List Management >> 475 Park Avenue South >> New York, NY 10016 >> >> Please include the email address which you have been contacted with. >> > > > -- > When a person can no longer laugh at himself, it is time for others to > laugh at him. > Thomas Szasz > > • The WDVL Discussion List from WDVL.COM • > To Join wdvltalk, Send An Email To: > mailto:[EMAIL PROTECTED] or > use the web interface http://e-newsletters.internet.com/discussionlists.html/ > Send Your Posts To: wdvltalk@lists.wdvl.com > To change subscription settings, add a password or view the web interface: > http://intm-dl.sparklist.com/read/?forum=wdvltalk > > http://www.wdvl.com ___ > > You are currently subscribed to wdvltalk as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > To unsubscribe via postal mail, please contact us at: > Jupitermedia Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. -- Matthew Macdonald-Wallace [EMAIL PROTECTED] "Sed quis custodiet ipsos custodies?" • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: unknown lmsubst tag argument: '' To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can
[wdvltalk] FF flash... or xml..
Ello all.. I've got an XML fed flash chart thingy: http://www.maani.us/xml_charts/ To see it, go here: http://w03-joshua.exalia.net/BrainPower/home.php User:[EMAIL PROTECTED] Pass: test101 If you login under IE (PC, not tested on a MAC at all) you'll see a white flash graph.. however, on FF, it just hangs and hangs til it times out.. the XML doc that feeds it is here: http://w03-joshua.exalia.net/BrainPower/sample.php Any brain storms as to why FF says 'I don't like it' (in my best northern UK accent)? Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] FF flash... or xml..
Oh yeah, bugger... I'd updated that page... http://w03-joshua.exalia.net/BrainPower/homeMaster.php login, then paste this URL... Sigh.. is it Friday yet?? On 04/01/07, Drew Trusz <[EMAIL PROTECTED]> wrote: On 1/4/07, Tris <[EMAIL PROTECTED]> wrote: > Ello all.. > I've got an XML fed flash chart thingy: > http://www.maani.us/xml_charts/ > > To see it, go here: > http://w03-joshua.exalia.net/BrainPower/homeMaster.php > User:[EMAIL PROTECTED] > Pass: test101 > > If you login under IE (PC, not tested on a MAC at all) > you'll see a white flash graph.. > however, on FF, it just hangs and hangs til it times out.. > > the XML doc that feeds it is here: > http://w03-joshua.exalia.net/BrainPower/sample.php > > Any brain storms as to why FF says 'I don't like it' (in my best > northern UK accent)? > Don't see any difference between the two. All I get is a page with a different logo and an incomplete message about "If you are not Test, please". drew • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] FF flash... or xml..
Ok, go back to home, and there's a link in the main body (I've just added it..) That DEFFO goes to the flash file... REALLY sorry about this, I should've set up a test site else where whil I was working on this one.. Tris... On 04/01/07, Drew Trusz <[EMAIL PROTECTED]> wrote: On 1/4/07, Tris <[EMAIL PROTECTED]> wrote: > Oh yeah, bugger... > I'd updated that page... > http://w03-joshua.exalia.net/BrainPower/homeMaster.php > login, then paste this URL... > > Sigh.. is it Friday yet?? > Nearly Friday. I still get the same thing but this time I think it's a good thing. I see a welcome to test and a "challenge a friend" image with a "top 5 league" listing in both browsers. The image is clickable and leads to an enter 5 email addy page. Again same behavior in both browsers. Did I miss something? If not, then it looks like you fixed it. Hoist the tankard! drew • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP 3rd party sessions...
We've created a site, that works great locally, an on our test servers. However, it's final resting place is via an Iframe on a 3rd party site. No worries there, but some in our office, with higher security settings, cannot login and are not assigned the session variables, due to the nature of their security settings. We've tried altering the ini file, to no avail... (use_only_cookies = 0, trans_sid = 1) Restarted and nothing.. has anyone come accross a similar 'bug' before? I know we can't expect our users to change their security settings, but there's gotta be a way??? (this is keeping us in the office till we get it.. .on a FRIDAY :-( ) Tris.. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP erros on..
I've just put a site I've built onto mybosses localhost... He ges LOADS of errors.. I don't.. sooo, how can I turn on all errors, so tat I can ensure I can clean all the code to be super good! I've looked at PHP.ini and i've got it on as far as I can see.. i think...? Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP and declaring variables...
Hi all.. when I started PHP (5 years ago.. or maybe 4... I forget) I learnt that to create a varaiable, I simply wrote: $variableName = "variableValue"; OR $variableInt = 3; All good, it's worked for years.. Buut During myturningon errors today, I was seeing LOADS of undeclared variable errors.. so I simply added to the top of each page, the problem variable names, and a blank value.. eg: $date = ""; $userName = ""; $score = ""; thus declaring them for later use... Now this strikes me as a pain in the back side.. Can anyone throw lighton to why I need to do this, OR can I fix the undeclared variables 'bug' without having a list of blank variales at the top of each page...? For now.. i'm off to browse the google... the wonderful goodle of web... (bad wizard of oz rip off, sorry) Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP, 8 digit string, to 8 item array..
I wanna take an Int (eg: 48392034) and make an array: $myArray[0] = 4; $myArray[1] = 8; $myArray[2] = 3; $myArray[3] = 9; $myArray[4] = 2; $myArray[5] = 0; $myArray[6] = 3; $myArray[7] = 4; I've looked at substr, ut it doesn't relal yhelp, as there's no characters to split by.. what am I missing? Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP: is_numeric... that's the question...
Hi all... I'm having probs with is_numeric... here's the body of a function I've written... the inout shoud be: 2 x letters 5 x numbers eg: fr23454 / kr5 / AP84754 Bt... these are coming up as valid too? F454354 / 4G64345 / L454345 it seems that if there's a single number in the usercode, it's accepting it... can anyone see what I'm doing wrong? stupid tech :-( = $codeLength = strlen($usercode); $getLast5Characters = substr($usercode, -5, 5); $getFirst2Characters = substr($usercode, 0, 2); $codeInt = is_numeric($getLast5Characters); $codeAlpha = is_numeric($getFirst2Characters); if (($codeLength == 7) && ($codeInt) && (!$codeAlpha)) { return "code valid"; } else { return "Code Invalid"; } = -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] [OT] - Freelance/contractors Accounting software...
Hi all.. I'm kinda new to freelancing, and got a big shock when tax time came around here in the UK. so going forward, I'd like to keep all my accoutns on line. Now clearly I can use Excel, or google docs etc.. but does anyone use a program that's more specificaly tailored to our kind of book keeping? Any advise, suggestions on the whole process are welcome, and I'd liek to get started as soon as possible! Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] [PHP] reformat date...
Simply put, I'm REALLY hungover, and want to die... However, before I go home.. I have to convert: (string)3/MAY/07 --> (date for MySQL)2007-05-03 google is confusing me... NEVER drinking again. Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] [PHP] reformat date...
sorry, it's for inclusion into a db.. so I need to convert the date before I create my MYSQL satement... On 25/01/07, r937 <[EMAIL PROTECTED]> wrote: > (string)3/MAY/07 --> (date for MySQL)2007-05-03 select str_to_date('3/MAY/07','%e/%M/%y') from daTable... ;o) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] onchange.. my aunt!
Hi all... going back to basics today.. I've got a form.. (a form!) that s giving me grief.. I want the form to self submit when I change a SE:ECT option. all good, javascript etc... Bt... top of my form: and further down.. i've tried using this: this.form.submit(); but it just gives me errors :-( A really rookie issue this morning... but google is not helping...! Any ideas? Cheers as always, luv n hugs, Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] onchange.. my aunt!
Ok.. fixed... what it was ... was... i'm in an artsy fartsy design agency, where I'm not allowed to design stuff, just make it 'work'... so I had an HTML/CSS page all perfect looking... but the designer had coded his form with teh submit button to have the NAME submit.. so my Javascript was talking to that.. so I've renamed it to submitIt... and all is well in the universe again... Thanks for all the brain power though guys... you rock! On 30/01/07, David Precious <[EMAIL PROTECTED]> wrote: On Tue, 30 Jan 2007, Tris wrote: > I've got a form.. (a form!) that s giving me grief.. > I want the form to self submit when I change a SE:ECT option. > all good, javascript etc... Bt... > > top of my form: > action=""> > > > and further down.. > onChange="document.forms['bookingForm'].submit(); return true;"> > > i've tried using this: > this.form.submit(); try onchange="document.bookingForm.submit()" Alternatively, parent.submit() *might* work, dunno though. Don't know why this.form.submit() didn't work, I think it should. You should be able to remove the return true off the end of the onchange, I don't think it's needed. Cheers Dave P � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] verification emails
yes! i am... On 30/01/07, Linda Cole <[EMAIL PROTECTED]> wrote: Hi Gang, I've set Peter's account to get mail; is anyone getting the verification emails when you post to the list? Thanks, Linda -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.15/659 - Release Date: 1/30/2007 9:31 AM • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] [PHP] DEFINE Vs $variable..?
Hi all... I've a 'help me learn' type question.. I've got to do a site in 2 languages... My first thought was to simply set a session variable for each language, and then have an include page like this: if lang == english then $textWelome = "Welcome"; else if lang == chinese then $textWelome = "Ni Hao"; etc... However, I've seen sites (PHPMyAdmin springs to mind?) where the language include uses DEFINE.. What is the difference, and why is one better than the other..? -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP date month list...?
Why doesn't this 'function' output a list of months? for ($h = 1; $h <= 12; $h++) { $monthNo = date("m", $h); $monthName = date("M", $h); $flightdateListMonth .= "" . $monthName . ""; } H... I know I'm missing something obvious... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] [MySQL] - REPLACE or INSERT IGNORE
Morning all..! i'm importing data from a csv file. No worries, but oneof the fields I wanna import is an email address.. BUT, if the address already exists, I don't wanna bother. To that end, I made the email column my index for the table, and used: REPLACE INTO imported_newAffiliates (`emailAddress`, `signUpDate`) VALUES('[EMAIL PROTECTED]', '2007-01-14 11:42:24') and yet it's still duplicating the data Duplicates are unlikley, but I'd like to be safe... Anyone care to tell me what I'm doing wrong? Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] [MySQL] - REPLACE or INSERT IGNORE
And THAT... is why they pay Rudy the big bucks.. It was an index, not unique.. Cheers!!! On 27/02/07, r937 <[EMAIL PROTECTED]> wrote: > Anyone care to tell me what I'm doing wrong? probably forgot to declare a primary or unique key rudy http://r937.com/ • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Cannot delete csv... so let's edit it?
Ello all... I've got 3 csv files that I'm ftping to a DIR.. Every 10 mins, they are scanned (along with lots of other functions). The contents of the CSV are dumped into a table I've got.. BUT.. I want to delete the CSV afterwards..(or the data is duplicated) but I'm getting permission denied errors. I've CHMODed them, but still no..? I've ggogled and there's lots of talk about server persmission, PHP permissions etc.. so, I thought.. why can't I just edit the file(s) on the fly and empty them when I'm done? Can I edit CSV files in PHP? How can I forceably delete a csv? Either option is fine by me... any idea? Back to google! Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP Sessions and Frames...
Bit of an odd one... i've built a registration area, and as it's mulitple pages, I've used a session to capture the ID number of the row I created in the database, for use in my UPDATE calls on subsequent pages... Anyhoo... The whole system has been plonked in a frame on their server, by the client. and for some users, the data is not being captured and the session data is into being remembered... I found this on google: http://www.dbforums.com/archive/index.php/t-1117749.html but It's for cfm pages... Has anyone come accross this bug before, and does anyone know a fix? I gotta a pissed off client on a Mondya morning... i just LOVE them! ;-p Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] [PHP] Hitting a URL from within a function, but NOT directing the browser there...
Hi all... I'm scanning a list of users and if any of them meet certain critiera, I'm supposed to add them to another DB on another server. The admin guys over there have set it up to collect that data in a URL, that i'm supposed to visit. all works great manually, but I need to do it a few dozen times, in the back end of my function. So, how can I hit a URL, without going there in teh browser? the mind boggles on this Monday morning..!!! Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP OO books....
I really need to get my head into OO and PHP.. Can anyone recommend any books or GOOD online tutorials to get me into the game proper.. My PHP is not that bad, but I've alot to learn... Suggestions? Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Stupid ..
Well, back to HTML basics for me today... http://www.tlc-rewards.com/5629JustinBridou/terms.html Has an tag and a few items... However, it's not showing a n ordered list... Did someone retire that tag and not tell me... I normally get all the memos... ideas? -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Stupid ..
Fixed now... Aren't you in Canada...? What you doing up at this hour!!! ;-p On 29/03/07, r937 <[EMAIL PROTECTED]> wrote: > http://www.tlc-rewards.com/5629JustinBridou/terms.html > > Has an tag and a few items... > However, it's not showing a n ordered list... looks fine in IE6 rudy • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] First Monday bug...
i'm trying to create a drop down tht contains the first Monday of each week, including the current week. From the function, I need to out put 2 bits of data: 1. the date in a happy DB compliant manner (-MM-DD) 2. the date in a user Friendly way (2nd April etc) Can a function even output 2 bits of data? Anyone more clever than me, care to run the code below, and tell me what I'm doing wrong? Hmmm === function showMondays($noWeeksBack = 10) { $oneDay = 86400; $WeekDayNumber = date('w'); for ($i = -1; $i <= $noWeeksBack; $i++) { $prevWeeks = $i * 7; $prevWeeks = $prevWeeks + 6; $showWeekStart[] = date("jS M Y",time() - ($WeekDayNumber + $prevWeeks) * $oneDay); $showFullDate[] = date("Y-m-d",time() - ($WeekDayNumber + $prevWeeks) * $oneDay); } return $showWeekStart; return $showFullDate; } $getMondays = showMondays(4); foreach ($getMondays as $value) { $i++; $showDates .= "" . $value["showFullDate"] . "\n"; } === -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Joining tables... in MySQL
Hi Rudy.. I mean everyone ;-p i've two tables: JobType id (int) name (varChar) Jobs id (int) user (int) week (date) day (int) jobNo (int) jobType (int) hours (int) I want to list all job types, and IF there's any corresponding with the jobs table, I want to marry them up. I've used this: SELECT jobType.name, jobs.user, jobs.jobNo, jobs.jobType, jobs.hours, jobs.day FROM jobType RIGHT JOIN jobs on jobs.jobType = jobType.id But I'm only getting results if there's the Jobtype id in the jobs table.. Anyhoo... how can I list all jobTypes, and 'fill in the gaps'? I've googled OUTER joins, but Im getting errors...?? Hm -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re:[wdvltalk] Joining tables... in MySQL
HERE's my SQL dump... CREATE TABLE `jobType` ( `id` int(12) NOT NULL auto_increment, `name` varchar(100) collate utf8_bin NOT NULL default '', `type` tinyint(10) NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ; -- -- Dumping data for table `jobType` -- INSERT INTO `jobType` VALUES (1, 'Design', 0); INSERT INTO `jobType` VALUES (2, 'Meeting', 0); INSERT INTO `jobType` VALUES (3, 'PHP', 0); INSERT INTO `jobType` VALUES (4, 'Downtime', 0); INSERT INTO `jobType` VALUES (5, 'Copy', 0); INSERT INTO `jobType` VALUES (6, 'Other', 0); -- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` int(12) NOT NULL auto_increment, `user` int(10) NOT NULL default '0', `week` date NOT NULL default '-00-00', `day` tinyint(3) NOT NULL default '0', `jobNo` int(10) NOT NULL default '0', `jobType` int(10) NOT NULL default '0', `hours` tinyint(5) NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=14 ; -- -- Dumping data for table `jobs` -- INSERT INTO `jobs` VALUES (4, 4, '2007-02-19', 1, 1, 1, 1); INSERT INTO `jobs` VALUES (5, 4, '2007-02-19', 2, 2, 2, 2); INSERT INTO `jobs` VALUES (6, 4, '2007-02-19', 3, 3, 3, 3); INSERT INTO `jobs` VALUES (7, 4, '2007-02-19', 4, 4, 4, 4); INSERT INTO `jobs` VALUES (8, 4, '2007-02-19', 5, 5, 5, 5); INSERT INTO `jobs` VALUES (13, 0, '2007-02-19', 0, 0, 0, 0); INSERT INTO `jobs` VALUES (12, 0, '2007-02-19', 0, 0, 0, 0); On 04/04/07, Tris <[EMAIL PROTECTED]> wrote: Hi Rudy.. I mean everyone ;-p i've two tables: JobType id (int) name (varChar) Jobs id (int) user (int) week (date) day (int) jobNo (int) jobType (int) hours (int) I want to list all job types, and IF there's any corresponding with the jobs table, I want to marry them up. I've used this: SELECT jobType.name, jobs.user, jobs.jobNo, jobs.jobType, jobs.hours, jobs.day FROM jobType RIGHT JOIN jobs on jobs.jobType = jobType.id But I'm only getting results if there's the Jobtype id in the jobs table.. Anyhoo... how can I list all jobTypes, and 'fill in the gaps'? I've googled OUTER joins, but Im getting errors...?? Hm -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Joining tables... in MySQL
Rudy, I knew you'd be there somewhere ;-p it's odd... I'd tried that, and just got one row of results. Still do... It's going through the jobs table and only returning jobTypes that have been flagged in jobs.. not ALL job types... any other ideas? On 04/04/07, r937 <[EMAIL PROTECTED]> wrote: > I've googled OUTER joins, but Im getting errors...?? Hm funny, google never gave me any errors, and i've been using it since it came out what you want, young paduan, is a LEFT OUTER JOIN instead ;o) • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Joining tables... in MySQL
Ah, i'm on 4.1.11 that make a difference? On 04/04/07, r937 <[EMAIL PROTECTED]> wrote: > It's going through the jobs table and only returning jobTypes that > have been flagged in jobs.. > not ALL job types... i tested the LEFT OUTER JOIN on the data you supplied and it works ~fabulously~ maybe you have some other conditions that are clouding the issue • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Joining tables... in MySQL
:-( Here I go again... it really doesn't work... ? :-( SELECT jobType.name, jobs.user, jobs.jobNo, jobs.jobType, jobs.hours, jobs.day FROM jobType LEFT OUTER JOIN jobs ON jobs.jobType = jobType.id WHERE jobs.id IS NULL OR ( jobs.user = '4' AND jobs.week = '2007-03-19' AND ( jobs.day = '3' OR jobs.day = '0' ) ) CREATE TABLE `jobType` ( `id` int(12) NOT NULL auto_increment, `name` varchar(100) collate utf8_bin NOT NULL default '', `type` tinyint(10) NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ; INSERT INTO `jobType` VALUES (1, 'Design', 0); INSERT INTO `jobType` VALUES (2, 'Meeting', 0); INSERT INTO `jobType` VALUES (3, 'PHP', 0); INSERT INTO `jobType` VALUES (4, 'Downtime', 0); INSERT INTO `jobType` VALUES (5, 'Copy', 0); INSERT INTO `jobType` VALUES (6, 'Other', 0); CREATE TABLE `jobs` ( `id` int(12) NOT NULL auto_increment, `user` int(10) NOT NULL default '0', `week` date NOT NULL default '-00-00', `day` tinyint(3) NOT NULL default '0', `jobNo` int(10) NOT NULL default '0', `jobType` int(10) NOT NULL default '0', `hours` tinyint(5) NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=19 ; INSERT INTO `jobs` VALUES (18, 4, '2007-03-05', 0, 45645, 0, 0); INSERT INTO `jobs` VALUES (4, 4, '2007-03-19', 1, 1, 1, 1); INSERT INTO `jobs` VALUES (5, 4, '2007-03-19', 2, 2, 2, 2); INSERT INTO `jobs` VALUES (6, 4, '2007-03-19', 3, 3, 3, 3); INSERT INTO `jobs` VALUES (7, 4, '2007-03-19', 4, 4, 4, 4); INSERT INTO `jobs` VALUES (8, 4, '2007-03-19', 5, 5, 5, 5); INSERT INTO `jobs` VALUES (13, 1, '2007-03-19', 2, 12, 6, 2); INSERT INTO `jobs` VALUES (12, 2, '2007-03-19', 4, 21, 3, 1); On 04/04/07, r937 <[EMAIL PROTECTED]> wrote: > Ah, i'm on 4.1.11 > that make a difference? none whatsoever ;o) • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] Joining tables... in MySQL
OHHH!!! Makes sence... Cheers Rudy... as ALWAYS!!! (I'd kiss you, but that'd be a bit too fruity for my taste... not that there's anything wrong with that!) On 04/04/07, r937 <[EMAIL PROTECTED]> wrote: > Here I go again... > it really doesn't work... ? :-( yes it does, but you have to be really careful with WHERE conditions in outer joins > SELECT jobType.name, jobs.user, jobs.jobNo, jobs.jobType, jobs.hours, > jobs.day > FROM jobType > LEFT OUTER JOIN jobs ON jobs.jobType = jobType.id > WHERE jobs.id IS NULL > OR ( > jobs.user = '4' > AND jobs.week = '2007-03-19' > AND ( > jobs.day = '3' > OR jobs.day = '0' > ) > ) this yields the Other jobtype, with no matching rows ;o) i'm guessing that what you really want (which you never explained) is something like this -- SELECT jobType.name , jobs.user , jobs.jobNo , jobs.jobType , jobs.hours , jobs.day FROM jobType LEFT OUTER JOIN jobs ON jobs.jobType = jobType.id AND ( ( jobs.user = 4 AND jobs.week = '2007-03-19' ) OR ( jobs.day in ( 0, 3 ) ) ) in outer joins, there is a big difference between conditions in the ON clause and conditions in the WHERE clause oh, and p.s., please do not make strings out of numbers to compare to numeric columns, it makes them soggy and hard to light ;o) • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] [OT] - I'm not a flash fan, bu tI've fallen in love with this...
http://www.gourmetoriental.com/ I'm probably the last to see this kinda thing, but I thought it was awesome... Love to see more of this kinda thing... Um, that's all, it tickled me... had to share... Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] WAY [OT] - Google homepage...
Mines reverted back to 'factory settings' All my bookmarks and custom modules are gone... :-( Is it just me, or are there other people stuck? -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] WAY [OT] - Google homepage...
rght ;-p On 26/04/07, r937 <[EMAIL PROTECTED]> wrote: > All my bookmarks and custom modules are gone... :-( what happen someone set up us the bomb we get signal what! main screen turn on it's you !! how are you gentlemen !! ALL YOUR BOOKMARKS AND CUSTOM MODULES ARE BELONG TO US you are on the way to destruction what you say !! you have no chance to survive, make your time ha ha ha ha oh, never mind • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] WAY [OT] - Google homepage...
I feel less alone... I wrote to google... might hear back in a few weeks ;-p I've checked my bookmarks and they're all still in existance... but i've tried to recreate my homepage... but the elemnts I had before, are not being accepted... Really weird... guess I should learn not to rely on a 3rd party and just make my own homepage and calender setup...??? On 26/04/07, Linda <[EMAIL PROTECTED]> wrote: Mine has gone too :-( Linda -Original Message- From: Tris [mailto:[EMAIL PROTECTED] Sent: 26 April 2007 12:22 To: wdvltalk@lists.wdvl.com Subject: [wdvltalk] WAY [OT] - Google homepage... Mines reverted back to 'factory settings' All my bookmarks and custom modules are gone... :-( Is it just me, or are there other people stuck? -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] WAY [OT] - Google homepage...
All browsers, at home, at work... :-( On 26/04/07, Peter MacGregor <[EMAIL PROTECTED]> wrote: Are you all using IE? I use Firefox and home page and bookmarks showing as normal. Peter MacGregor At 15:37 26/04/2007, you wrote: >I feel less alone... I wrote to google... might >hear back in a few weeks ;-p I've checked my >bookmarks and they're all still in existance... >but i've tried to recreate my homepage... but >the elemnts I had before, are not being >accepted... Really weird... guess I should learn >not to rely on a 3rd party and just make my own >homepage and calender setup...??? On 26/04/07, >Linda <[EMAIL PROTECTED]> wrote: > Mine has >gone too :-( > > Linda > > > -Original >Message- > From: Tris >[mailto:[EMAIL PROTECTED] > Sent: 26 April >2007 12:22 > To: wdvltalk@lists.wdvl.com > >Subject: [wdvltalk] WAY [OT] - Google >homepage... > > Mines reverted back to 'factory >settings' > All my bookmarks and custom modules >are gone... :-( > > Is it just me, or are there >other people stuck? > > -- > When a person can >no longer laugh at himself, it is time for >others to > laugh at him. > Thomas Szasz > > > The WDVL Discussion List from >WDVL.COM > To Join wdvltalk, Send An Email >To: > >mailto:[EMAIL PROTECTED] >or > use the web interface > >http://e-newsletters.internet.com/discussionlists.html/ > >Send Your Posts To: >wdvltalk@lists.wdvl.com > To change subscription >settings, add a password or view the web >interface: > >http://intm-dl.sparklist.com/read/?forum=wdvltalk > > > > http://www.wdvl.com >___ > > You are currently >subscribed to wdvltalk as: >[EMAIL PROTECTED] > To unsubscribe send a >blank email to >[EMAIL PROTECTED] > To >unsubscribe via postal mail, please contact us >at: > Jupitermedia Corp. > Attn: Discussion List >Management > 475 Park Avenue South > New York, >NY 10016 > > Please include the email address >which you have been contacted with. > > > >• The WDVL Discussion List from WDVL.COM • > > To Joinn wdvltalk, Send An Email To: >mailto:[EMAIL PROTECTED] >or > use the web interface >http://e-newsletters.internet.com/discussionlists.html/ > >Send Your Posts To: >wdvltalk@lists.wdvl.com > To change subscription >settings, add a password or view the web >interface: > >http://intm-dl.sparklist.com/read/?forum=wdvltalk > > > > http://www.wdvl.com >___ > > You are currently >subscribed to wdvltalk as: >[EMAIL PROTECTED] > To unsubscribe send a >blank email to >[EMAIL PROTECTED] > To >unsubscribe via postal mail, please contact us >at: > Jupitermedia Corp. > Attn: Discussion List >Management > 475 Park Avenue South > New York, >NY 10016 > > Please include the email address >which you have been contacted with. > -- When a >person can no longer laugh at himself, it is >time for others to laugh at him. Thomas Szasz > • The WDVL Discussion List from WDVL.COM • >To Join wdvltalk, Send An Email To: >mailto:[EMAIL PROTECTED] or >use the web interface http://e-newsletters.internet.com/discussionlists.html/ > Send Your Posts To: wdvltalk@lists.wdvl.com >To change subscription settings, add a password or view the web interface: >http://intm-dl.sparklist.com/read/?forum=wdvltalk > > http://www.wdvl.com ___ > >You are currently subscribed to >wdvltalk as: [EMAIL PROTECTED] >To unsubscribe send a blank email to >[EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: >Jupitermedia Corp. >Attn: Discussion List Management >475 Park Avenue South >New York, NY 10016 > >Please include the email address which you have been contacted with. > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.5.463 / Virus Database: 269.6.1/776 - >Release Date: 25/04/2007 12:19 • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: unknown lmsubst tag argument: '' To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupiter
[wdvltalk] Lazy PHPMyAdmin Question....
I've got a list of codes that I wanna import into a database (65k of them) can I import that list withough adding 'INSERT INTO `code`' etc... I've got a script that I can use, but I can't find it.. and i'm lazy... does PHPMyAdmin let you just dump a list? -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] A form in an HTML email?
si it possible to hav a form in an HMTL email? My current employer wants to send out a sutrvery to its staff. (I say survey, it's jsut a textarea box for comments) Can we have a box and submit button that talks to a web page? Clearly we'll have a link to a page with teh form on also, but this might encourage users to fill out the form... Anyone dne this before? -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] FF Vs IE?
http://www.getpracticing.com/index2.php5 the flash blurb on this page is opaic? Any ideas why...? -- `We are what we pretend to be, so we must be careful what we pretend to be.` Kurt Vonnegut `When a person can no longer laugh at himself, it is time for others to laugh at him.` Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re:[wdvltalk] FF Vs IE?
Ignore EVERY thing I said.. I'm a tool, and need a coffee...!!! Sigh... On 06/06/07, Tris <[EMAIL PROTECTED]> wrote: http://www.getpracticing.com/index2.php5 the flash blurb on this page is opaic? Any ideas why...? -- `We are what we pretend to be, so we must be careful what we pretend to be.` Kurt Vonnegut `When a person can no longer laugh at himself, it is time for others to laugh at him.` Thomas Szasz -- `We are what we pretend to be, so we must be careful what we pretend to be.` Kurt Vonnegut `When a person can no longer laugh at himself, it is time for others to laugh at him.` Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] PHP5 hosts...
I'm about to sign up with these guys: http://www.a2hosting.com/reseller_hosting.php on an intermediate packge for a 2 year contract. does anyone know of any better deals out there, before I sign my life away? I need: PHP 5 MySQL 5 Control panel for adding new emails, sites etc... (I'm crap at command line stuff.. for now) but have the option to use command line interface... Thouights? Cheers all!!! -- `We are what we pretend to be, so we must be careful what we pretend to be.` Kurt Vonnegut `When a person can no longer laugh at himself, it is time for others to laugh at him.` Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] i'm outta here !!!
have a BLAST!!! On 15/06/07, r937 <[EMAIL PROTECTED]> wrote: okay, that's it, i'm outta here !!! have a nice weekend folks, those of you not yet already having it see you back here monday morning!! ;o) oh, who am i kidding, i'll be back here tomorrow • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- `We are what we pretend to be, so we must be careful what we pretend to be.` Kurt Vonnegut `When a person can no longer laugh at himself, it is time for others to laugh at him.` Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.