[PHP-DB] All this spam crap

2003-09-08 Thread Lester Caine
Spam may be a problem, but the solution seems to be even 
more of a problem at the moment.

Can anybody do something about all these spam warnings - 
even if it means killing valid users until they fix their 
copy of 'SPAMASSASIN'

I think that some 'real' spam is trying to get onto the list 
as well, but that is actually less of a problem :)

--
Lester Caine
-
L.S.Caine Electronic Services
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP-DB] Re: mySQL Binaries for Linux

2003-09-08 Thread nabil
You just untar it and copy it to a directory like /ur/local/mysql
then copy php.ini to /etc

you read the read me that is in the same directory
shell groupadd mysql
 shell useradd -g mysql mysql
 shell cd /usr/local
 shell gunzip  /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
 shell ln -s full-path-to-mysql-VERSION-OS mysql
 shell cd mysql
 shell scripts/mysql_install_db
 shell chown -R root  .
 shell chown -R mysql data
 shell chgrp -R mysql .
 shell bin/safe_mysqld --user=mysql 
 or
 shell bin/mysqld_safe --user=mysql 
 if you are running MySQL 4.x


John Ryan [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 I downloaded what I thought was Linux mySQL binaries, and the INSTALL file
 said there should be a bin directory when I untar, but there isnt! Just a
 BUILD folder and loads of make files.

 Did I download the wrong one?
 I downloaded mysql-standard-4.0.14-pc-linux-i686.tar.gz

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: Newbie help

2003-09-08 Thread DragonEye WebDesign
 configuring PHP with apache is not that difficult, here's how you should
do
 it:

 You should get 2 files: php4apache.dll and php4ts.dll , normally you only
get these files when you compile
 PHP manually but conecting to PHP is much safer when you use these files,
so if you need to download both versions
 to use these 2 dll's in your automatic install

 I assume you have installed both apache and PHP and that Apache works
fine.
 You should try to get Apache 1.3 and not Apache 2 just because Apache 2
 support in PHP is still experimental and it is not (yet) recommended to
use
 PHP with apache 2.

 you must copy the 2 files to the directory php/sapi
 it is possible that you will have to create the sapi directory.

 When you have done that open the httpd.conf file, you can find this file
in
 your apache/conf directory
 and add these lines to the file

 LoadModule php4_module d:/php/sapi/php4apache.dll
 AddModule mod_php4.c
 AddType application/x-httpd-php .php

 in the first line you should change the path to the path on your pc.

 now restart your pc and start apache

 You should see the message

 Apache 1.3.xx running / PHP 4.x.x.

 your php scripts will work fine now

 Greetz DragonEye
Nicola Hartland [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I need some help to install and configure php I have tried downloading it a
dozen times to configure it on Apache on xp but I cannot seem to get it to
talk to my sql could someone provide me with an idiots guide to installing
it  please?

Thanks in advance

Nicci

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: All this spam crap

2003-09-08 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says...
 Spam may be a problem, but the solution seems to be even 
 more of a problem at the moment.
 
 Can anybody do something about all these spam warnings - 
 even if it means killing valid users until they fix their 
 copy of 'SPAMASSASIN'
 
 I think that some 'real' spam is trying to get onto the list 
 as well, but that is actually less of a problem :)

Perhaps a suitable filter would solve the problem?

-- 
Quod subigo farinam

A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] 2 problems

2003-09-08 Thread Balaji H. Kasal

Hi,

 I am facing 2 problems while using PHP along with form based HTML file. 
It takes inputs from the user and updates the DB.

Problems,
1) Not able to grab and store the checkbox status.
2) Not able to check the correctness of entered interger value. I realized 
that form always submits (POST) the value as text.

 Thanks in advance!

-- 
Regards,
--Balaji

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] 2 problems

2003-09-08 Thread Hutchins, Richard
Not really sure of the second part of your question, but, if I remember
correctly, check boxes only appear in the POST vars if they're checked. And
I'm pretty sure their values are ON. So, if you have a color checkbox named
red and tha user checks it, it should show up as $_POST['color'] = ON. If
the checkbox is not checked, you won't see it in the POST vars at all.

 -Original Message-
 From: Balaji H. Kasal [mailto:[EMAIL PROTECTED]
 Sent: Monday, September 08, 2003 8:24 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] 2 problems
 
 
 
 Hi,
 
  I am facing 2 problems while using PHP along with form based 
 HTML file. 
 It takes inputs from the user and updates the DB.
 
 Problems,
 1) Not able to grab and store the checkbox status.
 2) Not able to check the correctness of entered interger 
 value. I realized 
 that form always submits (POST) the value as text.
 
  Thanks in advance!
 
 -- 
 Regards,
 --Balaji
 
 -- 
 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] 2 problems

2003-09-08 Thread jeffrey_n_Dyke

the value will be what ever you set the value to be in your html tag.
intput type=checkbox name=color value=red
if checked $_POST['color'] will equal red.  if unchecked, the index
'color' will not be in the $_POST array.

hth
Jeff


   
  
  Hutchins, Richard  
  
  [EMAIL PROTECTED]To:   [EMAIL PROTECTED]
   
  ngeusa.com   cc:
  
Subject:  RE: [PHP-DB] 2 problems  
  
  09/08/2003 08:30 AM  
  
   
  
   
  




Not really sure of the second part of your question, but, if I remember
correctly, check boxes only appear in the POST vars if they're checked. And
I'm pretty sure their values are ON. So, if you have a color checkbox named
red and tha user checks it, it should show up as $_POST['color'] = ON. If
the checkbox is not checked, you won't see it in the POST vars at all.

 -Original Message-
 From: Balaji H. Kasal [mailto:[EMAIL PROTECTED]
 Sent: Monday, September 08, 2003 8:24 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] 2 problems



 Hi,

  I am facing 2 problems while using PHP along with form based
 HTML file.
 It takes inputs from the user and updates the DB.

 Problems,
 1) Not able to grab and store the checkbox status.
 2) Not able to check the correctness of entered interger
 value. I realized
 that form always submits (POST) the value as text.

  Thanks in advance!

 --
 Regards,
 --Balaji

 --
 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] Selection problem

2003-09-08 Thread Gary . Every
Try unset after the if statement

if ($nameb == ){
 
  $query = SELECT * FROM recipes WHERE points $pointsb;
 
 } else {
 
  $query = SELECT * FROM recipes WHERE name = '$nameb';
$new_nameb = $nameb;
unset($nameb);

}

Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com


 -Original Message-
 From: Chris Payne [mailto:[EMAIL PROTECTED]
 Sent: Sunday, September 07, 2003 5:43 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Selection problem
 
 
 Hi there everyone,
 
 I'm having a strange problem, I have a form with 2 fields, 1 
 is for points
 (Weightwatcher points) and one is for recipe names.  If you 
 select points
 (IE: 1-3, 3-6,6-9,9 and above) it works perfectly, displays 
 the recipes and
 allows you to select a new points range from the dropdown.
 
 Next to it, on the same form, you can also select by recipe 
 name and ignore
 the points instead selecting by the recipe name - this works 
 fine, you can
 select 1, view it and then select another.
 
 The problem comes when you select a recipe from the dropdown 
 and view it,
 then decide you want to select points instead - the points 
 won't work once
 you have selected a recipe.  Can anyone see anything below 
 that is wrong?  I
 am sure it's the if statement, i'm not sure how to handle it 
 as you can
 select either option to get the result.
 
 Any help would really be appreciated, if I haven't confused 
 you all to death
 :-)
 
 Regards
 
 Chris
 
 ?
 
 if ($nameb == ){
 
  $query = SELECT * FROM recipes WHERE points $pointsb;
 
 } else {
 
  $query = SELECT * FROM recipes WHERE name = '$nameb';
 
 };
 
  $sql_result = mysql_query($query,$connection)
  or die(Couldn't execute query.);
 
  while ($row = mysql_fetch_array($sql_result)) {
  $id = $row[id];
  $name = $row[name];
  $points = $row[points];
  $ingredients = $row[ingredients];
  $instructions = $row[instructions];
 
 };
 
 ?
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


[PHP-DB] Re: [SPAM?] [PHP-DB] Re: Approved - WARNING!!!!

2003-09-08 Thread jsWalter
This is the soBig virus!

Do not open attachement!

Do not open attachement!

Some SMTP servers bounce entire messages, even with attachements!

I hope the admin in here can remove this message from the server and NNTP
server so other do not get catch opening this!

Walter

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: [SPAM?] [PHP-DB] Re: Approved

2003-09-08 Thread jsWalter
This is the soBig virus!

Do not open attachement!

Do not open attachement!

Some SMTP servers bounce entire messages, even with attachements!

I hope the admin in here can remove this message from the server and NNTP
server so other do not get catch opening this!

Walter

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Where is libmysqlclient.so.10 file required for installing php-mysql rpm ?

2003-09-08 Thread shiv shukla
Hi All,

We are using a seperate machine as mysql database server. we have few 
other machines as application server which will use mysql database from 
database server using php. Environment Redhat 8.0, Php 4.2.2-8.0.8, 
apache 2.0

I do not have mysql server or mysql client installed on application 
server. Each application server is running same website in a load 
balancing. I am trying to install php-mysql package to get mysql support 
in php. I am getting following error that libmysqlclient.so.10 library 
not found.

My question is do i need to install mysql to get this library ??. I 
really do not want to install mysql on application servers and i am 
already using database server. Any suggestions will greatly be appreciated.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP-DB] Is it possible to open a .txt file into a recordset for validation?

