[PHP-DB] Oracel 9i connection problems.

2002-04-16 Thread Paul Edmondson
--with-apxs2=/usr/local/httpd-2.0.35 \ --enable-sigchild ${ORACLE_HOME}/lib appears in ld.so.conf Thanks in advance for any help. -- Paul Edmondson, Software Engineer Yospace: Creating Value for Wireless 7 The Courtyard, High Street

[PHP-DB] mixing character sets

2002-04-16 Thread Paul Pugh
Has anyone scene any resources on the web for building multi-lingual PHP apps? Thanks -Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-04-16 Thread Paul Edmondson
> /lib/ld-linux.so.2 (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)

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

2002-04-18 Thread Paul Edmondson
ur current NLS settings for your session, instance and database by querying NLS_SESSION_PARAMETERS, NLS_INSTANCE_PARAMETERS and NLS_DATABASE_PARAMETERS. Maybe that well help you. -- Paul Edmondson, Software Engineer Yospace: Creating Value for Wireless

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

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

[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 th

Re: [PHP-DB] selected problem

2002-04-26 Thread Paul Burney
the options into an array and then create the list by looping through the array, each time checking the value to see if it is the selected one using the code above. HTH. Sincerely, Paul Burney <http://paulburney.com/> -- 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
e Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- Paul Edmondson, Software Engineer Yospace: Creating Value for Wireless 7 The Courtyard, High Street, Staines, UK, TW18 4DR Tel: +44 1784 466388 Fax: +44

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 possib

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

2002-05-27 Thread Paul Burney
to delete your table's entire contents. Usually, with PHP and MySQL such a query would fail. If you use the above code, it would succeed. Just a word of warning. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[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] MySQL problem on Yellow Dog Linux

2002-06-06 Thread Paul Burney
or an RPM for PHP that mentions MySQL as well. HTH. Sincerely, Paul Burney <http://paulburney.com/> -- 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: > > >Results Test > > > > >$server = "mdotlims"; >$user = "httpuser"; >$pass = "pass"; > > > $db = @mysql_connect($server,$user,$pass); > if (!$db) { > echo( "Unable to connect to the " . > "d

Re: [PHP-DB] date format display

2002-06-10 Thread Paul Burney
ot;3"; Hope that helps. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] case

2002-06-11 Thread Paul Burney
al/en/function.preg-match.php> HTH. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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: >/* 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 = get

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 h

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 cont

[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

[PHP-DB] Re: Problem w/ mysql_pconnect

2002-06-23 Thread Paul D
ost -u pauld -p my_pwd", with no problem at all. That's why I'm assuming that the problem lies somewhere else. Paul D wrote: > 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 > fo

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

[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 w

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

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 = '1

Re: [PHP-DB] PDF/FDF Support

2002-07-03 Thread Paul Burney
and it must be set to handle the FDF type. This may 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-07-12 Thread Paul Cooper
icky to install, 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

Re: [PHP-DB] Header problem

2002-07-15 Thread Paul Burney
on php-general. FWIW, I believe 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

Re: [PHP-DB] Pulling the Enum Values from MySQL

2002-07-25 Thread Paul DuBois
At 14:40 -0700 7/25/02, Mark Middleton wrote: >Hi there, > >I've got a Form I'm building, and would like the drop down boxes to contain >the values for one of the fields of type "enum" (not from the actual records >in the DB, but the definition of the enum field in MySQL) > >For example: A field

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

2002-07-29 Thread Paul Worthington
, 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] --

[PHP-DB] Re: ORDER BY from 2 tables

2002-07-29 Thread Paul Dionne
delete the table from the database. You may run into problems if more than one person tries to do this at a time, so be careful. 3) Or. create an array using data from the first set then loop through the second set adding the data from the second set. Then sort. Good luck and keep us pos

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

2002-07-30 Thread Paul Burney
to use the CURL functions: <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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
ECTs. Can someone please help? I've checked all manuals and FAQs I can, but I can't 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 accomod

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 Worthing

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

2002-07-30 Thread Paul Worthington
I am 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 PhpMy

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

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

2002-07-30 Thread Paul Worthington
lp me. 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] > Subje

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]... > >

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 1EA7D3AE70ACD511BE6

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 PROTECT

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

2002-08-27 Thread Paul Burney
o run a version 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 Database Mailing List

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 s

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. >>

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 i

Re: [PHP-DB] set_magic_quotes_runtime???

2002-09-18 Thread Paul Burney
orrectly, 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. Since

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

2002-09-20 Thread Paul Burney
r further information: <http://www.php.net/manual/en/function.ini-set.php> HTH. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-10-01 Thread Paul Burney
her MySQL commands, type a question mark or \h 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] 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 (http://www.php.net/

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

2002-10-15 Thread Paul Burney
y a different port 8000 to see if the speed improves. I do think that HTTP is often better for downloading 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 s

Re: [PHP-DB] Calendar

2002-10-17 Thread Paul Burney
t's a simple MySQL based calendar in PHP. DevShed is good place for other PHP tutorials as well. HTH. Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-10-18 Thread Paul Burney
ange to DESC 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 Database Mailing List (http://www.php.net/) To uns

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

2002-10-25 Thread Paul Burney
rd = 'yes'; while (result = something) { if ($first_record == 'yes') { do_something(); $first_record == 'no'; } else { do_something_else(); } } HTH. Sincerely, Paul Burney <http://paulburney.com/> -- PHP D

[PHP-DB] Order DB through url toggle

2002-11-08 Thread Paul Ihrig
C 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($HTTP_GE

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=priLastName&dir=0 http://localhost/php/default2.php?orderBy=priLastName&dir=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
] == 1) { $diri = 'ASC'; } mysql_select_db($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

[PHP-DB] Moving mySql db's & odbc

2002-11-09 Thread Paul Ihrig
th mySql, 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] 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] 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 devel

[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] ocibindbyname: ORA-01008: not all variables bound

2001-04-05 Thread Paul Fernandez
Hello, The goal here is to insert a single row, then get a numerical value "id" (generated by the insert trigger) to use in another insert statement. I get, "ORA-01008: not all variables bound" when running this script: It seems so simple. What am I doing wrong? Paul

Re: [PHP-DB] PHP4 to PHP3 problem

2001-04-10 Thread Paul Burney
on 4/10/01 1:49 PM, Rob Griffiths at [EMAIL PROTECTED] wrote: > **50** print "{$A["fname"]}" . You need to separate out the array reference: print "" . $A["fname"] . "" That should do it. Hope it helps, Paul Burney http://

Re: [PHP-DB] select substring_index

2001-04-11 Thread Paul Burney
ELECT substring_index(body, "." ,2) FROM news' or $result = mysql_query("SELECT substring_index(body, '.' ,2) FROM news" Hope that helps, Paul Burney http://paulburney.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROT

Re: [PHP-DB] build drop-down pick from MYSQL table

2001-04-12 Thread Paul Burney
p<->mysql tutorial is. I like devshed.com tutorials. The format they use is very nice and easy to follow. Hope it helps, Paul Burney ++ Paul Burney Webmaster and Open Source Developer Educational Technology Unit Graduate School of Educa

Re: [PHP-DB] substring_index Part 2

2001-04-12 Thread Paul Burney
assume that somewhere in the code you have the connection made and the database selected. Can you try this? 0) { while ($myrow = mysql_fetch_array($result)) printf("%s\n", $myrow['headline']); printf("%s\n", $myrow['body']

Re: [PHP-DB] hide passing value

2001-04-18 Thread Paul DuBois
On Wed, Apr 18, 2001 at 06:55:57PM +0100, Russ Michell wrote: > Do you mean like: > > > The script this value gets passed to will now have available the > varible: pswd with a value of the password field.. As will any user who knows about their browser's View Source command. :-) > > ??? >

Re: [PHP-DB] HTTP1.0/404 Not found

2001-04-18 Thread Paul Burney
gt; Pls help me Sorry, you should really subscribe to the PHP General list to post non-php/database questions. You can do so here: <http://php.net/support.php> That page also has information about news groups and list archives. Sincerely, Paul Burney <http://paulburney.com/> -- PHP

Re: [PHP-DB] Sending e-mail thru PHP page (2nd part)

2001-04-19 Thread Paul Burney
net, zend.com, or the general list archives for more info. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list a

[PHP-DB] PHP question needing info

2001-04-20 Thread Paul S
I have a question that I need help with. The question is that how do I execute a script in PHP. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP Database Mailing List (http://www.php.ne

[PHP-DB] reword my question

2001-04-20 Thread Paul S
How do I execute a shell script in php? I just started to use php and I am learning it on the fly for a project. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP Database Mailing List (

Re: [PHP-DB] extracting login name

2001-04-25 Thread Paul Burney
ly set if PHP is sending the authentication. If they don't work for you, you should be able to use the environment variable $REMOTE_USER. HTH, Paul Burney http://paulburney.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional co

Re: [PHP-DB] update problems

2001-04-26 Thread Paul Burney
d they run a while loop to drop the values into a select field, i.e., echo '' , $row['fieldname'] , ''; You may want to check out a small script I wrote: <http://webdevel.burney.ws/code/id?14> Hope that helps, Paul Burney ++++

Re: [PHP-DB] Inserting correct value from database into formoption field

2001-04-28 Thread Paul Burney
add a " selected" keyword to the appropriate option tag. Typically in PHP, this is done with a series of if statements. For example, >One voyage only Hope that helps, Paul Burney http://paulburney.com/ http://webdevel.burney.ws/ -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] PHP4, APACHE, SCO & INFORMIX

2001-04-30 Thread Paul Gardiner
others to contribute with their particular build so that a centrally managed install guide could be set up and perhaps free up some of the traffic on the lists? Best regards, - Paul - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional c

Re: [PHP-DB] Apache+PHP+MySQL installation at once - HOW?

2001-05-04 Thread Paul DuBois
hree at once. >Don't you now where I can find it? >Thanks >Vojtech http://www.nusphere.com/ > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread Paul Burney
u delete all rows from the table or something similar. Hope that helps, Paul ++ Paul Burney Webmaster and Open Source Developer Educational Technology Unit Graduate School of Education and Information Studies University of California, Los Angel

Re: [PHP-DB] Creating/reading [TAGS]

2001-05-10 Thread Paul Burney
> > [b]bold[/b] > etc. Since phpBB is open source, you could probably look through the source code and find it. I would guess some kind of preg_replace loop. <http://www.phpbb.com/> Paul ++ Paul Burney Webmaster and Open S

[PHP-DB] php4 and sybase-ct seg fault

2001-05-11 Thread Paul Kozlenko
line 10 is actually the first line shown here - "sybase_connect") Data does come back however after a long period. Does anybody have any clues I might look for? I appreciate any help here from anybody. - Paul K -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Flash+PHP search error

2001-05-14 Thread Paul Burney
is visible. IE is just trying to display what it can of what it sees. Try changing the file name to nav.php. HTH, Paul ++ Paul Burney Webmaster and Open Source Developer Educational Technology Unit Graduate School of Education and Informat

Re: [PHP-DB] user need password

2001-05-16 Thread Paul Burney
#x27;ll need to log into MySQL as root and set the password to a new password that you can send to the user. Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] php notepad

2001-05-18 Thread Paul Shortis
PHPCoder at www.phpide.de is a complete free php editor & IDE (for Windows). The latest version has sorted out some of the quirks of the previous versions. Drivers for Windows (and links to Linux Driver sites) can be found at www.windrivers.com. Regards, Paul Shortis - Original Mes

Re: [PHP-DB] Filling a dropbox on form

2001-05-18 Thread Paul Burney
Other than that, you could have the user do a limiting search on the DB for the item first, and then make the drop box from that. HTH, Paul Burney http://paulburney.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: [PHP-DB] php-notepad

2001-05-19 Thread Paul Campbell
CTED]">news:[EMAIL PROTECTED]... > > > Please tell me an editor for Linux -- Paul Campbell http://www.cmm.uklinux.net/ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: [PHP-DB] newbie MySQL question

2001-05-19 Thread Paul Campbell
over$row->description > > > "; > } > mysql_close($link); > ?> > > > > > oh and the date is in this format : Month-Day-,Year (ex. May 19, 2001) > > if anyone can help me out on this at all (or has any questions about my > problem), please reply

Re: [PHP-DB] Deleting specific records from MySQL tables

2001-05-20 Thread Paul Burney
nnerID=' . $banresult[bannerID]; mysql_db_query("phpads", $this_query); If the bannerID field isn't numeric, you'll need to enclose it in quotes as someone else mentioned. HTH, Paul Burney http://paulburney.com/ http://webdevel.burney.ws/ -- PHP Database Mailing List

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

2001-05-22 Thread Paul Gardiner
Hi Robert, Your test code is correct although you could do with an ifx_close($conn_id); at the end. Have you tried running isql(assuming you've got it) and just trying to run the query from there? Regards, - Paul - "Robert Hennig" <[EMAIL PROTECTED]> wrote in mess

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

2001-05-22 Thread Paul Gardiner
ure it ran properly and I hadn't missed something. Obviously, changing the database connection and select field and table. Can you post the exact output of the page, not the html source? Regards, - Paul - - Original Message - From: "Robert Hennig" <[EMAIL PROTECTED]> To: &l

[PHP-DB] newbie: Trying to select a database in php

2001-06-20 Thread Paul Lockyer
Im using win2k and php to retrieve and dipslay database records, however whenever the page is loaded in a browser I get the following error (the line in question is in bold) Fatal error: Call to undefined function: msql_select_db() in D:\ASP\test\php\default.php on line 18 The code I am using

Re: [PHP-DB] MySQL connection: Change on syntaxis?

2001-06-22 Thread Paul Burney
m_rows($result); > > Is this a new use of the function mysql_num_rows? What are the error messages you get? The @ symbol suppresses warning messages being sent to the browser so it isn't "fixing" whatever the real problem is. Sincerely, Paul Burney +++++

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Paul Burney
do something with it. Call ifx_query or something.*/ } You could also just go through all the results in a similar fashion and set: $orderdate = $row['orderdate']; $ordertotal = $row['ordertotal']; Hope that helps. Sincerely, Paul Burney ++

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Paul Gardiner
$Query = "SELECT stuff ". "FROM somewhere ". "WHERE orderdate = '$orderdate' "; $rid = ifx_query($Query, $connid, IFX_SCROLL) or die("An error occurred querying database"); @ifx_htmltbl_result($rid,"bor

Re: [PHP-DB] submitbutton/imagebutton

2001-06-22 Thread Paul Burney
f checking for $submit, do something like: ... if (isset($submit_x)) { ... Sincerely, Paul Burney ++ Paul Burney Webmaster && Open Source Developer UCLA -> GSE&

Re: [PHP-DB] Is MySQL in 4.0.6?

2001-06-26 Thread Paul Burney
t entails the necessary MySQL header files so that PHP can compile with MySQL support. You still need to download and install MySQL on the machine. You can find packages and more information at: <http://www.mysql.com/> Hope that helps. Sincerely, Paul Burney +++

Re: [PHP-DB] Is MySQL in 4.0.6?

2001-06-26 Thread Paul DuBois
you can connect to. > >-Adam Lundrigan > CEO, VPU > http://www.vpu-virtual.com/ > > ICQ # 73617446 > [EMAIL PROTECTED] > > -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] php/mysql horizontal listing query

2001-06-27 Thread Paul Burney
ave a malformed table while ($c % $n != 0) { echo ' '; $c++; } echo ''; // end table code (omitted) ?> Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaste

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread Paul Burney
r, and it won't add them anymore. Any suggestions??? It looks like you set your key column as a TINYINT type rather than say, an INT. Try ALTER'ing that column type to INT and see if it works. Sincerely, Paul Burney ++ Paul Burn

Re: [PHP-DB] MySQL Error???

2001-06-29 Thread Paul DuBois
, because you don't use negative numbers in the column. Something like this: ALTER TABLE tbl_name MODIFY col_name INT UNSIGNED NOT NULL > >Thanks, > >B R I A N G R A Y L E S S > Web Administrator > Premier Resorts > www.premier-resorts.com > >P: 435-655-4

Re: [PHP-DB] MySQL connection: Change on syntaxis?

2001-06-29 Thread Paul DuBois
quot; > > Russ Michell > Anglia Polytechnic University Webteam > > e: [EMAIL PROTECTED] > w: www.apu.ac.uk/webteam > t: +44 (0)1223 363271 x 2331 > > www.theruss.com > >#---# > > >-- >

[PHP-DB] PEAR DB, prepare(), and placeholders

2001-06-30 Thread Paul DuBois
PEAR DB, I tried both null and an unset variable, with the result that an empty string was placed into the query string in both cases. -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] PhpMyAdmin phpPgAdmin Security Issues

2001-07-02 Thread Paul Burney
ig etc. respond to this. Sincerely, Paul Burney +-+-----+ | Paul Burney | P: 310.825.8365 | | Webmaster && Programmer | E: <[EMAIL PROTECTED]> | | UCLA -

Re: [PHP-DB] Authomatic Sorting

2001-07-04 Thread Paul Burney
add an "ORDER BY" clause to your query. That is, if you want to sort by reg_id, append "ORDER BY reg_id". You can also add a DESC keyword to put them in reverse order. HTH. Sincerely, Paul Burney ++++++ Paul Burney Webma

[PHP-DB] mysql_[p]connect() and mysql_error()/mysql_errno()

2001-07-23 Thread Paul DuBois
/mysql_errno() after a failed connection is with *no* argument, because when a failure occurs $conn_id won't have any reasonable value and shouldn't be passed to those functions. -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-

<    1   2   3   4   >