RE: [PHP-DB] Re: send email

2003-11-26 Thread Dan Brunner
$header .= "$text\n"; mail($To, $subject, "", $header); } That should do it!! And of course you should send some kind of feedback to the user, so they now it worked as well. I hope this helps. I know there are better ways of doing this, functions or classes. But t

Re: [PHP-DB] Where's the error?

2004-04-08 Thread Dan Brunner
Not even the title?!?! Dan On Apr 8, 2004, at 2:55 PM, [EMAIL PROTECTED] wrote: It is not displaying anything at all. -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 3:52 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Wher

Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Dan Brunner
Hello!!! What is the Length of the varchar field, in your database??? Dan On Friday, January 25, 2002, at 01:22 PM, [EMAIL PROTECTED] wrote: > I'm having a problem with varchar fields out of mssql which are only > returning value lenghts < = 256 characters. > > I know that the php.ini sett

Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Dan Brunner
G Web Developer, > Systems Administrator > Oregon Health Sciences University > (503) 418-4282 > cell: (503) 913-5367 > page: x15897 > fax: (503) 494-1888 > > > > >>>> Dan Brunner <[EMAIL PROTECTED]> 01/25/02 11:31AM >>> > Hello!!! > > What is

RE: [PHP-DB] FIle Uploading to database

2002-02-03 Thread Dan Brunner
Hello!!! You can do something like this $pat = array("#", "@", "*", "&", "%", "@","$","'","`"); $w= '_'; $pic_name2 = str_replace ($pat, $w, stripslashes($pic_name)); $query = "INSERT INTO Travel_Design (Tavel_Design, Design_Name, Season, Date, name, files

Re: [PHP-DB] Re: FIle Uploading to database

2002-02-04 Thread Dan Brunner
Hey did you get it to work yet?!?! Dan On Sunday, February 3, 2002, at 09:08 PM, [EMAIL PROTECTED] wrote: > Umm.. > > SET parameter is for the UPDATE query > > > "Adam Royle" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >> You missed the SET parameter in

Re: [PHP-DB] Re: FIle Uploading to database

2002-02-04 Thread Dan Brunner
statement works fine now, but the file isn't being uploaded. > I cannot figure out why > > -Original Message- > From: Dan Brunner [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 04, 2002 7:54 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-

Re: [PHP-DB] Re: FIle Uploading to database

2002-02-04 Thread Dan Brunner
GOOD What was the problem!?!? Dan On Monday, February 4, 2002, at 01:44 PM, [EMAIL PROTECTED] wrote: > Ok, > > I got it woohoo!!! > > It works! > > Thanks for all your help > > -Original Message- > From: Dan Brunner [mailto:[EMAIL PROTECTED]] > S

Re: [PHP-DB] Searching Documents

2002-02-08 Thread Dan Brunner
Hello!!! Use LIKE in your Select statement...Like this!! $sql = "Select File_Name From Table2 WHERE File_Name LIKE '%$Search%'"; $Search would come from a form... Dan On Friday, February 8, 2002, at 09:06 AM, [EMAIL PROTECTED] wrote: > I was wondering if there is a way to search documents

Re: [PHP-DB] optimizing script...

2002-02-15 Thread Dan Brunner
Hello... Try this... $pat = array("\", "@", "*", "&", "%"); $with = (_) \\What ever you want... $car_year = str_replace ($pat, $with, stripslashes($car_year)); echo $car_year; This would work with ONE VARIABLE... I suppose maybe you could make the Variables($car_type,$car_mod

Re: [PHP-DB] Re: forced page links...

2002-02-27 Thread Dan Brunner
Hello!! What I would do is have both the 2 page and the last page on the the same page!! All my pages are only two...a form page and a processing page...that's it However You could also have a variable pass from page to page, like a hidden variable, either in a form, or with cookie

RE: [PHP-DB] accessing system cmds w/ PHP

2002-02-27 Thread Dan Brunner
Hello... Try exec() I know it works moving files. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 7:37 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] accessing system cmds w/ PHP Can anyone tell me how to access linux syste

Re: [PHP-DB] easy date format question

2002-03-04 Thread Dan Brunner
Hello!! it should be $today = Date("Y"-"m"-"d"); Dan On Friday, March 1, 2002, at 04:50 PM, [EMAIL PROTECTED] wrote: > should be simple as pie, of course, but i can't find a straightforward > syntax example in the documentation. i'm trying to change the PHP date > format to mysql's. > > my

RE: [PHP-DB] any php/Linux gurus out there?

2002-03-04 Thread Dan Brunner
Hello!! First uninstall your old version of php(php-4.0.6-9.7.0) Then install the new RPM If you're using the Red Hat update thingy... Or download the source and recompile it!! Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04,

