Re: [PHP-DB] MySql PHP API

2004-03-01 Thread Doug
I'm confused. I replied to your inquiry to tell you what information you need to provide if you are to receive help.. Why are you asking me questions about *your* problem? And keep the discussion on the list. Doug Mike Ni wrote: Do you know for certain whether it is a matt

Re: [PHP-DB] database collision?

2001-01-09 Thread Doug Semig
k a row or table; also this serializes your inserts, so be aware that it is a potential bottleneck). 3. Use some kind of random data (can be timestamp or random number based) to compute non-sequential keys. Good luck, Doug At 11:45 AM 1/9/01 +0100, Luescher Samuel (MMVZSLU) wrote: >>

[PHP-DB] Remote Oracle Connection

2001-02-04 Thread Doug Schasteen
Am I blind? Or is there no support with the regular oracle functions to connect to a database that is hosted on another machine? The manual has this: $conn = Ora_Logon(username, password); but I don't see anywhere to put the host string. - Doug Schasteen

[PHP-DB] How to set up PHP to access Oracle

2001-02-05 Thread Doug Schasteen
another company hosts my website, so I don't have authority to make any changes. If it isn't too hard, then I might be able to convince them to make the changes for me. - Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comman

Re: [PHP-DB] case insensitive search

2001-02-10 Thread Doug Semig
s not specify anything else for it.) To sum it up, try these: ... WHERE UPPER(blah) LIKE UPPER('%blah%') ... WHERE blah ~* '*blah*' (Note the regex-like pattern specifiers) ... WHERE blah ILIKE '%blah%' (Only on the next version) Doug At 06:36 PM 2/10/01 +1000,

Re: [PHP-DB] PHP security

2001-02-20 Thread Doug Schasteen
As far as I know, you can not download PHP programs without access to download them. Meaning you need an account on the webserver, so they would need your account user and pass before they could steal your mysql user and pass. I don't know how frontpage works, but it would probably have to call on

[PHP-DB] Looking for free temp hosting; php w/ oracle support

2001-03-04 Thread Doug Schasteen
nfigured to connect to my school's oracle server. Drop me an email if you would be willing to help. Thanks. Doug Schasteen [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To cont

Re: [PHP-DB] upperCase

2001-03-11 Thread Doug Semig
Your personal dancing monkey says: strtoupper()http://www.php.net/manual/en/function.strtoupper.php RTFM. Doug At 06:01 PM 3/11/01 +0800, Hoo Kok Mun wrote: >Hi, > >I am using mysql-3.22.32 with php4. > >I have a little problem with the uppercase. >I wanted to display

Re: [PHP-DB] Oracle connection

2001-03-12 Thread Doug Schasteen
can odbc be used from php on linux, or is it just a windows thing? - Original Message - From: "Andrew Hill" <[EMAIL PROTECTED]> To: "Joe Brown" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 12, 2001 5:32 PM Subject: Re: [PHP-DB] Oracle connection > Or, you can use ODBC :

[PHP-DB] Need space!!! php w/ oracle support

2001-03-18 Thread Doug Schasteen
ect to my school's oracle server. Drop me an email if you would be willing to help. Thanks. Doug Schasteen [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] simple sql question

2001-03-27 Thread Doug Semig
n two mutually exclusive sets of dates. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DAT ETIME How about "...WHERE startDate >= '2001-03-01' AND startDate < '2001-04-01'" to pull out all of the March events? Doug At 06:49 PM 3/27/0

Re: [PHP-DB] help with a parse error

