Re: AW: [PHP-DB] image resizing

2003-11-25 Thread Kim Steinhaug
Imagemagick is THE preferred sollution, since downsizing images makes them blurry. With imagemagick you can sharpen then afterwards, and they are brand new shiny funky thumbs! There is a tutorial on phpbuilder.com which describes and shows a live example on how to incorporate the ImageMagick

[PHP-DB] Re: Validating a Session value

2003-11-25 Thread Kim Steinhaug
First you need to alter you else if statements, you write : If $session_ValueA $100 and $499 set $session_fee=$20 I would write : if(($session_ValueA =100) and ($session_ValueA =499)){ $session_fee=20; } And as you see, you cant evaluate $20 since PHP doesnt know that $20

Re: [PHP-DB] strings of variables,php, sql

2003-11-25 Thread Joffrey Leevy
--- George Patterson [EMAIL PROTECTED] wrote: On Mon, 24 Nov 2003 21:36:29 -0800 (PST) Joffrey Leevy [EMAIL PROTECTED] wrote: Would appreciate in anyone can help me. Let's say I do a query in php, eg. $query = select shed from structure; With the mysql_fetch_array function and a

[PHP-DB] send email

2003-11-25 Thread redhat
I have created a simple form that dumps input information into a mysql database. The person that I created it for said it would be nice if it would also notify him by email that an entry was added to the database. I have no idea where to begin with that - any ideas? thanks, DF -- PHP Database

Re: [PHP-DB] send email

2003-11-25 Thread jeffrey_n_Dyke
www.php.net/mail redhat

RE: [PHP-DB] send email

