I am just coming to grips with php, Dreamweaver and MySQL and I want to make
a facility available for the members of the group I am creating my web site
for. I want them to be able to print-out a list of address labels, using
standard Avery labels, on their home PC's using the data from my MySQL
tables. I am not yet sufficiently au fait with php to manage to code it
myself so I wondered if anybody knew of any Dreamweaver extensions, add-ins
or tutorials which would do the trick. I have had a good look at what is on
the web but I can't find very much about it.

Any ideas?
--


(\__/)
(='.'=)
(")_(")

"FredBear" <ThisIsNotMyAddress [at] Yahoo.com> wrote in message
news:13290j3c18spc85 [at] corp.supernews.com...
>I am just coming to grips with php, Dreamweaver and MySQL and I want to
>make a facility available for the members of the group I am creating my web
>site for. I want them to be able to print-out a list of address labels,
>using standard Avery labels, on their home PC's using the data from my
>MySQL tables. I am not yet sufficiently au fait with php to manage to code
>it myself so I wondered if anybody knew of any Dreamweaver extensions,
>add-ins or tutorials which would do the trick. I have had a good look at
>what is on the web but I can't find very much about it.
>
> Any ideas?
> --
>
>
> (\__/)
> (='.'=)
> (")_(")
>

Presumably you just need to create a HTML table to match the dimensions of
the labels, that can then be printed...... as you can specify the column
widths and row heights in cm this should be fairly easy to construct.

Adding code in PHP to create this on the fly from a database would also be
fairly easy, as you are only looping through a recordset to insert the data
into the cells of the table.

Following on from Sean's message. . .
>
>Presumably you just need to create a HTML table to match the dimensions of
>the labels, that can then be printed...... as you can specify the column
>widths and row heights in cm this should be fairly easy to construct.
Is the wrong answer.

Use PDF

--
PETER FOX Not the same since the adhesive company came unstuck
peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>

"Peter Fox" <peterfox [at] eminent.demon.co.uk.not.this.bit.no.html> wrote in
message news:gO2Y2LAAFKJGFwvd [at] eminent.demon.co.uk...
> Following on from Sean's message. . .
>>
>>Presumably you just need to create a HTML table to match the dimensions of
>>the labels, that can then be printed...... as you can specify the column
>>widths and row heights in cm this should be fairly easy to construct.
> Is the wrong answer.
>
> Use PDF
>
> --
> PETER FOX Not the same since the adhesive company came unstuck
> peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
> 2 Tees Close, Witham, Essex.
> Gravity beer in Essex <http://www.eminent.demon.co.uk>

Wrong? ... How?

PDF is an alternative to HTML, I would agree ... and would even concede that
it's a better alternative, IF the guy can find (or be given) the appropriate
code examples to complete the task, but HTML wouldn't be "wrong",
particularly if he's new to the coding that it would take to complete the
job.

Following on from Sean's message. . .
>
>"Peter Fox" <peterfox [at] eminent.demon.co.uk.not.this.bit.no.html> wrote in
>message news:gO2Y2LAAFKJGFwvd [at] eminent.demon.co.uk...
>> Following on from Sean's message. . .
>>>
>>>Presumably you just need to create a HTML table to match the dimensions of
>>>the labels, that can then be printed...... as you can specify the column
>>>widths and row heights in cm this should be fairly easy to construct.
>> Is the wrong answer.
>>
>> Use PDF
>>
>> --
>> PETER FOX Not the same since the adhesive company came unstuck
>> peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
>> 2 Tees Close, Witham, Essex.
>> Gravity beer in Essex <http://www.eminent.demon.co.uk>
>
>Wrong? ... How?
Try it yourself and you'll find out.
>
>PDF is an alternative to HTML, I would agree ... and would even concede that
>it's a better alternative, IF the guy can find (or be given) the appropriate
>code examples to complete the task, but HTML wouldn't be "wrong",
>particularly if he's new to the coding that it would take to complete the
>job.
HTML is not an alternative - it's a crap suggestion by somebody who
doesn't know what they're talking about.





--
PETER FOX Not the same since the exam marking business failed
peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>

>>Wrong? ... How?

> Try it yourself and you'll find out.

An HTML table to represent a sheet of Avery Labels (with PHP) could be done
in your sleep ... assuming that you have a "basic" knowledge of HTML and
PHP.

>>> Use PDF

Even with a PDF format you've still got to create some sort of table or
something in columns to match the layout.

>>PDF is an alternative to HTML, I would agree ... and would even concede
>>that
>>it's a better alternative, IF the guy can find (or be given) the
>>appropriate
>>code examples to complete the task, but HTML wouldn't be "wrong",
>>particularly if he's new to the coding that it would take to complete the
>>job.

> HTML is not an alternative - it's a crap suggestion by somebody who
> doesn't know what they're talking about.

There's nothing like being constructive ... and that's nothing like
constructive.

