Re: [PHP-DB] Sorting in numerical order, and then randomly

2002-11-17 Thread Peter Beckman
Your options, as I see them, with 3 being the best I could come up with: 1. Make two queries. Depending on how many rows returned, this may be the less taxing option processor wise. 2. Make the random query. As you iterate through them push folks with priority 0 on one stac

[PHP-DB] HTTP Authentication with MySQL/PHP

2002-11-17 Thread David Smith
I have a directory 'admin' that has been .htaccess'ed off. Ie, If you point your browser at that directory, you will be prompted with an HTTP authentication dialog. Nothing special about PHP or MySQL there. I like the security that .htaccess and Apache give me. Now, I have users in a MySQL table w

[PHP-DB] Trying to migrate from Windows php to FreeBSD...

2002-11-17 Thread Rainbear
I have a whole series of PHP scripts that I wrote on a Windows platform, that connect to our MSSQL server and present data from our Goldmine CRM tool. I'd really really really like to put these scripts on our webserver on FreeBSD instead of (blecch) IIS. However.. the mssql bits are apparently

RE: [PHP-DB] Email Encryption?

2002-11-17 Thread Gavin Amm
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Check out this link: http://www.pgpi.org/dev/ It is not exactly PHP material, but maybe if you wanted to contact them & ask them about supporting PHP you might get a response (i'd be interested if you get a responce, as i think having that fu

RE: [PHP-DB] Email Encryption?

2002-11-17 Thread Gavin Amm
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ookey, (i think Richard Hutchins' idea is a good one, and secure enough that most sites use this method... but if you want an alternative...) now i am a newby to security and PHP, but here's my logic: 1. During the account setup (presuming this is

[PHP-DB] Sorting in numerical order, and then randomly

2002-11-17 Thread Lisi
I am using MySQL to store ad information in the following table: CREATE TABLE IF NOT EXISTS ads_value ( img_link varchar(50), text text, service varchar(50) default NULL, title varchar(50) default NULL, priority int(2) default '0', status enum('current', 'old'), ID int(3) NOT

[PHP-DB] Re: DB vs file

2002-11-17 Thread Hp
I think a simple file is better, as it is easier to use doesn't use many resources. If you save it in a DB, you have to use a PHP script every time you need an image (bad for your resources). Apart from that, if you store images in a db it'll slow down that db quite a bit, because images usually ar

[PHP-DB] DB vs file

2002-11-17 Thread Garry Climacosa
I just want to ask which is better saving my jpeg on mysql or saving it as a file in a folder? which is faster and disk space saving? garry

Re: [PHP-DB] Inserting things into the DB

2002-11-17 Thread Rasmus Lerdorf
addslashes() On Sun, 17 Nov 2002, Peter Beckman wrote: > Having a little trouble doing some inserts into a db. > > The problem is escaping the right characters. Data integrity is important. > > Right now, I have taken an email and split it into $body and $header > (containing the respective part