Re: [PHP-DB] Calendar Question

2003-02-24 Thread Paul Burney
at: http://www.burney.ws/software/library.php?id=20 Hope that helps. Sincerely, Paul Burney http://paulburney.com/ Q: Tired of creating admin interfaces to your MySQL web applications? A: Use MySTRI instead. Version 3.1 now available. http://mystri.sourceforge.net

Re: [PHP-DB] Making a text wrapper

2003-02-22 Thread Paul Chvostek
doesn't do what you need, and the extra comments on that page don't provide additional resources that are useful for you, then perhaps you can provide more details on the php-general list, where this will be a little more on topic. -- Paul Chvostek [EMAIL

Re: [PHP-DB] file and https

2003-02-21 Thread Paul Burney
support, nor want to upgrade to PHP 4.3.x, you may be able to call a command line utility directly. For example, I've used this in the past: passthru('curl https://secure.example.com/some-file.html'); Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep

Re: [PHP-DB] Is my Hosting service full of it?

2003-02-09 Thread Paul Chvostek
be glad to provide further clarification if desired. I just have a real feeling that I'm not getting knowledgable answers. You are, they do, and you are. -- Paul Chvostek [EMAIL PROTECTED] Operations / Abuse / Whatever it.canada, hosting

Re: [PHP-DB] elseif

2003-01-27 Thread Paul Chvostek
co. [EMAIL PROTECTED] [EMAIL PROTECTED] -- Paul Chvostek [EMAIL PROTECTED] Operations / Abuse / Whatever it.canada, hosting and development http://www.it.ca/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] dates and updates recommendation?

2003-01-26 Thread Paul Chvostek
should be aware of with any particular field types? Thanks. :) -- Paul Chvostek [EMAIL PROTECTED] Operations / Abuse / Whatever it.canada, hosting and development http://www.it.ca/ -- PHP Database Mailing List (http

Re: [PHP-DB] Find and replace in a string

2003-01-26 Thread Paul Chvostek
need to wrap it. The better you can predict the input data, the cleaner the code you can use to parse it. Learn the regexps. -- Paul Chvostek [EMAIL PROTECTED] Operations / Abuse / Whatever it.canada, hosting and development http

Re: [PHP-DB] Cookies problems

2003-01-22 Thread Paul Burney
, you won't see the echo unless you reload. You may also wish to look at the documentation for the setcookie (not sendcookie) function: http://www.php.net/manual/en/function.setcookie.php HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count

Re: [PHP-DB] Array problems

2003-01-22 Thread Paul Burney
format it needs the data in and we'll help you figure out how to get it from the database into that format. If you can't figure out what format of data the class needs, you should let us see the graph class source. HTH. Sincerely, Paul Burney http://paulburney.com/ ?php if ($your_php_version

Re: [PHP-DB] Efficiency

2003-01-21 Thread Paul Burney
) = MySQL_fetch_row(MySQL_query($q,$dbh)); The $my_count variable now has your number of rows. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ Q: Tired of creating admin interfaces to your MySQL web applications? A: Use MySTRI instead. http://www.burney.ws/software/mystri/ -- PHP

Re: [PHP-DB] image in mysql?

2003-01-21 Thread Paul Burney
. Check the archives: http://marc.theaimsgroup.com/?l=php-db Also, a google search: http://www.google.com/search?q=mysql+php+image+blob Turns up a good tutorial as the first result: http://www.phpbuilder.com/columns/florian19991014.php3 Hope that helps. Sincerely, Paul Burney http

Re: [PHP-DB] session_destroy(); on submit?

2003-01-21 Thread Paul Burney
value=http://www.etc.com; thank you and best, addison No, it will not work. PHP is server side, JavaScript (onClick, etc.) is client side. Have the form submit to a PHP page that has the session functions at the top. HTH. Sincerely, Paul Burney http://paulburney.com/ Q: Tired of creating

Re: [PHP-DB] Recursive SQL Expression?

2003-01-17 Thread Paul Burney
/1,289483,sid13_gci537290,00.html http://www.dbmsmag.com/9605d06.html http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm Hope that helps. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP Database Mailing List

Re: [PHP-DB] extract() expects first argument to be an array

