[PHP-DB] 5928 Would you like to lose weight while you sleep? 537417

2001-11-30 Thread 753741ultimate
As seen on NBC, CBS, CNN, and even Oprah! The health discovery that actually reverses aging while burning fat, without dieting or exercise! This proven discovery has even been reported on by the New England Journal of Medicine. Forget aging and dieting forever! And it's Guaranteed! Click

RE: [PHP-DB] Re: Alternating rows pulled from database

2001-11-30 Thread Tim Foster
I'm new to PHP, so I don't know if there are any substantive advantages in execution time to any particular method, but here's what I do (granted, I've never tried it in PHP, but I do it all the time in VBScript). $cols = array("#FF", "#EEFFEE"); for ($i=1; $i<=count(mysql_num_rows($return);

Re: [PHP-DB] MSSQL 2000 and PHP on Linux..

2001-11-30 Thread Todd Williamsen
it doesn't matter what OS you are connecting from, all it cares about is who is connecting and how. MS SQL isn't that picky. As long as you issue the correct commands to connect, no problem at all. look at php.net to see the function to connect to a MS SQL Server box (odbc?) "Andrew Hill" <[EMA

Re: [PHP-DB] How to install gdlibrary on windows 2000?

2001-11-30 Thread Daniel Barton
I volunteer to be a patient with some patience. Sorry to spam a little humor. -db "Frank M. Kromann" wrote: > You can download binaries (from latest cvs) from http://kromann.info/php4.php > > I'm not compiling all binaries at this point, but this page is updated every morning >at 4am. > > If y

Re: [PHP-DB] Help with mail notifying via file upload

2001-11-30 Thread Daniel Barton
Are you positive fileupload.php is passing $userfile to the mail() script? A blank result would seem to indicate that it's not getting passed. You could try passing it through the URL if they're seperate scripts. Or, you could just include the mail() script in fileupload.php, eliminating the ne

[PHP-DB] Help with mail notifying via file upload

2001-11-30 Thread Brian Tegtmeier
Ok here is my story. I have this PHP script that uses a file system and when a person comes to one of my pages, they click the Browse button, click Submit, and get redirected to another page after they have gotten validated for uploading a JPG or Word document. Here is my thing.. I have it set

Re: [PHP-DB] How to install gdlibrary on windows 2000?

2001-11-30 Thread Frank M. Kromann
You can download binaries (from latest cvs) from http://kromann.info/php4.php I'm not compiling all binaries at this point, but this page is updated every morning at 4am. If you want to compile it your self you need MS Visual C++, some libraries (gd, jpeg, png, ttf etc.) some patients. - Fran

[PHP-DB] How to install gdlibrary on windows 2000?

2001-11-30 Thread Andy
Hello, I am trying to install gdlibrary on windows. Unfortunatelly this seams to be too complicated. There are 3 components: zlib, pnglib and gdlibrary. All of them seam to need to be compiled. I did not find binarys for win 2000. Does anybody know a good description on how to install this on win

[PHP-DB] Awkward query - simpler method?

2001-11-30 Thread Daniel Barton
Hi, I can't seem to nail down the simplest way to do this. I've got 10-15 lines of code right now to do something that should take less. The following code extracts the names of all the fields in a table, prints them across a table row in their own cells, and then extracts each record and prin

[PHP-DB] php.ini

2001-11-30 Thread Oli Wilkinson
I need to set the: upload_tmp_dir in my php.ini file on my remote server to enable me to upload files. However, where do I find it on my server to enable me to edit it? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mai

Re: [PHP-DB] How to update all the column types in a table...

2001-11-30 Thread Craig Vincent
> I need to change a varchar into password(varchar) for a password column. > What is the common SQL syntax to do this. > > The table allready has all of the password's stored. I just need to encrypt > them with password($value) > > ...Or will I have to just make a php script to extract and update?

[PHP-DB] R: [PHP-DB] PHP/Mysql

2001-11-30 Thread Riccardi Moreno
This is the value: ; ; Paths and Directories ; 3;1H; include_path= ; UNIX: "/path1:/path2" Windows: "\path1;\path2" doc_root= ; the root of th user_dir=

Re: [PHP-DB] PHP/Mysql

2001-11-30 Thread Paul Warner
> > Hello, > > I've got cobalt raq4 with php(work) and mysql(work) but when I try to > > connect via mysql_connect() this error happens: > > Fatal error: Call to undefined function: mysql_connect() > > This is my php.ini: > > I thing that it's all ok but it doesn't work. > > Any Ideas? > >

[PHP-DB] PHP/Mysql

2001-11-30 Thread Riccardi Moreno
Hello, I've got cobalt raq4 with php(work) and mysql(work) but when I try to connect via mysql_connect() this error happens: Fatal error: Call to undefined function: mysql_connect() This is my php.ini: [MySQL] mysql.allow_persistent = On ; allow or prevent persistent link mysql.max_per

Re: [PHP-DB] How to update all the column types in a table...

2001-11-30 Thread Dobromir Velev
Hi, you can run the following query from your mysql console ot from a php script update table_name set field_name=password(field_name); Be very careful because you will not be able to see the unencrypted data in your table afterwards. I recommend that you backup your table before running the U

RE: [PHP-DB] Re: Alternating rows pulled from database

2001-11-30 Thread Ryan Marrs
Whoops, error in the For statement, that should read: $return = mysql_query("SELECT This FROM That WHERE This = That"); Print " For($i=1;$i<=count(mysql_num_rows($return));$i++) If($i % 2 == 0){$color="color1";} else {$color="color2";} Print " ".

RE: [PHP-DB] Re: Alternating rows pulled from database

2001-11-30 Thread Ryan Marrs
I don't know if this is a better way to do it, but here's how I do it: $return = mysql_query("SELECT This FROM That WHERE This = That"); Print " For($i=1;$i<=count(mysql_num_rows($return);$i++) If($i % 2 == 0){$color="color1";} else {$color="color2";} Print " ".

[PHP-DB] How to update all the column types in a table...

2001-11-30 Thread Trond Erling Hundal
I need to change a varchar into password(varchar) for a password column. What is the common SQL syntax to do this. The table allready has all of the password's stored. I just need to encrypt them with password($value) ...Or will I have to just make a php script to extract and update? __ _

[PHP-DB] Re: Alternating rows pulled from database

2001-11-30 Thread Lee Willmann
I guess it would since you're doing basically the same thing, just a different route. "Mrbaseball34" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > says... > > Here's what I did to get alternating row colors

Re: [PHP-DB] Tables in mysql always corrupted

2001-11-30 Thread Miles Thompson
At 10:32 AM 11/23/2001 +0800, ahakim wrote: >hi world, > >i running php402 + mysql3.23.24beta on pc 800mhz win98. > >when pc hang was occured, then many tables in mysql >was corrupted. > >i always use 'repair tables' command, but can't recover >all record in that table. > >Anyone can help me to

Re: [PHP-DB] set primary key of a mysql-table automatically as value in other tables of the same db

2001-11-30 Thread Dobromir Velev
Hi, First you insert the record in the main table, then using the mysql_insert_id() finction (Check www.php.net/mysql_insert_id for details) you retrieve the new auto_increment value and then you insert the records in the related tables. your script should look something like this: Regards D

[PHP-DB] set primary key of a mysql-table automatically as value in other tables of the same db

2001-11-30 Thread es said
how to set the primary key of a mysql-table automatically as value in other tables of the same db via php? hi there, as being a newbie in this list, i don't know if my problem already has being solved. so here it is: i created a database containing 6 tables: 'main' got the key 'id_main' (intege

Re: [PHP-DB] mysql and regular expressions

2001-11-30 Thread Dobromir Velev
Hi, REGEXP is just a pattern matching operator it will always return true or false. I guess you'll have to use ereg_replace() when using the results of your query. You also can try to use the MID function if the desired result has an absolute position within the string you're matching. Hope t

Re: [PHP-DB] MySQL socket error

2001-11-30 Thread Dobromir Velev
Hi, Check if your MySQL server is working properly - this error usually appears when the MySQL server is down. The other thing is to check whether the socket the MySQL server uses is /tmp/mysql.sock and if it is not modify the php configuration variable MYSQL_SOCKET Hope this helps Dobromir Ve

[PHP-DB] Fw:Requested HolidaySpecial

2001-11-30 Thread usa
To: [EMAIL PROTECTED] From: () Subject: Fw:Requested HolidaySpecial Below is the result of your feedback form. It was submitted by () on Friday, November 30, 2001 at 03:05:27 --- message: