Re: [PHP-DB] mysqldump

2003-06-02 Thread Gürhan Özen
Hi, Can you show the code? How r u running mysqldump in your php code? I think phpmyadmin has such facility as well, you may want to check their code and see how they did it ... Gurhan On Sat, 2003-05-31 at 06:51, buttoz wrote: hi, i want to backup mysql database. i use mysqldump command .

[PHP-DB] Mail() on OS X

2003-06-02 Thread Tony S. Wu
hi all, i am trying to use mail() on Mac OS X 10.2 WITHOUT sendmail. I have php.ini file in my usr/local/lib directory, with SMTP set to my desire smtp server. But it just doesn't work. Does anyone here know how to use mail() on OS X? Thanks a lot. Tony S. Wu [EMAIL PROTECTED] The world doesn't

Re: [PHP-DB] formatting a timestamp

2003-06-02 Thread Gürhan Özen
Rick, Please give more information about your problem. Are you trying to format a timestamp field in a MySQL table? If yes, you can do something like, SELECT DATE_FORMAT( columnname, '%m-%d-%y : %T-%i' ); Hope this helps... Gurhan On Sat, 2003-05-31 at 01:38, Rick Dahl wrote: I want to print

RE: [PHP-DB] File input from form not detected

2003-06-02 Thread Dewi Wahyuni
Hi everyone I changed the code a bit. Using the file tmp now. Here's the code and the error (still error but less) Thanks for the help upload.php - ? phpinfo(); echo $_POST['userfile']['tmp']; if (is_uploaded_file($_POST['userfile']))

[PHP-DB] array question

2003-06-02 Thread John Coder
After Wracking my brain for too long on this I decided to give in and ask. I have holes in an array that came from a database. I put the holes there with unset some values so no prob. Now I need to fill the holes. Below is what I have and what I need for further manipulations. Array ( [0] =

[PHP-DB] Re: Mail() on OS X

2003-06-02 Thread Manuel Lemos
Hello, On 06/01/2003 10:37 PM, Tony S. Wu wrote: hi all, i am trying to use mail() on Mac OS X 10.2 WITHOUT sendmail. I have php.ini file in my usr/local/lib directory, with SMTP set to my desire smtp server. But it just doesn't work. Does anyone here know how to use mail() on OS X? No, the

[PHP-DB] query string

2003-06-02 Thread Ian Fingold
I'm trying to build a query string for one of my links.. for example... fant_stnd3.php?week=1team=fun%20team I need to be able to grab the values of 'week' and 'team' from an array, I can do that no problem, but when the code runs it cuts off the value if there is a space in the string. so

[PHP-DB] Re: Mail() on OS X

2003-06-02 Thread Tony Wu
thanks for the link, unfortunately, i have trouble getting it to work. and i can't find anything document for it. some instructions, please? also, someone told me before that it's impossible to use mail() on OS X without sendmail. is it true? On Sunday, June 01, 2003, at 07:05PM, Manuel Lemos

Re: [PHP-DB] query string

2003-06-02 Thread Gürhan Özen
On Sun, 2003-06-01 at 22:26, Ian Fingold wrote: I'm trying to build a query string for one of my links.. for example... fant_stnd3.php?week=1team=fun%20team I need to be able to grab the values of 'week' and 'team' from an array, I can do that no problem, but when the code runs it cuts off

[PHP-DB] PHP 4.3.1 maunal PDF

2003-06-02 Thread Creative Solutions New Media
Hi, Does anyone know of there is a PDF version of the manual for PHP 4.3.1 available? Thx Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL PROTECTED] [EMAIL PROTECTED] W: 902 450 5500 C: 902 430 8498 -- PHP Database Mailing List

Re: [PHP-DB] Re: Mail() on OS X [follow up]

2003-06-02 Thread Tony Wu
ok, i've installed a mail server on my machine (CommuniGate). But it still doesn't work. I've specified SMTP server in php.ini. a frind of mine got it to work with the same configure (CommuniGate) and he said he just put his SMTP in php.ini. and now we both have tried to get it to work on two

Re: [PHP-DB] query string

2003-06-02 Thread Ian Fingold
Sorry I don't think I explained very well... heres my situation... I have a mysql database set up... I have a user table with 2 fields...team_name and fant_week. What I want to do is, depending on who is logged in, I want my link to change the value of 'team' to the logged in members team name,

[PHP-DB] remote commands thought www

2003-06-02 Thread Jim
Hey, Where are some actual examples on url commands, ect www.blah.com/modules.phpCOMMANDS. Would really like to know the upload and download and run commands. thanks

Re: [PHP-DB] Re: Mail() on OS X [follow up]