2003-01-17 Thread Paul Burney
MySQL_fetch_assoc instead. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ Q: Tired of creating admin interfaces to your MySQL web applications? A: Use MySTRI instead. http://www.burney.ws/software/mystri/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Crash in OCI8 driver

2003-01-13 Thread Paul Rensing
. Maybe there is a particular shutdown sequence that I need to follow? Anybody experience similar problems? Thanks in advance, Paul Rensing -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql time format

2003-01-07 Thread Paul Burney
that result to build a query like that above. (You could also use one of the php mysql_field_* functions.) HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Re: Breaking up new lines for e-mail

2003-01-07 Thread Paul Burney
= str_replace(\n,\r\n,$text); // all to windows HTH. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Serve images from files, or db?

2002-12-31 Thread Paul Chvostek
when coming up with a strategy for these two projects? What are the strengths and weaknesses of storing files in a BLOB versus storing pointers to those files? Thanks. :) -- Paul Chvostek [EMAIL PROTECTED] Operations / Abuse / Whatever

Re: [PHP-DB] The ability of accessing DB

2002-12-30 Thread Paul Burney
. Check phpinfo() to see if sybase persistent connections are allowed, and if you aren't using the default database, make sure you are calling the sybase_select_db() command before the queries. http://www.php.net/manual/en/function.sybase-select-db.php HTH. Sincerely, Paul Burney http

Re: [PHP-DB] How can I use PHP to duplicate a mysql templatedatabase? [hack] bug

2002-12-18 Thread Paul Burney
If the databases are on the same server, I think you can do (c) as the following: INSERT INTO $new_database.$tablename SELECT * FROM $old_database.$tablename; If it's a remote server, I think it would require you to do it in PHP (ouch). Hope that helps. Sincerely, Paul Burney http://paulburney.com

Re: [PHP-DB] Delay Confirmation....

2002-12-09 Thread Paul Burney
of the sleep(10) command. Why do you want to sleep instead of giving the results to the user as soon as they are ready? Is it a security issue so the server doesn't get flooded with automated requests? Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts

[PHP-DB] Forums?

2002-11-22 Thread Paul Ihrig
hey guys. a friend want help setting up a forum. what are some good easy to use ones out there? thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] any free php mySql Host's?

2002-11-13 Thread Paul Ihrig
Hey guys. i have a host at cfm-resources.com for coldfusion but now that i am getting into php. i would like to find a free host. any ones out there? thanks. -paul Whatever you can do, or dream you can, begin it. Boldness has genius, power, and magic in it. - Goethe web developer

[PHP-DB] date questions in mySql

2002-11-12 Thread Paul Ihrig
ok i can parse a date from mySql date field so it displays as: 08/06/1972 but if i insert it into the field in this format then the date gets hosed. do i have to insert as -mm-dd can i have a form field that has mm/dd/ but then change it on insert? how would i do this? thanks. -paul

[PHP-DB] Moving mySql db's odbc

2002-11-09 Thread Paul Ihrig
, but i guess i don't need it to connect to the mySql server through PHP? thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Order DB through url toggle

2002-11-08 Thread Paul Ihrig
is make it a toggle between table name ASC or DESC.. any ideas? thanks. -paul #$orderBy = 'priFirstName'; $orderBy = 'priLastName'; if (isset($HTTP_GET_VARS['orderBy'])) { $orderBy = $HTTP_GET_VARS['orderBy']; } #?orderBy=priFirstName $maxRows_rsAll = 5;; $pageNum_rsAll = 0; if (isset

RE: [PHP-DB] Order DB through url toggle

2002-11-08 Thread Paul Ihrig
well i tried that.. but it out puts the right number. but it is not taking that var to switch ACS or DESC... http://localhost/php/default2.php?orderBy=priLastNamedir=0 http://localhost/php/default2.php?orderBy=priLastNamedir=1 /* here we set up out order by clause */ $orderBy = 'priLastName';

RE: [PHP-DB] Order DB through url toggle

2002-11-08 Thread Paul Ihrig
($database_myFirstSql, $myFirstSql); $query_rsAll = SELECT * FROM userinfo ORDER BY $orderBy $diri; -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] URGET HELP : Logic Help - for first record do_thisfor each record after do_that

