Article View: pl.comp.lang.php
Article #219842Re: Wolno dzialajacy skrypt
From: maYk
Date: Fri, 24 Jul 2009 16:29
Date: Fri, 24 Jul 2009 16:29
32 lines
2438 bytes
2438 bytes
On Jul 24, 6:27 am, Tomasz Bukowski <tomasz@_KILL_BOT_bukowski.kom.pl>
wrote:
> at czwartek, 23 lipca 2009 21:35 , maYk wrote:
> > - lista firm
> > - lista kontaktow
> > - lista statusow
>
> => przenieść większość kodu po stronie SQL nie PHP
>
> - spokojnie możesz użyć GROUP BY i ORDER
> - można to rozbić na 3 selecty ( comapnies , last_name i status )
>
> Jeżeli zdradzisz, co za magia czai się np: w $pull_up_product_status_info
> to "pomożemy więcej'
Tak tez zrobilem, jednak ciagle zastanawiam sie jak pominac ten
problem ze statusami. Jak nie parsowac lancucha statusow odzielonego
przecinkami za kazdym razem...
Oto funkcja o ktora proszono:
function pull_up_product_status_info(){
global $dbh1, $pull_up_product_status_info;
$sql = "SELECT * FROM `_cfg_status` ORDER BY ID";
$result = mysql_query($sql, $dbh1) or die ("Could not get result.".
mysql_error());
while ($wynik = mysql_fetch_array($result)) {
$pull_up_product_status_info[$wynik['ID']] = $wynik['status_name'];
}
return $pull_up_product_status_info;
}
Technical Details
Message-ID:
<5e1a8b0d-5ba4-4c1a-a9be-2f31bec9fb7b@g23g2000vbr.googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!nf1.ipartners.pl!ipartners.pl!plix.pl!newsfeed1.plix.pl!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!198.186.194.249.MISMATCH!news-out.readnews.com!transit3.readnews.com!postnews.google.com!g23g2000vbr.googlegroups.com!not-for-mailReferences:
<73ced6b9-b6ea-42c8-beb7-d3af06008365@26g2000yqk.googlegroups.com> <h4c221$68d$1@julia.coi.pw.edu.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!nf1.ipartners.pl!ipartners.pl!plix.pl!newsfeed1.plix.pl!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!198.186.194.249.MISMATCH!news-out.readnews.com!transit3.readnews.com!postnews.google.com!g23g2000vbr.googlegroups.com!not-for-mail From: maYk <m.gawrychowski@gmail.com> Newsgroups: pl.comp.lang.php Subject: Re: Wolno dzialajacy skrypt Date: Fri, 24 Jul 2009 09:29:26 -0700 (PDT) Organization: http://groups.google.com Lines: 33 Message-ID: <5e1a8b0d-5ba4-4c1a-a9be-2f31bec9fb7b@g23g2000vbr.googlegroups.com> References: <73ced6b9-b6ea-42c8-beb7-d3af06008365@26g2000yqk.googlegroups.com> <h4c221$68d$1@julia.coi.pw.edu.pl> NNTP-Posting-Host: 75.127.181.202 Mime-Version: 1.0 X-Trace: posting.google.com 1248452967 6781 127.0.0.1 (24 Jul 2009 16:29:27 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 24 Jul 2009 16:29:27 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: g23g2000vbr.googlegroups.com; posting-host=75.127.181.202; posting-account=VUaMuQoAAADTDiCQs1_Lzd2gS1Olr4rF User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.1) Gecko/20090715 Firefox/3.5.1 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit