[PHP-DB] php and oracle

[Marco Orsuni]

Hallo,
I have problems installing php in Linux Mandrake 7.2.

Php work, but I can't see the oracle funcions. I guessed I had to recompile
the source.

I have downloaded the latest version of php from php.net.

I unzipped the file in /tmp but when I write "./configure" the program go in
abend with this message:

creating cache ./config.cache
checking for a BSD compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... yes
checking for working aclocal... missing
checking for working autoconf... missing
checking for working automake... missing
checking for working autoheader... missing
checking for working makeinfo... missing
Updated php_version.h
checking whether to enable maintainer-specific portions of Makefiles... no
checking host system type... i586-pc-linux-gnu
checking for gawk... gawk
checking for bison... no
checking for byacc... no
configure: warning: You will need bison if you want to regenerate the PHP
parsers.
checking for gcc... gcc
checking whether the C compiler (gcc  ) works... yes
checking whether the C compiler (gcc  ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
checking how to run the C preprocessor... gcc -E
checking for AIX... no
checking for gcc option to accept ANSI C... none needed
checking for ranlib... ranlib
checking whether gcc and cc understand -c and -o together... yes
checking whether ln -s works... yes
checking for flex... lex
checking for yywrap in -ll... no
checking lex output file root... ./configure: lex: command not found
configure: error: cannot find output from lex; giving up

what is lex??? and where I did wrong?

thank you very much. Bye

Marco R.




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] How can I insert a binary-file into sybase dbsystem??

[Benjamin]

I'd finished install sysbase,but could not insert binary-file (pic or mp3)
into it ,why??

Thanks:)



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Category search w/o specified categories

[olinux]

Hi all,

I would like to know if anyone has any ideas on how a
script behind a search such as www.smartpages.com
would work. i.e a search for doctors returns "similar
categories" that do not even include the word "doctor"

So how is this possible, is there a cross reference of
synonyms ? 

Thanks much,
olinux

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Html email

[Benny]

Please help me. I have problem with html email. I send email to 3 email
address : [EMAIL PROTECTED], [EMAIL PROTECTED] and [EMAIL PROTECTED]

The email client for yahoo & eudoramail is their web. And for the last
destination, the email client is ms outlook.

The html email for yahoo & eudoramail are well received. But for the
last destination the ms outlook display the wrong result like encrypted
text. Below is my code and the result in ms outlook.

My code :

$s_to = '[EMAIL PROTECTED]';
$s_subject = 'Subject xxx';
$s_headers = "From: [EMAIL PROTECTED]\r\n"; 
$s_headers .= "MIME-Version: 1.0\r\n";
$s_boundary = uniqid("id"); 
$s_headers .= "Content-Type: multipart/alternative" . 
   "; boundary = $s_boundary\r\n\r\n"; 
$s_headers .= "This is a MIME encoded message.\r\n\r\n"; 

$s_headers .= "--$s_boundary\r\n" . 
$s_headers .=   "Content-Type: text/html; charset=\"iso-8859-1\"\r\n" . 
   "Content-Transfer-Encoding: base64\r\n\r\n"; 

