Re: [PHP-DB] Connecting to Oracle

2001-03-13 Thread Paul
Joe, I have had some tough problems changing SIDs in oracle via PHP. If your tnsnames.ora file correctly defines the SID, you may not need to declare it again via PHP. if you run phpinfo(), see if these values are already defined, and then try to connect with default values... -- ""Joe

[PHP-DB] The Dreaded Oracle 8 TNS:ORA-12154 Connection Error

2001-05-04 Thread Paul
corporate policy dictates that I must prove PHP against ASP on the existing IIS server before I can even attempt using Apache. I would greatly appreciate any construction :-) advise anyone can offer. Regards, Paul Shortis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

[PHP-DB] The Dreaded Oracle 8 TNS:ORA-12154 Connection Error

2001-05-07 Thread Paul
corporate policy dictates that I must prove PHP against ASP on the existing IIS server before I can even attempt using Apache. I would greatly appreciate any construction :-) advise anyone can offer. Regards, Paul Shortis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

[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

[PHP-DB] Gnarley drop-down db problem

2003-06-11 Thread Paul
with the $_GET, but I can't figure out how to both get the value from the query string and then send the changed value in the drop down. TIA, Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Gnarley drop-down db problem

2003-06-11 Thread Paul
Please disregard. I found an idiotic typo in my code ;-) Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL denying access to...everything

2004-08-18 Thread Paul
Also, take care with the new password hashing: http://dev.mysql.com/doc/mysql/en/Password_hashing.html Paul On Wed, 18 Aug 2004 00:56:08 -0700, Peter Ellis [EMAIL PROTECTED] wrote: This is a MySQL error on the server side - you need to make sure that whatever user you're signing into MySQL

Re: [PHP-DB] Re: Date Conversion

2004-08-18 Thread Paul
You might want to look into date conversion on the MySQL side: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Look for DATE_FORMAT(date,format) Paul On Wed, 18 Aug 2004 10:16:59 +0200, Torsten Roehr [EMAIL PROTECTED] wrote: Ng Hwee Hwee [EMAIL PROTECTED] wrote in message

[PHP-DB] PHP5: Initial connection to the MySQL server is carried out using the apache webserver userid

2009-02-20 Thread Paul Will
and the database is read OK and the pages are correctly compiled. The phpinfo() function also shows that the indexes apparently contain the correct values. Thanks in advance for any help. Paul Will -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Issue 45979: PHP code attached

2009-02-20 Thread Paul Will
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTML HEAD META HTTP-EQUIV=CONTENT-TYPE CONTENT=text/html; charset=utf-8 TITLE/TITLE META NAME=GENERATOR CONTENT=OpenOffice.org 2.4 (Linux) META NAME=AUTHOR CONTENT=Paul Will META NAME=CREATED CONTENT

[PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Paul
) { //do things } prev($obj); Is there an equivalent to object? I've tried the above method, but nothing happens. I've also tried type casting it to an array, without success. Is there anyway to iterate through this? Thanks, Paul -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] ENUM type

2001-01-15 Thread Paul DuBois
to construct a set of radio buttons or a popup menu in a web form. That way your form always presents exactly the legal options for the column. You can also use the column definition when validating submitted forms to make sure the value submitted is legal. -- Paul DuBois, [EMAIL PROTECTED] -- PHP

Re: [PHP-DB] Returning a formated dat

2001-02-02 Thread Paul DuBois
RIGHT(d,4)) FROM t; -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WORK.." -- Paul DuBois, [EMAIL PROTECTED] -- P

Re: [PHP-DB] passing object elements in urls

2001-02-06 Thread Paul Cooper
://www.php.net/manual/en/function.urldecode.php Paul You could try using a + instead of a space too. - Darryl -- Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED] Education Research Technology Services

Re: [PHP-DB] php client -- informix-se

2001-02-12 Thread Paul Gardiner
the web server from there. For us the unix box is so much more reliable. Regards, - Paul - - Original Message - From: "Luigi Casiraghi" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 09, 2001 10:10 PM Subject: [PHP-DB] php client -- informix-se Dear all

[PHP-DB] Microsoft SQL Server and views

2001-02-15 Thread Paul Clements
Hi, Sorry if this has been asked before but I've looked everywhere and not found the answer to the question Can you access views from mssql_query? I seem to be getting Invalid Object Name reported back to me. Any help would be appreciated Thanks Paul Clements -- PHP Database Mailing

Re: [PHP-DB] AUTO_INCREMENT

2001-03-04 Thread Paul Burney
but how can this be because i've set it to AUTO_INCREMENT. That's the limit of the TINYINT type. ALTER TABLE and change the type to INT. Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

