OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
php-general Digest 24 Apr 2006 15:19:48 -0000 Issue 4090

php-general-digest-helplists.php.net
Date: Mon Apr 24 2006 - 10:19:48 CDT


php-general Digest 24 Apr 2006 15:19:48 -0000 Issue 4090

Topics (messages 234603 through 234623):

Re: How to find <img> tag and get src of image
        234603 by: Paul Novitski
        234610 by: T.Lensselink
        234615 by: Paul Scott
        234619 by: Philip Thompson

Re: shopping carts
        234604 by: Richard Lynch
        234607 by: Robert Cummings
        234613 by: Jochem Maas
        234620 by: Tom Cruickshank

PHP Variables sizes
        234605 by: David Killen
        234606 by: chris smith

Need help with an if statement
        234608 by: Pub
        234609 by: admin.ensifex.nl
        234611 by: Anthony Ettinger

Re: strange php url
        234612 by: nicolas figaro
        234618 by: Ahmed Saad

Re: CMS for Auto Parts
        234614 by: Johan Martin

Jay-> RE: [PHP] How to find <img> tag and get src of image
        234616 by: Ryan A

Re: Jay-> RE: [PHP] How to find <img> tag and get src of image OT
        234617 by: Jay Blanchard
        234623 by: Ryan A

Re: sorting troubles
        234621 by: Philip Thompson
        234622 by: Philip Thompson

Administrivia:

To subscribe to the digest, e-mail:
        php-general-digest-subscribelists.php.net

To unsubscribe from the digest, e-mail:
        php-general-digest-unsubscribelists.php.net

To post to the list, e-mail:
        php-generallists.php.net

----------------------------------------------------------------------

attached mail follows:


At 05:30 PM 4/23/2006, Pham Huu Le Quoc Phuc wrote:
>I want to get src of image form a $text, I have a below text
>
>$Text = <table border="1" cellpadding="3%" cellspacing="3%" width="100%">
> <tr> <td width="20%">
> <img align="middle" border="0" id=userupload/78/Autumn.jpg
>src=userupload/78/Autumn.jpg onClick="javascript:ViewImage(this.id);"
>width="100" height="100" >
> </td>
> <td></td></tr> </table>
> </td>
> <td class="frame2_middle_right"></td>
> </tr>
> <tr>
> <td class="frame2_bottom_left"></td>
> <td class="frame2_bottom_center">
> </td>

Pham,

Before you do anything else, fix your HTML syntax which is full of
errors. Your </table> tag appears in the middle of the table and
your id syntax is invalid:

         id=userupload/78/Autumn.jpg

The specification for id [1] says it's an element of type 'name' [2]:

<quote>
ID and NAME tokens must begin with a letter ([A-Za-z]) and may be
followed by any number of letters, digits ([0-9]), hyphens ("-"),
underscores ("_"), colons (":"), and periods (".").
</quote>

In other words, you can't have slashes in your id.

Put your HTML through the W3C markup validator before trying to write
script that parses it:
http://validator.w3.org/

When you're ready, you can locate an image src using a Regular
Expression such as this:

         /<img\s+[^>]*src=\"([^"])*[^>]*>\"/

which means:

         <img\s+ = <img followed by one or more whitespace characters

         [^>]* = zero or more characters not including a close-bracket

         src=\" = src="

         ([^"])* = zero or more characters not including a close-quote
         (THIS IS YOUR SRC VALUE)

         \" = close-quote

         [^>]* = any number of characters excluding close-bracket

> = close-bracket

The src attribute value will be captured by $aMatches[1] by the logic:

         $sRegExp = <<< hdRE
         /<img\s+[^>]*src=\"([^"])*[^>]*>\"/
         hdRE;

         preg_match($sRegExp, $sText, $aMatches);

This RegExp is designed to confine its result to a single HTML IMG tag.

Documentation on PHP regular expression processing begins here:
http://php.net/pcre

Regards,
Paul

[1] specification for 'id':
http://www.w3.org/TR/html4/struct/global.html#adef-id