2002-10-25 Thread Paul Burney
'; while (result = something) { if ($first_record == 'yes') { do_something(); $first_record == 'no'; } else { do_something_else(); } } HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count

Re: [PHP-DB] Log Application Formatting Issue...

2002-10-18 Thread Paul Burney
as suggested by someone else, but instead of directly outputting the result, store it into another array. Then reverse that array in php and display it. HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List

Re: [PHP-DB] Calendar

2002-10-17 Thread Paul Burney
based calendar in PHP. DevShed is good place for other PHP tutorials as well. HTH. Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Obsession for Oil

2002-10-15 Thread Paul Burney
on 10/15/02 12:29 AM, CK Raju at [EMAIL PROTECTED] appended the following bits to my mbox: Reports of US annexing Iraq appears to be highly disturbing. The oil If (!preg_match('/php/',$message_body)) { redirect_message('/dev/null'); } -- PHP Database Mailing List

Re: [PHP-DB] Re: file upload and php (Not a begginer [sic]question!)

2002-10-15 Thread Paul Burney
because if you support HTTP-KeepAlive, you have only one connection instead of the two or more needed for each FTP request. It also works reliably in nearly all browsers whereas some may not support ftp. HTH, Paul -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts

Re: [PHP-DB] PhpHoo_create database phpHoo\p\g

2002-10-01 Thread Paul Burney
at the MySQL command prompt. mysql ? Hope that helps. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Still can't turn magic_quotes off!

2002-09-20 Thread Paul Burney
/manual/en/function.ini-set.php HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] set_magic_quotes_runtime???

2002-09-18 Thread Paul Burney
, that option is related to quoting for certain database queries. Specifically, it adds a ' to every ' character. If you are able to use .htaccess files to override settings on the server, you could try something like this: php_value magic_quotes_gpc 0 Hope that helps. Sincerely, Paul Burney http

Re: [PHP-DB] MySQL timestamp field update problem

2002-09-11 Thread Paul DuBois
At 11:59 -0500 9/11/02, Rob Day wrote: Hi all, I have a table in MySQL with the following field: 'time_date' timestamp(14) NOT NULL When a record is inserted into the table, NULL is inserted into the time_date field giving me a normal timestamp with the time of the INSERT. That much is

Re: [PHP-DB] transactions and persitent connections

2002-09-01 Thread Paul DuBois
At 12:52 +0900 9/1/02, Jean-Christian Imbeault wrote: Paul Dubois wrote: I am worried that if I use persistent connections it might be possible for more than one PHP script to be inside the same transaction at the same time. Not at the *same* time, because although a persistent connect

Re: [PHP-DB] transactions and persitent connections

2002-08-31 Thread Paul DuBois
At 17:46 +0900 8/31/02, Jean-Christian Imbeault wrote: I'm a little confused/worried about database transactions, persistent connections and PHP. I am worried that if I use persistent connections it might be possible for more than one PHP script to be inside the same transaction at the same

Re: [PHP-DB] Connecting to FileMaker Server?

2002-08-27 Thread Paul Burney
the FileMaker unlimited client connected to the FileMaker server. You can then use the native XML output from the Web Companion or one of the previously mentioned php scripts. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count

Re: [PHP-DB] How can you include an https?