2001-03-28 Thread Doug Semig
all I can think of. By the way, (and it shouldn't matter...) but have you also tried removing the space in the "end if;" (part of your larger if:-else:-endif; statement)? I personally don't use that alternative syntax, so I don't know if the space matters. Doug At 01:22

Re: [PHP-DB] help with a parse error

2001-03-28 Thread Doug Semig
Gee...all I looked at were the semicolons and the braces (those are what I mess up on the most). I guess it's a good thing I mentioned the space in the endif! It turns out that if you use that syntax, you cannot have a space there. Doug At 01:19 PM 3/29/01 +0930, Timothy Aslat wrote: &

Re: [PHP-DB] Best way to check if a query succeeded

2001-03-29 Thread Doug Semig
at least 3.23.36 or have transaction support compiled in. Doug At 12:00 PM 3/29/01 +0100, Jordan Elver wrote: >Hi, >i was just wondering what you guys do to check if a wquery suceeded or not? >I know about mysql_num_rows() and mysql_affected_rows(), just wondered what >you guys do? >

[PHP-DB] Selecting between using letters

2003-12-29 Thread Doug Parker
How would I create a select statement in MySQL that would return a range of records from the LastName field where the value starts with a designated letter - for example, returning the range where the first letter of LastName is between A and E... Any help would be greatly appreciated.

Re: [PHP-DB] Re: php/mysql weblog - addnews function problems

2004-02-18 Thread Doug Thompson
T['postdate']."',"; $query .= "'".$_POST['title']."',"; $query .= "'".$_POST['newstext']."')"; You should also add some db error checking and reporting, then you wouldn't get the erroneous "success" message. hth, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Q

2004-02-22 Thread Doug Thompson
On Sun, 22 Feb 2004 11:02:29 EST, [EMAIL PROTECTED] wrote: >Dear friends, > >I have pap4, mysql, apache installed. How do I enable to access > /"$_SERVER[PHP_SELF]/" >.Comments, please Correct your syntax errors: \"$_SERVER['PHP_SELF']\"

Re: [PHP-DB] SQL File Import problem (Was: HELP!!!)

2004-02-26 Thread Doug Thompson
; somefile.sql Of course, all the foregoing syntax for re-installing presumes *n*x. I move databases from my local windows system to a remote *n*x site frequently using the above process and it is very reliable and repeatable. hth, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySql PHP API

2004-03-01 Thread Doug Thompson
that has caused them to stop working? Is the installation on your local machine or on a remote server? More importantly, you need to provide a cut-and-paste copy of the portion of the code that isn't working and all error messages being returned by the system. Finally, please don't cros

Re: [PHP-DB] Password encryption

2004-03-04 Thread Doug Thompson
you have no knowledge of their password(s). Neither does anyone else who hacks in. hth, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Password encryption

2004-03-04 Thread Doug Thompson
vides more information than you want. Doug On Thu, 4 Mar 2004 15:35:52 -0500, Kevin wrote: >Hi Doug and All, > >I am real new to PHP and wanted to know if you can explain the >[md5("password");] code? Is this a set function? > >Thanks, >Kevin > >- Original M

Re: [PHP-DB] How to calculate size of INT(x) field

2004-03-05 Thread Doug Thompson
example, INT(4)). There is much more about how INT(x) works, but if I copied it all to here you wouldn't discover the other useful information available. Doug On Fri, 5 Mar 2004 11:29:03 +, Richard Davey wrote: >Hi all, > >Sorry for such a newbie question! But I have been d

Re: [PHP-DB] Re: How to calculate size of INT(x) field

2004-03-05 Thread Doug Thompson
d for values whose width exceeds that specified for the column. ..." http://www.mysql.com/documentation/mysql/bychapter/manual_Column_types.html#Numeric_types Pay particular attention to the second and third sentences in the excerpt above. Doug >Best regards, >Chris > >> >> Kae > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Pulldown value not passed to next page