"Sean" <sean.anderson [at] [nospam]oakleafgroup.biz> wrote in message
news:1176812575.894766 [at] kestrel.skynet.co.uk...
| >>Wrong? ... How?
|
| > Try it yourself and you'll find out.
|
| An HTML table to represent a sheet of Avery Labels (with PHP) could be
done
| in your sleep ... assuming that you have a "basic" knowledge of HTML and
| PHP.
|
| >>> Use PDF
|
| Even with a PDF format you've still got to create some sort of table or
| something in columns to match the layout.
|
| >>PDF is an alternative to HTML, I would agree ... and would even concede
| >>that
| >>it's a better alternative, IF the guy can find (or be given) the
| >>appropriate
| >>code examples to complete the task, but HTML wouldn't be "wrong",
| >>particularly if he's new to the coding that it would take to complete
the
| >>job.
|
| > HTML is not an alternative - it's a crap suggestion by somebody who
| > doesn't know what they're talking about.
|
| There's nothing like being constructive ... and that's nothing like
| constructive.

this world is becoming more and more crowded with whining babies! forget the
packaging of the suggestion and take it for what it's worth. PDF is
FORMALIZED, HTML is completely UNDEVELOPED when it comes to PRINTING. you
are 90% certain to have printed what you expect to have printed using
pdf...html is a crap-shoot. grow up and quit being defensive. his suggestion
is SPOT-ON.

and sean...i'm sure the guys at alt.php.sql just fucking L O V E to have
posts thrown their way that have absoFuckingLutely nothing to do with their
context!

On Apr 17, 2:16 pm, "Steve" <no.... [at] example.com> wrote:
> "Sean" <sean.anderson [at] [nospam]oakleafgroup.biz> wrote in message
>
> news:1176812575.894766 [at] kestrel.skynet.co.uk...
> | >>Wrong? ... How?
> |
> | > Try it yourself and you'll find out.
> |
> | An HTML table to represent a sheet of Avery Labels (with PHP) could be
> done
> | in your sleep ... assuming that you have a "basic" knowledge of HTML and
> | PHP.
> |
> | >>> Use PDF
> |
> | Even with a PDF format you've still got to create some sort of table or
> | something in columns to match the layout.
> |
> | >>PDF is an alternative to HTML, I would agree ... and would even concede
> | >>that
> | >>it's a better alternative, IF the guy can find (or be given) the
> | >>appropriate
> | >>code examples to complete the task, but HTML wouldn't be "wrong",
> | >>particularly if he's new to the coding that it would take to complete
> the
> | >>job.
> |
> | > HTML is not an alternative - it's a crap suggestion by somebody who
> | > doesn't know what they're talking about.
> |
> | There's nothing like being constructive ... and that's nothing like
> | constructive.
>
> this world is becoming more and more crowded with whining babies! forget the
> packaging of the suggestion and take it for what it's worth. PDF is
> FORMALIZED, HTML is completely UNDEVELOPED when it comes to PRINTING. you
> are 90% certain to have printed what you expect to have printed using
> pdf...html is a crap-shoot. grow up and quit being defensive. his suggestion
> is SPOT-ON.
>
> and sean...i'm sure the guys at alt.php.sql just fucking L O V E to have
> posts thrown their way that have absoFuckingLutely nothing to do with their
> context!

have a look at FPDF (www.fpdf.org). They have scripts over there for
creating labels, and it's pretty easy to add your own once you figure
it out a bit.

Sean wrote:
>>> Wrong? ... How?
>
>> Try it yourself and you'll find out.
>
> An HTML table to represent a sheet of Avery Labels (with PHP) could be done
> in your sleep ... assuming that you have a "basic" knowledge of HTML and
> PHP.
>
>>>> Use PDF
>
> Even with a PDF format you've still got to create some sort of table or
> something in columns to match the layout.
>
>>> PDF is an alternative to HTML, I would agree ... and would even concede
>>> that
>>> it's a better alternative, IF the guy can find (or be given) the
>>> appropriate
>>> code examples to complete the task, but HTML wouldn't be "wrong",
>>> particularly if he's new to the coding that it would take to complete the
>>> job.
>
>> HTML is not an alternative - it's a crap suggestion by somebody who
>> doesn't know what they're talking about.
>
> There's nothing like being constructive ... and that's nothing like
> constructive.
>
>
>

Sean,

The problem with HTML is it is a fluid layout, and he needs an
absolutely fixed one.

For instance, the user may not be using the default font size - on my
laptop with a high res screen, I use a larger than normal font. On my
desktop with it's 21" screen, I use a smaller than normal font. And my
default printer font is not the same.

Also, the printer size probably isn't exactly 8.5"x11" (assuming U.S.).
Most printers have an unprintable margin - and this margin varies in
size. The browser may attempt to shrink the page to fit in the margins,
or it may let the page overflow to the next one.

Lots of things like this can happen when you're using html. You can try
to force some of them - but html is only a *recommendation* on how to
display the page, not a *requirement*. You can't be sure you've got it
right.

A PDF, OTOH, is an exact layout and you can control the look of
everything to a very fine level. It's a much superior way to go when
you need exact placement like this.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex [at] attglobal.net
==================

