[wdvltalk] Mysql Query help!

[Tris]

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! :-(

[Tris]

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! :-(

[Tris]

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! :-(

[Tris]

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! :-(

[Tris]

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! :-(

[Tris]

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! :-(

[Tris]

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! :-(

[Tris]

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! :-(

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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)

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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?

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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?

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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!

[Tris]

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

[Tris]

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

[Tris]

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

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

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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?

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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!

[Tris]

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!

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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?

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

:-(

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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

[Tris]

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?

[Tris]

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?

[Tris]

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?

[Tris]

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

[Tris]

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

[Tris]

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.