$s_headers2 = chunk_split(base64_encode("bla...bla..."bla..."));
$s_headers = $s_headers.$s_headers2.'--'.$s_boundary.'--';
@mail ($s_to, $s_subject,"", $s_headers);



Result in ms outlook :

Return-Path: <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
Received: (qmail 2773 invoked by uid 252); 22 Oct 2001 23:35:00 -
Date: 22 Oct 2001 23:35:00 -
Message-ID: <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Subject xxx
From: [EMAIL PROTECTED]
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary = id3bd4ad2486465 This is
a MIME encoded message.


--id3bd4ad2486465
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: base64


PGZvbnQgZmFjZT0iVmVyZGEhlbHZldGljYSwgc2Fucy1zZXJpZiIgc2l6ZT0i

aXY+PC9mb250C90cj48L3RhYmxlPg==

--id3bd4ad2486465--


Regards;

Benny.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Newbie in Need of Assistance

[JMack]

Greetings.  I have been playing around with PHP this week, programming a
football pool.  I have hit a small snag that I would like some assistance
with, if anyone knows the answer -- it's probably very simple, but my Intro
to PHP book does not tell me how to do it.

I have an HTML form in a PHP page, with several controls on it.  I am
dynamically generating the names for these controls.  Here is the example --
for each game, the user selects the winner in a  control.  It's set
up to not care how many games there are for each week, just dynamically
build the form/controls and name them "pick1", "pick2", etc.

In my function that handles the form and uploads the user's picks to the
database (MySQL), I need to also dynamically generate the variable names
that refer to these controls.  I have them all declared as global variables,
since I know there will never be more than 15 games in a given week.  But, I
want to iterate through a loop for each game and update the database.  As I
loop through for each game, and try to dynamically generate the vaiable
names for $pick1, $pick2, etc.  I end up trying to update the DB by sending
in the string "$pick1" instead of the value from the form control for pick1.

I have attached the PHP file in question.  The code is not very clean,
especially the part where I am having problems, but hopefully, someone will
have some time to help me with this problem.  Please respond to this
newsgroup or directly to me at [EMAIL PROTECTED]  Thank you.

Joe Mack



begin 666 picks.php
M/#]P:' -"B\O:6YD97@N<&AP#0II;F-L=61E(BXO8V]M;6]N7V1B+FEN8R([
M#0H-"F9U;F-T:6]N('-T87)T=7 H*0T*>PT*(&=L;V)A;" D=7-E7-Q;%]S96QE8W1?9&(H(F=E96MS(BD[#0H@)'%U97)Y(#T@(E-%
M3$5#5" J($923TT@=V5E:W,@5TA%4D4@86-T:79E(#T@,2!/4D1%4B!"62!W
M965K:60@05-#(CL-"B DPT*(&=L;V)A;" D=V5E:RP@)'5S97)I9"P@)'-E;&5C=&5D+" D
M<&]I;G1S.PT*(&=L;V)A;" D<&EC:S$L("1P:6-K,BP@)'!I8VLS+" D<&EC
M:S0L("1P:6-K-2P@)'!I8VLV+" D<&EC:S2 ](")3
M14Q%0U0@9V%M96ED+"!M;VYD87D@1E)/32!G86UE7-Q;%]Q=65R>2@D9V%M97-?
M<75E7-Q;%]N=6U?PT*(" @(" D
M9V%M95]D871A(#T@;7ES<6Q?9F5T8VA?5]S
M='(@(CL-"B @(" @(" @(" @(" D2D[#0H@(" @(" @("!]#0H@(" @(" @("!E;'-E
M#0H@(" @(" @("![#0H@(" @(" @(" @(" @)'%U97)Y7W-T2 N/2 B)'%U97)Y7W-T2D[#0H@(" @(" @("!]#0H@(" @('T-"B @
M(" @96QS90T*(" @("![#0H@(" @(" @("!E8VAO("));B!-;VYD87D@;&]O
M<"!A="!R97-U;'0@PT*(" @(" @(" @(" @
M("1Q=65R>5]S='(@/2 B<&EC:R1I(CL-"B @(" @(" @(" @(" DPT*(" @(" @(" @(" @("1Q=65R>5]S='(@/2 B
M<&EC:R(@+B B)&DB.PT*(" @(" @(" @(" @("1Q=65R>5]V86QU92 ]("(D
M(B N("1Q=65R>5]S='([#0H@(" @(" @(" @(" @96-H;R B475E5]S='(N/$)2/B([#0H@(" @(" @(" @(" @)'-E;&5C
M=%]Q=65R>2 ]("))3E-%4E0@24Y43R!S96QE8W1I;VYS(%9!3%5%4R H;G5L
M;"P@)'5S97)I9"P@)'=E96LL#0H@(" @(" @(" @(" @(" @(" @(" @(" @
M(" D9V%M95]D871A6S!=+" B.PT*(" @(" @(" @(" @("1S96QE8W1?<75E
M5]V86QU92P@)'!O:6YT5]T=V\@/2 D5]T=V\N/$)2/B([#0H@(" @(" @
M(" @(" @)'-E;&5C=%]R97-U;'0@/2!M>7-Q;%]Q=65R>2@D7-Q;%]S96QE8W1?9&(H(F=E96MS(BD[
M#0HD<75E2D[#0HD<75E2 ](")3
M14Q%0U0@=V5E:W1E>'0@1E)/32!W965K5]D
M871A(#T@;7ES<6Q?9F5T8VA?2D[#0H-"FEF("AM>7-Q;%]N=6U?PT*(" @96-H;R B57-I;F<@<')ECTP.R1Z/&UY7-Q;%]Q=65R>2@D=&5A;5]Q=65R>2D[#0H@(" @)&%W87E?9&%T82 ](&UY
M5]D871A6S!=("1A=V%Y7V1A=&%;,5T@0" B
M.PT*(" @("1T96%M7W%U97)Y(#T@(E-%3$5#5"!C:71Y+"!M87-C;W0@1E)/
M32!T96%M7-Q;%]Q=65R>2@D=&5A;5]Q=65R>2D[#0H@(" @
M)&AO;65?9&%T82 ](&UY5LD9V%M95]D871A6S-=72D-"B @(" @("!E8VAO
M(")314Q%0U1%1"([#0H@(" @96-H;R B/B1H;VUE7V1A=&%;,%TB.PT*(" @
M(&5C:&\@(CPO4T5,14-4/B([#0H@(" @:68@*"1G86UE7V1A=&%;-5T@/3T@
M,2D-"B @(" @("!E8VAO("(\5$0@04Q)1TX]7")#14Y415)<(CX\24Y0550@
M5%E013U<(G1E>'1<(B!.04U%/5PB<&]I;G1S7"(@4TE:13U<(C5<(CX\+U1$
M/B([#0H@(" @96QS90T*(" @(" @("!E8VAO("(\5$0@04Q)1TX]7")#14Y4
M15)<(CX\+U1$/B([#0H@(" @96-H;R B/"]44CXB.PT*#0I]#0H_/@T*(" @
M(" @(" \5%(^#0H@(" @(" @(" @(" \5$0@8V]L7!E/2)354)-
M250B(%9!3%5%/2)%;G1E2 ](")314Q%0U0@*B!&4D]-(&=A;65S(%=(15)%('=E
M96L@/2 D=V5E:R!/4D1%4B!"62!G86UE7V1A=&4L(&=A;65?=&EM92([#0H@
M(" @)')E2D[#0H_/@T*/&AT;6P^
M#0H\8F]D>2!B9V-O;&]R/2)B;'5E(CX-"CQ(,SX\/R!E8VAO("1U2 ](")314Q%0U0@8VET>2P@;6%S8V]T
M($923TT@=&5A;7,@5TA%4D4@=&5A;6ED(#T@)&=A;65?9&%T85LT72([#0H@
M(" @)'1E86U?7-Q;%]F971C:%]R;W5]D871A6S%=($ @(CL-"B @(" D=&5A;5]Q=65R>2 ](")314Q%
M0U0@8VET>2P@;6%S8V]T($923TT@=&5A;7,@5TA%4D4@=&5A;6ED(#T@)&=A
M;65?9&%T85LS72([#0H@(" @)'1E86U?7-Q;%]F971C:%]R
M;W5]D871A6S!=(CL-"B @("!E8VAO
M("(\3U!424].(%9!3%5%/5PB)&=A;65?9&%T85LS75PB/B1H;VUE7V1A=&%;
M,%TB.PT*(" @(&5C:&\@(CPO4T5,14-4/B([#0H@(" @:68@*"1G86UE7V1A
M=&%;-5T@/3T@,2D-"B @(" @("!E8VAO("(\5$0@04Q)1TX]7")#14Y415)<
M(CX\24Y0550@5%E013U<(G1E>'1<(B!.04U%/5PB<&]I;G1S7"(@4TE:13U<
M(C5<(CX\+U1$/B([#0H@(" @96QS90T*(" @(" @("!E8VAO("(\5$0@04Q)
M1TX]7")#14Y415)<(CX\+U1$/B([#0H@(" @96-H;R B/"]44CXB.PT*#0I]
M#0H_/@T*(" @(" @(" \5%(^#0H@(" @(" @(" @(" \5$0@8V]L7!E/2)354)-250B(%9!3%5%/2)%;G1EPT*(" @(&1E9F%U;'0Z#0H@(" @(" @("!S=&%R='5P
M*"D[#0H@(" @8G)E86L[#0H@(" @8V%S92 Bhttp://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTE

RE: [PHP-DB] PHP form to search MySQL DB

[Rick Emery]

The error messages have NOTHING to do with the date format.
See my previous email to determine how to determine where error is.

rick

-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 4:52 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP form to search MySQL DB


Ok here is my problem... I have a form on a page named index.php and the
code for the form is as follows:


 *I.E. - Format is 04/01/2001*
 Search for Ads by date:
 
 
 
 
 
 
 

This form is used to supply the variable that we would like to seach the
database by. I.E. by date in this case. The php script that connects to the
database and performs the search is in a file named search01.php. And the
php script is as follows:

Name: ".$row['fname'].", ".$row[' lname']."\n";
   print "Date: ".$row['date']."\n";
}
}
else {
print "No rows found";}
?>

Ok now that I have the form and the search script in place and as I test
it out I recieve an error message on 2 lines regardless of the format of the
date I use (i.e. 10/23/2001, %23%, 2001-23-10, etc.) The error messages are
as follows:

Warning: 0 is not a MySQL result index in search01.php on line 141

Warning: 0 is not a MySQL result index in search01.php on line 143
No rows found

Now that we have the background info out of the way I am wondering what
these error messages mean and how to resolve them.  I have been using a
couple of books as reference when creating this seach page but they do not
cover using a form to pass a variable to a php script for use withing a
select statement against a database.  If anyone has any ideas, suggestions
or otherwise please let me know because I would love to get this script
finished and posted somewhere.  Thanks again.
Jason



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] PHP form to search MySQL DB

[Peter Lovatt]

Hi


echo $query;
echo mysql_error( $mysql_db_link);

is useful for finding query errors (it echos the query itself, and any error
message) but the problem here I think is that you are using 'date' as a
field name and/or variable name. Try using a name which is not a reserved
word.

HTH

Peter



> -Original Message-
> From: Jason [mailto:[EMAIL PROTECTED]]
> Sent: 23 October 2001 22:52
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] PHP form to search MySQL DB
>
>
> Ok here is my problem... I have a form on a page named index.php and the
> code for the form is as follows:
>
> 
>  *I.E. - Format is 04/01/2001*
>  Search for Ads by date:
>  
>  
>  
>  
>  
>  
>  
>
> This form is used to supply the variable that we would like to seach the
> database by. I.E. by date in this case. The php script that
> connects to the
> database and performs the search is in a file named search01.php. And the
> php script is as follows:
>
>  mysql_connect ("db_hostname", "db_username", "db_password");
>
> mysql_select_db ("db_name");
>
> if ($date == "")
> {$date = '%';}
>
> $result = mysql_query ("SELECT
> fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,c
> rmo,cryr,w
> eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
> FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 ");
>
> $count = mysql_num_rows($result);
>
> if (mysql_num_rows($result) )
> {
> while( $row = mysql_fetch_array($result) )
> {
>
>print "Name: ".$row['fname'].", ".$row[' lname']."\n";
>print "Date: ".$row['date']."\n";
> }
> }
> else {
> print "No rows found";}
> ?>
>
> Ok now that I have the form and the search script in place
> and as I test
> it out I recieve an error message on 2 lines regardless of the
> format of the
> date I use (i.e. 10/23/2001, %23%, 2001-23-10, etc.) The error
> messages are
> as follows:
>
> Warning: 0 is not a MySQL result index in search01.php on line 141
>
> Warning: 0 is not a MySQL result index in search01.php on line 143
> No rows found
>
> Now that we have the background info out of the way I am wondering what
> these error messages mean and how to resolve them.  I have been using a
> couple of books as reference when creating this seach page but they do not
> cover using a form to pass a variable to a php script for use withing a
> select statement against a database.  If anyone has any ideas, suggestions
> or otherwise please let me know because I would love to get this script
> finished and posted somewhere.  Thanks again.
> Jason
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Using A Query Results Multiple Times

[Peter Lovatt]

Hi

while(...)
{
do whatever
}

mysql_data_seek ($mysqlresultid, 0)

while(...)
{
do whatever
}

mysql_data_seek ($mysqlresultid, 0)
etc

will set the pointer back to the beginning of the result set, so you can
scan through it as many times as you need to, without needing to repeat the
query.


HTH

Peter

> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: 23 October 2001 19:48
> To: PHP-DB (mailing list) (E-mail); PHP-General (mailing list) (E-mail)
> Subject: [PHP-DB] Using A Query Results Multiple Times
>
>
>   I have an instance where I have to query my MySQL database and then
> use the multiple row results to create multiple pull down menus on a web
> page. My problem is how can I take the results of the query and use them
> more the once to create pull down menus? I've always used a while look to
> fetch each row of the results and have it create the pull down menu as it
> goes through each row. But doing it this way only stores one row
> of results
> in a variable. Is there a way I can grab all the results from a query that
> would go into an array so I could use it multiple times? I've looking
> briefly for a function to MySQL that would allow me to do this but haven't
> found anything unless I misunderstand mysql_fetch_array function.
> At first I
> thought I could loop through my while loop and have it put the
> results from
> the query of each row in to a multidimensional array. But then how would I
> add to the array after the initial row?
>
> BTW, I'm using PHP 3.0.16 so I can't use the added array
> functions that
> PHP 4 has. I do plan on upgrading soon.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] PHP form to search MySQL DB

[Jason]

Ok here is my problem... I have a form on a page named index.php and the
code for the form is as follows:


 *I.E. - Format is 04/01/2001*
 Search for Ads by date:
 
 
 
 
 
 
 

This form is used to supply the variable that we would like to seach the
database by. I.E. by date in this case. The php script that connects to the
database and performs the search is in a file named search01.php. And the
php script is as follows:

Name: ".$row['fname'].", ".$row[' lname']."\n";
   print "Date: ".$row['date']."\n";
}
}
else {
print "No rows found";}
?>

Ok now that I have the form and the search script in place and as I test
it out I recieve an error message on 2 lines regardless of the format of the
date I use (i.e. 10/23/2001, %23%, 2001-23-10, etc.) The error messages are
as follows:

Warning: 0 is not a MySQL result index in search01.php on line 141

Warning: 0 is not a MySQL result index in search01.php on line 143
No rows found

Now that we have the background info out of the way I am wondering what
these error messages mean and how to resolve them.  I have been using a
couple of books as reference when creating this seach page but they do not
cover using a form to pass a variable to a php script for use withing a
select statement against a database.  If anyone has any ideas, suggestions
or otherwise please let me know because I would love to get this script
finished and posted somewhere.  Thanks again.
Jason



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: Warning: MySQL: Unable to save result set

[Leobarod Cortes]

HI there..

I ahve the following issue

Error
MySQL said:


Host 'bbtest' is not allowed to connect to this MySQL server



Do you have any idea what could go wrong???

Leo




Doug Schasteen wrote:

> Warning: MySQL: Unable to save result set in  on
> line ***
>
> I recently upgraded to php 4 from 3. I also upgraded MySQL to 3.23.43 at
> the same time and repopulated my database with a .sql file. Everything
> works fine but I get this warning message every time I do an UPDATE,
> DELETE, or an INSERT. The data still gets updated, deleted or inserted
> though. SELECTs work fine without any problems. Pretty much everything
> works, I just keep getting warning messages.
>
> I searched the web and found that several people have fixed the problem
> in the past by doing myisamchk -r on all the tables. This did not work
> for me.
>
> I also have plenty of diskspace, so I dont think I'm running out of
> room.
>
> These scripts were all working perfectly on another server with php 3
> and a slightly older version of mysql. Also, if I run the SQL commands
> in the commandline they run fine without any warnings.
>
> Any ideas?
>
> - Doug


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Re: PHP and MySQL queries...

[Jason]

Ok I made the changes and now I am getting these 2 errors...
Warning: 0 is not a MySQL result index in search01.php on line 141
  and this one...
Warning: 0 is not a MySQL result index in search01.php on line 143
No rows found
On line 141 - $count = mysql_num_rows($results);
On line 143 - if (mysql_num_rows($results) )
I am not sure what this error message means, does that mean that there were
no results to display? Oh by the way I sincerely want to thank you for
helping me out with this, I have been working on it for a few days and just
today decided I should get help with it.  Thanks again.
Jason

"Rick Emery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> OK.  Ya followed me just a little too literally.  We needed you to
> restructure.  So you're part way there.
> i've made some changes below.
>
> I don't have access to PHP here at work, otherwise I'd test the changes I
> made below.  So you'll have to test them.
>
> You'll note that I placed the while(){} loop where it should be.
> I also split the Name line into two different array elements.  The array
> element names refer directly to the variables after SELECT in your SELECT
> query.
> I did the same in the Phone line.
>
> -Original Message-
> From: Jason Gerfen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 23, 2001 2:23 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Re: PHP and MySQL queries...
>
>
> Ok here is what I have done after your suggestions...
> if ($date == "")
> {$date = '%';}
>
> $result = mysql_query ("SELECT
>
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
> eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
> FROM ads WHERE date LIKE
> '%$date%' LIMIT 0, 30 ");
> $count = mysql_num_rows($results);
>
> if (mysql_num_rows($results) )
> {
> while( $row = mysql_fetch_array($result) )
> {
>
>print "Name: ".$row['fname'].", ".$row[' lname']."\n";
>print "Address: ".$row['address']."\n";
>print "City: ".$row['city']."\n";
>print "State: ".$row['state']."\n";
>print "Zip: ".$row['zip']."\n";
>print "Phone: ".$row['phonea'].", ".$row[' phone']."\n";
>print "Email: ".$row['email']."\n";
>print "Credit Type: ".$row['crty']."\n";
>print "Credit Number: ".$row['crnum']."\n";
>print "Credit Date: ".$row['crmo']."\n";
>print "Weeks: ".$row['weeks']."\n";
>print "Ogden: ".$row['ogden']."\n";
>print "Logan: ".$row['logan']."\n";
>print "IP Address: ".$row['ipaddress']."\n";
>print "Ad: ".$row['ad']."\n";
>print "Total: ".$row['total']."\n";
>print "Ad Number: ".$row['num']."\n";
>print "Date: ".$row['date']."\n";
>print "Time: ".$row['time']."\n";
> }
> }
> else {
> print "No rows found";
> }
> ?>
> After I have uploaded it to the webserver I now get a parse error on line
> 201 and that is the end of the php file, so there isn't anything to
change.
>
> I am still fairly new to this so any help you can provide would be great.
> Thanks again.
> Jason
>
>
> >From: Rick Emery <[EMAIL PROTECTED]>
> >To: 'Jason' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> >Subject: RE: [PHP-DB] Re: PHP and MySQL queries...
> >Date: Tue, 23 Oct 2001 13:13:21 -0500
> >
> >First o all, GET RID of the 19 constructs using mysql_result().  You've
> >already captured the row with the $row=mysql_fetch_array().
> >mysql_result() cannot be mixed with mysql_fetch_arry().
> >
> >So instead of:
> >echo "Address: ";
> >printf(mysql_result($result,$count,"address"));
> >echo "\n";
> >
> >use:
> >print "Address: ".$row['address']."\n";
> >
> >Next, dates are stored in MySQL as -MM-DD.  Use that format in your
> >input.
> >
> >Next, don't combine that "if(mysql_fetch_array())" with the "do while()"
> >Instead, use:
> >
> >if (mysql_num_rows($results) )
> >{
> > while( $row = mysql_fetch_array($result) )
> > {
> > }
> >}
> >else {
> >print "No rows found";
> >}
> >
> >Do the above.  Re-submit.  Tell me the results.  W'ell go from there...
> >
> >rick
> >
> >-Original Message-
> >From: Jason [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, October 23, 2001 12:37 PM
> >To: [EMAIL PROTECTED]
> >Subject: [PHP-DB] Re: PHP and MySQL queries...
> >
> >
> >As of yet I have tried all sorts for date formating for the search field
to
> >work.  I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc.  The date
> >field in the database is stored as 10/23/2001 and yet when a user enters
> >the
> >date and clicks the search button it does not display the results.  I am
> >almost certain that as the user clicks the submit button the php script
is
> >parsing the search string (i.e. 10/23/2001) incorrectly.  I believe it is
> >parsing the sting as 10&nsb;23&nsb;2001 or something to that effect.  If
> >anyone has some more information on this please let me know.  I am pretty
> >sure I have exhausted my resources.
> >
> >"Jason" <[EMAIL PROTECTED]> wrote in message
> >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > I am having a hard time 

Re: [PHP-DB] Re: PHP and MySQL queries...

[Jason Wood]

Let me guess, the parse error is on the last line of the file?

I get that all the time, its usually caused by a loop thats still open...
and, in your case, your "do" and "if" statements arent closed

try this.



mysql_connect ("db_hostname", "db_username", "db_password");

mysql_select_db ("db_name");

if ($date == "")
{$date = '%';}

$result = mysql_query ("SELECT
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
  FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 ");
$count = -1;
if ($row = mysql_fetch_array($result))
 {
  $count ++;
  do
  {
   print "Name: ".$row['fname, lname']."\n";

   if (mysql_num_rows($results) )
   {
 while( $row = mysql_fetch_array($result) )
{
}
   }
   else
   {
print "No rows found";
   }
  }
 }

Let me know if it works!!


--
Jason Wood
Chief Technology Officer
Expressive Tek, Inc.
407 Kehrs Mill Road
Ballwin, MO 63011
Phone 636.256.1362
www.expressivetek.com

"Jason" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Ok here is the script after changes...
> 
> mysql_connect ("db_hostname", "db_username", "db_password");
>
> mysql_select_db ("db_name");
>
> if ($date == "")
> {$date = '%';}
>
> $result = mysql_query ("SELECT
>
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
> eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
>   FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 ");
> $count = -1;
> if ($row = mysql_fetch_array($result)) {
> $count ++;
> do {
> print "Name: ".$row['fname, lname']."\n";
>
> if (mysql_num_rows($results) )
> {
>  while( $row = mysql_fetch_array($result) )
> {
> }
> }
> else {
> print "No rows found";
> }
> ?>
> And now I get a parse error on line 201 which is below the html and php
> code, so there isn't anything to change.  Please help?
>
> "Rick Emery" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > First o all, GET RID of the 19 constructs using mysql_result().  You've
> > already captured the row with the $row=mysql_fetch_array().
> > mysql_result() cannot be mixed with mysql_fetch_arry().
> >
> > So instead of:
> > echo "Address: ";
> > printf(mysql_result($result,$count,"address"));
> > echo "\n";
> >
> > use:
> > print "Address: ".$row['address']."\n";
> >
> > Next, dates are stored in MySQL as -MM-DD.  Use that format in your
> > input.
> >
> > Next, don't combine that "if(mysql_fetch_array())" with the "do while()"
> > Instead, use:
> >
> > if (mysql_num_rows($results) )
> > {
> > while( $row = mysql_fetch_array($result) )
> > {
> > }
> > }
> > else {
> > print "No rows found";
> > }
> >
> > Do the above.  Re-submit.  Tell me the results.  W'ell go from there...
> >
> > rick
> >
> > -Original Message-
> > From: Jason [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 23, 2001 12:37 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Re: PHP and MySQL queries...
> >
> >
> > As of yet I have tried all sorts for date formating for the search field
> to
> > work.  I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc.  The date
> > field in the database is stored as 10/23/2001 and yet when a user enters
> the
> > date and clicks the search button it does not display the results.  I am
> > almost certain that as the user clicks the submit button the php script
is
> > parsing the search string (i.e. 10/23/2001) incorrectly.  I believe it
is
> > parsing the sting as 10&nsb;23&nsb;2001 or something to that effect.  If
> > anyone has some more information on this please let me know.  I am
pretty
> > sure I have exhausted my resources.
> >
> > "Jason" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > I am having a hard time setting up a form for users to enter a date in
> the
> > > format of 00/00/ (of course they would use an actual date).  My
form
> > is
> > > as follows...
> > > 
> > >   *I.E. - Format is 04/01/2001*
> > >   Search for Ads by date:
> > > 
> > >   
> > >   
> > >  > > value="Submit">
> > >  > value="Reset">
> > >   
> > > 
> > > 
> > > On my search.php page I have the following MySQL connection and search
> > > parameters...
> > >  > >
> > > mysql_connect ("db_hostname", "db_username", "db_password");
> > >
> > > mysql_select_db ("db_name");
> > >
> > > if ($date == "")
> > > {$date = '%';}
> > >
> > > $result = mysql_query ("SELECT
> > >
> >
>
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
> > > eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
> > >   FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 ");
> > > $count = -1;
> > > if ($row = mysql_fet

RE: [PHP-DB] Re: PHP and MySQL queries...

[Rick Emery]

OK.  Ya followed me just a little too literally.  We needed you to
restructure.  So you're part way there.
i've made some changes below.

I don't have access to PHP here at work, otherwise I'd test the changes I
made below.  So you'll have to test them.

You'll note that I placed the while(){} loop where it should be.
I also split the Name line into two different array elements.  The array
element names refer directly to the variables after SELECT in your SELECT
query.
I did the same in the Phone line.

-Original Message-
From: Jason Gerfen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 2:23 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: PHP and MySQL queries...


Ok here is what I have done after your suggestions...
if ($date == "")
{$date = '%';}

$result = mysql_query ("SELECT 
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
FROM ads WHERE date LIKE
'%$date%' LIMIT 0, 30 ");
$count = mysql_num_rows($results);

if (mysql_num_rows($results) )
{
while( $row = mysql_fetch_array($result) )
{

   print "Name: ".$row['fname'].", ".$row[' lname']."\n";
   print "Address: ".$row['address']."\n";
   print "City: ".$row['city']."\n";
   print "State: ".$row['state']."\n";
   print "Zip: ".$row['zip']."\n";
   print "Phone: ".$row['phonea'].", ".$row[' phone']."\n";
   print "Email: ".$row['email']."\n";
   print "Credit Type: ".$row['crty']."\n";
   print "Credit Number: ".$row['crnum']."\n";
   print "Credit Date: ".$row['crmo']."\n";
   print "Weeks: ".$row['weeks']."\n";
   print "Ogden: ".$row['ogden']."\n";
   print "Logan: ".$row['logan']."\n";
   print "IP Address: ".$row['ipaddress']."\n";
   print "Ad: ".$row['ad']."\n";
   print "Total: ".$row['total']."\n";
   print "Ad Number: ".$row['num']."\n";
   print "Date: ".$row['date']."\n";
   print "Time: ".$row['time']."\n";
}
}
else {
print "No rows found";
}
?>
After I have uploaded it to the webserver I now get a parse error on line 
201 and that is the end of the php file, so there isn't anything to change.

I am still fairly new to this so any help you can provide would be great.  
Thanks again.
Jason


>From: Rick Emery <[EMAIL PROTECTED]>
>To: 'Jason' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: RE: [PHP-DB] Re: PHP and MySQL queries...
>Date: Tue, 23 Oct 2001 13:13:21 -0500
>
>First o all, GET RID of the 19 constructs using mysql_result().  You've
>already captured the row with the $row=mysql_fetch_array().
>mysql_result() cannot be mixed with mysql_fetch_arry().
>
>So instead of:
>echo "Address: ";
>printf(mysql_result($result,$count,"address"));
>echo "\n";
>
>use:
>print "Address: ".$row['address']."\n";
>
>Next, dates are stored in MySQL as -MM-DD.  Use that format in your
>input.
>
>Next, don't combine that "if(mysql_fetch_array())" with the "do while()"
>Instead, use:
>
>if (mysql_num_rows($results) )
>{
>   while( $row = mysql_fetch_array($result) )
>   {
>   }
>}
>else {
>print "No rows found";
>}
>
>Do the above.  Re-submit.  Tell me the results.  W'ell go from there...
>
>rick
>
>-Original Message-
>From: Jason [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, October 23, 2001 12:37 PM
>To: [EMAIL PROTECTED]
>Subject: [PHP-DB] Re: PHP and MySQL queries...
>
>
>As of yet I have tried all sorts for date formating for the search field to
>work.  I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc.  The date
>field in the database is stored as 10/23/2001 and yet when a user enters 
>the
>date and clicks the search button it does not display the results.  I am
>almost certain that as the user clicks the submit button the php script is
>parsing the search string (i.e. 10/23/2001) incorrectly.  I believe it is
>parsing the sting as 10&nsb;23&nsb;2001 or something to that effect.  If
>anyone has some more information on this please let me know.  I am pretty
>sure I have exhausted my resources.
>
>"Jason" <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I am having a hard time setting up a form for users to enter a date in 
>the
> > format of 00/00/ (of course they would use an actual date).  My form
>is
> > as follows...
> > 
> >   *I.E. - Format is 04/01/2001*
> >   Search for Ads by date:
> > 
> >   
> >   
> >  > value="Submit">
> > value="Reset">
> >   
> > 
> > 
> > On my search.php page I have the following MySQL connection and search
> > parameters...
> >  >
> > mysql_connect ("db_hostname", "db_username", "db_password");
> >
> > mysql_select_db ("db_name");
> >
> > if ($date == "")
> > {$date = '%';}
> >
> > $result = mysql_query ("SELECT
> >
>fname,l

Re: [PHP-DB] Re: PHP and MySQL queries...

[Jason]

Ok here is the script after changes...
Name: ".$row['fname, lname']."\n";

if (mysql_num_rows($results) )
{
 while( $row = mysql_fetch_array($result) )
{
}
}
else {
print "No rows found";
}
?>
And now I get a parse error on line 201 which is below the html and php
code, so there isn't anything to change.  Please help?

"Rick Emery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> First o all, GET RID of the 19 constructs using mysql_result().  You've
> already captured the row with the $row=mysql_fetch_array().
> mysql_result() cannot be mixed with mysql_fetch_arry().
>
> So instead of:
> echo "Address: ";
> printf(mysql_result($result,$count,"address"));
> echo "\n";
>
> use:
> print "Address: ".$row['address']."\n";
>
> Next, dates are stored in MySQL as -MM-DD.  Use that format in your
> input.
>
> Next, don't combine that "if(mysql_fetch_array())" with the "do while()"
> Instead, use:
>
> if (mysql_num_rows($results) )
> {
> while( $row = mysql_fetch_array($result) )
> {
> }
> }
> else {
> print "No rows found";
> }
>
> Do the above.  Re-submit.  Tell me the results.  W'ell go from there...
>
> rick
>
> -Original Message-
> From: Jason [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 23, 2001 12:37 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: PHP and MySQL queries...
>
>
> As of yet I have tried all sorts for date formating for the search field
to
> work.  I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc.  The date
> field in the database is stored as 10/23/2001 and yet when a user enters
the
> date and clicks the search button it does not display the results.  I am
> almost certain that as the user clicks the submit button the php script is
> parsing the search string (i.e. 10/23/2001) incorrectly.  I believe it is
> parsing the sting as 10&nsb;23&nsb;2001 or something to that effect.  If
> anyone has some more information on this please let me know.  I am pretty
> sure I have exhausted my resources.
>
> "Jason" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I am having a hard time setting up a form for users to enter a date in
the
> > format of 00/00/ (of course they would use an actual date).  My form
> is
> > as follows...
> > 
> >   *I.E. - Format is 04/01/2001*
> >   Search for Ads by date:
> > 
> >   
> >   
> >  > value="Submit">
> >  value="Reset">
> >   
> > 
> > 
> > On my search.php page I have the following MySQL connection and search
> > parameters...
> >  >
> > mysql_connect ("db_hostname", "db_username", "db_password");
> >
> > mysql_select_db ("db_name");
> >
> > if ($date == "")
> > {$date = '%';}
> >
> > $result = mysql_query ("SELECT
> >
>
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
> > eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
> >   FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 ");
> > $count = -1;
> > if ($row = mysql_fetch_array($result)) {
> > $count ++;
> > do {
> > echo "Name: ";
> > printf(mysql_result($result,$count,"fname"));
> > echo " ";
> > printf(mysql_result($result,$count,"lname"));
> > echo "\n";
> >
> > echo "Address: ";
> > printf(mysql_result($result,$count,"address"));
> > echo "\n";
> >
> > echo "City: ";
> > printf(mysql_result($result,$count,"city"));
> > echo "\n";
> >
> > echo "State: ";
> > printf(mysql_result($result,$count,"state"));
> > echo "\n";
> >
> > echo "Zip: ";
> > printf(mysql_result($result,$count,"zip"));
> > echo "\n";
> >
> > echo "Phone: (";
> > printf(mysql_result($result,$count,"phonea"));
> > echo ") ";
> > printf(mysql_result($result,$count,"phone"));
> > echo "\n";
> >
> > echo "Email: ";
> > printf(mysql_result($result,$count,"email"));
> > echo "\n";
> >
> > echo "Credit Type: ";
> > printf(mysql_result($result,$count,"crty"));
> > echo "\n";
> >
> > echo "Credit Number: ";
> > printf(mysql_result($result,$count,"crnum"));
> > echo "\n";
> >
> > echo "Credit Card Date: ";
> > printf(mysql_result($result,$count,"crmo"));
> > echo " ";
> > printf(mysql_result($result,$count,"cryr"));
> > echo "\n";
> >
> > echo "Weeks: ";
> > printf(mysql_result($result,$count,"weeks"));
> > echo "\n";
> >
> > echo "town1: ";
> > printf(mysql_result($result,$count,"town1"));
> > echo "\n";
> >
> > echo "town2: ";
> > printf(mysql_result($result,$count,"town2"));
> > echo "\n";
> >
> > echo "town3: ";
> > printf(mysql_result($result,$count,"town3"));
> > echo "\n";
> >
> > echo "IP Address: ";
> > printf(mysql_result($result,$count,"ipaddress"));
> > echo "\n";
> >
> > echo "Ad: ";
> >
> > $ad[$count] = (mysql_result($result,$count,"ad"));
> >
> > $ad[$count] = ereg_replace ("&a&", "'", $ad[$count]);
> > $ad[$count] = ereg_rep

Re: [PHP-DB] keys in mysql

[Jason G.]

You read the mysql manual.

www.mysql.com

Look up alter table.

ALTER TABLE mytable ADD KEY keyname (keyfield1, keyfield2);

-Jason Garber

At 08:33 PM 10/23/2001 -0700, søren eriksen wrote:
>How do I set up secondary keys in mysql?


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Using A Query Results Multiple Times

[Rick Emery]

You're on the right track.  Did you try?:

while( $row[] = mysql_fetch_array($result) );

This should load each result row into a row of a multi-dimensional array.

You would then access it with:

$row[0]['colname']

-Original Message-
From: Adam Douglas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 1:48 PM
To: PHP-DB (mailing list) (E-mail); PHP-General (mailing list) (E-mail)
Subject: [PHP-DB] Using A Query Results Multiple Times


I have an instance where I have to query my MySQL database and then
use the multiple row results to create multiple pull down menus on a web
page. My problem is how can I take the results of the query and use them
more the once to create pull down menus? I've always used a while look to
fetch each row of the results and have it create the pull down menu as it
goes through each row. But doing it this way only stores one row of results
in a variable. Is there a way I can grab all the results from a query that
would go into an array so I could use it multiple times? I've looking
briefly for a function to MySQL that would allow me to do this but haven't
found anything unless I misunderstand mysql_fetch_array function. At first I
thought I could loop through my while loop and have it put the results from
the query of each row in to a multidimensional array. But then how would I
add to the array after the initial row?

BTW, I'm using PHP 3.0.16 so I can't use the added array functions that
PHP 4 has. I do plan on upgrading soon.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Using A Query Results Multiple Times

[Adam Douglas]

I have an instance where I have to query my MySQL database and then
use the multiple row results to create multiple pull down menus on a web
page. My problem is how can I take the results of the query and use them
more the once to create pull down menus? I've always used a while look to
fetch each row of the results and have it create the pull down menu as it
goes through each row. But doing it this way only stores one row of results
in a variable. Is there a way I can grab all the results from a query that
would go into an array so I could use it multiple times? I've looking
briefly for a function to MySQL that would allow me to do this but haven't
found anything unless I misunderstand mysql_fetch_array function. At first I
thought I could loop through my while loop and have it put the results from
the query of each row in to a multidimensional array. But then how would I
add to the array after the initial row?

BTW, I'm using PHP 3.0.16 so I can't use the added array functions that
PHP 4 has. I do plan on upgrading soon.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Cant connect to a remote mySQL database

[Matt Williams]

> Warning: Access denied for user: '[EMAIL PROTECTED]' (Using
> password:
> NO) in /usr/local/apache/htdocs/pruebamysql.php on line 5
>
> Warning: MySQL Connection Failed: Access denied for user:
> '[EMAIL PROTECTED]' (Using password: NO) in
> /usr/local/apache/htdocs/pruebamysql.php on line 5
> 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
> password: NO)
>
>
> And here it is the php.. wher it says localhost, I should only
> type the remote
> IP address?
>
> Form Results 
> 
>
>  $connection = mysql_connect('localhost,'root');
> if ($connection == false){
>   echo mysql_errno().": ".mysql_error()."";
>   exit;
> }

you need to supply the host address (name or ip), your username and
password.

look here for more

www.php.net/mysql_connect

M:


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] keys in mysql

[søren eriksen]

How do I set up secondary keys in mysql?

[PHP-DB] Cant connect to a remote mySQL database

[Leobarod Cortes]

Hi John:

Im trying to connect to a remote mysql database but it seems that this thing
is not working

This is the information that thw browser sent to me:

Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO) in /usr/local/apache/htdocs/pruebamysql.php on line 5

Warning: MySQL Connection Failed: Access denied for user:
'[EMAIL PROTECTED]' (Using password: NO) in
/usr/local/apache/htdocs/pruebamysql.php on line 5
1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)


And here it is the php.. wher it says localhost, I should only type the remote
IP address?

Form Results 


";
  exit;
}
mysql_select_db ('bb50');

$query = "select course_id,course_name from course_main";
$result = mysql_query ($query);

if ($result){
  echo "";
  echo "NumeroNombre del cursoClave
d
el curso";

  $numOfRows = mysql_num_rows ($result);
  for ($i = 0; $i < $numOfRows; $i++){
$coursename = mysql_result ($result, $i, 0);
$courseid = mysql_result ($result, $i, 0);

echo "$i$coursename$courseid";
  }

  echo "";
}
else{
  echo mysql_errno().": ".mysql_error()."";
}

mysql_close ($connection);

?>









John McKown wrote:

> On Fri, 8 Sep 2000, Kevin Xin Lin wrote:
>
> > int mysql_connect ([string hostname [:port] [:/path/to/socket] [, string
> > username [, string password]]])
> > 
> >
> > This is the syntax of mysql_connect, I don't see any db information.
> > What DB is in USE when I create a connection to MySQL? What have I
> > overlooked?
>
> Well, I overlooked it too. The sequence is mysql_connect(),
> mysql_select_db(), then mysql_query(). I overlooked the
> mysql_select_db() as well. I guess that's because I always use the
> "default" database which is the same as my username. Also, I tend to use
> PostgreSQL more often than MySQL, so I forget some of the MySQL
> steps. Sorry about that!
>
> $connect=mysql_connect(...);
> $database=mysql_select_db("foo",$connect);
> $result=mysql_query($query,$connect);
>
> All queries which use $connect will go against the last
> mysql_select_db() which specified $connect (or the default db if it wasn't
> called).
>
> I hope I made more sense this time !
>
> John
>
> P.S. Does anybody know if doing this is more efficient that using the
> mysql_db_query() call? I would think that it might since MySQL would be
> in the correct database already. True?


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Re: PHP and MySQL queries...

[Rick Emery]

First o all, GET RID of the 19 constructs using mysql_result().  You've
already captured the row with the $row=mysql_fetch_array().
mysql_result() cannot be mixed with mysql_fetch_arry().

So instead of:
echo "Address: ";
printf(mysql_result($result,$count,"address"));
echo "\n";

use:
print "Address: ".$row['address']."\n";

Next, dates are stored in MySQL as -MM-DD.  Use that format in your
input.

Next, don't combine that "if(mysql_fetch_array())" with the "do while()"
Instead, use:

if (mysql_num_rows($results) )
{
while( $row = mysql_fetch_array($result) )
{
}
}
else {
print "No rows found";
}

Do the above.  Re-submit.  Tell me the results.  W'ell go from there...

rick

-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 12:37 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: PHP and MySQL queries...


As of yet I have tried all sorts for date formating for the search field to
work.  I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc.  The date
field in the database is stored as 10/23/2001 and yet when a user enters the
date and clicks the search button it does not display the results.  I am
almost certain that as the user clicks the submit button the php script is
parsing the search string (i.e. 10/23/2001) incorrectly.  I believe it is
parsing the sting as 10&nsb;23&nsb;2001 or something to that effect.  If
anyone has some more information on this please let me know.  I am pretty
sure I have exhausted my resources.

"Jason" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am having a hard time setting up a form for users to enter a date in the
> format of 00/00/ (of course they would use an actual date).  My form
is
> as follows...
> 
>   *I.E. - Format is 04/01/2001*
>   Search for Ads by date:
> 
>   
>   
>  value="Submit">
> 
>   
> 
> 
> On my search.php page I have the following MySQL connection and search
> parameters...
> 
> mysql_connect ("db_hostname", "db_username", "db_password");
>
> mysql_select_db ("db_name");
>
> if ($date == "")
> {$date = '%';}
>
> $result = mysql_query ("SELECT
>
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
> eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
>   FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 ");
> $count = -1;
> if ($row = mysql_fetch_array($result)) {
> $count ++;
> do {
> echo "Name: ";
> printf(mysql_result($result,$count,"fname"));
> echo " ";
> printf(mysql_result($result,$count,"lname"));
> echo "\n";
>
> echo "Address: ";
> printf(mysql_result($result,$count,"address"));
> echo "\n";
>
> echo "City: ";
> printf(mysql_result($result,$count,"city"));
> echo "\n";
>
> echo "State: ";
> printf(mysql_result($result,$count,"state"));
> echo "\n";
>
> echo "Zip: ";
> printf(mysql_result($result,$count,"zip"));
> echo "\n";
>
> echo "Phone: (";
> printf(mysql_result($result,$count,"phonea"));
> echo ") ";
> printf(mysql_result($result,$count,"phone"));
> echo "\n";
>
> echo "Email: ";
> printf(mysql_result($result,$count,"email"));
> echo "\n";
>
> echo "Credit Type: ";
> printf(mysql_result($result,$count,"crty"));
> echo "\n";
>
> echo "Credit Number: ";
> printf(mysql_result($result,$count,"crnum"));
> echo "\n";
>
> echo "Credit Card Date: ";
> printf(mysql_result($result,$count,"crmo"));
> echo " ";
> printf(mysql_result($result,$count,"cryr"));
> echo "\n";
>
> echo "Weeks: ";
> printf(mysql_result($result,$count,"weeks"));
> echo "\n";
>
> echo "town1: ";
> printf(mysql_result($result,$count,"town1"));
> echo "\n";
>
> echo "town2: ";
> printf(mysql_result($result,$count,"town2"));
> echo "\n";
>
> echo "town3: ";
> printf(mysql_result($result,$count,"town3"));
> echo "\n";
>
> echo "IP Address: ";
> printf(mysql_result($result,$count,"ipaddress"));
> echo "\n";
>
> echo "Ad: ";
>
> $ad[$count] = (mysql_result($result,$count,"ad"));
>
> $ad[$count] = ereg_replace ("&a&", "'", $ad[$count]);
> $ad[$count] = ereg_replace ("&q&", "\"", $ad[$count]);
> $ad[$count] = ereg_replace ("&p&", "%", $ad[$count]);
> $ad[$count] = ereg_replace ("&bs&", "\\", $ad[$count]);
>
>
> echo $ad[$count];
> echo "\n";
>
> echo "Total: ";
> printf(mysql_result($result,$count,"total"));
> echo "\n";
>
> echo "Ad Number: ";
> printf(mysql_result($result,$count,"num"));
> echo "\n";
>
> echo "Date: ";
> printf(mysql_result($result,$count,"date"));
> echo "\n";
>
> echo "Time: ";
> printf(mysql_result($result,$count,"time"));
> echo "\n";
>
> } while($row = mysql_fetch_array($result));
>
> } else {print "Sorry, no records were found!";}
>
> ?>
> So far I have come to the conclusion that the input from the user is
> probably where my problem is

Re: [PHP-DB] ADORecordset Equivalent in PHP?

[Richard Chauvaux]

I would suggest checking out the classes at 
http://phpclasses.upperdesign.com/browse.html
I've used the mysql_recordset class that is part of the mysql_db 
package. It has the basic methods similar to ADO. I found it to be very 
functional if you're using mysql. There are other classes there as well 
that aren't necessarily mysql oriented. I haven't tried any of those myself.

MrBaseball34 wrote:

> I know about mysql_fetch_array but how would I do it for
> each row into a "recordset" that I can use instead?
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: PHP and MySQL queries...

[Jason]

As of yet I have tried all sorts for date formating for the search field to
work.  I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc.  The date
field in the database is stored as 10/23/2001 and yet when a user enters the
date and clicks the search button it does not display the results.  I am
almost certain that as the user clicks the submit button the php script is
parsing the search string (i.e. 10/23/2001) incorrectly.  I believe it is
parsing the sting as 10&nsb;23&nsb;2001 or something to that effect.  If
anyone has some more information on this please let me know.  I am pretty
sure I have exhausted my resources.

"Jason" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am having a hard time setting up a form for users to enter a date in the
> format of 00/00/ (of course they would use an actual date).  My form
is
> as follows...
> 
>   *I.E. - Format is 04/01/2001*
>   Search for Ads by date:
> 
>   
>   
>  value="Submit">
> 
>   
> 
> 
> On my search.php page I have the following MySQL connection and search
> parameters...
> 
> mysql_connect ("db_hostname", "db_username", "db_password");
>
> mysql_select_db ("db_name");
>
> if ($date == "")
> {$date = '%';}
>
> $result = mysql_query ("SELECT
>
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
> eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
>   FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 ");
> $count = -1;
> if ($row = mysql_fetch_array($result)) {
> $count ++;
> do {
> echo "Name: ";
> printf(mysql_result($result,$count,"fname"));
> echo " ";
> printf(mysql_result($result,$count,"lname"));
> echo "\n";
>
> echo "Address: ";
> printf(mysql_result($result,$count,"address"));
> echo "\n";
>
> echo "City: ";
> printf(mysql_result($result,$count,"city"));
> echo "\n";
>
> echo "State: ";
> printf(mysql_result($result,$count,"state"));
> echo "\n";
>
> echo "Zip: ";
> printf(mysql_result($result,$count,"zip"));
> echo "\n";
>
> echo "Phone: (";
> printf(mysql_result($result,$count,"phonea"));
> echo ") ";
> printf(mysql_result($result,$count,"phone"));
> echo "\n";
>
> echo "Email: ";
> printf(mysql_result($result,$count,"email"));
> echo "\n";
>
> echo "Credit Type: ";
> printf(mysql_result($result,$count,"crty"));
> echo "\n";
>
> echo "Credit Number: ";
> printf(mysql_result($result,$count,"crnum"));
> echo "\n";
>
> echo "Credit Card Date: ";
> printf(mysql_result($result,$count,"crmo"));
> echo " ";
> printf(mysql_result($result,$count,"cryr"));
> echo "\n";
>
> echo "Weeks: ";
> printf(mysql_result($result,$count,"weeks"));
> echo "\n";
>
> echo "town1: ";
> printf(mysql_result($result,$count,"town1"));
> echo "\n";
>
> echo "town2: ";
> printf(mysql_result($result,$count,"town2"));
> echo "\n";
>
> echo "town3: ";
> printf(mysql_result($result,$count,"town3"));
> echo "\n";
>
> echo "IP Address: ";
> printf(mysql_result($result,$count,"ipaddress"));
> echo "\n";
>
> echo "Ad: ";
>
> $ad[$count] = (mysql_result($result,$count,"ad"));
>
> $ad[$count] = ereg_replace ("&a&", "'", $ad[$count]);
> $ad[$count] = ereg_replace ("&q&", "\"", $ad[$count]);
> $ad[$count] = ereg_replace ("&p&", "%", $ad[$count]);
> $ad[$count] = ereg_replace ("&bs&", "\\", $ad[$count]);
>
>
> echo $ad[$count];
> echo "\n";
>
> echo "Total: ";
> printf(mysql_result($result,$count,"total"));
> echo "\n";
>
> echo "Ad Number: ";
> printf(mysql_result($result,$count,"num"));
> echo "\n";
>
> echo "Date: ";
> printf(mysql_result($result,$count,"date"));
> echo "\n";
>
> echo "Time: ";
> printf(mysql_result($result,$count,"time"));
> echo "\n";
>
> } while($row = mysql_fetch_array($result));
>
> } else {print "Sorry, no records were found!";}
>
> ?>
> So far I have come to the conclusion that the input from the user is
> probably where my problem is because I am assuming it is taking the "/" in
> the date they enter and doing something I don't want it to.  In any event
if
> someone could give me a clue as to how to resolve this issue it would be
> greatly appreciated.
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] datetime in MSSQL7

[Frank M. Kromann]

This problem has just been fixed in CVS. 

- Frank

> Hello!
> 
> How can I force PHP to fetch datetime field i 'mmdd hh:mm:ss'  WITHOUT
> using MSSQL query like *SELECT convert(varchar,dtfield,20) as 'dtfield'* and
> so on?
> I have a few tables on MSSQL with the different structures and some of
> fields are datetime. I have to use CLASS in php with querys inside the code
> that are independent on order of fields.
> 
> setlocale? but what?
> 
> regards
> Konrad
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 
> 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: PHP and MySQL queries...

[Jason Wood]

I'm not positive, but try switching the day and month fields.  ie:
28/04/1981   for April 28th, 1981 instead of 04/28/1981

Could work... I know alot of programs, etc, use this format, and I cant
remember offhand right now.  Let me know if it works for you!!


--
Jason Wood
Chief Technology Officer
Expressive Tek, Inc.
407 Kehrs Mill Road
Ballwin, MO 63011
Phone 636.256.1362
www.expressivetek.com



"Jason" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am having a hard time setting up a form for users to enter a date in the
> format of 00/00/ (of course they would use an actual date).  My form
is
> as follows...
> 
>   *I.E. - Format is 04/01/2001*
>   Search for Ads by date:
> 
>   
>   
>  value="Submit">
> 
>   
> 
> 
> On my search.php page I have the following MySQL connection and search
> parameters...
> 
> mysql_connect ("db_hostname", "db_username", "db_password");
>
> mysql_select_db ("db_name");
>
> if ($date == "")
> {$date = '%';}
>
> $result = mysql_query ("SELECT
>
fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
> eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
>   FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 ");
> $count = -1;
> if ($row = mysql_fetch_array($result)) {
> $count ++;
> do {
> echo "Name: ";
> printf(mysql_result($result,$count,"fname"));
> echo " ";
> printf(mysql_result($result,$count,"lname"));
> echo "\n";
>
> echo "Address: ";
> printf(mysql_result($result,$count,"address"));
> echo "\n";
>
> echo "City: ";
> printf(mysql_result($result,$count,"city"));
> echo "\n";
>
> echo "State: ";
> printf(mysql_result($result,$count,"state"));
> echo "\n";
>
> echo "Zip: ";
> printf(mysql_result($result,$count,"zip"));
> echo "\n";
>
> echo "Phone: (";
> printf(mysql_result($result,$count,"phonea"));
> echo ") ";
> printf(mysql_result($result,$count,"phone"));
> echo "\n";
>
> echo "Email: ";
> printf(mysql_result($result,$count,"email"));
> echo "\n";
>
> echo "Credit Type: ";
> printf(mysql_result($result,$count,"crty"));
> echo "\n";
>
> echo "Credit Number: ";
> printf(mysql_result($result,$count,"crnum"));
> echo "\n";
>
> echo "Credit Card Date: ";
> printf(mysql_result($result,$count,"crmo"));
> echo " ";
> printf(mysql_result($result,$count,"cryr"));
> echo "\n";
>
> echo "Weeks: ";
> printf(mysql_result($result,$count,"weeks"));
> echo "\n";
>
> echo "town1: ";
> printf(mysql_result($result,$count,"town1"));
> echo "\n";
>
> echo "town2: ";
> printf(mysql_result($result,$count,"town2"));
> echo "\n";
>
> echo "town3: ";
> printf(mysql_result($result,$count,"town3"));
> echo "\n";
>
> echo "IP Address: ";
> printf(mysql_result($result,$count,"ipaddress"));
> echo "\n";
>
> echo "Ad: ";
>
> $ad[$count] = (mysql_result($result,$count,"ad"));
>
> $ad[$count] = ereg_replace ("&a&", "'", $ad[$count]);
> $ad[$count] = ereg_replace ("&q&", "\"", $ad[$count]);
> $ad[$count] = ereg_replace ("&p&", "%", $ad[$count]);
> $ad[$count] = ereg_replace ("&bs&", "\\", $ad[$count]);
>
>
> echo $ad[$count];
> echo "\n";
>
> echo "Total: ";
> printf(mysql_result($result,$count,"total"));
> echo "\n";
>
> echo "Ad Number: ";
> printf(mysql_result($result,$count,"num"));
> echo "\n";
>
> echo "Date: ";
> printf(mysql_result($result,$count,"date"));
> echo "\n";
>
> echo "Time: ";
> printf(mysql_result($result,$count,"time"));
> echo "\n";
>
> } while($row = mysql_fetch_array($result));
>
> } else {print "Sorry, no records were found!";}
>
> ?>
> So far I have come to the conclusion that the input from the user is
> probably where my problem is because I am assuming it is taking the "/" in
> the date they enter and doing something I don't want it to.  In any event
if
> someone could give me a clue as to how to resolve this issue it would be
> greatly appreciated.
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] PHP and MySQL queries...

[Jason]

I am having a hard time setting up a form for users to enter a date in the
format of 00/00/ (of course they would use an actual date).  My form is
as follows...

  *I.E. - Format is 04/01/2001*
  Search for Ads by date:

  
  


  


On my search.php page I have the following MySQL connection and search
parameters...
Name: ";
printf(mysql_result($result,$count,"fname"));
echo " ";
printf(mysql_result($result,$count,"lname"));
echo "\n";

echo "Address: ";
printf(mysql_result($result,$count,"address"));
echo "\n";

echo "City: ";
printf(mysql_result($result,$count,"city"));
echo "\n";

echo "State: ";
printf(mysql_result($result,$count,"state"));
echo "\n";

echo "Zip: ";
printf(mysql_result($result,$count,"zip"));
echo "\n";

echo "Phone: (";
printf(mysql_result($result,$count,"phonea"));
echo ") ";
printf(mysql_result($result,$count,"phone"));
echo "\n";

echo "Email: ";
printf(mysql_result($result,$count,"email"));
echo "\n";

echo "Credit Type: ";
printf(mysql_result($result,$count,"crty"));
echo "\n";

echo "Credit Number: ";
printf(mysql_result($result,$count,"crnum"));
echo "\n";

echo "Credit Card Date: ";
printf(mysql_result($result,$count,"crmo"));
echo " ";
printf(mysql_result($result,$count,"cryr"));
echo "\n";

echo "Weeks: ";
printf(mysql_result($result,$count,"weeks"));
echo "\n";

echo "town1: ";
printf(mysql_result($result,$count,"town1"));
echo "\n";

echo "town2: ";
printf(mysql_result($result,$count,"town2"));
echo "\n";

echo "town3: ";
printf(mysql_result($result,$count,"town3"));
echo "\n";

echo "IP Address: ";
printf(mysql_result($result,$count,"ipaddress"));
echo "\n";

echo "Ad: ";

$ad[$count] = (mysql_result($result,$count,"ad"));

$ad[$count] = ereg_replace ("&a&", "'", $ad[$count]);
$ad[$count] = ereg_replace ("&q&", "\"", $ad[$count]);
$ad[$count] = ereg_replace ("&p&", "%", $ad[$count]);
$ad[$count] = ereg_replace ("&bs&", "\\", $ad[$count]);


echo $ad[$count];
echo "\n";

echo "Total: ";
printf(mysql_result($result,$count,"total"));
echo "\n";

echo "Ad Number: ";
printf(mysql_result($result,$count,"num"));
echo "\n";

echo "Date: ";
printf(mysql_result($result,$count,"date"));
echo "\n";

echo "Time: ";
printf(mysql_result($result,$count,"time"));
echo "\n";

} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

?>
So far I have come to the conclusion that the input from the user is
probably where my problem is because I am assuming it is taking the "/" in
the date they enter and doing something I don't want it to.  In any event if
someone could give me a clue as to how to resolve this issue it would be
greatly appreciated.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Informix + PHP any gotcha's to watch out for?

[Mark Roedel]

> -Original Message-
> From: davemacgb [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, October 22, 2001 12:12 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Informix + PHP any gotcha's to watch out for?
> 
> 
> I've only used MySQL via PHP until now, does anyone know of 
> any gotchas that I should watch out for?
> 
> The web site will hopefully run on Linux using Apache and PHP.

A few things that I've run into so far:

Make sure that your INFORMIXDIR environment variable is set.  Apache
would segfault on my systems when I tried to use any of the informix
functions otherwise.  I added a line to my apachectl script just to be
sure.

Ifx_connect() doesn't take quite the same parameters as mysql_connect().
The server you're connecting to is specified via either the
INFORMIXSERVER environment variable or one of the ifx default settings
in your php.ini.  (In either case, it's a pointer to an entry in your
INFORMIXDIR/etc/sqlhosts, not a hostname.)  Ifx_connect() also expects
the database name that you're connecting to.

Obviously, in light of the above, there is no ifx_select_db().

Ifx_num_rows() doesn't do the same thing as mysql_num_rows().  It counts
the number of rows that you've viewed from the result set, not the total
number of rows returned.

If you use mysql_fetch_array(), the equivalent Informix function is
ifx_fetch_row().


---
Mark Roedel |  "Blessed is he who has learned to laugh
Systems Programmer  |   at himself, for he shall never cease
LeTourneau University   |   to be entertained."
Longview, Texas, USA|   -- John Powell 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: looped insert

[Russ Michell]

Relax!

$email comes from a text input, and the categories come from checkboxes dynamically 
displayed from 
table column names:

//Get all table column names, dynamically display, and use to accept subscriptions to 
category updates:
$fields = mysql_list_fields("$dbName", "myanet_categories", $connect);
$nocolumns = mysql_num_fields($fields);
for ($i=0; $i<$nocolumns; $i++) {
$names = mysql_field_name($fields, $i) . "\n";
$catselect .= "$names \n";
}

I got it to work thus:

//Start off sql
$sql = "INSERT INTO $myanet02 (";
//start display confirmation of subscribed categories
$category_list = "\n\t";
//loop while categories have been ticked
while(list($key,$val) = each($category)) {
//trim whitespace from the end of $key (inherited from original var declaration of 
'$names' above)
$sql1 .= rtrim($key) . ",";
$sql2 = substr($sql1,0,-1). ")"; 
$sql3 .= "'$email',";
$sql4 = $sql . $sql2 . " VALUES (" . $sql3;
//continue display confirmation of subscribed categories
$category_list .= "$key\n";
}
$category_list .= "";
//Remove the last comma from data to be inserted
$sql = substr($sql4,0,-1) . ")";
$query = mysql_query($sql,$connect) or die(mysql_error());  
$confirm = "You have now been subscribed to the following categories: $category_list";
}
}

Thanks v.much for your concern, but it works quite well now!
Cheers.

Russ

On Tue, 23 Oct 2001 11:39:30 -0400 bill <[EMAIL PROTECTED]> wrote:

> Hi Russ,
> 
> It's not clear that you're keeping track of which categories are being checked.
> 
> You name them category[$names]  but you refer to them as $category[$i] where $i is a 
>number.  How will you know what $category[1] refers to?
> 
> Other issues: It's also not clear where the value of $email comes from.  Nor is it 
>clear if you're trying to obtain one row in the database with all subscriptions or 
>whether
> you could have multiple lines for multiple subscriptions.
> 
> Try this
> 
> while (list($key,$val)= each ($HTTP_POST_VARS[category]) ) {
> 
> $thisname=$key;  // this is the "name" of the checkbox, as in $category[$name]
> $thisval=$val;   // this is the value, which in every case is "yes"
> 
> $sql="INSERT INTO $myanet02($thisname) values ($email)";
> // this will produce a line in the db for each subscription
> 
> // if you want one line for all subscriptions, remvoe the $sql line above and
> // uncomment these lines below
> // to compound the sql and run the query after the while
> 
> // if ($thefields) $thefields .= ", $thisname"; } else { $thefields = 
>"$thisname"; }
> // if($thevalues) $thevalues .= ",'$email' " } else { $thevalues = "'$email'"; }
> 
> $query = mysql_query($sql,$connect) or die(mysql_error());
> 
> } // end while
> 
> // uncomment following lines for single row entry
> // $sql= INSERT INTO $myanet02($thefields) values ($thevalues)";
> // echo $sql;
> // $query = mysql_query($sql,$connect) or die(mysql_error());
> 
> kind regards,
> 
> bill hollett
> 
> Russ Michell wrote:
> 
> > Hi everyone:
> >
> > I've been fiddling with this all day, and well - if it was working you wouldn't be 
>reading this 
> right now! ;-) > My script should take the selections made by users and process them 
>via 
> straightforward MySQL inserts: >
> > //Get all table column names, dynamically display them as checkboxes. Use to 
>process 
> subscriptions: > $fields = mysql_list_fields("$dbName", "myanet_categories", 
>$connect);
> > $columns = mysql_num_fields($fields); > for ($i=0; $i<$columns; $i++) {
> > $names = mysql_field_name($fields, $i) . "\n"; > $catselect .= 
>"$names 
> \n"; >  
>   }
> > > //If submit button selected, process those ticked checkbox categories:
> > if(isset($submit)) { > //loop while categories have been ticked
> > for($i=0;$i 
>if($HTTP_POST_VARS["category{$i}"] 
> == 'yes') { //Not sure about this bit... > $sql = "INSERT 
>INTO $myanet02 
> (staffdev,strategies,rules,news,information,policies) 
> VALUES('$email','$email','$email','$email','$email','$email')"; >
> //$query 
> = mysql_query($sql,$connect) or die(mysql_error()); > echo 
>$sql;
> > } > }
> > } >
> > At the moment not even echoing my $sql works. I know this aint gonna work as it 
>is, because what 
> I really need to know is: >
> > * How do I insert into only those categories that have been checked? (default is 
>'null' in a 
> VARCHAR(50) field) > * How do I only declare '$email' a single time as this is the 
>only value being 
> inserted? >
> > Many thanks: > Russ
> > > #---#
> > >   "Believe nothing - consider everything"
> > >   Russ Michell
> >   Anglia Polytechnic University Webteam >   Room 1C 'The Eastings' East Road, 
>Cambridge
> > >   e: [EMAIL PROTECTED]
> > 

[PHP-DB] Re: looped insert

[bill]

Hi Russ,

It's not clear that you're keeping track of which categories are being checked.

You name them category[$names]  but you refer to them as $category[$i] where $i is a 
number.  How will you know what $category[1] refers to?

Other issues: It's also not clear where the value of $email comes from.  Nor is it 
clear if you're trying to obtain one row in the database with all subscriptions or 
whether
you could have multiple lines for multiple subscriptions.

Try this

while (list($key,$val)= each ($HTTP_POST_VARS[category]) ) {

$thisname=$key;  // this is the "name" of the checkbox, as in $category[$name]
$thisval=$val;   // this is the value, which in every case is "yes"

$sql="INSERT INTO $myanet02($thisname) values ($email)";
// this will produce a line in the db for each subscription

// if you want one line for all subscriptions, remvoe the $sql line above and
// uncomment these lines below
// to compound the sql and run the query after the while

// if ($thefields) $thefields .= ", $thisname"; } else { $thefields = "$thisname"; 
}
// if($thevalues) $thevalues .= ",'$email' " } else { $thevalues = "'$email'"; }

$query = mysql_query($sql,$connect) or die(mysql_error());

} // end while

// uncomment following lines for single row entry
// $sql= INSERT INTO $myanet02($thefields) values ($thevalues)";
// echo $sql;
// $query = mysql_query($sql,$connect) or die(mysql_error());

kind regards,

bill hollett

Russ Michell wrote:

> Hi everyone:
>
> I've been fiddling with this all day, and well - if it was working you wouldn't be 
>reading this right now! ;-)
> My script should take the selections made by users and process them via 
>straightforward MySQL inserts:
>
> //Get all table column names, dynamically display them as checkboxes. Use to process 
>subscriptions:
> $fields = mysql_list_fields("$dbName", "myanet_categories", $connect);
> $columns = mysql_num_fields($fields);
> for ($i=0; $i<$columns; $i++) {
> $names = mysql_field_name($fields, $i) . "\n";
> $catselect .= "$names name=\"category[$names]\" value=\"yes\">\n";
> }
>
> //If submit button selected, process those ticked checkbox categories:
> if(isset($submit)) {
> //loop while categories have been ticked
> for($i=0;$i if($HTTP_POST_VARS["category{$i}"] == 'yes') { //Not sure about this 
>bit...
> $sql = "INSERT INTO $myanet02 
>(staffdev,strategies,rules,news,information,policies) 
>VALUES('$email','$email','$email','$email','$email','$email')";
> //$query = mysql_query($sql,$connect) or die(mysql_error());
> echo $sql;
> }
> }
> }
>
> At the moment not even echoing my $sql works. I know this aint gonna work as it is, 
>because what I really need to know is:
>
> * How do I insert into only those categories that have been checked? (default is 
>'null' in a VARCHAR(50) field)
> * How do I only declare '$email' a single time as this is the only value being 
>inserted?
>
> Many thanks:
> Russ
>
> #---#
>
>   "Believe nothing - consider everything"
>
>   Russ Michell
>   Anglia Polytechnic University Webteam
>   Room 1C 'The Eastings' East Road, Cambridge
>
>   e: [EMAIL PROTECTED]
>   w: www.apu.ac.uk/webteam
>
>   www.theruss.com
>
> #---#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] ADORecordset Equivalent in PHP?

[MrBaseball34]

I know about mysql_fetch_array but how would I do it for
each row into a "recordset" that I can use instead?

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Flatrate - Request 559

Below is the result of your feedback form.  It was submitted by
 ([EMAIL PROTECTED]) on Tuesday, October 23, 2001 at 09:06:48
---

message: 
Introducing
The Newest Flatrate LongDistance Plan
Along With A System To Make $5800 Per Month Using Our Unique System.

email us at [EMAIL PROTECTED]
Include your name, phone number, and best time to call or you will not receive a 
response back.


__
To be romoved from this database email [EMAIL PROTECTED]
__



---


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] PHP/IIF/INFORMIX

[Andreas Schmitz]

Hi,

I have some problems with the interface between windows PHP and
informix. the following constellation is on the windows box:

Windows2000
Microsoft-IIS/5.0
PHP 4.0.6
php_ifx.dll aus PHP 4.0.6 ist installiert
IFX-ClientSDK 2.70 TC1.1

the windows box is used to generate templates for the webserver working
with apache/php and informix IDS2000 (9.21uc4) on solaris.
the guys working on the templates try to use a preview executing a
preview from windows with PHP accessing the content of the
iformix database. It works kind of fine with standard datafields like
varchar, integer etc. if datatypes like lvarchar or even collection
types like set, list etc. appear the preview doesn't work. "ESQL/C :
vorspann : unsupported field type[184]" appears as an 
error message. I suppose PHP needs to be compiled with informix support
on windows. 

is there anybody out there with knowledge about the topic ?

thanks a lot in advance

regards 

-andreas

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: RE: [PHP-DB] looped insert

[Russ Michell]

Gottit at last!:

//If submit button selected, process those ticked checkbox categories:
if(isset($submit)) {
//Start off sql
$sql = "INSERT INTO $myanet02 (";
//loop while categories have been ticked
while(list($key,$val) = each($category)) {
//trim whitespace from the end of $names
$sql1 .= rtrim($key) . ",";
$sql2 = substr($sql1,0,-1). ")"; 
$sql3 .= "'$email',";
$sql4 = $sql . $sql2 . " VALUES (" . $sql3;
}
//Remove the last comma from data to be inserted
$sql = substr($sql4,0,-1) . ")";
$query = mysql_query($sql,$connect) or die(mysql_error());
}

Thanks for the initial pointer Rick! I was simply repeating the inclusion of the 
contents of the 
var: $sql1 (within $sql2 and in $sql4)

Cheers once again.
Russ

On Mon, 22 Oct 2001 12:28:38 -0500 Rick Emery <[EMAIL PROTECTED]> wrote:

> Construct your INSERT a piece at a time.  Something like:
> 
> $sql = "INSERT INTO $myanet02
> (staffdev,strategies,rules,news,information,policies) VALUES(";
> 
> for($i=0;$i   if($HTTP_POST_VARS["category{$i}"] == 'yes') { 
>   $sql .= "\'$email\',";
>   }
>   else {
>   $sql .= "NULL,";
>   }
> }
> $sql = substring($sql,0,-1).")";
> //$query = mysql_query($sql,$connect) or die(mysql_error());
> echo $sql;
> 
> -Original Message-
> From: Russ Michell [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 11:23 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] looped insert
> 
> 
> Hi everyone:
> 
> I've been fiddling with this all day, and well - if it was working you
> wouldn't be reading this right now! ;-)
> My script should take the selections made by users and process them via
> straightforward MySQL inserts:
> 
> //Get all table column names, dynamically display them as checkboxes. Use to
> process subscriptions:
> $fields = mysql_list_fields("$dbName", "myanet_categories", $connect);
> $columns = mysql_num_fields($fields);
> for ($i=0; $i<$columns; $i++) {
>   $names = mysql_field_name($fields, $i) . "\n";
>   $catselect .= "$names  name=\"category[$names]\" value=\"yes\">\n";
>   }
> 
> 
> //If submit button selected, process those ticked checkbox categories:
> if(isset($submit)) {
>   //loop while categories have been ticked
>   for($i=0;$i   if($HTTP_POST_VARS["category{$i}"] == 'yes') { //Not sure
> about this bit...
>   $sql = "INSERT INTO $myanet02
> (staffdev,strategies,rules,news,information,policies)
> VALUES('$email','$email','$email','$email','$email','$email')";
>   //$query = mysql_query($sql,$connect) or
> die(mysql_error());
>   echo $sql;
>   }
>   }
>   }
> 
> At the moment not even echoing my $sql works. I know this aint gonna work as
> it is, because what I really need to know is:
> 
> * How do I insert into only those categories that have been checked?
> (default is 'null' in a VARCHAR(50) field)
> * How do I only declare '$email' a single time as this is the only value
> being inserted?
> 
> Many thanks:
> Russ
> 
> #---#
>   
>   "Believe nothing - consider everything" 
>   
>   Russ Michell
>   Anglia Polytechnic University Webteam
>   Room 1C 'The Eastings' East Road, Cambridge
>   
>   e: [EMAIL PROTECTED]
>   w: www.apu.ac.uk/webteam
> 
>   www.theruss.com
>   
> #---#
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 

#---#

  "Believe nothing - consider everything"   
  
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam

  www.theruss.com

#---#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: RE: [PHP-DB] looped insert

[Russ Michell]

Hi all + Rick:

Since the last email I have got even closer, here is the code:

//If submit button selected, process those ticked checkbox categories:
if(isset($submit)) {
//Start off sql
$sql = "INSERT INTO $myanet02 (";
//loop while categories have been ticked
while(list($key,$val) = each($category)) {
if($val != 'yes') { 
$sql1 .= "$key,";
$sql2 = substr($sql1,0,-1) . ")";
$sql3 .= "'NULL',";
$sql4 = $sql . $sql1 . $sql2 . "VALUES (" . $sql3;
}
else {
$sql1 .= "$key,";
$sql2 = substr($sql1,0,-1) . ")";
$sql3 .= "'$email',";
$sql4 = $sql . $sql1 . $sql2 . "VALUES (" . $sql3;
}   
}
//Remove the last comma
$sql = substr($sql4,0,-1) . ")";
//$query = mysql_query($sql,$connect) or die(mysql_error());
echo $sql;
}

However, this returns the following echoed SQL query:
INSERT INTO myanet_categories (staffdev ,staffdev )VALUES ('[EMAIL PROTECTED]') 

This is almost correct, in that I only selected a single category to INSERT INTO (a 
single email 
being the inserted value). But as you can see, that category has been repeated in the 
list of 
fields to be inserted into. If I select say, 3 categories, then this is what happens:

INSERT INTO myanet_categories (staffdev ,rules ,policies ,staffdev ,rules ,policies )
VALUES ('[EMAIL PROTECTED]','[EMAIL PROTECTED]','[EMAIL PROTECTED]') 

See what I mean?
If anyone has any other pointers I would be more than happy to receive them!!

Cheers
Russ

#---#

  "Believe nothing - consider everything"   
  
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam

  www.theruss.com

#---#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: ifx_connect error

[Andreas Schmitz]

Muciño Zúñiga Marco Antonio wrote:
> 
> I'm trying to connect to a Informix database but I get the error :
> 
> Warning: ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829] in
> /usr/local/apache/htdocs/php/connect.php on line 2
> Imposible conectarse a la base de datos.
> 
> My script is :
> 
>$conn_id = ifx_connect("nomin@compaq6","mmucino","marquito") or die
> ("Imposible conectarse a la base de datos.");
> ?>
> 
> Any suggestion? Thanks.

hi  


did you check the sql-error ?

finderr 1829
-1829   Cannot open file citoxmsg.pam.

The file citoxmsg.pam is missing from the directory $INFORMIXDIR/msg.

If this error occurs, please note all circumstances and contact
Informix Technical Support.

regards 

-andreas

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: RE: [PHP-DB] looped insert

[Russ Michell]

Hi Rick:

Cheers for the info. Thwe following code almost does it, however, the NULL value isn't 
inserted, if 
checkboxes are != to 'yes':

//If submit button selected, process those ticked checkbox categories:
if(isset($submit)) {
//Start off sql
$sql = "INSERT INTO $myanet02 (staffdev,strategies,rules,news,information,policies) 
VALUES(";
//loop while categories have been ticked
for($i=0;$i\n";
}

You can see it happening at:
http://gertrude.anglia.ac.uk/intranet/myanet/index.php

Many thanks.
Russ




On Mon, 22 Oct 2001 12:28:38 -0500 Rick Emery <[EMAIL PROTECTED]> wrote:

> Construct your INSERT a piece at a time.  Something like:
> 
> $sql = "INSERT INTO $myanet02
> (staffdev,strategies,rules,news,information,policies) VALUES(";
> 
> for($i=0;$i   if($HTTP_POST_VARS["category{$i}"] == 'yes') { 
>   $sql .= "\'$email\',";
>   }
>   else {
>   $sql .= "NULL,";
>   }
> }
> $sql = substring($sql,0,-1).")";
> //$query = mysql_query($sql,$connect) or die(mysql_error());
> echo $sql;
> 
> -Original Message-
> From: Russ Michell [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 11:23 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] looped insert
> 
> 
> Hi everyone:
> 
> I've been fiddling with this all day, and well - if it was working you
> wouldn't be reading this right now! ;-)
> My script should take the selections made by users and process them via
> straightforward MySQL inserts:
> 
> //Get all table column names, dynamically display them as checkboxes. Use to
> process subscriptions:
> $fields = mysql_list_fields("$dbName", "myanet_categories", $connect);
> $columns = mysql_num_fields($fields);
> for ($i=0; $i<$columns; $i++) {
>   $names = mysql_field_name($fields, $i) . "\n";
>   $catselect .= "$names  name=\"category[$names]\" value=\"yes\">\n";
>   }
> 
> 
> //If submit button selected, process those ticked checkbox categories:
> if(isset($submit)) {
>   //loop while categories have been ticked
>   for($i=0;$i   if($HTTP_POST_VARS["category{$i}"] == 'yes') { //Not sure
> about this bit...
>   $sql = "INSERT INTO $myanet02
> (staffdev,strategies,rules,news,information,policies)
> VALUES('$email','$email','$email','$email','$email','$email')";
>   //$query = mysql_query($sql,$connect) or
> die(mysql_error());
>   echo $sql;
>   }
>   }
>   }
> 
> At the moment not even echoing my $sql works. I know this aint gonna work as
> it is, because what I really need to know is:
> 
> * How do I insert into only those categories that have been checked?
> (default is 'null' in a VARCHAR(50) field)
> * How do I only declare '$email' a single time as this is the only value
> being inserted?
> 
> Many thanks:
> Russ
> 
> #---#
>   
>   "Believe nothing - consider everything" 
>   
>   Russ Michell
>   Anglia Polytechnic University Webteam
>   Room 1C 'The Eastings' East Road, Cambridge
>   
>   e: [EMAIL PROTECTED]
>   w: www.apu.ac.uk/webteam
> 
>   www.theruss.com
>   
> #---#
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 

#---#

  "Believe nothing - consider everything"   
  
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam

  www.theruss.com

#---#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Creating a file using php

[Jon Farmer]

- Original Message - 
> 
> Polite: Well its easier to post and get a reply rather then me going and
> serching fo it.;)


Easier for who?

Regards

Jon

--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send blank email to [EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]