[PHP-DB] need INSERT help

2003-01-27 Thread Addison Ellis
hello, can someone help me with this? i have tried all i know and i am very new at this... my apologies. i am trying to have multiple forms, all with different fields/values, point to one .php that will foreach($HTTP_POST_VARS as $key = $VALUE) 1) check for if ($value == ) 2) ereg function 3)

[PHP-DB] REVISED; need INSERT help

2003-01-27 Thread Addison Ellis
hello again and i am sorry i was not more specififc in my last post. here is where i am confused: else { $today = date(Y-m-d h:m:s); $sql = INSERT INTO ads ()

RE: [PHP-DB] simple mail attachment with php?

2003-01-27 Thread Bruno Pereira
Try that, is very good, i have the same problem and someone send me that, try it. I hope is the right one. Thats just a class, but inside there is the instruction. I put it to work and is very good. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: cornelia es said

[PHP-DB] BLOB

2003-01-27 Thread heilo
Hi everybody out there! Does anybody know a good reference, where I can lern how to insert binary data (e.g. Images) into a BLOB-Field of a MySQL-Database? Any help would be warmely appreciated - Matthias St. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] BLOB

2003-01-27 Thread heilo
Hi everybody out there! Does anybody know a good reference, where I can lern how to insert binary data (e.g. Images) into a BLOB-Field of a MySQL-Database? Any help would be warmely appreciated - Matthias St. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] BLOB

2003-01-27 Thread John W. Holmes
Does anybody know a good reference, where I can lern how to insert binary data (e.g. Images) into a BLOB-Field of a MySQL-Database? Use fopen() to open the image, fread() it into a variable, and insert that variable like you would any other one. If the image is coming from an input type=file

Re: [PHP-DB] BLOB

2003-01-27 Thread heilo
Thxalot! I didn't thought it would be that easy *g* - matthias st. John W. Holmes [EMAIL PROTECTED] [EMAIL PROTECTED] 14:12 Uhr: Does anybody know a good reference, where I can lern how to insert binary data (e.g. Images) into a BLOB-Field of a MySQL-Database? Use fopen() to open the

[PHP-DB] problem configuring PHP 4.3 to get sybase ct_connect to connect

2003-01-27 Thread Art Chevalier
Hello, I recently upgraded from PHP 4.2.3 to 4.3 and Apache 1.3 to 2.+. Previously I wasnt having a problem connecting to Sybase. After the upgrade I cant connect using the ct_connect library. My php.ini file hasnt changed. Any ideas? Here is my error: Warning: sybase_connect()

[PHP-DB] Help/Advice/Suggestions need to Upload 9 images on one submit button.

2003-01-27 Thread Geckodeep
Hi, Can any one guide me through the uploading file procedure please? Should I use copy() function to copy the image file to a temp file and rename it to the real name and then reference the name in the data base. Or is there any other way. Should say though my Service Provider does not support

RE: [PHP-DB] Help/Advice/Suggestions need to Upload 9 images on one submit button.

2003-01-27 Thread John W. Holmes
Can any one guide me through the uploading file procedure please? Should I use copy() function to copy the image file to a temp file and rename it to the real name and then reference the name in the data base. Or is there any other way. Should say though my Service Provider does not support

RE: [PHP-DB] simple mail attachment with php?

2003-01-27 Thread Matthew Moldvan
Did you forget to attach the class? Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc Work: (313) 593-7993 x 116 Cell: (734) 658-0997 http://www.trilogyintl.com/ecommerce/ ---

RE: [PHP-DB] simple mail attachment with php?

2003-01-27 Thread Bruno Pereira
No, you didn't get it? But cornelia es said, just told me that i have mistaken and put an ftp clss, my mistake. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 27 de Janeiro de 2003 17:21 To: 'Bruno

[PHP-DB] too many connections?

2003-01-27 Thread Addison Ellis
hello and thank you. any idea what this means? i have not touched or changed my config.php file since i put it up the first time... it contains my db connect info. also, i just downloaded it from the server to see if it had been modified and it had not. thanks again and best, addison Warning:

Re: [PHP-DB] too many connections?