[2] element type 'name': http://www.w3.org/TR/html4/types.html#type-name

attached mail follows:


Use preg_match_all

Think this will work. But i'm for sure no regular expresion guru :)

preg_match_all("/src=(.*)\040/i", $Text, $Result);
print_r($Result);

Gr,
Thijs

> Hi everybody!
> I want to get src of image form a $text, I have a below text
>
> $Text = <table border="1" cellpadding="3%" cellspacing="3%" width="100%">
> <tr> <td width="20%">
> <img align="middle" border="0" id=userupload/78/Autumn.jpg
> src=userupload/78/Autumn.jpg onClick="javascript:ViewImage(this.id);"
> width="100" height="100" >
> </td>
> <td></td></tr> </table>
> </td>
> <td class="frame2_middle_right"></td>
> </tr>
> <tr>
> <td class="frame2_bottom_left"></td>
> <td class="frame2_bottom_center">
> </td>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

attached mail follows:


On Mon, 2006-04-24 at 07:30 +0700, Pham Huu Le Quoc Phuc wrote:
> Hi everybody!
> I want to get src of image form a $text, I have a below text
>

Regex - there is one for exactly that on http://fsiu.uwc.ac.za check out
the wiki page of regular expressions.

--Paul

attached mail follows:


On Apr 23, 2006, at 10:10 PM, Paul Novitski wrote:

> At 05:30 PM 4/23/2006, Pham Huu Le Quoc Phuc wrote:
>> I want to get src of image form a $text, I have a below text
>>
>> $Text = <table border="1" cellpadding="3%" cellspacing="3%"
>> width="100%">
>> <tr> <td width="20%">
>> <img align="middle" border="0" id=userupload/78/Autumn.jpg
>> src=userupload/78/Autumn.jpg onClick="javascript:ViewImage(this.id);"
>> width="100" height="100" >
>> </td>
>> <td></td></tr> </table>
>> </td>
>> <td class="frame2_middle_right"></td>
>> </tr>
>> <tr>
>> <td class="frame2_bottom_left"></td>
>> <td class="frame2_bottom_center">
>> </td>
>
>
> Pham,
>
> Before you do anything else, fix your HTML syntax which is full of
> errors. Your </table> tag appears in the middle of the table and
> your id syntax is invalid:
>
> id=userupload/78/Autumn.jpg
>
> The specification for id [1] says it's an element of type 'name' [2]:
>
> <quote>
> ID and NAME tokens must begin with a letter ([A-Za-z]) and may be
> followed by any number of letters, digits ([0-9]), hyphens ("-"),
> underscores ("_"), colons (":"), and periods (".").
> </quote>
>
> In other words, you can't have slashes in your id.
>
> Put your HTML through the W3C markup validator before trying to
> write script that parses it:
> http://validator.w3.org/
>
>
> When you're ready, you can locate an image src using a Regular
> Expression such as this:
>
> /<img\s+[^>]*src=\"([^"])*[^>]*>\"/
>
> which means:
>
> <img\s+ = <img followed by one or more whitespace characters
>
> [^>]* = zero or more characters not including a close-bracket
>
> src=\" = src="
>
> ([^"])* = zero or more characters not including a close-quote
> (THIS IS YOUR SRC VALUE)
>
> \" = close-quote
>
> [^>]* = any number of characters excluding close-bracket
>
> > = close-bracket
>
> The src attribute value will be captured by $aMatches[1] by the logic:
>
> $sRegExp = <<< hdRE
> /<img\s+[^>]*src=\"([^"])*[^>]*>\"/
> hdRE;
>
> preg_match($sRegExp, $sText, $aMatches);
>
> This RegExp is designed to confine its result to a single HTML IMG
> tag.
>
> Documentation on PHP regular expression processing begins here:
> http://php.net/pcre
>
> Regards,
> Paul
>
> [1] specification for 'id': http://www.w3.org/TR/html4/struct/
> global.html#adef-id
>
> [2] element type 'name': http://www.w3.org/TR/html4/types.html#type-
> name