Sean kirjoitti:
> "Peter Fox" <peterfox [at] eminent.demon.co.uk.not.this.bit.no.html> wrote in
> message news:gO2Y2LAAFKJGFwvd [at] eminent.demon.co.uk...
>> Following on from Sean's message. . .
>>> Presumably you just need to create a HTML table to match the dimensions of
>>> the labels, that can then be printed...... as you can specify the column
>>> widths and row heights in cm this should be fairly easy to construct.
>> Is the wrong answer.
>>
>> Use PDF
>>
>> --
>> PETER FOX Not the same since the adhesive company came unstuck
>> peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
>> 2 Tees Close, Witham, Essex.
>> Gravity beer in Essex <http://www.eminent.demon.co.uk>
>
> Wrong? ... How?
>
> PDF is an alternative to HTML, I would agree ... and would even concede that
> it's a better alternative, IF the guy can find (or be given) the appropriate
> code examples to complete the task, but HTML wouldn't be "wrong",
> particularly if he's new to the coding that it would take to complete the
> job.

I would agree that pdf in this case would be more suited, since it's
better suited for printing than html. With pdf you can define better the
layout of the print, with html the results aren't as precise. Html is
suitable for publishing material that looks good or at least acceptable
in most media (screen, print, handheld, etc.). When the target medium is
print, then pdf is absolutely the best choice, because it's intended to
be used in printing. Furthermore, pdf is not an alternative to html.
They do have similarities, like they both are ways of presenting a
document, but they are suited for different media.

--
Rami.Elomaa [at] gmail.com

"Wikipedia on vähän niinq internetin raamattu, kukaan ei pohjimmiltaan
usko siihen ja kukaan ei tiedä mikä pitää paikkansa." -- z00ze

Sean wrote:

>> HTML is not an alternative - it's a crap suggestion by somebody who
>> doesn't know what they're talking about.
>
> There's nothing like being constructive ... and that's nothing like
> constructive.

Pdf is a better alternative - it's too bad that some people don't have
the communication skills required to say that without sounding like an
ass. But I guess an ass is bigger than a fox and that's what he values.

Mike

"FredBear" <ThisIsNotMyAddress [at] Yahoo.com> wrote in message
news:13290j3c18spc85 [at] corp.supernews.com...
>I am just coming to grips with php, Dreamweaver and MySQL and I want to
>make a facility available for the members of the group I am creating my web
>site for. I want them to be able to print-out a list of address labels,
>using standard Avery labels, on their home PC's using the data from my
>MySQL tables. I am not yet sufficiently au fait with php to manage to code
>it myself so I wondered if anybody knew of any Dreamweaver extensions,
>add-ins or tutorials which would do the trick. I have had a good look at
>what is on the web but I can't find very much about it.
>
> Any ideas?
> --
>
>
> (\__/)
> (='.'=)
> (")_(")
>

Presumably you just need to create a HTML table to match the dimensions of
the labels, that can then be printed...... as you can specify the column
widths and row heights in cm this should be fairly easy to construct.

Adding code in PHP to create this on the fly from a database would also be
fairly easy, as you are only looping through a recordset to insert the data
into the cells of the table.

Following on from Sean's message. . .
>
>Presumably you just need to create a HTML table to match the dimensions of
>the labels, that can then be printed...... as you can specify the column
>widths and row heights in cm this should be fairly easy to construct.
Is the wrong answer.

Use PDF

--
PETER FOX Not the same since the adhesive company came unstuck
peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>

"Peter Fox" <peterfox [at] eminent.demon.co.uk.not.this.bit.no.html> wrote in
message news:gO2Y2LAAFKJGFwvd [at] eminent.demon.co.uk...
> Following on from Sean's message. . .
>>
>>Presumably you just need to create a HTML table to match the dimensions of
>>the labels, that can then be printed...... as you can specify the column
>>widths and row heights in cm this should be fairly easy to construct.
> Is the wrong answer.
>
> Use PDF
>
> --
> PETER FOX Not the same since the adhesive company came unstuck
> peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
> 2 Tees Close, Witham, Essex.
> Gravity beer in Essex <http://www.eminent.demon.co.uk>

Wrong? ... How?

PDF is an alternative to HTML, I would agree ... and would even concede that
it's a better alternative, IF the guy can find (or be given) the appropriate
code examples to complete the task, but HTML wouldn't be "wrong",
particularly if he's new to the coding that it would take to complete the
job.

Following on from Sean's message. . .
>
>"Peter Fox" <peterfox [at] eminent.demon.co.uk.not.this.bit.no.html> wrote in
>message news:gO2Y2LAAFKJGFwvd [at] eminent.demon.co.uk...
>> Following on from Sean's message. . .
>>>
>>>Presumably you just need to create a HTML table to match the dimensions of
>>>the labels, that can then be printed...... as you can specify the column
>>>widths and row heights in cm this should be fairly easy to construct.
>> Is the wrong answer.
>>
>> Use PDF
>>
>> --
>> PETER FOX Not the same since the adhesive company came unstuck
>> peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
>> 2 Tees Close, Witham, Essex.
>> Gravity beer in Essex <http://www.eminent.demon.co.uk>
>
>Wrong? ... How?
Try it yourself and you'll find out.
>
>PDF is an alternative to HTML, I would agree ... and would even concede that
>it's a better alternative, IF the guy can find (or be given) the appropriate
>code examples to complete the task, but HTML wouldn't be "wrong",
>particularly if he's new to the coding that it would take to complete the
>job.
HTML is not an alternative - it's a crap suggestion by somebody who
doesn't know what they're talking about.