2002-07-30 Thread Paul Burney
: http://php.us.themoes.org/manual/en/ref.curl.php I'd suggest looking for an RPM that has them included. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
figure out why I'm having this problem. It should not be happening at all. Is there some size limitation to the array created via mysql_fetch_array()? Is there some other function that will accomodate my data? Is there any custom code to handle my data correctly? Thanks, Paul Worthington [EMAIL

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
Thank you for that idea. I don't think that's it, though, because this script is the only one I'm ever running on this site. The problem is perfectly consistent and repeatable, which leads me to believe it's something in the way the array is being built. Paul Worthington [EMAIL PROTECTED

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
trying to figure out why, and how I can work around this problem. Thanks again, Paul Worthington [EMAIL PROTECTED] Andrey Hristov [EMAIL PROTECTED] wrote in message 01ed01c237ea$0d0fcf10$1601a8c0@nik">news:01ed01c237ea$0d0fcf10$1601a8c0@nik... Do you have PhpMyAdmin installed? If you

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Burney
on 7/30/02 10:34 AM, Paul Worthington at [EMAIL PROTECTED] appended the following bits to my mbox: I'm using this PHP code, very simple and straightforward, to select two columns into an array and then display the results in an HTML table

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
. Paul Mark A. Roedel [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... -Original Message- From: Paul Worthington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 9:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql_fetch_array limit? - more

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
My mistake: I was setting the limit myself via an incorrect column definition whilst creating a temporary table. I feel so stupid. Thanks for trying to help me. Paul Kodrik [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I use mysql_fetch array to

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
Problem solved. I was stupidly overlooking an incorrect column definition in a temporary table. Everything's fine now. Thank you so much for trying to help me, and please excuse my errors. Paul Richard Hutchins [EMAIL PROTECTED] wrote in message 1EA7D3AE70ACD511BE6D006097A78C1E022BF618@USROCEXC

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
Thanks for all your helpful suggestions. It turns out I was limiting the array myself by setting a temporary table column definition to varchar(255). I have been overlooking it all this time. I feel so stupid. Thanks again for trying to help me. Paul Paul Burney [EMAIL PROTECTED] wrote

[PHP-DB] Is there a size limit in mysql_fetch_array?

2002-07-29 Thread Paul Worthington
is there, but mysql_fetch_array will only grab the first 255 bytes of it. Is there a limit built into mysql_fetch_array? What can you recommend I use instead, to make sure I'm always getting the complete contents of a database column? Thank you very much, in advance, Paul Worthington [EMAIL PROTECTED] -- The views

Re: [PHP-DB] Header problem

2002-07-15 Thread Paul Burney
that the location needs to include the scheme and FQDN, i.e., http://example.com/file.php Some browsers (notably Lynx) complain or don't work with relative Location headers. It's also possible that the . is causing a problem. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self

Re: [PHP-DB] Final Year Computer Science Project involving PHP

2002-07-12 Thread Paul Cooper
, and probably has a few bugs, and also has stuff yet to be implemented. This is a challenging project worthy of a very high mark (if you, or anyone else, can get it working that is). HTH, Paul On Fri, 2002-07-12 at 16:13, Serdar Sokmen wrote: Hi, Please read the rest of this email if you're

Re: [PHP-DB] PDF/FDF Support

2002-07-03 Thread Paul Burney
be the default case in Windows, but I know from experience that it is a PITA on old Macs. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] delete multiple records with one query

2002-07-01 Thread Paul DuBois
At 22:37 -0400 7/1/02, Matt Nigh wrote: hi, i'm trying to delete multiple records at once from a mysql db and can't seem to figure out how to do so. here's the code i've been trying to troubleshoot with: $result_insert = mysql_query(delete from $mysql_table where id = '8' AND where id = '18');

Re: [PHP-DB] Excel to MySQL??

2002-06-29 Thread Paul DuBois
At 15:21 -0600 6/29/02, Chase wrote: Does anyone know of a way that I can export an Excel spreadsheet to a file that I can import to MySQL? I found a program that will do this for Access, but I would rather leave Access out of this if possible. Thanks!! Chase Does it have to be written in

[PHP-DB] Re: XML

2002-06-27 Thread Paul DuBois
At 21:33 -0400 6/27/02, MikeParton wrote: Would be interesting to hear from Peter on why he feels the urge to store XML docs in MySQL (or, better said: I would be interested in hearing what he is trying to accomplish and why he...or someone...feels XML stored in a relational database is the way

Re: [PHP-DB] MySql password

2002-06-24 Thread Paul DuBois
At 14:58 -0400 6/24/02, Page Works Web Solutions wrote: Hi all, I have a Cobalt Raq 4 running Linux. I've installed the .pkg file RaQ3-RaQ4-MySQL-3.23.37-1.pkg I can telnet into the server and I type mysql, now I see that I'm in MySql, but when I type bin/mysqladmin -password and put a

[PHP-DB] Problem w/ mysql_pconnect

2002-06-23 Thread Paul D
I'm using PHP 4.2.0 with MYSQL 3.23. When I try to use either the mysql_connect or mysql_pconnect to access the database, I get the following error message: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have tried different user names and nothing seems to work. If I use

RE: [PHP-DB] Innodb and transactions.

2002-06-21 Thread Paul DuBois
At 8:55 -0400 6/21/02, Steve Bradwell wrote: So should I be using Innodb tables or BDB tables? You have to be using *some* kind of transaction-safe tables (InnoDB and BDB qualify). If you use a table type like MyISAM, then all statements are committed as they execute, and use of a transaction

Re: [PHP-DB] how expensive is mysql_connect in performance

2002-06-21 Thread Paul DuBois
At 22:39 -0400 6/21/02, Michael Zornek wrote: I'm just getting into some stuff where I seem to be making a lot of mysql_connect and mysql_close calls. I wonder, how taxing is this on the server? Not very. MySQL's connection-establishment sequence is pretty efficient. mysql_pconnect() by

Re: [PHP-DB] resource id#2 - ????

2002-06-12 Thread Paul DuBois
At 11:42 -0600 6/12/02, Jas wrote: Not sure how to over come this, the result of a database query keeps giving me this: ?php /* Get Ip address, where they came from, and stamp the time */ if (getenv(HTTP_X_FORWARDED_FOR)){ $ipaddy = getenv(HTTP_X_FORWARDED_FOR); } else { $ipaddy =

Re: [PHP-DB] case

2002-06-11 Thread Paul Burney
, Paul Burney http://paulburney.com/ ?php // the statement formerly known as prince if ($the_elevator == 'tries to bring you down') { go_crazy('punch a higher floor'); } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Anyone know why this won't return results?

2002-06-07 Thread Paul DuBois
At 17:45 -0400 6/7/02, Blaine Dinsmore wrote: html head titleResults Test/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body bgcolor=#FF text=#00 ?php $server = mdotlims; $user = httpuser; $pass = pass; $db = mysql_connect($server,$user,$pass);

Re: [PHP-DB] MySQL problem on Yellow Dog Linux

2002-06-06 Thread Paul Burney
that mentions MySQL as well. HTH. Sincerely, Paul Burney http://paulburney.com/ ?php // the statement formerly known as prince if ($the_elevator == 'tries to bring you down') { go_crazy('punch a higher floor'); } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Re: how to create a graph from a db?

2002-06-04 Thread Paul Willard
Take a look phplot.php http://www.phplot.com Chris Payne wrote: Hi there everyone, I have a db and the last column is id2 ? this adds a 1 everytime a banner is clicked so that I can track which banners are being clicked the most ? that works great, no problems ? but how can I get the

Re: [PHP-DB] db sql issue from var

2002-05-27 Thread Paul Burney
the above code, it would succeed. Just a word of warning. Sincerely, Paul Burney http://paulburney.com/ ?php // the statement formerly known as prince if ($the_elevator == 'tries to bring you down') { go_crazy('punch a higher floor'); } ? -- PHP Database Mailing List (http

Re: [PHP-DB] translating password($var) back to text

2002-05-03 Thread Paul DuBois
At 15:47 -0700 5/3/02, John Hughes wrote: I am setting up a PHP-mySQL login script. One key feature I need is the ability automatically to e-mail people their password when they forget it. Obviously, I can store the password without using password() and retrieve it at any time. Is it possible to

[PHP-DB] Spaces Problem php mysql

2002-05-01 Thread Paul
this. Do I have to take the first entry apart with string functions to get my desired end, which is the entire name in one field in the database? TIA, Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How do I assign Oracle pakage variable's value to aphp variable?

2002-04-30 Thread Paul Edmondson
-- Paul Edmondson, Software Engineer Yospace: Creating Value for Wireless 7 The Courtyard, High Street, Staines, UK, TW18 4DR Tel: +44 1784 466388 Fax: +44 1784 466387 http://www.yospace.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] selected problem

2002-04-26 Thread Paul Burney
. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Date of Birth From Form

2002-04-19 Thread Brandon Paul
Hey all, I have a credit application form, and one of the required elements is the applicant's Date of Birth. I have creditapp table with a birthdate field and it is a DATE datatype. On the form, I want to be able to have them enter their Date of Birth as mm/dd/ and have it go into the

Re: [PHP-DB] PHP and OCI NLS behaviour

2002-04-18 Thread Paul Edmondson
. -- Paul Edmondson, Software Engineer Yospace: Creating Value for Wireless 7 The Courtyard, High Street, Staines, UK, TW18 4DR Tel: +44 1784 466388 Fax: +44 1784 466387 http://www.yospace.com -- PHP Database Mailing List (http

Re: [PHP-DB] Any idea what's wrog with this query?

2002-04-18 Thread Paul Edmondson
-- Paul Edmondson, Software Engineer Yospace: Creating Value for Wireless 7 The Courtyard, High Street, Staines, UK, TW18 4DR Tel: +44 1784 466388 Fax: +44 1784 466387 http://www.yospace.com -- PHP Database Mailing List (http

Re: [PHP-DB] Oracel 9i connection problems.

2002-04-16 Thread Paul Edmondson
(0x4000) On Tue, 2002-04-16 at 16:49, Thies C. Arntzen wrote: On Tue, Apr 16, 2002 at 04:48:19PM +0100, Paul Edmondson wrote: Hello there, I have a problem with getting php-4.2.0 RC4 connecting to an Oracle 9i (9.0.1) database running locally. I am running Apache 2.0.35 on SuSE 7.3

Re: [PHP-DB] Closing curly brackets?

2002-04-13 Thread Paul Burney
id if statement /* More code after this point */ } // end while if statement. === Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP

[PHP-DB] Upload Multiple Images

2002-04-11 Thread Brandon Paul
having to type each one in and submit it? Your help would be very much appreciated! Thanks, Brandon Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Updating Forms Values

2002-04-04 Thread Paul Burney
. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] using multiple checkboxes to delete from db

2002-03-30 Thread Paul Burney
produce something like: DELETE FROM table WHERE id IN ('3','4','123'); Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] displaying info in a form

2002-03-29 Thread Paul Burney
=text value=?php echo htmlspecialchars($name); ? HTH, Paul Burney http://burney.ws/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] https post using php

2002-03-28 Thread Paul Burney
scheme to access this URL, please. 1) Since this post is non-database related, it should be posted to the PHP-General list. 2) That said, I don't think it's possible to do what you want without curl. There's much more to an SSL/HTTPS connection that talking on a different port. Paul ?php while