2003-09-08 Thread karen97214
Want to allow users to upload .txt file and then loop
through it's contents to validate and reject/accept
based on results.

Is this possible?
Got any links, code, etc?

Thanks

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Is it possible to open a .txt file into a recordset for validation?

2003-09-08 Thread John W. Holmes
[EMAIL PROTECTED] wrote:

Want to allow users to upload .txt file and then loop
through it's contents to validate and reject/accept
based on results.
Is this possible?
Got any links, code, etc?
Yes.

http://us2.php.net/manual/en/features.file-upload.php

and then

http://us2.php.net/manual/en/ref.filesystem.php

specifically

http://us2.php.net/manual/en/function.fopen.php

--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals  www.phparch.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP-DB] Best method to search mySQL with PHP?

2003-09-08 Thread Jeff Lewis
Looking for input on best way to search an mySQL table using PHP. 
 
Using LIKE can't be good at all so I was looking into FULLTEXT but then
I started to hear horror stories about the length of time it takes to
build an index and return results on very large databases.
 
Does anyone have any experience with this?
 
Jeff


[PHP-DB] Clueless abt Error with MySql

2003-09-08 Thread Robin Kopetzky
Good Evening!

I have installed Mysql from RedHat 8.0 and am having difficulties starting
mysql. I check the my.cnf file and it appears fine as all files it calls for
are in the right directories. When I attempt to start mysql, I get a cannot
connect through mysql.sock. What is causing this or put more simply, where
did I screw up??

Any help would be appreciated.

Robin 'Sparky' Kopetzky
Black Mesa Computers/Internet Service
Grants, NM 87020

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Clueless abt Error with MySql

2003-09-08 Thread John Coder
On Mon, 2003-09-08 at 19:56, Robin Kopetzky wrote:
 Good Evening!
 
 I have installed Mysql from RedHat 8.0 and am having difficulties starting
 mysql. I check the my.cnf file and it appears fine as all files it calls for
 are in the right directories. When I attempt to start mysql, I get a cannot
 connect through mysql.sock. What is causing this or put more simply, where
 did I screw up??
 Where is it looking for mysql.sock? I believe with rpm based install it
should be in /var/lib/mysql.
if it's looking in tmp just do a symlink to /tmp/mysql.sock and that
should take care of that prob.

John Coder

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php