--
PETER FOX Not the same since the exam marking business failed
peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>

>>Wrong? ... How?

> Try it yourself and you'll find out.

An HTML table to represent a sheet of Avery Labels (with PHP) could be done
in your sleep ... assuming that you have a "basic" knowledge of HTML and
PHP.

>>> Use PDF

Even with a PDF format you've still got to create some sort of table or
something in columns to match the layout.

>>PDF is an alternative to HTML, I would agree ... and would even concede
>>that
>>it's a better alternative, IF the guy can find (or be given) the
>>appropriate
>>code examples to complete the task, but HTML wouldn't be "wrong",
>>particularly if he's new to the coding that it would take to complete the
>>job.

> HTML is not an alternative - it's a crap suggestion by somebody who
> doesn't know what they're talking about.

There's nothing like being constructive ... and that's nothing like
constructive.

"Sean" <sean.anderson [at] [nospam]oakleafgroup.biz> wrote in message
news:1176812575.894766 [at] kestrel.skynet.co.uk...
| >>Wrong? ... How?
|
| > Try it yourself and you'll find out.
|
| An HTML table to represent a sheet of Avery Labels (with PHP) could be
done
| in your sleep ... assuming that you have a "basic" knowledge of HTML and
| PHP.
|
| >>> Use PDF
|
| Even with a PDF format you've still got to create some sort of table or
| something in columns to match the layout.
|
| >>PDF is an alternative to HTML, I would agree ... and would even concede
| >>that
| >>it's a better alternative, IF the guy can find (or be given) the
| >>appropriate
| >>code examples to complete the task, but HTML wouldn't be "wrong",
| >>particularly if he's new to the coding that it would take to complete
the
| >>job.
|
| > HTML is not an alternative - it's a crap suggestion by somebody who
| > doesn't know what they're talking about.
|
| There's nothing like being constructive ... and that's nothing like
| constructive.

this world is becoming more and more crowded with whining babies! forget the
packaging of the suggestion and take it for what it's worth. PDF is
FORMALIZED, HTML is completely UNDEVELOPED when it comes to PRINTING. you
are 90% certain to have printed what you expect to have printed using
pdf...html is a crap-shoot. grow up and quit being defensive. his suggestion
is SPOT-ON.

and sean...i'm sure the guys at alt.php.sql just fucking L O V E to have
posts thrown their way that have absoFuckingLutely nothing to do with their
context!

On Apr 17, 2:16 pm, "Steve" <no.... [at] example.com> wrote:
> "Sean" <sean.anderson [at] [nospam]oakleafgroup.biz> wrote in message
>
> news:1176812575.894766 [at] kestrel.skynet.co.uk...
> | >>Wrong? ... How?
> |
> | > Try it yourself and you'll find out.
> |
> | An HTML table to represent a sheet of Avery Labels (with PHP) could be
> done
> | in your sleep ... assuming that you have a "basic" knowledge of HTML and
> | PHP.
> |
> | >>> Use PDF
> |
> | Even with a PDF format you've still got to create some sort of table or
> | something in columns to match the layout.
> |
> | >>PDF is an alternative to HTML, I would agree ... and would even concede
> | >>that
> | >>it's a better alternative, IF the guy can find (or be given) the
> | >>appropriate
> | >>code examples to complete the task, but HTML wouldn't be "wrong",
> | >>particularly if he's new to the coding that it would take to complete
> the
> | >>job.
> |
> | > HTML is not an alternative - it's a crap suggestion by somebody who
> | > doesn't know what they're talking about.
> |
> | There's nothing like being constructive ... and that's nothing like
> | constructive.
>
> this world is becoming more and more crowded with whining babies! forget the
> packaging of the suggestion and take it for what it's worth. PDF is
> FORMALIZED, HTML is completely UNDEVELOPED when it comes to PRINTING. you
> are 90% certain to have printed what you expect to have printed using
> pdf...html is a crap-shoot. grow up and quit being defensive. his suggestion
> is SPOT-ON.
>
> and sean...i'm sure the guys at alt.php.sql just fucking L O V E to have
> posts thrown their way that have absoFuckingLutely nothing to do with their
> context!

have a look at FPDF (www.fpdf.org). They have scripts over there for
creating labels, and it's pretty easy to add your own once you figure
it out a bit.

