[PHP-DB] Appeal For Assitance
Dear Sir, Appeal For Assitance I wish to write you pleading with you to be my Investor trustee over $12.5million. My late Husband was a rich oil Contractor in South Africa, But before his death in July 29th 1999. He deposited the sum of ($12,500,000.00) USD in a safe keeping company in Europe through Debt Reconciliation Committee (DRC). The money which he made from oil contract and he left an instruction with the (DRC) to release the money to me his wife and his son Ali who at that time was studying, that an Investor should accompany us before the $12.5Million will be released to us for proper investment, and also for the welfare of the children which he left behind for me. I plead with you to accept to help me and act as my investor trustee to manage the $12.5Million for me. We can both arrange on how to invest this money into your company. We have agreed to give you 20% of the $12.5Million for your own assistance. All the relevant documents shall be forwarded to you upon your indications to assist me in this project. May the Almighty God bless you, if you will of trust and faithful to assist me. Please contact me on the above e-mail address or my Son Ali on his for more Informations. Looking forward to hearing from you. Sincerely Yours, Mrs. Fatima Abdul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance
This mail is probably spam. The original message has been attached along with this report, so you can recognize or block similar unwanted mail in future. See http://spamassassin.org/tag/ for more details. Content preview: Dear Sir, Appeal For Assitance I wish to write you pleading with you to be my Investor trustee over $12.5million. My late Husband was a rich oil Contractor in South Africa, But before his death in July 29th 1999. He deposited the sum of ($12,500,000.00) USD in a safe keeping company in Europe through Debt Reconciliation Committee (DRC). [...] Content analysis details: (6.60 points, 5 required) RATWARE_OE_MALFORMED (2.9 points) X-Mailer contains malformed Outlook Express version DEAR_SOMETHING (2.6 points) BODY: Contains 'Dear (something)' US_DOLLARS_3 (0.9 points) BODY: Nigerian scam key phrase ($NN,NNN,NNN.NN) MIME_LONG_LINE_QP (0.2 points) RAW: Quoted-printable line longer than 76 characters ---BeginMessage--- Dear Sir, Appeal For Assitance I wish to write you pleading with you to be my Investor trustee over $12.5million. My late Husband was a rich oil Contractor in South Africa, But before his death in July 29th 1999. He deposited the sum of ($12,500,000.00) USD in a safe keeping company in Europe through Debt Reconciliation Committee (DRC). The money which he made from oil contract and he left an instruction with the (DRC) to release the money to me his wife and his son Ali who at that time was studying, that an Investor should accompany us before the $12.5Million will be released to us for proper investment, and also for the welfare of the children which he left behind for me. I plead with you to accept to help me and act as my investor trustee to manage the $12.5Million for me. We can both arrange on how to invest this money into your company. We have agreed to give you 20% of the $12.5Million for your own assistance. All the relevant documents shall be forwarded to you upon your indications to assist me in this project. May the Almighty God bless you, if you will of trust and faithful to assist me. Please contact me on the above e-mail address or my Son Ali on his for more Informations. Looking forward to hearing from you. Sincerely Yours, Mrs. Fatima Abdul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ---End Message--- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] [unixODBC]Client unable to establish connection
I got the follwing error when i try to use isql -v or in my php code
thet looks like
$hh= odbc_connect('DSNname','user','password') or die(odbc_error());
[unixODBC]Client unable to establish connection
[ISQL]ERROR: Could not SQLDriverConnect
I have FreeTDS compiled --with-unixodbc and i tested the connection :
bash tsql DSNname -S 192.168.0.1 -U user -P pass
and i got connected... and i tried telnet 192.168.0.1 1433 and i managed too
SO what do u think the prblem is?
--
Nabil Attar
Advanced Web Solutions
/***
Everyone is a beginner once, and no one is an expert at everything.
***/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] alphabetical sorting... limiting and paginatingonnext set of letter group
Hi Ramil,
I'm also facing a similar problem, I would like to get the list
based on user Input.
Please input 1st Letter of designers wanted : A, D, P
I've tried using OR but it somehow screws things up.
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:38 AM
To: [EMAIL PROTECTED]
Cc: Aaron Wolski
Subject: RE: [PHP-DB] alphabetical sorting... limiting and
paginatingonnext set of letter group
On Wed, 2003-07-30 at 11:17, Aaron Wolski wrote:
Hey,
Thanks.
Is there anyway this can be performed one function/loop?
yes of course. =) just create a function that takes in two letters as a
parameter,
then build the query string from it.
function($char_begin, $char_end)
{
$q_begin = strtolower($char_begin);
$q_end = chr(ord(strtolower($char_begin))+1);
$query = SELECT designer_name FROM designer WHERE designer_name BETWEEN
'.$q_begin.' AND '.$q_end.' ORDER BY designer_name;
//do your query here.
}
I knew it was possible with several queries.. I guess I was just looking
for a all_in_one solution.
Thanks for your help!
Aaron
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:07 PM
To: Aaron Wolski
Subject: Re: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
On Wed, 2003-07-30 at 10:36, Aaron Wolski wrote:
Hi Guys,
What I would like to do is:
Pattern Designers:
A/B/C
Artists Collection The
Barrick Samplers
Bent Creek
Bobbie G. Designs
Calico Crossroads
Charland Designs
Country Cross Stitch
Click for D/E/F
Click for G/H/I
Click for J/K/L
When the user clicks on one of the another Letter Groupings... the
A/B/C changes to whatever they selected as does the displayed
results
for their selection.
Is this even possible?
Aaron
yes it is. =)
try for a/b/c
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'a' AND
'd' ORDER BY designer_name;
for d/e/f :
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'd' AND
'g' ORDER BY designer_name;
for j/k/l:
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'j' AND
'm' ORDER BY designer_name;
hope this helps.
ramil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: Session help...
Thanks for the responses. I ended up resolving this by fixing the
form destination. I had hard coded a location in there, and did not realize
this. Once I replaced this with the PHP variable everything magically
started to work. My bad on that. Thanks again for the feedback though.
-Original Message-
From: Ow Mun Heng [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 11:13 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: Session help...
As mentioned previously in this list,
$_SESSION and session_register, session_is_register, is not compatible with
each other.
Anyway, I used your idea as inspiration for my own code.. My code works..
Try to change From:
if (!session_is_registered(valid_user)) {
To:
if ($_SESSION['valid_user']){
//your code
}
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 9:19 PM
To: [EMAIL PROTECTED]
Subject: Session help...
Sorry for the slightly off-topic post... I have a couple pages that
use a login page. If the user tries to bring up one of these pages without
being logged in, then the pages redirects him to the login page. After
successful login, the user is directed back to the page they were attempting
to originally load. For some reason, this is not working and I have been
looking at this off and on for two days now without much luck. The first
section of code is the snippet that directs users to the login page, and the
second snippet is the code from the login page that sends users back.
First code snippet...
session_start();
if ($sbcuid $passwd) {
mysql_select_db($database, $Prod);
$query = select * from contacts_sa
. where sbcuid='$sbcuid' and passwd='$passwd';
$result = mysql_query($query, $Prod) or die(mysql_error());
# $data = mysql_fetch_assoc($result);
$test = mysql_num_rows($result);
if (mysql_num_rows($result) 0 )
{
$valid_user = $sbcuid;
$_SESSION['valid_user'] = $sbcuid;
}
}
if (!session_is_registered(valid_user)) {
$return_url = $_SERVER['PHP_SELF'];
$_SESSION['return_url'] = $return_url;
header('Location: http://ldsa.sbcld.sbc.com/DW/sa_login.php');
exit();
} else {
$sbcuid = $valid_user;
}
End of first snippet...
Second code snippet...
session_start();
if ($sbcuid $passwd) {
if (isset($_SESSION['return_url'])) {
$link = $_SESSION['return_url'];
} else {
$link = 'oncall_log.php';
}
mysql_select_db($database, $Prod);
$query = select * from contacts_sa
. where sbcuid='$sbcuid' and passwd='$passwd';
$result = mysql_query($query, $Prod) or die(mysql_error());
# $data = mysql_fetch_assoc($result);
$test = mysql_num_rows($result);
if (mysql_num_rows($result) 0 ) {
$valid_user = $sbcuid;
# session_register(valid_user);
$_SESSION['valid_user'] = $sbcuid;
header(Location: http://.$_SERVER['HTTP_HOST'].$link);
}
}
End of second snippet...
Thanks in advance for any help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] alphabetical sorting... limiting and paginating onnext set of letter group
Alrighty..
Working with your code and some others I've come up with this:
?php
if ($sort) {
$list = explode(-, $sort);
}
$test = Array('A-D', 'D-G', 'G-J', 'J-M', 'M-P', 'P-S', 'S-V', 'V-Y',
'Y-Z');
foreach ($test as $group) {
if (strtolower ($group) != $sort) {
$lgroup = strtolower ($group);
echo a
href=\patterns.php?sort={$lgroup}\{$group}/abr /;
}
}
$designerQuery = db_query(SELECT designer FROM kcs_patterns WHERE
designer BETWEEN '.$list[0].' and '.$list[1].' GROUP BY designer
ORDER BY designer);
while ($designerResult = db_fetch($designerQuery)) {
?
img src=Graphics/spacer.gif width=10 height=1a href=font
class=catalogueSubCatLink?php echo $designerResult['designer']; ?
Designers/font/abr
?php
}
?
This works as I need it to.. shifting from one set of results to
another. My problem is how do I format it like the following(assuming
A-D was selected):
A-D Designers
Artists Collection The
Barrick Samplers
Bent Creek
Brown House Studio
Butternut Road
Calico Crossroads
Canterbury
Cross My Heart
Crossed Wing Collection
D-G
G-J
J-M
M-P
P-S
S-V
V-Y
Y-Z
Or if D-G was selected:
A-D
D-G Designers
Datta Bonnie
Design Connection
Design Connection The
DMC
Donna Gallagher Creative Needlearts
Dragon Dreams
Family Tree The
Fanci That
Full Circle Designs
G-J
J-M
M-P
P-S
S-V
V-Y
Y-Z
I've tried a few placements of the foreach loop but nothing seems to
work. Any ideas?
Thanks!
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:38 PM
To: [EMAIL PROTECTED]
Cc: Aaron Wolski
Subject: RE: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
On Wed, 2003-07-30 at 11:17, Aaron Wolski wrote:
Hey,
Thanks.
Is there anyway this can be performed one function/loop?
yes of course. =) just create a function that takes in two letters as a
parameter,
then build the query string from it.
function($char_begin, $char_end)
{
$q_begin = strtolower($char_begin);
$q_end = chr(ord(strtolower($char_begin))+1);
$query = SELECT designer_name FROM designer WHERE designer_name
BETWEEN '.$q_begin.' AND '.$q_end.' ORDER BY designer_name;
//do your query here.
}
I knew it was possible with several queries.. I guess I was just
looking
for a all_in_one solution.
Thanks for your help!
Aaron
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:07 PM
To: Aaron Wolski
Subject: Re: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
On Wed, 2003-07-30 at 10:36, Aaron Wolski wrote:
Hi Guys,
What I would like to do is:
Pattern Designers:
A/B/C
Artists Collection The
Barrick Samplers
Bent Creek
Bobbie G. Designs
Calico Crossroads
Charland Designs
Country Cross Stitch
Click for D/E/F
Click for G/H/I
Click for J/K/L
When the user clicks on one of the another Letter Groupings... the
A/B/C changes to whatever they selected as does the displayed
results
for their selection.
Is this even possible?
Aaron
yes it is. =)
try for a/b/c
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'a' AND
'd' ORDER BY designer_name;
for d/e/f :
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'd' AND
'g' ORDER BY designer_name;
for j/k/l:
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'j' AND
'm' ORDER BY designer_name;
hope this helps.
ramil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance
why doesnt she stick the money up her a$$ - Original Message - From: Mrs. Fatima Abdul [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:06 AM Subject: [PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance This mail is probably spam. The original message has been attached along with this report, so you can recognize or block similar unwanted mail in future. See http://spamassassin.org/tag/ for more details. Content preview: Dear Sir, Appeal For Assitance I wish to write you pleading with you to be my Investor trustee over $12.5million. My late Husband was a rich oil Contractor in South Africa, But before his death in July 29th 1999. He deposited the sum of ($12,500,000.00) USD in a safe keeping company in Europe through Debt Reconciliation Committee (DRC). [...] Content analysis details: (6.60 points, 5 required) RATWARE_OE_MALFORMED (2.9 points) X-Mailer contains malformed Outlook Express version DEAR_SOMETHING (2.6 points) BODY: Contains 'Dear (something)' US_DOLLARS_3 (0.9 points) BODY: Nigerian scam key phrase ($NN,NNN,NNN.NN) MIME_LONG_LINE_QP (0.2 points) RAW: Quoted-printable line longer than 76 characters -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] alphabetical sorting... limiting and paginating onnext set of letter group
Sorry all but getting kinda desparate here :(
Trying a few different things and still nothing seems to work.
Does anyone have a kick in the right direction that I could explore
here?
Sorry for the repost.
Thanks
Aaron
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED]
Sent: July 30, 2003 9:47 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
Alrighty..
Working with your code and some others I've come up with this:
?php
if ($sort) {
$list = explode(-, $sort);
}
$test = Array('A-D', 'D-G', 'G-J', 'J-M', 'M-P', 'P-S', 'S-V', 'V-Y',
'Y-Z');
foreach ($test as $group) {
if (strtolower ($group) != $sort) {
$lgroup = strtolower ($group);
echo a
href=\patterns.php?sort={$lgroup}\{$group}/abr /;
}
}
$designerQuery = db_query(SELECT designer FROM kcs_patterns WHERE
designer BETWEEN '.$list[0].' and '.$list[1].' GROUP BY designer
ORDER BY designer);
while ($designerResult = db_fetch($designerQuery)) {
?
img src=Graphics/spacer.gif width=10 height=1a href=font
class=catalogueSubCatLink?php echo $designerResult['designer']; ?
Designers/font/abr
?php
}
?
This works as I need it to.. shifting from one set of results to
another. My problem is how do I format it like the following(assuming
A-D was selected):
A-D Designers
Artists Collection The
Barrick Samplers
Bent Creek
Brown House Studio
Butternut Road
Calico Crossroads
Canterbury
Cross My Heart
Crossed Wing Collection
D-G
G-J
J-M
M-P
P-S
S-V
V-Y
Y-Z
Or if D-G was selected:
A-D
D-G Designers
Datta Bonnie
Design Connection
Design Connection The
DMC
Donna Gallagher Creative Needlearts
Dragon Dreams
Family Tree The
Fanci That
Full Circle Designs
G-J
J-M
M-P
P-S
S-V
V-Y
Y-Z
I've tried a few placements of the foreach loop but nothing seems to
work. Any ideas?
Thanks!
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:38 PM
To: [EMAIL PROTECTED]
Cc: Aaron Wolski
Subject: RE: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
On Wed, 2003-07-30 at 11:17, Aaron Wolski wrote:
Hey,
Thanks.
Is there anyway this can be performed one function/loop?
yes of course. =) just create a function that takes in two letters as a
parameter,
then build the query string from it.
function($char_begin, $char_end)
{
$q_begin = strtolower($char_begin);
$q_end = chr(ord(strtolower($char_begin))+1);
$query = SELECT designer_name FROM designer WHERE designer_name
BETWEEN '.$q_begin.' AND '.$q_end.' ORDER BY designer_name;
//do your query here.
}
I knew it was possible with several queries.. I guess I was just
looking
for a all_in_one solution.
Thanks for your help!
Aaron
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:07 PM
To: Aaron Wolski
Subject: Re: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
On Wed, 2003-07-30 at 10:36, Aaron Wolski wrote:
Hi Guys,
What I would like to do is:
Pattern Designers:
A/B/C
Artists Collection The
Barrick Samplers
Bent Creek
Bobbie G. Designs
Calico Crossroads
Charland Designs
Country Cross Stitch
Click for D/E/F
Click for G/H/I
Click for J/K/L
When the user clicks on one of the another Letter Groupings... the
A/B/C changes to whatever they selected as does the displayed
results
for their selection.
Is this even possible?
Aaron
yes it is. =)
try for a/b/c
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'a' AND
'd' ORDER BY designer_name;
for d/e/f :
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'd' AND
'g' ORDER BY designer_name;
for j/k/l:
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'j' AND
'm' ORDER BY designer_name;
hope this helps.
ramil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] alphabetical sorting... limiting and paginating onnext set of letter group
You have to do:
foreach ($test as $group) {
if (strtolower ($group) != $sort) {
$lgroup = strtolower ($group);
echo a href=\patterns.php?sort={$lgroup}\{$group}/abr /;
} else {
echo {$group}BRBR;
... query db and show results ...
echo BR;
}
}
- Original Message -
From: Aaron Wolski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 6:19 PM
Subject: RE: [PHP-DB] alphabetical sorting... limiting and paginating onnext
set of letter group
Sorry all but getting kinda desparate here :(
Trying a few different things and still nothing seems to work.
Does anyone have a kick in the right direction that I could explore
here?
Sorry for the repost.
Thanks
Aaron
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED]
Sent: July 30, 2003 9:47 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
Alrighty..
Working with your code and some others I've come up with this:
?php
if ($sort) {
$list = explode(-, $sort);
}
$test = Array('A-D', 'D-G', 'G-J', 'J-M', 'M-P', 'P-S', 'S-V', 'V-Y',
'Y-Z');
foreach ($test as $group) {
if (strtolower ($group) != $sort) {
$lgroup = strtolower ($group);
echo a
href=\patterns.php?sort={$lgroup}\{$group}/abr /;
}
}
$designerQuery = db_query(SELECT designer FROM kcs_patterns WHERE
designer BETWEEN '.$list[0].' and '.$list[1].' GROUP BY designer
ORDER BY designer);
while ($designerResult = db_fetch($designerQuery)) {
?
img src=Graphics/spacer.gif width=10 height=1a href=font
class=catalogueSubCatLink?php echo $designerResult['designer']; ?
Designers/font/abr
?php
}
?
This works as I need it to.. shifting from one set of results to
another. My problem is how do I format it like the following(assuming
A-D was selected):
A-D Designers
Artists Collection The
Barrick Samplers
Bent Creek
Brown House Studio
Butternut Road
Calico Crossroads
Canterbury
Cross My Heart
Crossed Wing Collection
D-G
G-J
J-M
M-P
P-S
S-V
V-Y
Y-Z
Or if D-G was selected:
A-D
D-G Designers
Datta Bonnie
Design Connection
Design Connection The
DMC
Donna Gallagher Creative Needlearts
Dragon Dreams
Family Tree The
Fanci That
Full Circle Designs
G-J
J-M
M-P
P-S
S-V
V-Y
Y-Z
I've tried a few placements of the foreach loop but nothing seems to
work. Any ideas?
Thanks!
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:38 PM
To: [EMAIL PROTECTED]
Cc: Aaron Wolski
Subject: RE: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
On Wed, 2003-07-30 at 11:17, Aaron Wolski wrote:
Hey,
Thanks.
Is there anyway this can be performed one function/loop?
yes of course. =) just create a function that takes in two letters as a
parameter,
then build the query string from it.
function($char_begin, $char_end)
{
$q_begin = strtolower($char_begin);
$q_end = chr(ord(strtolower($char_begin))+1);
$query = SELECT designer_name FROM designer WHERE designer_name
BETWEEN '.$q_begin.' AND '.$q_end.' ORDER BY designer_name;
//do your query here.
}
I knew it was possible with several queries.. I guess I was just
looking
for a all_in_one solution.
Thanks for your help!
Aaron
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:07 PM
To: Aaron Wolski
Subject: Re: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
On Wed, 2003-07-30 at 10:36, Aaron Wolski wrote:
Hi Guys,
What I would like to do is:
Pattern Designers:
A/B/C
Artists Collection The
Barrick Samplers
Bent Creek
Bobbie G. Designs
Calico Crossroads
Charland Designs
Country Cross Stitch
Click for D/E/F
Click for G/H/I
Click for J/K/L
When the user clicks on one of the another Letter Groupings... the
A/B/C changes to whatever they selected as does the displayed
results
for their selection.
Is this even possible?
Aaron
yes it is. =)
try for a/b/c
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'a' AND
'd' ORDER BY designer_name;
for d/e/f :
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'd' AND
'g' ORDER BY designer_name;
for j/k/l:
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'j' AND
'm' ORDER BY designer_name;
hope this helps.
ramil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance
Ever tried sticking 12.5million dollars of crisp non sequential bills up there ??? You'd need a VERY big a$$ :) -Original Message- From: Angelo Zanetti [mailto:[EMAIL PROTECTED] Sent: 30 July 2003 15:47 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance why doesnt she stick the money up her a$$ - Original Message - From: Mrs. Fatima Abdul [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:06 AM Subject: [PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance This mail is probably spam. The original message has been attached along with this report, so you can recognize or block similar unwanted mail in future. See http://spamassassin.org/tag/ for more details. Content preview: Dear Sir, Appeal For Assitance I wish to write you pleading with you to be my Investor trustee over $12.5million. My late Husband was a rich oil Contractor in South Africa, But before his death in July 29th 1999. He deposited the sum of ($12,500,000.00) USD in a safe keeping company in Europe through Debt Reconciliation Committee (DRC). [...] Content analysis details: (6.60 points, 5 required) RATWARE_OE_MALFORMED (2.9 points) X-Mailer contains malformed Outlook Express version DEAR_SOMETHING (2.6 points) BODY: Contains 'Dear (something)' US_DOLLARS_3 (0.9 points) BODY: Nigerian scam key phrase ($NN,NNN,NNN.NN) MIME_LONG_LINE_QP (0.2 points) RAW: Quoted-printable line longer than 76 characters -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance
...hence her request for a$$istance... Phil
[PHP-DB] PHP errors - strange variables causing form corruption?
I cobbled together a really quick and dirty PHP to run a dice-rolling simulator. Sometimes, it works great. Other times, it gets into some weird state, when strange extra characters are injected into variable values and/or variable NAMES even! You can see an uploaded version at http://www.westergaard.ca/dierolling. php - if you key in something like 30d100+40 k20 (by which I mean roll 30 100-sided dice, keep the best 20, and add 40 to the resulting sum), then click roll a few times, you'll probably notice that at some point, the string +/- in the help text disappears. The next time you click Roll the system will stop giving roll results, will reset to rolling 3d6, and will ignore input. I've struggled with this till I'm red in the face. I'm stumped. Please, Help! :) I've also uploaded the source at http://www.westergaard.ca/dierolling. phpsrc The webserver at westergaard.ca is Linux, but I've also tested this on a Win2000 IIS webserver, and have the exact same results. If anyone has any clue what is going on, I'd really appreciate a suggestion. Thanks! Peter Westergaard [EMAIL PROTECTED] ### ICQ#: 10294457 http://www.westergaard.ca/ ### http://courtly.livejournal.com -- 'Our response to being bored and rich is not to discard our possessions and live more simply, but to buy more stuff to reduce the space in which we might contemplate our shame.' - Stuart Jeffries Robots without a cause === EASY and FREE access to your email anywhere: http://Mailreader.com/ === -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] (Addendum)
I guess the .phpsrc is being interpreted as PHP anyhow, so let me
just include the body of the page, below:
---
?php
# (DEBUG) -- foreach ($HTTP_POST_VARS as $key = $value) print ($key
= $value br);
# (DEBUG) -- foreach ($HTTP_SERVER_VARS as $key = $value) print
($key = $value br);
# (DEBUG) -- foreach ($HTTP_ENV_VARS as $key = $value) print ($key
= $value br);
print (!-- Die Roller for {$HTTP_POST_VARS['roll']} --);
if (isset($roll)) {
mt_srand ((double) microtime() * 100); # Seed the random number
generator
$x = 0;
$roll = strtolower($roll);
if (!(strpos($roll,'d')===false)) {
$number = substr($roll,0,strpos($roll,'d'));
if (!$number || $number == 0) $number =1;
$rest = substr(strstr($roll,'d'),1);
if (!(strpos($rest,'-')===false)) {
$highnumber=substr($rest,0,strpos($rest,'-'));
$rest = strstr($roll,'-');
if (!(strpos($roll,'k')===false)) {
# user has used the keep method
$bonus = substr($rest,0,strpos($rest,'k'));
$keep = substr(strstr($rest,'k'),1);
} else {
$bonus=substr($rest,strpos($rest,'-'));
}
} else if (!(strpos($rest,'+')===false)) {
$highnumber=substr($rest,0,strpos($rest,'+'));
$rest = strstr($roll,'+');
if (!(strpos($roll,'k')===false)) {
# user has used the keep method
$bonus = substr($rest,0,strpos($rest,'k'));
$keep = substr(strstr($rest,'k'),1);
} else {
$bonus=substr($rest,strpos($rest,'+'));
}
} else {
$bonus = '+0';
if (!(strpos($roll,'k')===false)) {
# user has used the keep method
$highnumber = substr($rest,0,strpos($rest,'k'));
$keep = substr(strstr($rest,'k'),1);
} else {
$highnumber=substr($rest,strpos($rest,'+'));
}
}
if (!(strpos($roll,'k')===false)) {
# user has used the keep method
$keep = trim(substr(strstr($roll,'k'),1));
}
if ($keep == null) {
$keep = $number;
}
if ($keep $number or !is_numeric($keep)) {
$keep = $number;
echo (bInvalid value for 'k'/b. Keeping all dice rolled.
p);
}
} else {
print (Invalid entry. Please use the format:
i[number]/idi[number]/i(+/-
i[number]/i). brii.e. 3d6+3 or 1d8-1/ip);
$number = 1;
$highnumber = 6;
$bonus = '+0';
$keep = 1;
}
print (number, highnumber, bonus, keep: {$number}, {$highnumber},
{$bonus}, {$keep} p);
echo (Rolling {$number}d{$highnumber}{$bonus}:br\n);
if ($keep $number) {
echo (Keeping best {$keep} br\n);
}
echo (TABLE BORDER=1\n\tTR\n\t\tTHDie
#/th\n\t\tTHValue/TH\n\t/TR\n);
$x = 0;
while (++$x = $number) {
$die[$x] = mt_rand(1,$highnumber);
echo
(\n\tTR\n\t\ttd{$x}/td\n\t\tTD{$die[$x]}/TD\n\t/tr\n);
}
sort($die);
$x = trim($keep);
while ($x++ $number) {
array_shift($die);
}
$total = array_sum($die) + $bonus;
echo (/TABLE\n\n);
if ($bonus 0) echo (BBonus:/b {$bonus} BR);
if ($bonus 0) echo (BPenalty:/b {$bonus} BR);
echo (PFONT SIZE=5BTotal:/b {$total}/font);
} else {
$number = 3; $highnumber = 6; $keep = 3;
}
?
FORM ACTION= METHOD=POST
Roll dice:input type=text size=30 name=roll value=?php
echo ($number.'d'.$highnumber);
if ($bonus 0) echo $bonus;
if ($keep != $number) echo k{$keep};
? br
input type=submit name=submit value=Roll
/form
Enter the dice as follows: inum/i d inum/i (+/- inum/i)
(k inum/i) p uExplanation:/u The first three parameters
are self-explanatory, br and the fourth number ('k') is an option
to keep the best (inum/i) rolls. br Obviously k (if it is
specified) must be less than the total number of dice rolled.p
uExamples/u: 4d6 k3 4d10-3 ... 1d8+3 ... 2d20 ... (etc.) p
===
EASY and FREE access to your email anywhere: http://Mailreader.com/
Re: [PHP-DB] PHP errors - strange variables causing form corruption?
I just played with it for a few minutes. It worked fine for me, no problems. Keyed in 5d6-3 k2 and it kept rolling and not resetting. Are you using IE or some other browser? It could be a browser problem. Or you've fixed it since you've posted. On Wed, 30 Jul 2003, Peter Westergaard wrote: I cobbled together a really quick and dirty PHP to run a dice-rolling simulator. Sometimes, it works great. Other times, it gets into some weird state, when strange extra characters are injected into variable values and/or variable NAMES even! You can see an uploaded version at http://www.westergaard.ca/dierolling. php - if you key in something like 30d100+40 k20 (by which I mean roll 30 100-sided dice, keep the best 20, and add 40 to the resulting sum), then click roll a few times, you'll probably notice that at some point, the string +/- in the help text disappears. The next time you click Roll the system will stop giving roll results, will reset to rolling 3d6, and will ignore input. I've struggled with this till I'm red in the face. I'm stumped. Please, Help! :) I've also uploaded the source at http://www.westergaard.ca/dierolling. phpsrc The webserver at westergaard.ca is Linux, but I've also tested this on a Win2000 IIS webserver, and have the exact same results. If anyone has any clue what is going on, I'd really appreciate a suggestion. Thanks! Peter Westergaard [EMAIL PROTECTED] ### ICQ#: 10294457 http://www.westergaard.ca/ ### http://courtly.livejournal.com -- 'Our response to being bored and rich is not to discard our possessions and live more simply, but to buy more stuff to reduce the space in which we might contemplate our shame.' - Stuart Jeffries Robots without a cause === EASY and FREE access to your email anywhere: http://Mailreader.com/ === -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] alphabetical sorting... limiting and paginatingonnext set of letter group
Hi John,
Your Suggestion worked GREAT! I'm new at this so.. Many Thanks.
Now I can use it as I like it..
KEWL...
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 7:18 PM
To: Ow Mun Heng; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: Aaron Wolski
Subject: Re: [PHP-DB] alphabetical sorting... limiting and
paginatingonnext set of letter group
Where $string = 'A, D, P'
$fstring = str_replace(',',',',$string);
$query = SELECT * FROM Table WHERE LEFT(column,1) IN ('$fstring');
Some validation would be in order, but that's the basic idea. Same idea for
the original question, only you control the value of $string.
---John Holmes...
- Original Message -
From: Ow Mun Heng [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: Aaron Wolski [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 6:53 AM
Subject: RE: [PHP-DB] alphabetical sorting... limiting and paginatingonnext
set of letter group
Hi Ramil,
I'm also facing a similar problem, I would like to get the list
based on user Input.
Please input 1st Letter of designers wanted : A, D, P
I've tried using OR but it somehow screws things up.
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:38 AM
To: [EMAIL PROTECTED]
Cc: Aaron Wolski
Subject: RE: [PHP-DB] alphabetical sorting... limiting and
paginatingonnext set of letter group
On Wed, 2003-07-30 at 11:17, Aaron Wolski wrote:
Hey,
Thanks.
Is there anyway this can be performed one function/loop?
yes of course. =) just create a function that takes in two letters as a
parameter,
then build the query string from it.
function($char_begin, $char_end)
{
$q_begin = strtolower($char_begin);
$q_end = chr(ord(strtolower($char_begin))+1);
$query = SELECT designer_name FROM designer WHERE designer_name BETWEEN
'.$q_begin.' AND '.$q_end.' ORDER BY designer_name;
//do your query here.
}
I knew it was possible with several queries.. I guess I was just looking
for a all_in_one solution.
Thanks for your help!
Aaron
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:07 PM
To: Aaron Wolski
Subject: Re: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
On Wed, 2003-07-30 at 10:36, Aaron Wolski wrote:
Hi Guys,
What I would like to do is:
Pattern Designers:
A/B/C
Artists Collection The
Barrick Samplers
Bent Creek
Bobbie G. Designs
Calico Crossroads
Charland Designs
Country Cross Stitch
Click for D/E/F
Click for G/H/I
Click for J/K/L
When the user clicks on one of the another Letter Groupings... the
A/B/C changes to whatever they selected as does the displayed
results
for their selection.
Is this even possible?
Aaron
yes it is. =)
try for a/b/c
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'a' AND
'd' ORDER BY designer_name;
for d/e/f :
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'd' AND
'g' ORDER BY designer_name;
for j/k/l:
SELECT designer_name FROM designer WHERE designer_name BETWEEN 'j' AND
'm' ORDER BY designer_name;
hope this helps.
ramil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