Re: [PHP-DB] how to start and bring down mysql.server on OSX

2002-03-15 Thread Paul Burney
startup script for MySQL on OS X. http://www.entropy.ch/software/macosx/mysql/ HTH. Sincerely, Paul Burney http://paulburney.com/ ?php If ($your_php_version 4.1.2) { upgrade_now(); // to avoid major security problems /* Please see http://security.e-matters.de/advisories/012002.html

Re: [PHP-DB] Looking for a good MySQL db abstraction layer

2002-03-08 Thread Paul Burney
, Paul Burney http://paulburney.com/ ?php If ($your_php_version 4.1.2) { upgrade_now(); // to avoid major security problems /* Please see http://security.e-matters.de/advisories/012002.html */ ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Can I attach an image to a newsgroup post?

2002-03-07 Thread Paul Burney
to place it on a public web server somewhere and then use a link to it in your post, like this: http://example.com/somefolder/my_image.jpg Or http://example.com/somefolder/my_php_file.phps Sincerely, Paul Burney http://paulburney.com/ ?php If ($your_php_version 4.1.2) { upgrade_now

Re: [PHP-DB] Dynamic Drop Down Box

2002-03-06 Thread Paul Burney
and tutorial here: http://webreference.com/dev/menus/ And they even have a script that'll generate the code for you here: http://webreference.com/js/tools/menus/ Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php If ($your_php_version 4.1.2) { upgrade_now(); // to avoid major