Sean wrote:
>>> Wrong? ... How?
>
>> Try it yourself and you'll find out.
>
> An HTML table to represent a sheet of Avery Labels (with PHP) could be done
> in your sleep ... assuming that you have a "basic" knowledge of HTML and
> PHP.
>
>>>> Use PDF
>
> Even with a PDF format you've still got to create some sort of table or
> something in columns to match the layout.
>
>>> PDF is an alternative to HTML, I would agree ... and would even concede
>>> that
>>> it's a better alternative, IF the guy can find (or be given) the
>>> appropriate
>>> code examples to complete the task, but HTML wouldn't be "wrong",
>>> particularly if he's new to the coding that it would take to complete the
>>> job.
>
>> HTML is not an alternative - it's a crap suggestion by somebody who
>> doesn't know what they're talking about.
>
> There's nothing like being constructive ... and that's nothing like
> constructive.
>
>
>

Sean,

The problem with HTML is it is a fluid layout, and he needs an
absolutely fixed one.

For instance, the user may not be using the default font size - on my
laptop with a high res screen, I use a larger than normal font. On my
desktop with it's 21" screen, I use a smaller than normal font. And my
default printer font is not the same.

Also, the printer size probably isn't exactly 8.5"x11" (assuming U.S.).
Most printers have an unprintable margin - and this margin varies in
size. The browser may attempt to shrink the page to fit in the margins,
or it may let the page overflow to the next one.

Lots of things like this can happen when you're using html. You can try
to force some of them - but html is only a *recommendation* on how to
display the page, not a *requirement*. You can't be sure you've got it
right.

A PDF, OTOH, is an exact layout and you can control the look of
everything to a very fine level. It's a much superior way to go when
you need exact placement like this.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex [at] attglobal.net
==================

Sean kirjoitti:
> "Peter Fox" <peterfox [at] eminent.demon.co.uk.not.this.bit.no.html> wrote in
> message news:gO2Y2LAAFKJGFwvd [at] eminent.demon.co.uk...
>> Following on from Sean's message. . .
>>> Presumably you just need to create a HTML table to match the dimensions of
>>> the labels, that can then be printed...... as you can specify the column
>>> widths and row heights in cm this should be fairly easy to construct.
>> Is the wrong answer.
>>
>> Use PDF
>>
>> --
>> PETER FOX Not the same since the adhesive company came unstuck
>> peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
>> 2 Tees Close, Witham, Essex.
>> Gravity beer in Essex <http://www.eminent.demon.co.uk>
>
> Wrong? ... How?
>
> PDF is an alternative to HTML, I would agree ... and would even concede that
> it's a better alternative, IF the guy can find (or be given) the appropriate
> code examples to complete the task, but HTML wouldn't be "wrong",
> particularly if he's new to the coding that it would take to complete the
> job.

I would agree that pdf in this case would be more suited, since it's
better suited for printing than html. With pdf you can define better the
layout of the print, with html the results aren't as precise. Html is
suitable for publishing material that looks good or at least acceptable
in most media (screen, print, handheld, etc.). When the target medium is
print, then pdf is absolutely the best choice, because it's intended to
be used in printing. Furthermore, pdf is not an alternative to html.
They do have similarities, like they both are ways of presenting a
document, but they are suited for different media.

--
Rami.Elomaa [at] gmail.com

"Wikipedia on vähän niinq internetin raamattu, kukaan ei pohjimmiltaan
usko siihen ja kukaan ei tiedä mikä pitää paikkansa." -- z00ze

Sean wrote:

>> HTML is not an alternative - it's a crap suggestion by somebody who
>> doesn't know what they're talking about.
>
> There's nothing like being constructive ... and that's nothing like
> constructive.

Pdf is a better alternative - it's too bad that some people don't have
the communication skills required to say that without sounding like an
ass. But I guess an ass is bigger than a fox and that's what he values.

Mike

"FredBear" <ThisIsNotMyAddress [at] Yahoo.com> wrote in message
news:13290j3c18spc85 [at] corp.supernews.com...
>I am just coming to grips with php, Dreamweaver and MySQL and I want to
>make a facility available for the members of the group I am creating my web
>site for. I want them to be able to print-out a list of address labels,
>using standard Avery labels, on their home PC's using the data from my
>MySQL tables. I am not yet sufficiently au fait with php to manage to code
>it myself so I wondered if anybody knew of any Dreamweaver extensions,
>add-ins or tutorials which would do the trick. I have had a good look at
>what is on the web but I can't find very much about it.
>
> Any ideas?
> --
>
>
> (\__/)
> (='.'=)
> (")_(")
>

Presumably you just need to create a HTML table to match the dimensions of
the labels, that can then be printed...... as you can specify the column
widths and row heights in cm this should be fairly easy to construct.

Adding code in PHP to create this on the fly from a database would also be
fairly easy, as you are only looping through a recordset to insert the data
into the cells of the table.

Following on from Sean's message. . .
>
>Presumably you just need to create a HTML table to match the dimensions of
>the labels, that can then be printed...... as you can specify the column
>widths and row heights in cm this should be fairly easy to construct.
Is the wrong answer.

Use PDF

--
PETER FOX Not the same since the adhesive company came unstuck
peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>