Re: [PHP-DB] records into an editable box

2002-03-06 Thread Dan Brunner
Hello!! Do you mean a textarea?? And you want to populate the "textarea" with the data, right? Dan On Wednesday, March 6, 2002, at 01:34 AM, [EMAIL PROTECTED] wrote: > How would I change this sql statement to pull the db table and display > it > within an editable box within a form? Any h

RE: [PHP-DB] include() statement hell!

2002-03-27 Thread Dan Brunner
Has anybody told him to check his PHP.INI??? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 6:28 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] include() statement hell! #1. You may want to double-check the path w

Re: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Dan Brunner
Hello!! What I was able to do was this On every form page I have, I have a checkbox that is labeled "Ok To Save", that the user would check or not.. I would then pass that variable to the next page and check to see if the value was true or not... If it is true then it would continue

Re: [PHP-DB] AOL Problems

2002-04-09 Thread Dan Brunner
Hello!! So is the old value of "new location" not being passed to the next page? OR Is the new "category" variable not being passed to the next page?? Dan On Tuesday, April 9, 2002, at 12:44 PM, [EMAIL PROTECTED] wrote: > Hi group, > > I wonder if anyone can help me with some prob

Re: [PHP-DB] auto-increment question

2002-04-23 Thread Dan Brunner
Hello!! ALTER TABLE table1 AUTO_INCREMENT = 1000; That should do it... You can use that anytime.. Dan On Tuesday, April 23, 2002, at 12:21 AM, [EMAIL PROTECTED] wrote: > Hi all, > > I'm wondering if there is a way to start an auto-increment field at a > number > other than 1. I'm working on

Re: [PHP-DB] Search tutroial

2002-04-24 Thread Dan Brunner
Hello!! Use LIKE in your WHERE clause... You can also more then when Field Example. $query = "SELECT uid, id, image, iname, quantity, type FROM {$config["prefix"]}_shop WHERE iname LIKE = '%$shopsearch% ORDER BY iname'"; $ret = mysql_query($query); while(list($quantity

Re: [PHP-DB] Search Script

2002-04-25 Thread Dan Brunner
WHERE iname LIKE '%$shopsearch% ORDER BY > iname'"; > > HTH > > Maureen > > > Jennifer Downey <[EMAIL PROTECTED]> said: > >> Hi all, >> >> I have been trying to build a search script for my site that deals >> with only >> o

Re: [PHP-DB] Need help urgent!!

2002-09-26 Thread Dan Brunner
Check your register_globals value in your PHP.INI!! Dan On Thursday, September 26, 2002, at 11:48 AM, [EMAIL PROTECTED] wrote: > I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't pass vars > from > 1 php to the other how i fix it? > > Thanks > > > > -- > PHP Database Mailing List

Re: [PHP-DB] uploading

2002-11-05 Thread Dan Brunner
Hello... ... ... ... $pat = array("#", "@", "*", "#", "@", "$","'", "`"); $w= '_'; $pic_name2 = str_replace ($pat, $w, stripslashes($pic_name)); $query = "INSERT INTO Travel_Design (Travel_Design_Num, Season, Date, name, filesize, filetype ) VALUES ( '$Travel_Design_Num', '$Season', '$Da

Re: [PHP-DB] mssql_fetch_array problem

2001-06-19 Thread Dan Brunner
Hello!!! Try using the second argument of mysql _fetch_array MYSQL_NUM This will insure that an integer is used.. If not let me knowI'll do testing... Dan Brunner On Monday, June 18, 2001, at 11:18 PM, Jennifer Arcino Demeterio wrote: > hello all, > > hope

Fw: [PHP-DB] PHP redirect?

2001-08-01 Thread Dan Brunner
OPPS WRONG SENDER HAHAHAHAHA! I'm a little absent minded Hello!!! Here try this if ($DATABASE===Custom) { $table=Table1; } if ($DATABASE===Return_Log) { $table=table=3; $DATABASE=Return_Log; echo (""); echo (""); echo (" $us On Linux

Re: [PHP-DB] Backups, best practices

2001-09-06 Thread Dan Brunner
Hey Hey Hey!!! That depends on what system your running!?!?!? I run LinuxPPC and use 3 ways 1. Bru Tape back system 2. At 12:00 AM the shell script runs and copies the files.. 3. Once a month I manually copy the files to a zip. Dan PS WindowsGood luck. On Thursday, September 6,

[PHP-DB] Require() and Performance hit...

2001-09-25 Thread Dan Brunner
Hello!! A simple question... Has anybody had a performance hit, when using multiple Require() and Include() functions?? Just askingI use them all the timeBut want to simplify the code. Tanks!! Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMA

Re: [PHP-DB] i know i caused u a headache:)

2001-09-26 Thread Dan Brunner
Yep He is right... Use php to do the variable Dan On Wednesday, September 26, 2001, at 08:05 AM, Dave Watkinson wrote: > you need to do ?brand= > > > > -Original Message- > From: its me [mailto:[EMAIL PROTECTED]] > Sent: 26 September 2001 14:11 > To: [EMAIL PROTECTED] > Subje

Re: [PHP-DB] i know i caused u a headache:)