Re: [PHP-DB] meta tag inside php / redirect / refresh

2001-03-16 Thread Paul Gardiner
Hi Marc, Try this - untested and I'm very sleepy, but should get you closer ;o) html head titleRefresh Test/title ?php if($check_num == 0) echo "META HTTP-EQUIV=\"REFRESH\" CONTENT=\"5;URL=http://www.chescolawyers.com/BB/index2.shtml\""; ? /head

[PHP-DB] ocibindbyname: ORA-01008: not all variables bound

2001-04-05 Thread Paul Fernandez
$parsed2 = OCIParse($connection,$query2); $cursor2 = OCIExecute($parsed2); ? It seems so simple. What am I doing wrong? Paul Fernandez -- 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] select substring_index

2001-04-11 Thread Paul Burney
ot;." ,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 PROTECTED] For additional commands, e-mail

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

2001-04-12 Thread Paul Burney
utorials. 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 Education and Information Studies University of Californ

Re: [PHP-DB] substring_index Part 2

2001-04-12 Thread Paul Burney
he connection made and the database selected. Can you try this? ?php if (mysql_num_rows($result) 0) { while ($myrow = mysql_fetch_array($result)) printf("%s\nbr", $myrow['headline']); printf("%s\n", $myrow['body']); } } else { echo 'No results found

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: input type="hidden" name="pswd" value="$password" 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

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

2001-04-18 Thread Paul Burney
, 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 Database Mailing List (http

[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

[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] update problems

2001-04-26 Thread Paul Burney
a while loop to drop the values into a select field, i.e., echo 'option value=' , $row['fieldname'] , '' , $row['fieldname'] , '/option'; 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
voyage only/option Hope that helps, Paul Burney http://paulburney.com/ http://webdevel.burney.ws/ -- 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

[PHP-DB] PHP4, APACHE, SCO INFORMIX

2001-04-30 Thread Paul Gardiner
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 commands, e

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

2001-05-04 Thread Paul DuBois
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 list administrators, e-mail: [EMAIL PROTECTED] -- Paul DuBois, [EMAIL

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread Paul Burney
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 Angeles (310) 825-8365

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

2001-05-10 Thread Paul Burney
] 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 Source Developer Educational

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

2001-05-14 Thread Paul Burney
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 Information Studies University of California, Los Angeles

Re: [PHP-DB] user need password

2001-05-16 Thread Paul Burney
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 Message

Re: [PHP-DB] php-notepad

2001-05-19 Thread Paul Campbell
ROTECTED]... 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, e-mail: [EMAIL PROTECTED] To contact the list admini

Re: [PHP-DB] newbie MySQL question

2001-05-19 Thread Paul Campbell
($link); ? /tr/table 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 to this post, i'd be very appreciative. Thanks, Matt -- Paul Campbell http://www.cmm.uklinux.net

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
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: [EMAIL PROTECTED] Sent: Tuesday, May 22

[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
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 ++ Paul Burney Webmaster

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

2001-06-22 Thread Paul Burney
['ordertotal']; Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

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

2001-06-22 Thread Paul Gardiner
' ; $rid = ifx_query($Query, $connid, IFX_SCROLL) or die(An error occurred querying database); @ifx_htmltbl_result($rid,border=1); ifx_free_result ($rid); ifx_close($connid); Regards, - Paul - - Original Message - From: wflow [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

Re: [PHP-DB] submitbutton/imagebutton

2001-06-22 Thread Paul Burney
of checking for $submit, do something like: ... if (isset($submit_x)) { ... Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

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

2001-06-26 Thread Paul Burney
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 ++ Paul Burney Webmaster Open Source Developer UCLA

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

2001-06-26 Thread Paul DuBois
-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 commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

2001-06-27 Thread Paul Burney
++; } // make sure you don't have a malformed table while ($c % $n != 0) { echo 'tdnbsp;/td'; $c++; } echo '/tr'; // end table code (omitted) ? Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA

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

2001-06-28 Thread Paul Burney
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 Burney Webmaster Open Source Developer UCLA - GSEIS

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

2001-06-29 Thread Paul DuBois
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-4812 F: 413-618-1518 -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http

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

2001-06-29 Thread Paul DuBois
] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- 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

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

2001-06-30 Thread Paul DuBois
like $stmt is being munged? Question 2: How to you bind a NULL value to a placeholder? In DBI, you use undef to stick a NULL into a query; in 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

[PHP-DB] PhpMyAdmin phpPgAdmin Security Issues

2001-07-02 Thread Paul Burney
, Paul Burney +-+-+ | Paul Burney | P: 310.825.8365 | | Webmaster Programmer | E: [EMAIL PROTECTED] | | UCLA - GSEIS - ETU | W: http://www.gseis.ucla.edu

Re: [PHP-DB] Authomatic Sorting

2001-07-04 Thread Paul Burney
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 Webmaster Open Source Developer UCLA - GSEIS - ETU (310

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

2001-07-23 Thread Paul DuBois
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-mail: [EMAIL PROTECTED] For additional commands, e-mail

Re: [PHP-DB] Counting Number of Instances in a One2ManyRelationships

2001-07-23 Thread Paul Burney
the database and return the publisherID and a count of the number of books. You can do a group by to get them all at once: SELECT COUNT(*) AS book_count, publisherID FROM bookDB GROUP BY publisherID; Then use your favorite mysql_fetch_*** and access them. Hope that helps. Sincerely, Paul Burney

Re: [PHP-DB] Problem with my first script

2001-07-24 Thread Paul Burney
an invisible control character between the mysql_fetch_ and the array part. Try deleting the line and retyping: $myrow = mysql_fetch_array($result); Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA

RE: [PHP-DB] WHERE field = str

2001-07-25 Thread Paul DuBois
$17.95 www.yourname.com http://www.SeaPortNet.com/ 1(209)551-7028 -- 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

Re: [PHP-DB] mysql query problem

2001-07-26 Thread Paul Burney
='$ContactID'; echo 'SQL query is: ' , $sql, 'br'; $result = mysql_query($sql,$db); printf(%s\n, mysql_result($result,FirstName)); printf(%sbr\n, mysql_result($result,LastName)); ? Hope that helps. Sincerely, Paul Burney +-+-+ | Paul Burney

Re: [PHP-DB] PHP and Informix installation

2001-07-27 Thread Paul Gardiner
-lprot -lx \ -ltinfo -lm -lc /usr/informix/lib/esql/checkapi.o -lifglx # Add any extra libs in here if required LIBS=$IFX_LIBS export LIBS ./configure --prefix=$APACHE_DIR \ --activate-module=src/modules/php4/libphp4.a Regards, - Paul - - Original Message - From: Muciño Zúñiga

Re: [PHP-DB] UPDATE Not Updating

2001-08-01 Thread Paul DuBois
\ ; $result = @mysql_query($update_contact_sql, $connection) or die (Couldn't execute query.); -- 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

Re: [PHP-DB] Grouping functions inside WHERE clause - may or not

2001-08-04 Thread Paul DuBois
: 11199819 e-mail: [EMAIL PROTECTED] -- 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] odbc problems - cannot connect to MS Access db

2001-08-04 Thread Paul Fenton
Please help I am trying to get PHP to connect to MS Access db on a win2000 server, but only getting following errors: Warning: SQL error: , SQL state 0 in SQLConnect in d:\websites\~nit\hello.php on line 7 Warning: Supplied argument is not a valid ODBC-Link resource in

Re: [PHP-DB] Query on Oracle Views

2001-08-06 Thread Paul Burney
instance_name, host_name FROM v\$instance; HTH. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] mysql_fetch_array missing first record

2001-08-07 Thread Paul Burney
before this in your code, perhaps to see if there is a result? If so, that's the problem. Each call to mysql_fetch_array (mysql_fetch_row) increments the array pointer. If that isn't your problem, please post more of the code so that we can make a better diagnosis. Sincerely, Paul Burney

Re: [PHP-DB] mysql_fetch_array missing first record

2001-08-07 Thread Paul DuBois
record in the table, or the first record in the result set? Why is this and how can I get round it? Hard to say without seeing the surrounding context. Thanks. Jamie Saunders -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

Re: [PHP-DB] auto fill field with value from another

2001-08-07 Thread Paul DuBois
manual says default values must be constants: http://www.mysql.com/doc/C/R/CREATE_TABLE.html thanks, bill hollett -- 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

Re: [PHP-DB] Submit forms

2001-08-10 Thread Paul Burney
variable will be set to yes. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] MySQL Modules and multiple database

2001-08-13 Thread Paul Burney
sure that you select the db before each query otherwise a query will use the last selected database. Sincerely, Paul Burney +-+-+ | Paul Burney | P: 310.825.8365 | | Webmaster Programmer | E: [EMAIL PROTECTED

Re: [PHP-DB] mysql optional file - my.cnf

2001-08-17 Thread Paul Burney
this is a PHP / Database discussion list. See mysql.com for more information. Sincerely, Paul Burney +-+-+ | Paul Burney | P: 310.825.8365 | | Webmaster Programmer | E: [EMAIL PROTECTED] | | UCLA - GSEIS - ETU

[PHP-DB] Oracle OCI/Client install without OUI?

2001-08-22 Thread Paul Blacquiere
Hi, Does anybody have an idea on how I could install the oracle client/libraries required to build PHP with OCI support without using the OUI. The server is headless, and behind a firewalls, so X-Server is not an option, it also has no local CD-Rom, just to add to the problem. Platform :=

Re: [PHP-DB] Error with in_use() from Beginning PHP4 book.

2001-08-25 Thread Paul Burney
this have anything to do with updated MySQL parser? I am now using MySQL version 3.23.36. Possibly if the version of PHP that you are using was linked to old versions of the MySQL headers. You may need to recompile PHP. Sincerely, Paul Burney

Re: [PHP-DB] PHP/mySQL and INSERT statements

2001-08-28 Thread Paul Burney
() , ': ' , mysql_error() , 'BR'; HTH. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] Error making php with informix

2001-08-29 Thread Paul Gardiner
a look back to the last mail I sent you about a month ago for more info. Regards, - Paul - - Original Message - From: Muciño Zúñiga Marco Antonio [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 7:28 PM Subject: [PHP-DB] Error making php with informix Hi, I'm trying

Re: [PHP-DB] MySQL UPDATE problem

2001-08-30 Thread Paul Burney
. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu/ ++ -- PHP Database Mailing List (http

Re: [PHP-DB] Random

2001-08-31 Thread Paul Burney
by rand() only working in 3.23.xx. If you're using 3.22.xx, it won't work. You could do something with mysql_data_seek() and the php mt_rand() function if that's the case. It would be klunky, but you could probably get it to work. Sincerely, Paul Burney

Re: [PHP-DB] How can you hide database login passwd in yourscript?

2001-09-05 Thread Paul Burney
databases regularly and hope you never really need to use them. Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] newbie needs to format time field

2001-09-05 Thread Paul Burney
, the value you're looking for is mydate, i.e., echo $myrow['mydate']; HTH. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] Forms Question

2001-09-06 Thread Paul Gardiner
Hi there, Take a look at the following snippet below. It is similar to what you're looking for without having to bugger about duplicating loads of lines for each store. Just add a new one to the array if required. Best Regards, - Paul - select name=MonthSelected size=1 ?php $MonthArr

Re: [PHP-DB] PHP linux interbase Apache

2001-09-06 Thread Paul Cooper
think the rpm version installs itself in /opt/interbase (you can check with rpm -ql interbase). If that is the case then you need to configure with ./configure --with-apxs=/path/to/apxs --with-interbase=/opt/interbase --enable-track-vars Paul Meir Kriheli a écrit : On Thursday 06

Re: [PHP-DB] ghost server?

2001-09-10 Thread Paul Jongsma
an index can increase performance 100x. If you need more info let me know... Brgds hPF i was wondering if its is because of mysql or other service installed on the hPF server. has anyone the same problem in the past? what is the reason? please hPF help. -- Paul Jongsma WEBtic Internet

Re: [PHP-DB] db's war

2001-09-18 Thread Paul Gardiner
. They had a special offer on for anyone who jumped over two them quickly but I like to 'look before you leap' :) We plan to start looking at possible alternative's before we're forced to change and so would be glad to hear from anyone else who is in the same boat so to speak. Best Regards, - Paul

Re: [PHP-DB] MySQL alphabetical listing

2001-09-18 Thread Paul DuBois
with that letter), do this: SELECT DISTINCT LEFT(last_name,1) AS letter FROM tbl_name ORDER BY letter -- 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

[PHP-DB] Fatal Error

2001-09-22 Thread Paul Devine
this snippet of code ?php $link = mysql_connect (localhost, fantasy, password) or die (Could not connect); print (Connected successfully); mysql_close ($link); ? Thanks Paul Devine -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] PHP4 Compile using Informix Client SDK

2001-10-03 Thread Paul Daly
site where I had Openlink ODBC installed. Could I use Openlink ODBC clients to go across I-Net? If anyone could help, I'd be most grateful. Thanks in advance. Regards, Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

Re: [PHP-DB] Session Broken

2001-11-08 Thread Paul DuBois
At 9:25 AM + 11/8/01, Russ Michell wrote: 1: Rid any whitespace between '?php' and 'session_start()' 2: You need to populate the variable you wish to use as a session variable before registering it Is 2 actually true? The sessions chapter in the PHP manual doesn't seem to specify any order

Re: [PHP-DB] Not a valid MySQL result resource

2001-11-08 Thread Paul DuBois
At 2:04 AM +0100 11/9/01, MPropre wrote: ?php //.../... first part of the code is to connect to the right DB on a MySQL server. It works fine //This code to show the query. It runs well under MySQL and gives 1 result : $query=SELECT Login, Password FROM `user` WHERE user.login=''$login'' and

[PHP-DB] MS Access Error