"Peter Fox" <peterfox [at] eminent.demon.co.uk.not.this.bit.no.html> wrote in
message news:gO2Y2LAAFKJGFwvd [at] eminent.demon.co.uk...
> Following on from Sean's message. . .
>>
>>Presumably you just need to create a HTML table to match the dimensions of
>>the labels, that can then be printed...... as you can specify the column
>>widths and row heights in cm this should be fairly easy to construct.
> Is the wrong answer.
>
> Use PDF
>
> --
> PETER FOX Not the same since the adhesive company came unstuck
> peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
> 2 Tees Close, Witham, Essex.
> Gravity beer in Essex <http://www.eminent.demon.co.uk>

Wrong? ... How?

PDF is an alternative to HTML, I would agree ... and would even concede that
it's a better alternative, IF the guy can find (or be given) the appropriate
code examples to complete the task, but HTML wouldn't be "wrong",
particularly if he's new to the coding that it would take to complete the
job.

Following on from Sean's message. . .
>
>"Peter Fox" <peterfox [at] eminent.demon.co.uk.not.this.bit.no.html> wrote in
>message news:gO2Y2LAAFKJGFwvd [at] eminent.demon.co.uk...
>> Following on from Sean's message. . .
>>>
>>>Presumably you just need to create a HTML table to match the dimensions of
>>>the labels, that can then be printed...... as you can specify the column
>>>widths and row heights in cm this should be fairly easy to construct.
>> Is the wrong answer.
>>
>> Use PDF
>>
>> --
>> PETER FOX Not the same since the adhesive company came unstuck
>> peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
>> 2 Tees Close, Witham, Essex.
>> Gravity beer in Essex <http://www.eminent.demon.co.uk>
>
>Wrong? ... How?
Try it yourself and you'll find out.
>
>PDF is an alternative to HTML, I would agree ... and would even concede that
>it's a better alternative, IF the guy can find (or be given) the appropriate
>code examples to complete the task, but HTML wouldn't be "wrong",
>particularly if he's new to the coding that it would take to complete the
>job.
HTML is not an alternative - it's a crap suggestion by somebody who
doesn't know what they're talking about.





--
PETER FOX Not the same since the exam marking business failed
peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>

>>Wrong? ... How?

> Try it yourself and you'll find out.

An HTML table to represent a sheet of Avery Labels (with PHP) could be done
in your sleep ... assuming that you have a "basic" knowledge of HTML and
PHP.

>>> Use PDF

Even with a PDF format you've still got to create some sort of table or
something in columns to match the layout.

>>PDF is an alternative to HTML, I would agree ... and would even concede
>>that
>>it's a better alternative, IF the guy can find (or be given) the
>>appropriate
>>code examples to complete the task, but HTML wouldn't be "wrong",
>>particularly if he's new to the coding that it would take to complete the
>>job.

> HTML is not an alternative - it's a crap suggestion by somebody who
> doesn't know what they're talking about.

There's nothing like being constructive ... and that's nothing like
constructive.

"Sean" <sean.anderson [at] [nospam]oakleafgroup.biz> wrote in message
news:1176812575.894766 [at] kestrel.skynet.co.uk...
| >>Wrong? ... How?
|
| > Try it yourself and you'll find out.
|
| An HTML table to represent a sheet of Avery Labels (with PHP) could be
done
| in your sleep ... assuming that you have a "basic" knowledge of HTML and
| PHP.
|
| >>> Use PDF
|
| Even with a PDF format you've still got to create some sort of table or
| something in columns to match the layout.
|
| >>PDF is an alternative to HTML, I would agree ... and would even concede
| >>that
| >>it's a better alternative, IF the guy can find (or be given) the
| >>appropriate
| >>code examples to complete the task, but HTML wouldn't be "wrong",
| >>particularly if he's new to the coding that it would take to complete
the
| >>job.
|
| > HTML is not an alternative - it's a crap suggestion by somebody who
| > doesn't know what they're talking about.
|
| There's nothing like being constructive ... and that's nothing like
| constructive.

this world is becoming more and more crowded with whining babies! forget the
packaging of the suggestion and take it for what it's worth. PDF is
FORMALIZED, HTML is completely UNDEVELOPED when it comes to PRINTING. you
are 90% certain to have printed what you expect to have printed using
pdf...html is a crap-shoot. grow up and quit being defensive. his suggestion
is SPOT-ON.

and sean...i'm sure the guys at alt.php.sql just fucking L O V E to have
posts thrown their way that have absoFuckingLutely nothing to do with their
context!

On Apr 17, 2:16 pm, "Steve" <no.... [at] example.com> wrote:
> "Sean" <sean.anderson [at] [nospam]oakleafgroup.biz> wrote in message
>
> news:1176812575.894766 [at] kestrel.skynet.co.uk...
> | >>Wrong? ... How?
> |
> | > Try it yourself and you'll find out.
> |
> | An HTML table to represent a sheet of Avery Labels (with PHP) could be
> done
> | in your sleep ... assuming that you have a "basic" knowledge of HTML and
> | PHP.
> |
> | >>> Use PDF
> |
> | Even with a PDF format you've still got to create some sort of table or
> | something in columns to match the layout.
> |
> | >>PDF is an alternative to HTML, I would agree ... and would even concede
> | >>that
> | >>it's a better alternative, IF the guy can find (or be given) the
> | >>appropriate
> | >>code examples to complete the task, but HTML wouldn't be "wrong",
> | >>particularly if he's new to the coding that it would take to complete
> the
> | >>job.
> |
> | > HTML is not an alternative - it's a crap suggestion by somebody who
> | > doesn't know what they're talking about.
> |
> | There's nothing like being constructive ... and that's nothing like
> | constructive.
>
> this world is becoming more and more crowded with whining babies! forget the
> packaging of the suggestion and take it for what it's worth. PDF is
> FORMALIZED, HTML is completely UNDEVELOPED when it comes to PRINTING. you
> are 90% certain to have printed what you expect to have printed using
> pdf...html is a crap-shoot. grow up and quit being defensive. his suggestion
> is SPOT-ON.
>
> and sean...i'm sure the guys at alt.php.sql just fucking L O V E to have
> posts thrown their way that have absoFuckingLutely nothing to do with their
> context!