2003-11-25 Thread Jacob A. van Zanen
Hi, Here a bit of code that I use in a members list (this is the update bit) CODE SNIPPET if (isset ($_GET['update']) OR isset ($_POST['update'])) { $db = @mysql_connect(localhost, username,password); mysql_select_db(walvis,$db); if(isset($_POST['enter'])) {

[PHP-DB] Re: nested sets?

2003-11-25 Thread Hans Lellelid
You may want to try the famous Joe Celko's approach that he described in this book: Book review: SQL for Smarties http://www.phpclasses.org/products.html/id/1558605762.html Also, be sure to check our the PEAR classes DB_NestedSet/MDB_NestedSet which will make using this model much, much

[PHP-DB] Oracle to Sybase PHP question

2003-11-25 Thread Jon Davis
Hello PHP gurus, I have just started to learn PHP, since I have inherited some previous PHP scripts that I must maintain. My question is this: I have to write a script that gets data from a view in Oracle. I then need to insert that data into a Sybase database. Can this be done? This will

RE: [PHP-DB] Splitting a CSV file

2003-11-25 Thread Ryan Jameson (USA)
I've never seen where the file size causes a problem that wasn't one of the file size settings either in the upload form or php.ini. I'd focus on figuring out why it's failing on the large files before trying to split it. No errors at all? Just a blank screen? Are you uploading the file through a

RE: [PHP-DB] send email

2003-11-25 Thread Ryan Jameson (USA)
You may want to loop through the form results and create the message body dynamically based on the info from the form as well. PHP's mail function is the easiest of any scripting language I've used. www.php.net/mail -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] Oracle to Sybase PHP question

2003-11-25 Thread Ryan Jameson (USA)
I haven't done it in a while but Oracle can write to Sybase directly using a linked server connection. PHP should not be necessary in this case. Though PHP is the best scripting language out. :-) Ryan -Original Message- From: Jon Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November

Re: [PHP-DB] Splitting a CSV file

2003-11-25 Thread Tiberiu Ardeleanu
try to parse the csv file line by line and you won't have memory problems ever: === $d = \t; // fields delimiter $fp = fopen ($file_name, r); while ($arr_row = fgetcsv ($fp, 4096, $d, )) { do_something ($arr_row); } fclose ($fp); ===

Re: [PHP-DB] Splitting a CSV file

2003-11-25 Thread Ignatius Reilly
You may have hit the browser time-out limit, which you can not control (at least for IE; don't know about others). To prevent this, arrange for the script send regularly some invisible content to the browser (eg send a HTML comment line every 100 lines of your CSV file) HTH Ignatius

Re: [PHP-DB] Splitting a CSV file

2003-11-25 Thread Chris Payne
Hey there, I just want to thank everyone for their time and help, you've all been so valuable and solved my problems :-) I needed the hidden max_file_size bit in the form. But i'm also going to look at all your other suggestions you've all made, as what you say makes perfect sense from a coding

[PHP-DB] sql query

2003-11-25 Thread pete M
why does this select date(date_file_created) from files create the error error near near '(date_file_created) from files' at line 1 trying to extract the date part of the date_tile filed tia pete -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: sql query

2003-11-25 Thread pete M
got round the problem like this select distinct(to_days(date_file_created)), date_file_created from files Pete M wrote: why does this select date(date_file_created) from files create the error error near near '(date_file_created) from files' at line 1 trying to extract the date part of the

Re: [PHP-DB] Splitting a CSV file

2003-11-25 Thread David T-G
Chris, et al -- ...and then Chris Payne said... % % Hey there, Hiya! % % I just want to thank everyone for their time and help, you've all been so % valuable and solved my problems :-) I needed the hidden max_file_size bit Glad to hear it, and sorry it took me so long to get here. There's

[PHP-DB] Re: send email

2003-11-25 Thread Kim Steinhaug
Well this shouldnt be any problem. I suspect you dont know how to set up the email routine since your asking. All you need to do is insert a sendmail script together with the update of the mySQL database. You could use PHPs internal functions for this, but Ill recommend you using PHPmailer which

Re: [PHP-DB] Re: send email

2003-11-25 Thread howard gramer
I am in the same boat, ( I posted a couple of days ago Subject: Re: [PHP-DB] Send formmail data to Email and Database ), not knowing where to put the Mail() into my own code. I am working on it but no success yet. But, my real question in this topic; with formmail.pl using Sendmail your able

Re: [PHP-DB] Array question

2003-11-25 Thread CPT John W. Holmes
From: ShortStay [EMAIL PROTECTED] How do you delete a value and key from an array? I know the value. You need to know the key. unset($Array[$key]); There are various array functions that'll find the key for you if you know the value. Is it OK to post array questions to the db list? Not

RE: [PHP-DB] Re: send email

2003-11-25 Thread Jack van Zanen
Hi my example earlier does not show the email address in the source of the displayed web page. It is in the source code, but you can change that to be put in a config file and include this file in the script. Jack -Original Message- From: howard gramer [mailto:[EMAIL PROTECTED] Sent:

[PHP-DB] MySql backup

2003-11-25 Thread Robin Kopetzky
Question - if I stop MySql using WinMySqladmin on NT4.0, will I be able to completely backup the data directory or do I need to do something else? This is a commercial application that I need to backup, so it's mighty darned important. Any help is appreciated. Robin 'Sparky' Kopetzky Black Mesa

Re: [PHP-DB] MySql backup

2003-11-25 Thread John W. Holmes
Robin Kopetzky wrote: Question - if I stop MySql using WinMySqladmin on NT4.0, will I be able to completely backup the data directory or do I need to do something else? This is a commercial application that I need to backup, so it's mighty darned important. I don't think PHP can stop MySQL...

[PHP-DB] LIKE % command

2003-11-25 Thread Chris Payne
Hi there everyone, I'm doing a search in my DB using LIKE '%$word%' which works great, but it's not case sensitive, so if I search for bike it WON'T find BIKE, i'm using PHP and MySQL. Probably something very obvious LOL it's just a basic select using LIKE. Chris

[PHP-DB] Selecting date/time from an Access database

2003-11-25 Thread Metin Kale
Hello all.. I've been tasked to retrieve info from an Access database and I've been successful in selecting data and displaying it. But I do have a problem with DATE/TIME data. When I run a query asking for TIME data, I get the value -1 returned. ? $conn = new COM(ADODB.Connection) or