2004-03-11 Thread Doug Thompson
Hi Karen, Depending upon the method used for your form, you should be able to find the value in either $_GET['pagesize'] or $_POST['pagesize']. hth, Doug Karen Resplendo wrote: What is wrong with this picture? I build a pulldown for selecting page size(number of rows in o

[PHP-DB] Stuck on basic concept, how to use a list selection?

2004-03-19 Thread Doug F
I want to: Populate a dropdown list with values from a MySQL db (done and working). Use the selected value as the 'where' clause in a second query. Return the results and display them to the user. Any pointers are appreciated - noob^3 (html, mysql, and php). Doug Code that

Re: [PHP-DB] tick mark `

2004-03-22 Thread Doug Thompson
Craig: I don't see a reply to your question in today's posts. "Backticks" or "tick marks" allow you to use reserved words for column names. Interval is a reserved word. Hope you weren't waiting this long for a response. Doug Thompson Craig Hoffman wrote: Why

Re: [PHP-DB] Strange problem with mySQL

2004-03-25 Thread Doug Thompson
w that the script made a valid connection and db selection? Put an ECHO $query; statement and some other error checking in there and quit tearing out your hair over assumptions that may be wrong. Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: spam: [PHP-DB] php, mysql security question

2004-03-31 Thread Doug Thompson
JeRRy wrote: Hi, I have a php, mysql security question. You know how there is a way to enable/disable hot linking to your images via CPanel to allow/disallow people to link to your images from an external site? Well is there a way to allow/disable external sites connecting to a mysql via P

[Fwd: Re: [PHP-DB] php, mysql security question]

2004-03-31 Thread Doug Thompson
Oops. For some reason my filter concluded your email was spam and it modifies the subject line. I missed cleaning the subject line on the first reply. Here is is again in case others filter on that keyword. I apologize for the double post and possible confusion. \Doug JeRRy wrote: Hi, I

Re: [PHP-DB] Can't access HTTP Post Array

2004-04-10 Thread Doug Thompson
[EMAIL PROTECTED] wrote: I'm running Apache/2.0.49 and PHP/4.3.5 on windows XP with MSIE 6.0. -- local host. When I try to access the variables in the array (HTTP POST), they are empty or null. Did I miss a PHP or Apache setting in the php.ini or httpd.conf? Use$_POST['array_eleme

Re: [PHP-DB] Handling missing rows on joins

2004-04-21 Thread Doug Thompson
all users assigned to that level to a different one. Any suggestions for handling this better would be appreciated ... TIA Rene Maybe I haven't had enough coffee, yet, but my first inclination is to suggest adding a user_status flag to hf_users. Doug -- PHP Database Mailing List (http://w

Re: [PHP-DB] supernoob strikes again

2004-05-09 Thread Doug Thompson
() to test for this condition. Doug Finished product at http://www.dibcomputers.com/new-dibcomputers/index.php.txt if anyone wants to steal it... D -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PostgreSQL lib and character case

2004-04-28 Thread Doug Thompson
Tumurbaatar S. wrote: I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? Assuming you want all lower case, convert the form field entry usi

Re: [PHP-DB] Getting a result from MAX() query

2004-07-13 Thread Doug Thompson
t;SELECT fee_recd FROM members ORDER BY fee_recd DESC LIMIT 1",$connectup)or die ("Query failed:$latestError: " . mysql_error()); Louise Here's a concept: RTM "In MySQL versions prior to Version 3.22.5, you can use MAX() instead of GREATEST. " What does your inquiry

Re: [PHP-DB] Case sensitive search

2004-07-18 Thread Doug Thompson
7; " - it return me both rows. http://dev.mysql.com/doc/mysql/en/Case_Sensitivity_Operators.html Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Php if statement in a form

2004-08-05 Thread Doug Thompson
if (is_null($row["timeout"]).) [EMAIL PROTECTED] wrote: Still no joy. The parse error actually refers to the -- if ($row["timeout"] IS NULL); --- line. -Original Message- From: Eric Schwartz [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 11:32 AM To: [EMAIL PROTECTED] Subject:

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

2004-08-18 Thread Doug Thompson
[EMAIL PROTECTED] wrote: I finally got my PHP5 installation to support MySQL and now this. When I try to edit anything on mysqlgui.exe, it just gives me this error: error in database function: access denied for user @localhost... I don't know if this has to do with my php installation or what. I

Re: [PHP-DB] Q

2004-08-22 Thread Doug Thompson
[EMAIL PROTECTED] wrote: Dear Friends, Data in the table is displayed by php query. .Say column A, in which name of company will be stored. Now i want to add another column B to table in which web addresse will be stored against each name in Column B.and same should be displayed in an html table

Re: [PHP-DB] mysql results with limit

2004-09-04 Thread Doug Thompson
SQL_CALC_FOUND_ROWS as it works somewhat differently, and probably faster, than the approach you suggest above. This function was introduced in mysql 4.0.0. http://dev.mysql.com/doc/mysql/en/Information_functions.html Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] where can I post some mysql related questions?

2004-09-19 Thread Doug Thompson
Mike wrote: hi, I've currently been looking for a mysql news server where I could post some questions on mysql database design (cause they shurely wouldn't fit here) and I have yet to find one. Can anyone help? http://lists.mysql.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubs

Re: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Doug Thompson
e Alabama great it gives back to me all accounting and finance records Alabama But if I add in LocationState, Alabama and California then a no records is returned. Anyway, if anyone has some pointers or ideas I'd greatly appreciate. Stuart You need LocationState to be, in your example, Alabama OR California. Also, I would write that SQL phrase "LocationState = 'Alabama' OR LocationState='California' ". Doug Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] parse error in php backend sqlite

2004-10-20 Thread Doug Thompson
t_error($handle))); if (sqlite_num_rows($result) > 0) { echo ""; while ($row = sqlite_fetch_array($result)) { echo ""; echo "".$row[0].""; echo "".$row[1].""; echo "".$row[2].""; echo "".$row[3].""; echo "".$row[4].""; echo "".$row[5].""; echo "".$row[6].""; echo "".$row[7].""; echo "".$row[8].""; echo "".$row[9].""; echo ""; } echo ""; } sqlite_close($handle); ?> i would appreciate if you can help me in correcting this error.. thanks in advance.. sai Your braces don't match up. The problem starts at the ELSE statement in line 33. Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problems with mysql_num-rows()

2004-10-31 Thread Doug Thompson
m user where name='".$userid."' and pass=password('".$password."')" Good luck, Doug Arne Essa Madsen wrote: I have the following problem: This one does not work: $query = "SELECT * from user where name='$userid' and pass=password('

Re: [PHP-DB] MySQL problem..

2004-11-08 Thread Doug Thompson
ian wrote: Any body met this error? Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /usr/local/apache2/html/poems/browse.php on line 15 http://dev.mysql.com/doc/mysql/en/Old_client.html -- PHP Database Mailing List (h

[PHP-DB] timestamp problem

2004-11-18 Thread Doug Parker
I'm trying to format a MySQL Timestamp Column Type with PHP, and it's not going well. In reading up on it, I see that the idea is to convert the Timestamp type to Unix format using the strtotime() function, then using the date() function to format that result. However, this only appears to work w

Re: [PHP-DB] timestamp problem

2004-11-18 Thread Doug Parker
d %Y', projects.Date1) AS Date1, DATE_FORMAT('%m %d %Y', projects.Date2) AS Date2,... etc" any other suggestions? "John Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Doug Parker wrote: > > I'm trying to format a MySQL Timestamp

[PHP-DB] Cisco UBR interface with PHP

2004-11-19 Thread Doug Finch
ou have to have enable mode access to run this function and two, I would fear creating a security loophole by running an enabled function all of the time. Can I get your thoughts on this? thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php newsletter with mysql data

2004-11-22 Thread Doug Thompson
ok at http://hotscripts.com/PHP/Scripts_and_Programs/index.html They have several hundred scripts listed, some free - some not, that can help you complete your project quickly. Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] searching an entry in inventory db

2004-12-04 Thread Doug Thompson
Aravalli Sai wrote: hi i had designed an inventory management system where in i can ADD,INSERT,DELETE,UPDATE the data elements..but when i am trying to find(search) an entry in theinventory data base system (i want to find the entrybased on the "tagno" since this is the primary key in my table) t

Re: [PHP-DB] select particular columns in query

2004-12-08 Thread Doug Thompson
The manual is your friend. You cannot execute the SQL statement you provided because mysql specifically disallows it: http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html Same reference, your presumption about auto-increment columns is also wrong. Doug blackwater dev wrote: Hello, I want to

Re: [PHP-DB] List Active??

2004-12-29 Thread Doug Thompson
Dave, The list has been very active with many posts per day all week. Based on your domain, you might check with the sysops and see if they've done any updating to firewalls and/or corporate filters. Good luck, Doug [EMAIL PROTECTED] wrote: Just testing the list mail server as I haven'

Re: [PHP-DB] MySQL version issue

2005-01-04 Thread Doug Thompson
n general, you should try to avoid using the ON DUPLICATE KEY clause on tables with multiple UNIQUE keys." Or, you might find a more interesting answer on a MySQL list. Doug Mark Benson wrote: As some of you will recall, I enquired on this list about versions of MySQL and PHP a while back rega

Re: [PHP-DB] Re: MySQL version issue

2005-01-05 Thread Doug Thompson
I isn't my intention to start a peeing contest, but if *you* get rid of the chip and actually read the manual excerpt, the equivalent SQL statements it cites are very definitely available in mysql 3.xx.xx. DT Mark Benson wrote: Doug, read my e-mail again, specifically the second and

Re: [PHP-DB] Integrating Interbase.so and PHP

2005-01-15 Thread Doug Thompson
/?l=php-db&m=107118069802473&w=4 Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Doug Thompson
upposed to. Doug Shay wrote: My hosting company gave me one database and one root user account, and I have no access for priviliges at all. So as far as I can tell, the only way for me to connect to the database on my site is to do a mysql_connect("host", "user", "pass"

Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Doug Thompson
you have a business model that calls for that. In which case, refer to my first comment in my original reply. I have a question about what you said Doug: Use INCLUDEs for the login portions of the script(s) and place them in a protected directory. If >you are unable to protect director

Re: [PHP-DB] Given only one mySQL user account by Host Company

2005-01-23 Thread Doug Thompson
quot;test" 5. Attempt to create new user "foo" with (any) privileges on test.testtable. You will receive the following error message: "Error Code : 1044 Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'" Shay is in the same boa

Re: [PHP-DB] PHP4 MSSQL Error handling

2002-07-24 Thread Doug Durham
$result=mssql_query($sql2)or die("sql2 failed" . mysql_errno() . ": " . mysql_error()); At 04:48 PM 7/24/2002 -0700, Salve Tinkerworth wrote: >Does anyone have any good tips for error handling? I've tried different >methods to retrieve good error information from mssql_query but nothing >seems t

Re: [PHP-DB] PHP4 MSSQL Error handling

2002-07-24 Thread Doug Durham
Oops! Sorry all, wrong db. At 05:05 PM 7/24/2002 -0700, Doug Durham wrote: >$result=mssql_query($sql2)or die("sql2 failed" . mysql_errno() . ": " >. mysql_error()); > >At 04:48 PM 7/24/2002 -0700, Salve Tinkerworth wrote: >>Does anyone have any go

[PHP-DB] Re: need an idea...

2002-09-06 Thread Doug Smith
g. I've seen results on PriceWatch that say some things along the line of "It's this price ONLY if you mention PriceWatch" -- which to me, is a hint that people submit their prices to that site, or possibly even pay to participate in it. But... That's only a best guess. HT

[PHP-DB] Structure Question...

2002-11-07 Thread Doug Coning
ny to many relationship? Thanks, Doug Coning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] NewB: Return New Record ID...

2002-12-05 Thread Doug Coning
tion to be populated based on the ID it first returned. How would I do this? Thank you, thank you! Doug Coning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2001-04-08 Thread Doug Semig
ool available to you * suitability to a task * features * security * scalability * portability And in Matt's case, it may be that MySQL is the one that should be used. But certainly unfounded hype is not among the reasons anyone should select a platform. Doug At 10:22 AM 4/7/01 +0200, J

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

2001-04-08 Thread Doug Semig
and WinCVS. This laptop that I'm typing on right now is outfitted as described. I couldn't buy this laptop without Win98 so I am still using it. (Maybe my next laptop won't be so limited?) Anyway, getting PostgreSQL to work on Win32 is a PITA. PostgreSQL does work on Win32. I know b

Re: [PHP-DB] Separating paragraphs in mySQL?

2001-04-09 Thread Doug Semig
nl2br() is useful in such cases. http://www.php.net/manual/en/html/function.nl2br.html Doug At 11:32 AM 4/9/01 +0800, sam wrote: >Hello, > >I have this field filled up from within a text area. Something the same as >that on message boards but something that has more characters i

Re: [PHP-DB] SELECT query

2001-04-13 Thread Doug Semig
Have you thought about normalizing your data model? It could make your task a lot easier. Doug At 11:33 PM 4/13/01 +0530, Sharmad Naik wrote: >I have three table called table1, table2, table3 all having fields like: >table1 contain id and username and id referencing table4 >table2 co

Re: [PHP-DB] Postgres auto increment.

2001-04-13 Thread Doug Semig
Just off the top of my head...so please forgive any typos or blatant mistakes... CREATE SEQUENCE sequencename; CREATE TABLE mytable ( id int DEFAULT NEXTVAL('sequencename'), whatever varchar(32), PRIMARY KEY(id) ); Doug At 11:28 PM 4/13/01 -0600, John Starkey wrote: >I&

[PHP-DB] Oracle session cursor

2001-04-15 Thread Doug Schasteen
fo would be helpful. This project is due on wednesday so I need the help ASAP. Thanks. - Doug Schasteen

Re: [PHP-DB] php with mysql or interebase?

2001-04-17 Thread Doug Semig
esses, you really should pick the platform based upon your needs, even the best database will not help you if you start with a poorly designed schema. Doug At 02:33 PM 4/17/01 -0400, [EMAIL PROTECTED] wrote: >I'm trying to decide whether to use interbase or mysql with php. >Both are free

Re: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

2001-04-18 Thread Doug Semig
the value has been updated by someone else...you can show the value and ask if they want to proceed with the update, but that's all up to you and/or your interface designers. This is all similar to how folks design old fashioned screen-oriented database systems (like with CICS). Good lu

Re: AW: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

2001-04-18 Thread Doug Semig
PROs above and could become a CON because it could mean that programmers can list unnecessary fields in the UPDATE statement, which is unnecessary network traffic. There are other pros and cons, but that's enough to get anyone who is interested in this topic started. Doug At 11:23 PM 4/

[PHP-DB] mysql --> Commercial DBs, When will I need to upgrade?

2001-04-19 Thread Doug Schasteen
ng to give me a head start in my research. Point me in the right direction! - Doug Schasteen [EMAIL PROTECTED] P.S. - if you know of any good articles online that compare different servers or databases please share.

Re: [PHP-DB] Treelike data: adjacency list or nested sets?

2001-04-20 Thread Doug Semig
able. If you have to modify the tree/categories later on, it can get hairy. Doug At 02:40 PM 4/20/01 +0200, Tomás GarcíY+0=a Ferrari wrote: >Hello, > >I'm developing a system (with PHP-MySQL) in which I will have different >articles published. Any given article can correspond to

[PHP-DB] Need Database Design help

2001-05-18 Thread Doug Schasteen
order to get the database to work. If anyone out there is a database design expert and can see my mistake right away, please help me out. - Doug Schasteen

[PHP-DB] Unable to Load Modules (php_oci8.dll)

2001-05-19 Thread Doug Schasteen
find module d:\php\extensions\php_oci8.dll" when I know for a fact that it is in that directory as well as many others. Is there another file I need to add to system32 that php_oci8.dll requires? I never ran into this problem installing oracle and php on win98 and PWS. - Doug

Re: [PHP-DB] sql problem

2001-06-26 Thread Doug Semig
ill doesn't bring it on topic, but at least I tried.) Doug At 11:54 AM 6/26/01 +0800, Fai wrote: >SELECT @A:=SUM(salary) FROM table1 WHERE type=1; >UPDATE table2 SET summmary=@A WHERE type=1; > >What does @A: mean? > >Thank you very much! > -- PHP Database Mailing L

Re: [PHP-DB] adding Carrol O'Conner in a form

2001-06-30 Thread Doug Semig
You may want to use stripslashes($name) in there instead of just $name. Doug At 09:18 PM 6/30/01 -0700, Ken Sommers wrote: >HI, >IF i add my name as Carol O'Conner in a form and Echo (PHP 4.06 on win 95) it back I see > >Carol O\'Conner > ... snip ... > >I a

Re: [PHP-DB] Interbase: how can I insert null values with placeholders?

2001-07-06 Thread Doug Semig
integer = "NULL"; /* notice the quotes */ it may work. This would make the $asinteger PHP variable a string, but since the SQL would either like to have a numeric value there or the keyword NULL, that is probably what you want. Good luck, Doug At 07:23 PM 7/6/01 +0200, Kiss Marton wrote: >

Re: [PHP-DB] Re: enum !!

2001-07-16 Thread Doug Semig
arter of this mailing list. The overall purpose of this particular mailing list is for discussions about PHP's ability to interface with databases. There may possibly be an SQL beginners mailing list on egroups or someplace similar...you might find an environment like that better than the P

RE: [PHP-DB] 2 Tables- 1 Insert Problem

2001-07-29 Thread Doug Semig
nd if it doesn't then either change databases or web hosts), use them. It helps ensure the integrity of the data. Please feel free to be more elegant in the error checking...the above is just an example and would undoubtedly not be used, even fixed up for syntax, on a production site. D

[PHP-DB] Problem importing large db to mysql in windows

2001-08-01 Thread Doug Schasteen
kips straight to "SQL command executed successfully" but says "No Tables", so obviously it isn't even trying to run the file. This is almost exactly what was happening on the "dump" end before I started using mysqldump. So, what's the IMPORT equivalent of mysqldump and how do I run it on windows? - Doug Schasteen

RE: [PHP-DB] Problem importing large db to mysql in windows

2001-08-01 Thread Doug Schasteen
know? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 10:41 AM To: Doug Schasteen; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Problem importing large db to mysql in windows It sounds like the problem you are having is the same one

Re: [PHP-DB] SQL Help?

2001-08-16 Thread Doug Semig
from a where a.id NOT IN (select id from b); There are undoubtedly other ways to do this, but the above query works on an old PostgreSQL installation I mess around with sometimes. Hope this helps. Doug At 02:30 PM 8/16/01 -0700, Barry Prentiss wrote: >Hi, > Here's another SQL que

Re: [PHP-DB] MySQL DB CleanUp Help!

2001-08-23 Thread Doug Semig
could log status messages and errors to syslog or a file or a db table. Good luck! Doug At 03:30 PM 8/23/01 +0800, Jason Wong wrote: >- Original Message - >From: Arcadius A. <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Thursday, August 23, 2001 9:28 PM >

Re: [PHP-DB] Database "Transactions" and HTTP statelessness

2001-08-28 Thread Doug Semig
n and notifying the user that the record has already been modified by another user or process). Hope this helps! Doug At 02:02 AM 8/29/01 GMT, Bopolissimus Platypus wrote: >hello all, > >I've got a question about what's got to be a common problem. >I'm sort of doing

Re: [PHP-DB] Database "Transactions" and HTTP statelessness

2001-08-29 Thread Doug Semig
changed by the user with the fields as they appear in the record during the transaction that UPDATEs the record. If they're different then those fields really have been modified by another user or process and the transaction should be abandoned until the user gets a chance to review the situation.

Re: [PHP-DB] SELECT giving too much :)

2001-08-29 Thread Doug Semig
Hi Beau-- This is just a wild guess (I've only glanced at your SQL), but do you have two locations in your locations table? You might want to try yanking locations out of the join since you're not using it in your WHERE clause or showing any info from it. Doug At 12:06 PM 8/30/01 +

RE: [PHP-DB] SELECT giving too much :)

2001-08-29 Thread Doug Semig
of ELIZA (or whatever it was) style programs? Dang! 2 minutes! Good job . Doug At 12:33 PM 8/30/01 +0800, Beau Lebens wrote: >Actually yes I do :) >thanks for that - it fixes it when i remove the "FROM locations" >although I didn't want to have to pull it, because

RE: [PHP-DB] Simple database error (SPACE)

2001-08-30 Thread Doug Semig
all in one big echo, but think maintainability. Hope this helps, Doug At 05:01 PM 8/30/01 -0700, Nagasea wrote: >it's still not working :( > >maybe u need my script to see > >$db = mysql_connect("localhost", "","pass"); > >mysql_select

Re: [PHP-DB] Really weird problem: cross-server databasing *g*

2001-09-01 Thread Doug Semig
for you for a monthly fee? Doug At 04:42 AM 9/2/01 +0200, Markus Mayer wrote: >Hi folks! > >Let's say you have two servers, on the first one ("A") you have your website >containig all those nice php scripts and co but only a crazy small database >(2 megs), on the seco

Re: [PHP-DB] Searching sql database using php

2001-09-02 Thread Doug Semig
Yes. If you have a specific question, please post it and I'm sure folks will be willing to try to help you out. Doug At 12:50 PM 9/3/01 +1000, Devon wrote: >As per topic anyone know how to do it? > >Cheers --Doug's Signature File ~ ~

[PHP-DB] Re: Forms Question

2001-09-07 Thread Doug Granzow
I would think you would want the "name" of your select to be "store" and not "$store". That way the value will be in the variable $store when the form is submitted. Now, as I understand, what you want is for the value of $store from the database to be preselected when the form is displayed. You

Re: [PHP-DB] DB design question (so maybe a little OT)

2001-09-07 Thread Doug Semig
n the future. Hope this helps, Doug At 08:26 PM 9/7/01 +, Alexander Deruwe wrote: >Hey all, > >I have 4 database tables, that each describe some sort of 'person' >(transporting company, truck-driver, ..) and have almost exactly the same >fields. >Is this the best way o

[PHP-DB] Looking for a PHP/MySQL Developer for short project

2001-10-01 Thread Doug Daulton
someone with lots of dev experience in this environment. If you are interested in working on this, please email me at [EMAIL PROTECTED] Please include your number of years experience in this environment, hourly rate, current availability, links to some sample sites and two professional refer

[PHP-DB] Warning: MySQL: Unable to save result set

2001-10-22 Thread Doug Schasteen
ideas? - Doug

[PHP-DB] Looking for a JavaScript routine built by PHP and populated from MySQL

2001-11-08 Thread Doug Daulton
reset next to av1 (create loop) Does that description make sense? Has anyone already written a similar beast? I am in a time crunch, any and all help is appreciated. Regards, Doug Daulton -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addit

[PHP-DB] Return 1 instance of each unique record?

2002-12-06 Thread Doug Coning
Hi everyone: How do I get MySQL to summarize a query so that I receive only 1 instance per similar record. I.E. if you have 10 records with name "Smith" and 5 records with "Barney, etc, that it would return 2 records instead of 15. Thanks! Doug Coning -- PHP Database Mai

Re: [PHP-DB] Return 1 instance of each unique record?

2002-12-06 Thread Doug Coning
MySQL on the terminology I'm used to, which in this case was "summarize by"and found nothing. Then I have to bother you guys to find out what the correct verbage is. Thank you for your patience! Doug - Original Message - From: "Adam Williams" <[EMAIL PROT

[PHP-DB] approaching a relational database

2002-12-15 Thread Doug Parker
I'm about to embark on a project where I have to enter many, many fields into a MySQL database, and I don't know how to approach the database structure. The data is statistics for a golf course. There are 18 holes, and each hole has a Red Tee Par, White Tee Par, and Blue Tee Par, which is 54

[PHP-DB] Re: approaching a relational database

2002-12-16 Thread Doug Parker
think of, but i'm not too experienced in database design, so i figured i'd ask. Thanks, Doug Stas Trefilov wrote: > Doug Parker wrote: > > I'm about to embark on a project where I have to enter many, many fields > > into a MySQL database, and I don't know how to approa

  1   2   >