have a look at FPDF (www.fpdf.org). They have scripts over there for
creating labels, and it's pretty easy to add your own once you figure
it out a bit.

Sean wrote:
>>> Wrong? ... How?
>
>> Try it yourself and you'll find out.
>
> An HTML table to represent a sheet of Avery Labels (with PHP) could be done
> in your sleep ... assuming that you have a "basic" knowledge of HTML and
> PHP.
>
>>>> Use PDF
>
> Even with a PDF format you've still got to create some sort of table or
> something in columns to match the layout.
>
>>> PDF is an alternative to HTML, I would agree ... and would even concede
>>> that
>>> it's a better alternative, IF the guy can find (or be given) the
>>> appropriate
>>> code examples to complete the task, but HTML wouldn't be "wrong",
>>> particularly if he's new to the coding that it would take to complete the
>>> job.
>
>> HTML is not an alternative - it's a crap suggestion by somebody who
>> doesn't know what they're talking about.
>
> There's nothing like being constructive ... and that's nothing like
> constructive.
>
>
>

Sean,

The problem with HTML is it is a fluid layout, and he needs an
absolutely fixed one.

For instance, the user may not be using the default font size - on my
laptop with a high res screen, I use a larger than normal font. On my
desktop with it's 21" screen, I use a smaller than normal font. And my
default printer font is not the same.

Also, the printer size probably isn't exactly 8.5"x11" (assuming U.S.).
Most printers have an unprintable margin - and this margin varies in
size. The browser may attempt to shrink the page to fit in the margins,
or it may let the page overflow to the next one.

Lots of things like this can happen when you're using html. You can try
to force some of them - but html is only a *recommendation* on how to
display the page, not a *requirement*. You can't be sure you've got it
right.

A PDF, OTOH, is an exact layout and you can control the look of
everything to a very fine level. It's a much superior way to go when
you need exact placement like this.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex [at] attglobal.net
==================

Sean kirjoitti:
> "Peter Fox" <peterfox [at] eminent.demon.co.uk.not.this.bit.no.html> wrote in
> message news:gO2Y2LAAFKJGFwvd [at] eminent.demon.co.uk...
>> Following on from Sean's message. . .
>>> Presumably you just need to create a HTML table to match the dimensions of
>>> the labels, that can then be printed...... as you can specify the column
>>> widths and row heights in cm this should be fairly easy to construct.
>> Is the wrong answer.
>>
>> Use PDF
>>
>> --
>> PETER FOX Not the same since the adhesive company came unstuck
>> peterfox [at] eminent.demon.co.uk.not.this.bit.no.html
>> 2 Tees Close, Witham, Essex.
>> Gravity beer in Essex <http://www.eminent.demon.co.uk>
>
> Wrong? ... How?
>
> PDF is an alternative to HTML, I would agree ... and would even concede that
> it's a better alternative, IF the guy can find (or be given) the appropriate
> code examples to complete the task, but HTML wouldn't be "wrong",
> particularly if he's new to the coding that it would take to complete the
> job.

I would agree that pdf in this case would be more suited, since it's
better suited for printing than html. With pdf you can define better the
layout of the print, with html the results aren't as precise. Html is
suitable for publishing material that looks good or at least acceptable
in most media (screen, print, handheld, etc.). When the target medium is
print, then pdf is absolutely the best choice, because it's intended to
be used in printing. Furthermore, pdf is not an alternative to html.
They do have similarities, like they both are ways of presenting a
document, but they are suited for different media.

--
Rami.Elomaa [at] gmail.com

"Wikipedia on vähän niinq internetin raamattu, kukaan ei pohjimmiltaan
usko siihen ja kukaan ei tiedä mikä pitää paikkansa." -- z00ze

Sean wrote:

>> HTML is not an alternative - it's a crap suggestion by somebody who
>> doesn't know what they're talking about.
>
> There's nothing like being constructive ... and that's nothing like
> constructive.

Pdf is a better alternative - it's too bad that some people don't have
the communication skills required to say that without sounding like an
ass. But I guess an ass is bigger than a fox and that's what he values.

Mike

| Pdf is a better alternative - it's too bad that some people don't have
| the communication skills required to say that without sounding like an
| ass.

or he spoke his mind - 'ass' being relative to one's own sensitivity...which
i've already stated, more and more skins are thinning every day. buck up! i
believe he said almost word for word, 'pdf is a better alternative'...if no
one else got that because they got their feelings hurt, cry to momma.

jesus christ!

and quit it with the fucking cross posting...do you really think that
alt.php.sql could give a rat's ass about a presentation layer question?!!!

Steve wrote:
> | Pdf is a better alternative - it's too bad that some people don't have
> | the communication skills required to say that without sounding like an
> | ass.
>
> believe he said almost word for word, 'pdf is a better alternative'

What he wrote _exactly_ (you can check it yourself) was

> > it's a crap suggestion by somebody who doesn't know what
> > they're talking about.

If you think that's effective communication, then you're no doubt the
same kind of ass.


> and quit it with the fucking cross posting...do you really think that
> alt.php.sql could give a rat's ass about a presentation layer question?!!!

cry to momma.

Cheers,
Mike

Thanks for all the input, People, but I am now running out of the will to
live reading through it all so I have devised a new strategy.

I am going to do a mail merge in MS Word and upload it to my web site each
time I add a new name to the database.

The users can then print their Avery address labels straight from the Word
Document. Not an entirely elegant solution but one which will work.


(\__/)
(='.'=)
(")_(")

"FredBear" <ThisIsNotMyAddress [at] Yahoo.com> wrote in message
news:132bv2dffo07325 [at] corp.supernews.com...
| Thanks for all the input, People, but I am now running out of the will to
| live reading through it all so I have devised a new strategy.
|
| I am going to do a mail merge in MS Word and upload it to my web site each
| time I add a new name to the database.
|
| The users can then print their Avery address labels straight from the Word
| Document. Not an entirely elegant solution but one which will work.

if you're server is windows and you have office installed, just use COM()
and create a word object. perform whatever operations need to take place.
then, set the headers appropriately for the browser and echo word's results.
you don't need to break out of php to do any of that.

cheers.

On Apr 18, 12:09 pm, "FredBear" <ThisIsNotMyAddr... [at] Yahoo.com> wrote:
> Thanks for all the input, People, but I am now running out of the will to
> live reading through it all so I have devised a new strategy.
>
> I am going to do a mail merge in MS Word and upload it to my web site each
> time I add a new name to the database.
>
> The users can then print their Avery address labels straight from the Word
> Document. Not an entirely elegant solution but one which will work.
>
> (\__/)
> (='.'=)
> (")_(")

Funny you should mention mail merge.
You can in fact mail merge into Word with a direct connection to a
MySQL database on the web. The MySQL database just replaces the Excel
Sheet or Access DB. I'll try to root out an example of this as I have
successfully managed this in the past.

Message-ID: <1176902089.699511.10970 [at] y80g2000hsf.googlegroups.com> from
Captain Paralytic contained the following:

>Funny you should mention mail merge.
>You can in fact mail merge into Word with a direct connection to a
>MySQL database on the web. The MySQL database just replaces the Excel
>Sheet or Access DB. I'll try to root out an example of this as I have
>successfully managed this in the past.

I could use that...

--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011

On Apr 18, 2:37 pm, Geoff Berrow <blthe... [at] ckdog.co.uk> wrote:
> Message-ID: <1176902089.699511.10970 [at] y80g2000hsf.googlegroups.com> from
> Captain Paralytic contained the following:
>
> >Funny you should mention mail merge.
> >You can in fact mail merge into Word with a direct connection to a
> >MySQL database on the web. The MySQL database just replaces the Excel
> >Sheet or Access DB. I'll try to root out an example of this as I have
> >successfully managed this in the past.
>
> I could use that...
>
> --
> Geoff Berrow 0110001001101100010000000110
> 001101101011011001000110111101100111001011
> 100110001101101111001011100111010101101011

I'll have a poke around this evening and if I can find it I'll pop it
up on the web somewhere.

Geof,

Have a look at:
http://torque.oncloud8.com/archives/000160.html

I just tried it out and it works fine.



"Geoff Berrow" <blthecat [at] ckdog.co.uk> wrote in message
news:sn7c23t4utttg0dtmv9pkbfrahg7s8j2up [at] 4ax.com...
> Message-ID: <1176902089.699511.10970 [at] y80g2000hsf.googlegroups.com> from
> Captain Paralytic contained the following:
>
>>Funny you should mention mail merge.
>>You can in fact mail merge into Word with a direct connection to a
>>MySQL database on the web. The MySQL database just replaces the Excel
>>Sheet or Access DB. I'll try to root out an example of this as I have
>>successfully managed this in the past.
>
> I could use that...
>
> --
> Geoff Berrow 0110001001101100010000000110
> 001101101011011001000110111101100111001011
> 100110001101101111001011100111010101101011

Thanks for all the input, People, but I am now running out of the will to
live reading through it all so I have devised a new strategy.

I am going to do a mail merge in MS Word and upload it to my web site each
time I add a new name to the database.

The users can then print their Avery address labels straight from the Word
Document. Not an entirely elegant solution but one which will work.


(\__/)
(='.'=)
(")_(")