2003-01-27 Thread John Krewson
This would make a whole lot more sense within a context...such as how busy is your application, what kind of connection you are using (pconnect vs. connect) and so on. A quick search on MySQL's web site resulted in: http://www.mysql.com/doc/en/Too_many_connections.html Be sure to check out

Re: [PHP-DB] too many connections?

2003-01-27 Thread 1LT John W. Holmes
any idea what this means? i have not touched or changed my config.php file since i put it up the first time... it contains my db connect info. also, i just downloaded it from the server to see if it had been modified and it had not. thanks again and best, addison Warning: Too many

[PHP-DB] resolved : Re: [PHP-DB] too many connections?

2003-01-27 Thread Addison Ellis
i searched at mysql.com and it said basically what you are asking. i contacted the server admin and they are going to re-set the server. thank you for your time. best regards, addison Assuming that line 5 is the dbconnect, is there a limit on the number of connections that your MySQL server

[PHP-DB] elseif

2003-01-27 Thread Addison Ellis
hello and thank you for your time. will the below work to check if one field or the other is filled in upon submission? either contact_phone or contact_email is required but not both. best, addison $error = ; if ($name == ) { $error = $errorLIYou must enter a company name./LI; } if

RE: [PHP-DB] elseif

2003-01-27 Thread Ryan Jameson (USA)
You should probably replace $name == with strlen($name) 1. Also, you should probably used $error .= instead of $error = so that you can list all the errors instead of just the last one. Ryan -Original Message- From: Addison Ellis [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27,

Re: [PHP-DB] elseif

2003-01-27 Thread Paul Chvostek
On Mon, Jan 27, 2003 at 06:26:06PM -0600, Addison Ellis wrote: hello and thank you for your time. will the below work to check if one field or the other is filled in upon submission? either contact_phone or contact_email is required but not both. best, addison I would use something

Re: [PHP-DB] backing up databases

2003-01-27 Thread David T-G
Chris -- ...and then Chris Payne said... % % Hi there everyone, Hi! % % I have way too many databases to backup manually or with PHPMyADMIN, how, using PHP with MySQL could I backup multiple databases easily? 1) What level of 'manual' is too much? 2) Are all of the databases on the server

Re: [PHP-DB] Help/Advice/Suggestions need to Upload 9 images on one submit button.

2003-01-27 Thread Rajesh Fowkar
On Mon, Jan 27, 2003 at 05:05:02PM +0100, Geckodeep wrote: Hi, Can any one guide me through the uploading file procedure please? Should I use copy() function to copy the image file to a temp file and rename it to the real name and then reference the name in the data base. Or is there any other

[PHP-DB] MySQL Error

2003-01-27 Thread JordanW
I'm getting this error message when I try the following code: $link = mysql_connect(localhost) or die(Could not connect); print (Connected successfully); mysql_close($link); The scripts outputs: Warning: Can't create TCP/IP socket (10106) in C:\Projects\WebServer\admin.php on

[PHP-DB] Sorting Arrays

2003-01-27 Thread Mark @ Webbiz NZ
Hello, I don't understand arrays that well. If someone can help me sort the contents it would be appreciated. I have data being retrieved from a text file and the fields as an array inserted into another array. orderby is numeric is 1-99 and requires sorting ASC content is just formatted

[PHP-DB] if ($key !=

2003-01-27 Thread Addison Ellis
hello and presumably, thank you again... i have quite a few fields from different forms that are not required and almost as many that are so i have opted to go with if ($key != middle_name) format. in using this can i separate the different fields like so if ($key !=

[PHP-DB] $HTTP_POST_VARS

2003-01-27 Thread Addison Ellis
hello, will this work? $sql = INSERT INTO ads ($HTTP_POST_VARS,createdate) VALUES ('$key','$today'); mysql_query($sql); i have this at the top: foreach ($HTTP_POST_VARS as $key = $value) thanks again, addison ellis -- Addison Ellis small independent publishing co. 114 B 29th

Re: [PHP-DB] $HTTP_POST_VARS

2003-01-27 Thread Micah Stevens
No, if you're trying to store an array in the database, use serialize(); http://www.php.net/manual/en/function.serialize.php Something like this: $serialized_data = serialize($HTTP_POST_VARS); $serialized_data = addslashes($serialized_data); mysql_query(INSERT INTO ads (post_vars, createdate)