Paul,

I think you are too kind. I think my response would have been likes
Jay's... RTFM. However, you went above and beyond. Isn't this
listserv great!! =D

~Phil

attached mail follows:


On Sun, April 23, 2006 9:01 am, tedd wrote:
> This apparently is a common theme -- "I want a good basic shopping
> cart that works AND I don't want to pay over $100 for it."
>
> Well... I want a good basic car and not pay over $100 for it too.
> But, everyone knows that those two wants are mutually exclusives. My
> question is, why aren't shopping carts viewed in the same common
> sense perspective?
>
> What's the reason?

Much good stuff deleted.

I think one of the reasons goes like this:

The Internet is such a huge marketplace.

Shopping carts are so ubiquitous (sp?)

Based on sheer volume, there oughta be a fifty dolla basic shopping
cart that is easy to install and doesn't try to do everything for
everybody.

The problem is, that inevitably, each user needs "just that one feature"

Maybe it's shipping costs.

Maybe it's T-Shirt sizes that may or may not cost more.

Maybe it's quantity discounts.

Maybe it's Taxes. :-^

Maybe it's...

And, next thing you know, you've got this nasty MONSTER on your hands
of a shopping cart that nobody without a Ph.D. can figure out how to
work the damn thing.

Another aspect is this:
Why do we call it a shopping cart?

Look, a shopping cart is a goddam big basket on wheels.

What we call a "shopping cart" on-line is actually, your entire stock
catalog, fulfillment, cash register, check-out, delivery, stock
management, and internal accounting system, with credit card POS
widgets. And baggers.

Hey. That ain't a "shopping cart" That's a friggin' store.

[shrug]

--
Like Music?
http://l-i-e.com/artists.htm

attached mail follows:


On Sun, 2006-04-23 at 23:20, Richard Lynch wrote:
>
> Another aspect is this:
> Why do we call it a shopping cart?
>
> Look, a shopping cart is a goddam big basket on wheels.
>
> What we call a "shopping cart" on-line is actually, your entire stock
> catalog, fulfillment, cash register, check-out, delivery, stock
> management, and internal accounting system, with credit card POS
> widgets. And baggers.
>
> Hey. That ain't a "shopping cart" That's a friggin' store.
>
> [shrug]

*lol* Thanks for the Sunday night comedy :)