2001-11-13 Thread Paul Lalli
in D:\www\Lalli\php\access.php on line 7 Connection NOT established The server is running MS WinNT 4.0 SP6, with PHP 4.0. Can anyone help me out? Thank you, Paul Lalli -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

[PHP-DB] Intro to PEAR:DB

2001-11-21 Thread Paul Meagher
for example. Regards, Paul Meagher -- PEAR Development Mailing List (http://pear.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 Database Mailing List (http://www.php.net

Re: [PHP-DB] Combination of SQL statements invalid in MySQL?

2001-11-22 Thread Paul DuBois
At 4:08 PM +0100 11/22/01, Andy wrote: Hi there, I am trying to do a combination of SQL statements like described in a SQL bÛok. Is it possible, that mysql does not allow this syntax? According to the MySQL Reference Manual, subselects are not supported. Thanx Andy Error: Occured during

Re: [PHP-DB] Result is not empty

2001-11-22 Thread Paul DuBois
Take out the while statement-- i.e. simply use: $row = mysql_fetch_array($result); the way you have things constructed now, the while statement evaluates true on the first iteration and $row equals the result row from the query. Because the while returned true, it is evaluated a second time,

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-11-23 Thread Paul DuBois
Has this thread got anything at all to do with PHP? -- 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] PHP MySql