Re: [PHP-DB] addslashes needed for db security? Hack proving webapps

2002-03-05 Thread Paul Burney
interesting. HTH. Paul ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] security

2002-03-05 Thread Paul Burney
the problem. HTH Paul ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] security

2002-03-03 Thread Paul Burney
and 4.1.1. 3) Upgrade to PHP 4.1.2 You should really do this as soon as possible. I'm sure someone will make a Code Red type of infestation soon to exploit this bug soon. Evidently, there is a crude exploit circulating. Hope that helps. Paul ?php while ($self != asleep) { $sheep_count

Re: [PHP-DB] Question about setting up multiple relations

2002-02-28 Thread Paul Burney
setup a members_images in the same way. Hope that helps. Paul ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Upgrading from php -4.0.3

2002-02-27 Thread Paul Burney
problems to the PHP-INSTALL list. Since this is the database list, you *should not* post those questions here. Paul ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem in programming PHP with WML

2002-02-25 Thread Paul Burney
header of text/html. Evidently, WAP enabled devices don't like that. Try something like this: Header('Content-type: text/vnd.wap.wml'); Not sure about that content type, but it was what I found on a simple google search. HTH. Paul ?php while ($self != asleep) { $sheep_count

Re: [PHP-DB] Maintain MySQL Transactions

