Re: [PHP-DB] Connecting to Oracle

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

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

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

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

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

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

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

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

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] PHP Objects and SQL Results

) { //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

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] passing object elements in urls

://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

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

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] meta tag inside php / redirect / refresh

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

$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

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

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

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] HTTP1.0/404 Not found

, 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

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

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

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

[PHP-DB] PHP4, APACHE, SCO INFORMIX

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] Creating/reading [TAGS]

] 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

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

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

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

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

($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

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

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?

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)

['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)

' ; $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

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?

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?

-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

++; } // 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???

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 connection: Change on syntaxis?

] 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

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

, 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

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()

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

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

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

$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

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

-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] Grouping functions inside WHERE clause - may or not

: 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

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

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

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

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

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

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

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

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?

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] PHP/mySQL and INSERT statements

() , ': ' , 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

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

. 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

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?

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

, 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

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

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?

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

[PHP-DB] Fatal Error

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

? Got any ideas? Thanks Alot! -Paul

Re: [PHP-DB] FreeBSD 4.2 and ODBC

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

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

Re: [PHP-DB] Storing Credit Card info - Encryption Functions

that will generate a new one for you. Look at the mcrypt_encrypt and mcrypt_decrypt functions at php.net for details. I lifted the hex2bin() from the user comments If I remember correctly. Have Fun... -Paul

Re: [PHP-DB] distinct - how to do

At 2:28 +1300 1/20/02, Barry Rumsey wrote: I have the following query: $query = SELECT * FROM xp_topics, xp_stories WHERE xp_topics.topicid = xp_stories.topicid AND xp_topics.artistname='Faith Hill' ORDER BY topictext DESC LIMIT 0,20; It returns the lot but a lot of doubles. I want to put a

Re: [PHP-DB] Sum Columns

At 23:19 -0600 1/25/02, [EMAIL PROTECTED] wrote: Hello, I've been experimenting with adding decimal columns. From the mysql docs I got this SELECT sum(value) FROM pets; So I did this $result = mysql_query(SELECT sum(value) FROM pets,$db); $myrow =

[PHP-DB] Re: [PHP] PHP and MYSQL Security`

At 16:59 -0800 1/27/02, Fred wrote: If this file has a .php extension remote users will not have access to the variables because the file is parsed by php and they never see the actual file contents when requesting the document via the web. If you are concerned with users on localhost having

[PHP-DB] mySQL 4.0.2-alpha

Hi guys, I'm running mySQL 3.23.43 at the mo' with PHP-GTK 0.5.0. Long and the short of the matter is, anyone running mySQL 4.0.2-alpha in anywhere near a production environment yet, and if so, how is it? My server is a Win2K Server SP2 box...so how steady are those windows binaries??? :-) --

Re: [PHP-DB] UPDATE query to add to a field

At 9:06 -0800 1/28/02, Adv. Systems Design wrote: hello all: I need to be able to update a field in MySQL, the catch is that I have to add on to text that is already there and I have to be able to do it within MySQL (phpMyAdmin). My first idea was to do: SET prod_desc = prod_desc + more info

Re: [PHP-DB] request and response objects?

At 12:30 -0600 1/30/02, Matthew Crouch wrote: basically a yes or no question my brother wants me to ask: Does PHP support these objects? If not, Can they be faked? What, like in Java servlets/JSP pages? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] Re: LEFT JOIN in UPDATE

the select statement first with the join, then loop through the results and perform the update. 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] MySQL connect

: mysql_connect($db[host],$db[user],$db[password]); mysql_select_db($db[database]) Paul ?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] Can't get left join to work

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

2SamA 3Fred RobertA 4Paul A 121212121George A 121212122George C. A 121212123George A ABCABCABCIanA BBobA QJoan Billy Bob

Re: [PHP-DB] addslashes()

At 16:54 -0600 2/7/02, Todd Williamsen wrote: Ok.. i tried it out... and it almost works like I want it... weird though 1. when I put in pfont color=bluethis is BLUE/p/font it prints it in like a bright green. but if i use the RGB # then its fine. weird 2. if there is an apostrophe in

  1   2   3   >