Cheers,
Rob.
--
.------------------------------------------------------------.
| InterJinn Application Framework - http://www.interjinn.com |
:------------------------------------------------------------:
| An application and templating framework for PHP. Boasting |
| a powerful, scalable system for accessing system services |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for |
| creating re-usable components quickly and easily. |
`------------------------------------------------------------'

attached mail follows:


cheers Richard! you brightened up my monday morning.
the badger reference will keep me going till wednesday ;-)

Richard Lynch wrote:
> On Sun, April 23, 2006 9:01 am, tedd wrote:
>

...

>
>
> Another aspect is this:
> Why do we call it a shopping cart?
>
> Look, a shopping cart is a goddam big basket on wheels.
>
> What we call a "shopping cart" on-line is actually, your entire stock
> catalog, fulfillment, cash register, check-out, delivery, stock
> management, and internal accounting system, with credit card POS
> widgets. And baggers.
>
> Hey. That ain't a "shopping cart" That's a friggin' store.
>
> [shrug]
>

attached mail follows:


Have you checked out oscommerce? www.oscommerce.com?

It does what I think you need. And I think it might even be free, that is,
if your time
doesn't cost anything. As for it being simple....you'll need to define that
term.

Simple for me could be rather complicated for you or vice versa.

Tom

On 4/22/06, Lisa A <lisawebscapesdesigns.com> wrote:
>
> Can anyone suggest someone to write a simple client side shopping cart I
> can
> use? I need to install something that my client can update the
> merchandise
> themselves. Something inxepensive please.
> thanks,
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

attached mail follows:


Is there a maximum size for a variable in PHP. A client of mine is
having problems working with a file of around 4Mb. Not really being a
php developer I cannot really answer him. To quote him:

We are not uploading excel from ftp. We are reading excel file which is
about 4 MB. In php settings maximum size of any variable is set to 2 MB so
this setting has to change. As any file reading in a variable will only read
up to 2 MB and then it will stop.

I wasn't aware of any setting that allows you to change the max variable
size. Can anyone shed any light on this?

Cheers,

David.

attached mail follows:


On 4/24/06, David Killen <davekhwy.com.au> wrote:
> Is there a maximum size for a variable in PHP. A client of mine is
> having problems working with a file of around 4Mb. Not really being a
> php developer I cannot really answer him. To quote him:
>
> We are not uploading excel from ftp. We are reading excel file which is
> about 4 MB. In php settings maximum size of any variable is set to 2 MB so
> this setting has to change. As any file reading in a variable will only read
> up to 2 MB and then it will stop.
>
> I wasn't aware of any setting that allows you to change the max variable
> size. Can anyone shed any light on this?

memory_limit will affect this.

http://www.php.net/manual/en/ini.core.php and
http://www.php.net/manual/en/ini.php#ini.list will show you how to
change the limit.

--
Postgresql & php tutorials
http://www.designmagick.com/

attached mail follows:


Hello,

I am really new to all this and I am really hoping I can get some
help PLEASE...
I am making a website with x-cart which uses PHP and Smarty templates.

I need to make an " if " statement that puts a little arrow gif in
front of the link that is clicked on! make any sense?

In other words:

    item 1 (not selected)
    item 2 (not selected)
> item 3 (selected)
    item 4 (not selected)

This is what I have now, but I don't know what to call my {if ?????}

{if ?????}<A href="{?????}"><FONT class="buttontextonly"><IMG
src="{$ImagesDir}/arrow.gif" width="9" height="7" border="0"
align="abstop">{$menu_content}</FONT></A>
{else}
<FONT class="VertMenuTitle">{$menu_content}</FONT>
{/if}</TD>

attached mail follows:


Kinda depends on how you build the list of links i guess. What you need is
a unique identifier. But would be more easy if you show some code.

item 1 cart.php?item=1
item 2 cart.php?item=2

Then when you make the links. Use a loop

foreach($links as $link) {
    if ($link["id"] == $_GET["item"])
    {
        // arrow image here
    }
}

Well anyway. Show some code how you build the links list. My code sucks
but it's a start. It's to early :)

Gr,
Thijs

> Hello,
>
> I am really new to all this and I am really hoping I can get some
> help PLEASE...
> I am making a website with x-cart which uses PHP and Smarty templates.
>
> I need to make an " if " statement that puts a little arrow gif in
> front of the link that is clicked on! make any sense?
>
> In other words:
>
> item 1 (not selected)
> item 2 (not selected)
> > item 3 (selected)
> item 4 (not selected)
>
> This is what I have now, but I don't know what to call my {if ?????}
>
> {if ?????}<A href="{?????}"><FONT class="buttontextonly"><IMG
> src="{$ImagesDir}/arrow.gif" width="9" height="7" border="0"
> align="abstop">{$menu_content}</FONT></A>
> {else}
> <FONT class="VertMenuTitle">{$menu_content}</FONT>
> {/if}</TD>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

attached mail follows:


Yikes...<font>? that's been deprecated since the turn of the century!

do it with css...

html
<ul>
<li>item 1</li>
<li class="selected">item 2</li>
<li>item 3</li>
</ul>

css:

ul li { background-image: url("/img/arrow-off.png"); color: gray; }
ul .selected { background-image: url("/img/arrow-on.png"); color: red; }

http://www.w3.org/TR/CSS21/colors.html#propdef-background-image

The real question here though is looping through your menu items or
"nodes" in your tree (unordered list)...you'll need to read up on DOM
in php5 or domxml in php4.

I have broken down my page into libraries, for example, my menu.php is
included at the top of every page, and loops through the tree,
checking for whatever condition (in my case I check the current url
against the anchor href for every list item, and if it's equal, then I
dynamically set the class="selected" on the item (parent of anchor),
which can turn it blue, and add an arrowon.png (this part should be
taken care of with css, so you can easily redesign it without changing
your code.

<?php

function selectMenuItem()
{
        global $htdocs;
        global $uri;
        $uri = getenv('REQUEST_URI');

        $dom = new DOMDocument;
        #xhtml fragment which contains the menu
        $dom->load("$htdocs/xml/menu.xml");
        $xpath = new DOMXPath($dom);

        #uses xpath query to find anchors with parent of list item
        $nodes = $xpath->query("//a[parent::li]");

        foreach ($nodes as $node)
        {
                $attr = $node->getAttribute('href');

                if($attr == $uri)
                {
                        $node->setAttribute('class', 'selected');
                }
        }

        #print $dom->saveXML(); #prepends xml declaration and breaks
in IE6 if not the first line.
        print $dom->saveHTML();
}

You can read more about dom with php here: http://www.php.net/dom

Be aware, that you can decorate the heck out of your class/id with
css, an unordered list can look like a set of tabs if needed.

On 4/23/06, Pub <pubearthlink.net> wrote:
> Hello,
>
> I am really new to all this and I am really hoping I can get some
> help PLEASE...
> I am making a website with x-cart which uses PHP and Smarty templates.
>
> I need to make an " if " statement that puts a little arrow gif in
> front of the link that is clicked on! make any sense?
>
> In other words:
>
> item 1 (not selected)
> item 2 (not selected)
> > item 3 (selected)
> item 4 (not selected)
>
> This is what I have now, but I don't know what to call my {if ?????}
>
> {if ?????}<A href="{?????}"><FONT class="buttontextonly"><IMG
> src="{$ImagesDir}/arrow.gif" width="9" height="7" border="0"
> align="abstop">{$menu_content}</FONT></A>
> {else}
> <FONT class="VertMenuTitle">{$menu_content}</FONT>
> {/if}</TD>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>

--
Anthony Ettinger
Signature: http://chovy.dyndns.org/hcard.html

attached mail follows:


Hi all and thanks for the answers.

On my server, the building of some webpages with url like the one below
produces a loop
and crashes the server.
(http://myurl.mydomain/path/index.php/path/index.php).

As I never heard about the PATH_INFO before, I'm not sure the site uses
this value.
(I'll check the code to be sure).

If I can make sure the PATH_INFO isn't used anywhere in the code, is
there a way to
change the config in order to generate a 404 for each url with a not
null PATH_INFO ?

Nicolas Figaro

Joe Wollard a écrit :
> I believe Kevin is on the right track there. To expand a bit, you can use
> $_SERVER['PATH_INFO'] with these urls instead of $_GET to make use of the
> data it contains
>
> example for url http://www.example.com/index.php/foo/bar
> <?php
> echo $_SERVER['PATH_INFO'];
> ?>
>
> produces:
> /foo/bar
>
> You can then parse this string, (generally by using the '/' character as a
> deliminator) and extract the data. MediaWiki even provides information
> (can't think of where at the moment) on how to use Apache's mod_rewrite to
> hide index.php thus making the url even cleaner:
> http://www.example.com/foo/bar
>
> Cheers!
> - Joe
>
> On 4/21/06, Kevin Kinsey <kdkdaleco.biz> wrote:
>
>>> Hi,
>>>
>>> could anyone tell me why the following url doesn't
>>> generate a "page not found" ?
>>>
>> http://www.php.net/manual/en/function.checkdnsrr.php/manual/
>>
>>
>>> you can try with a longer url after the last .php.
>>>
>>> I tried with ../manual instead of manual and this produces a 404.
>>>
>>> I checked with www.php.net because my own site does the same and I
>>> wanted to be sure it didn't come from my config.
>>>
>>> thanks
>>>
>>> Nicolas Figaro
>>>
>> tg-phpgryffyndevelopment.com wrote:
>>
>>
>>> The other thing that could happen is they could be
>>> using something like the Apache mod_rewrite (some
>>> info at http://www.modrewrite.com/ among others) which
>>> can dynamically change the requested URL to a more
>>> standard URL before sending back to the user.
>>>
>>> Something like this:
>>> http://www.testserver.com/tgryffyn/homepage/middlesection
>>>
>>> Could be turned into something like:
>>>
>>>
>> http://www.testserver.com/userpage.php?user=tgryffyn&page=home#middleanchor
>>
>>> But to the user requesting the page, it'll always look like the first
>>>
>> URL.
>>
>>> Forgive me if I got any syntax or capability of mod_rewrite wrong,
>>> never used it myself just know that's the general sort of thing that it
>>>
>> does.
>>
>>>
>> Pretty good thoughts, there. Some years ago, Tim Perdue
>> (of PHPBuilder and SourceForge fame) had a popular
>> article on "Search Engine Friendly URL's" (or some such),
>> in which he described use of the Apache ForceLocal
>> directive to make a site just One Big Script, parsing
>> the slashed portions of the query string as variables
>> (instead of GET, a la "?section=man&term=foo") so that
>> the browser appears to be accessing documents in subfolders,
>> but it's really just telling the server to grab a page with certain
>> values defined in the URI.
>>
>> It sure looks like a possibility of this or similar magic in
>> this case. Of course, I could be way off my tree...
>>
>> Kevin Kinsey
>>
>> --
>> Byte your tongue.
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>
>

attached mail follows:


On 4/21/06, tg-phpgryffyndevelopment.com <tg-phpgryffyndevelopment.com> wrote:
> redirects to:
> http://www.example.com/index.php?action=edit&type=customer&id=1234&adminaccess=1

and you put admin access flags (read, determine roles) in URL parameters?

-ahmed

attached mail follows:


On 23 Apr 2006, at 8:03 PM, John Hicks wrote:

> CK wrote:
> > Hi,
> > On Apr 22, 2006, at 1:26 PM, John Hicks wrote:
> >
> >> CK wrote:
> >>> Hi,
> >>> I've been commissioned to design a web application for auto parts
> >>> sales. The Flash Front end will communicate with a MySQL DB via
> PHP.
> >>> In addition, PHP/XML should be used with a client-side Web GUI to
> >>> upload images, part no., descriptions and inventory into the DB; a
> >>> Product Management System.
> >>>
> >> I am curious as to how you plan to using XML for the client's back
> >> end? (I don't see any reason to use it.)
> >
> > Using XML to keep an "inventory" dynamically, was the thought.
> The XML
> > file would be updated with each entry, then could be imported into a
> > spreadsheet.
> >
>
> If you are storing your inventory in an XML document, then what are
> you using the MySQL database for?
>
> >>> After "Googling" the returned queries have been slim, any leads on
> >>> more specific examples?
>
> What specifically are you looking for and how are you googling for it?
>
> --John
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>

You may want to look into openlaszlo. http://www.openlaszlo.org/ You
can use it to provide the Internet front-end and use PHP for the back-
end. Also, now has the option for either DHTML or Flash on the client
side.

Johan Martin
Catenare LLC

attached mail follows:


--- Jay Blanchard <jblanchardpocket.com> wrote:

> [snip]
> Hi everybody!
> I want to get src of image form a $text, I have a
> below text
>
> $Text = <table border="1" cellpadding="3%"
> cellspacing="3%"
> width="100%">
> <tr> <td width="20%">
> <img align="middle" border="0"
> id=userupload/78/Autumn.jpg
> src=userupload/78/Autumn.jpg
> onClick="javascript:ViewImage(this.id);"
> width="100" height="100" >
> </td>
> <td></td></tr> </table>
> </td>
> <td class="frame2_middle_right"></td>
> </tr>
> <tr>
> <td class="frame2_bottom_left"></td>
> <td class="frame2_bottom_center">
> </td>
> [/snip]
>
> And I want a pony!
>
> RTFM http://www.php.net/regex

Jay, a warning would be nice before you post stuff
like you posted above... I am _supposed_ to be working
here and suddenly when I burst into laughter and then
control myself to a big smile on my face everyone
looks at me and thinks I am not working but just
goofing off on the job.

Cheers!

------
- The faulty interface lies between the chair and the keyboard.
- Creativity is great, but plagiarism is faster!
- Smile, everyone loves a moron. :-)

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

attached mail follows:


[snip]
> I want to get src of image form a $text

> And I want a pony!
>

Jay, a warning would be nice before you post stuff
like you posted above... I am _supposed_ to be working
here and suddenly when I burst into laughter and then
control myself to a big smile on my face everyone
looks at me and thinks I am not working but just
goofing off on the job.
[/snip]

PHP Comic Relief! Send in your money now! I will see if I can conjure up
an appropriate disclaimer.

attached mail follows:


--- Jay Blanchard <jblanchardpocket.com> wrote:

> [snip]
> > I want to get src of image form a $text
>
> > And I want a pony!
> >
>
> Jay, a warning would be nice before you post stuff
> like you posted above... I am _supposed_ to be
> working
> here and suddenly when I burst into laughter and
> then
> control myself to a big smile on my face everyone
> looks at me and thinks I am not working but just
> goofing off on the job.
> [/snip]
>
> PHP Comic Relief! Send in your money now! I will see
> if I can conjure up
> an appropriate disclaimer.

"Send in your money now!"????!!??
ok, stopped laughing.....

------
- The faulty interface lies between the chair and the keyboard.
- Creativity is great, but plagiarism is faster!
- Smile, everyone loves a moron. :-)

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

attached mail follows:


On Apr 22, 2006, at 4:49 AM, William Stokes wrote:

> Hello,
>
> Any idea how to sort this?
>
> I have a column in DB that contains this kind of data,
> A20,B16,B17C14,C15,D13,D12 etc.
>
> I would like to print this data to a page and sort it ascending by the
> letter an descending by the number. Can this be done? Like
>
> A20
> B17
> B16
> C15
> C14
> D13
> D12
>
> Thanks
> -Will

Maybe I'm missing something, but I don't think that I've seen anyone
mention this. Can you not just sort the data before it reaches your
php code... meaning, via the db? My example uses MySQL:

<?
$result = msyql_query("SELECT * FROM your_database ORDER BY ASC",
$link);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
   $column[$i++] = $row["your_column"];

...

for ($i=0; $i<$numOfCols; $i++)
   echo "$column[$i]<br/>";
?>

Again, I may have misread what you are asking, but this appears to be
a simple solution when pulling from a database.

Good luck,
~Philip

attached mail follows:


On Apr 24, 2006, at 9:06 AM, Philip Thompson wrote:

> On Apr 22, 2006, at 4:49 AM, William Stokes wrote:
>
>> Hello,
>>
>> Any idea how to sort this?
>>
>> I have a column in DB that contains this kind of data,
>> A20,B16,B17C14,C15,D13,D12 etc.
>>
>> I would like to print this data to a page and sort it ascending by
>> the
>> letter an descending by the number. Can this be done? Like
>>
>> A20
>> B17
>> B16
>> C15
>> C14
>> D13
>> D12
>>
>> Thanks
>> -Will
>
> Maybe I'm missing something, but I don't think that I've seen
> anyone mention this. Can you not just sort the data before it
> reaches your php code... meaning, via the db? My example uses MySQL:
>
> <?
> $result = msyql_query("SELECT * FROM your_database ORDER BY ASC",
> $link);

Ooops!

... ORDER BY your_column ASC ...

> while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
> $column[$i++] = $row["your_column"];
>
> ...
>
> for ($i=0; $i<$numOfCols; $i++)
> echo "$column[$i]<br/>";
> ?>
>
> Again, I may have misread what you are asking, but this appears to
> be a simple solution when pulling from a database.
>
> Good luck,
> ~Philip