2002-02-09 Thread Paul DuBois
At 2:00 +0800 2/10/02, Jason Wong wrote: On Sunday 10 February 2002 00:21, Miles Thompson wrote: Unless there has been a very recent development, MySQL doesn't support transactions. Use PostgreSQL, DB, etc. The v4 series of MySQL does support transactions. MySQL has supported transactions

Re: [PHP-DB] addslashes()

2002-02-08 Thread Paul DuBois
D] wrote in message 002601c1b033$382a4700$f6b2d83f@goofy1">news:002601c1b033$382a4700$f6b2d83f@goofy1... Paul, It is being inserted into a database -Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 5:41 PM To:

RE: [PHP-DB] addslashes()

2002-02-08 Thread Paul DuBois
At 10:06 -0600 2/8/02, Todd Williamsen wrote: Paul, Sorry for the confusion... Ok.. I have an application where it organizes candidates for positions for HR. There is a Notes field where they can update actions with the potential candidate. Now this can be when this person has been contacted

RE: [PHP-DB] addslashes()

2002-02-08 Thread Paul DuBois
At 10:22 -0600 2/8/02, Todd Williamsen wrote: Paul, No kidding I see the problem, that is why I am asking how do I solve it. By writing a content parser that is intelligent enough to recognize HTML constructs and pass them through literally, while recognizing when your people write other stuff

RE: [PHP-DB] addslashes()

2002-02-08 Thread Paul DuBois
of values. If the one that works continues to work and the one that fails continues to fail, then clear they're not really *exactly* the same. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 10:34 AM To: Todd Williamsen; [EMAIL PROTECTED] Subject

Re: [PHP-DB] Simple Display

2002-02-08 Thread Paul DuBois
At 7:46 +1300 2/9/02, Barry Rumsey wrote: I am trying to do a simple fetch of the lastest add name. I have the following code : $query = SELECT name FROM name ORDER BY name DESC LIMIT 1; $latename = mysql_query($query) or die(Select Failed!); $latename = mysql_fetch_array($latename); echo

Re: [PHP-DB] Round a float to the next highest value despite thevalue after the point

2002-02-08 Thread Paul DuBois
At 15:31 -0400 2/8/02, Renaldo De Silva wrote: how can I round a float to the next highest value reguardless of the value after the point, does anyone have any suggestion, any help would be apreciated. Define next highest value. -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Exact String replace with eregi_replace()

2002-02-08 Thread Paul Burney
List, since it isn't db related. That said, look at the preg_replace function: http://www.php.net/manual/en/function.preg-replace.php And use the \b escape in your search string: http://www.php.net/manual/en/pcre.pattern.syntax.php Paul ?php while ($self != asleep) { $sheep_count

[PHP-DB] Can't get left join to work

2002-02-07 Thread paul wilczynski
I've got 2 MySQL tables: Employees, and Mileage. Mileage records trips for employees and there may be 0 or more Mileage rows for each Employee row. The Mileage table has a trip_date column. For testing purposes, the trip_date column in all rows is set to 2002-03-01. There are currently 15 rows

Re: [PHP-DB] Can't get left join to work

2002-02-07 Thread paul wilczynski
2SamA 3Fred RobertA 4Paul A 121212121George A 121212122George C. A 121212123George A ABCABCABCIanA BBobA QJoan Billy Bob

<    1   2   3   >