2001-11-23 Thread Paul DuBois
At 4:16 PM -0700 4/8/01, Jonathan Underfoot wrote: I'm getting an Invalid Query error after inputting the following connect to Server select DB $sql_query = UPDATE commentary SET com_num=$com_num, com_by=$com_by, com_band=$com_band, com_title=$com_title, com_release=$com_release,

Re: [PHP-DB] Re: Dynamically populating a dropdown box

2001-12-14 Thread Paul DuBois
At 10:46 -0800 12/14/01, Richard S. Crawford wrote: At the risk of sounding like a browser-snob... The quotes probably don't matter in IE, but that's primarily IE allows (and, in my opinion, encourages) bad coding practices. Your echo command really ought to look like this: echo option

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Paul DuBois
On Thu, Dec 20, 2001 at 11:40:14AM -0500, SpyProductions Support Team wrote: I've looked around in a few of the PHP lists for an answer to this, but can't come up with one. On this question, you'd be better off just reading an HTML reference. It doesn't matter what the value of a checkbox is.

Re: [PHP-DB] mail() - Return-Path

2002-01-12 Thread Paul Burney
apache, you can change the sendmail path to: sendmail -t -i -f [EMAIL PROTECTED] That bounces all mail to that address. I believe that in PHP 4.0.6 they added another parameter of the mail function that lets you add options to sendmail from each script, but check the docs. HTH. Paul BTW, since

Re: [PHP-DB] The New Guy

2002-01-14 Thread Paul Burney
with Perl. Choose the best tool for the job at hand, TMTOWTDI. Paul ?php while ($self != asleep) { $sheep_count++; } ? -- 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

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

2002-01-15 Thread Paul Burney
. Paul ?php while ($self != asleep) { $sheep_count++; } ? -- 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] mysql_insert_id?

2002-01-15 Thread Paul Burney
mysql_insert_id work accurately? 1) Please don't cross post to two lists. 2) No. MySQL uses separate threads for each connection. They don't interact with one another. Check the mysql docs for more info. Paul Paul ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database

[PHP-DB] FreeBSD 4.2 and ODBC

2002-01-15 Thread Paul G
? Got any ideas? Thanks Alot! -Paul

Re: [PHP-DB] FreeBSD 4.2 and ODBC

2002-01-15 Thread Paul G
emphasize!) Also, any ODBC driver you would recommend? -Paul - Original Message - From: Andrew Hill [EMAIL PROTECTED] To: Paul G [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 2:37 PM Subject: RE: [PHP-DB] FreeBSD 4.2 and ODBC Paul, You can simply download

Re: [PHP-DB] Storing Credit Card info

2002-01-17 Thread Paul G
pretty quickly. PHPs hooks into the mcrypt libraries are the best. So easy to use(and high quality) compared to anything else I've seen. Hope that helps, -Paul - Original Message - From: olinux [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 1:22 PM Subject: [PHP-DB

  1   2   3   4   >