2001-09-26 Thread Dan Brunner
anyname' "; > $result=mysql_query($sql,$conn); > $num=mysql_num_rows($result); > $cur=0; > while($num> $cur) > { > $row=mysql_fetch_array($result); > $brand=$row["brand"]; > echo "$brand"; > $cur++; > } > ?> > > &

Re: [PHP-DB] Looking for a JavaScript routine built by PHP and populated from MySQL

2001-11-08 Thread Dan Brunner
Hello!! So you have a page that show pics and you want to have something that show the next and back url...right??? Dan On Thursday, November 8, 2001, at 04:23 PM, Doug Daulton wrote: > Hello, > > I need to build a chunk of code which creates a click through view of > all > pictures in a g

Re: [PHP-DB] Resource Id #2

2002-01-23 Thread Dan Brunner
something like: > > $query="select var1 from table1 where var2='$var3' > and var4='$var5'"; > > $somevar=mysql_query($query) or die.. yada yada > echo $somevar; > > I tried your code, and it works wonderfully! Thanks so much. :) &

Re: [PHP-DB] Resource Id #2

2002-01-23 Thread Dan Brunner
AHAHAHHAHA AHHAHAHAH Dan On Wednesday, January 23, 2002, at 02:19 PM, [EMAIL PROTECTED] wrote: > Dan, > >> Good, I'm glad it worked!!! >> >> I see a lot of people using mysql_fetch_array(). >> >> Which is fine...But I'm more into Object Oriented programming...and >> that's why I always

Re: [PHP-DB] Email an attached file

2003-05-29 Thread Dan Brunner
ot;); $mess .= ("\n"); $mess .= ("\n"); $mess .= ("Here is that Pic you wanted..."); sendfile($To, $sub, $mess, $cc, $From, $file2, $type); //- Of course all of the $To,$sub,etc...etc...etc...are from posting the data from a

Re: [PHP-DB] Email an attached file

2003-05-29 Thread Dan Brunner
4 PM, [EMAIL PROTECTED] wrote: I am storing the file on my server. -Original Message- From: Dan Brunner [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 2:42 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Email an attached file Hello!! If your storing the f

Re: [PHP-DB] address info, forms, maintanance

2003-06-05 Thread Dan Brunner
Hello!! Are talking about the same "Post Question"??? On another words, what is being duplicated?? If not, you can use auto_increment. Dan On Wednesday, June 4, 2003, at 03:13 PM, [EMAIL PROTECTED] wrote: I need to modify some company web pages that include a form for asking the company

Re: [PHP-DB] Re: textarea with multiple rows and mysql insert

2003-10-10 Thread Dan Brunner
What is your field length??? Varchar(10)?? You should set the column type to text. Dan On Oct 10, 2003, at 10:27 AM, [EMAIL PROTECTED] wrote: I have a form that includes two text areas that span multiple rows. The first textarea (rows=2, cols=50) is used to insert a pretty long url, while t

Re: [PHP-DB] Can't conect with mysql_connect(), please help.

2003-10-14 Thread Dan Brunner
Hello!! Does that file "/var/lib/mysql/mysql.sock" exist?!!?!? Check to make sure mysql is running. Dan On Oct 14, 2003, at 4:34 PM, [EMAIL PROTECTED] wrote: I'm starting to use MySQL, well, trying to, and I get the next message: Warning: mysql_connect(): Can't connect to local MySQL server

Re: [PHP-DB] Can't conect with mysql_connect(), please help.

2003-10-14 Thread Dan Brunner
abled MYSQL_SOCKET /var/lib/mysql/mysql.sock but in fact the file /var/lib/mysql/mysql.sock doesn't exists. So I understand that the first step is to check the configuration of MySQL, is it? "Dan Brunner" <[EMAIL PROTECTED]> escribió en el mensaje news:[EMAIL PROTECTED] Hello!!

Re: [PHP-DB] removing space ?

2003-10-28 Thread Dan Brunner
Hello. Use ltrim(). $image = ltrim($data->JPG_Name); echo $image; Or use trim() Or http://www.php.net/manual/en/ref.strings.php Dan On Oct 28, 2003, at 4:11 PM, [EMAIL PROTECTED] wrote: When I select data from my data base I have spaces on the lead side for example the data that is