2003-06-02 Thread Manuel Lemos
Hello, On 06/02/2003 12:17 AM, Tony Wu wrote: ok, i've installed a mail server on my machine (CommuniGate). But it still doesn't work. I've specified SMTP server in php.ini. a frind of mine got it to work with the same configure (CommuniGate) and he said he just put his SMTP in php.ini. and now

Re: [PHP-DB] remote commands thought www

2003-06-02 Thread Becoming Digital
Link is bad. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Jim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, 01 June, 2003 23:24 Subject: [PHP-DB] remote commands thought www Hey, Where are some actual examples on url commands, ect

Re: [PHP-DB] query string

2003-06-02 Thread Becoming Digital
Check out http://www.php.net/manual/en/ref.url.php Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Ian Fingold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, 01 June, 2003 23:20 Subject: Re: [PHP-DB] query string Sorry I don't think I explained

Re: [PHP-DB] query string

2003-06-02 Thread Gürhan Özen
On Sun, 2003-06-01 at 23:20, Ian Fingold wrote: Sorry I don't think I explained very well... heres my situation... I have a mysql database set up... I have a user table with 2 fields...team_name and fant_week. What I want to do is, depending on who is logged in, I want my link to change

Re: [PHP-DB] Re: Mail() on OS X

2003-06-02 Thread Manuel Lemos
Hello, On 06/02/2003 02:27 AM, Tony S . Wu wrote: thanks. but unfortunately, i still get errors: Warning: Failed opening '/Library/WebServer/Documents/mime/test.php' for inclusion (include_path='.:/usr/local/lib/php') in Unknown on line 0 the include path is somehow wrong... I would need to

Re: [PHP-DB] mysqldump

2003-06-02 Thread Ronan Chilvers
Hi buttoz Here's how I did it ... function get_script($dbname) { $cmd = /usr/bin/mysqldump -u._DBUSER. -p._DBPASS. ._MDFLAGS. .$dbname; $script = `$cmd`; return $script; } _MDFLAGS is a constant which holds the flags you want to pass to mysqldump ... I commonly use -c

Re: [PHP-DB] query string

2003-06-02 Thread Ronan Chilvers
Hi Ian Comments inline... On 01 Jun,2003 at 23:20 Ian Fingold wrote: snip link will look like this fant_stnd3.php?week=1team=silly team but again, my problem is that it's cutting off the team value when there is a space in the string.. /snip Don't allow spaces in the string ? Are we

[PHP-DB] Dealing with ENUM fields

2003-06-02 Thread Becoming Digital
I have a field in my database for which there are only four potential values and, as such, I would like to use an ENUM field. However, I can't find an easy way to load the values of this field into a select form element. Is there a simple method for doing this or are the only solutions fairly

RE: [PHP-DB] Dealing with ENUM fields

2003-06-02 Thread Lisi
I am forwarding this useful function someone once sent to the list that I use often. Hope this fits your needs. -Lisi -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 7:47 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB]

Re: [PHP-DB] Dealing with ENUM fields

2003-06-02 Thread heilo
Hi! there is a much shorter way to do this (which works with ENUM and SET): $qry = 'SHOW COLUMNS FROM `gruzilla_content` LIKE module'; $res = mysql_query($qry); if(mysql_num_rows($res)0) { $row = mysql_fetch_row($res); $pattern = #(enum|set)\('(.+?)'\)#i; $replace = '\\2';

Re: [PHP-DB] Dealing with ENUM fields

2003-06-02 Thread Becoming Digital
Thanks to both Heilo and Lisi. These scripts should make things easier. Is it safe to assume that we are in agreement about the use of an ENUM field for this application? Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: heilo [EMAIL PROTECTED] To:

Re: [PHP-DB] Dealing with ENUM fields

2003-06-02 Thread Lisi
What's the application? What are the issues with using ENUM verses something else? -Lisi At 05:32 AM 6/2/03 -0400, Becoming Digital wrote: Thanks to both Heilo and Lisi. These scripts should make things easier. Is it safe to assume that we are in agreement about the use of an ENUM field for

Re: [PHP-DB] Dealing with ENUM fields

2003-06-02 Thread heilo
hi! i think it would be better to make a second table because then you do not need any of those scripts and just can use a JOIN. anyways it is better for the database-management to make it as module as possible and saving those 4 values (which do not change?) in a enum-field - i do not know. If

Re: [PHP-DB] query string

2003-06-02 Thread Leif K-Brooks
To answer your question, you should urlencode() the team name. However, I would store the user in a cookie or session, and fetch the team name on each page load. Otherwise, they can easily change which team they're using. Ian Fingold wrote: Sorry I don't think I explained very well... heres