Re: [PHP-DB] use php variable within postgresql query

2023-06-12 Thread Michael Oki
'{$databasequery2['databasecolumn']}'"); > echo $databasequery3 > " > > The html file 2 shows: > " > resource id#3 > " > > The expected result was to show all columns for the row constraint > (...WHERE ...) > > It seems that

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Michael Stowe
Can we kill this thread? Or can you guys continue the conversation between yourselves. We now have 8 emails pertaining to the technical question, and 8 emails ranting about him asking it. I understand that some people do not believe this is the appropriate forum for that question - but personal

Re: [PHP-DB] Subject Matter

2013-08-26 Thread Michael Stowe
*"There are a lot of off topic emails sent. But there is far more whining and **complaining. Good grief!" +1* Let's remember that not everyone on the list is an expert programmer or someone with years of DBA experience. The purpose of the list (IMHO) is to HELP others with their PHP/DB questions

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Michael Oki
Install Komodo IDE or Adobe Dreamweaver. They'll highlight errors and warnings. On 23 August 2013 08:20, Lester Caine wrote: > Ethan Rosenberg wrote: > >> Dear List - >> >> How do I configure Bluefish for PHP? I am running version 2.2.4 of >> Bluefish. >> > > I'd forgotten about bluefish. You

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Michael Oki
Simply install wamp server and save yourself from separate installation of MySQL,PHP,Apache server,phpMyAdmin and sqlite. Check the link below. http://wampserver.com On 23 August 2013 01:29, Ethan Rosenberg wrote: > Dear List - > > How do I configure Bluefish for PHP? I am running version 2.2

Re: [PHP-DB] mysql query

2013-08-22 Thread Michael Oki
Try the insertion like this: $sql2 = mysql_query("insert into Inventory (`UPC` , `quant`, `manuf`, `item`, `orderpt`, `ordrpt_flag`, `stock`)" ."values ('$upc', $qnt,'$mnf','$itm', '$odrpt', '0', '$stk') " ) or die(mysql_error()); On 22 August 2013 05:10, Daniel Kro

Re: [PHP-DB] Re: Problem with query

2013-06-25 Thread Michael Oki
I'm sorry I've not been following the last three responses. In a nutshell, what "EXACTLY" does the poster of this issue want? On 25 June 2013 11:06, Toby Hart Dyke wrote: > > What Jim means is here in the manual: > > http://www.php.net/manual/en/**language.types.array.php#** > language.types.ar

Re: [PHP-DB] Re: AJAX/Javascript??

2013-02-11 Thread Michael Oki
Create a form and add a submit button that will run a php file. The SQL query in the php file will have something like "SELECT custName FROM table WHERE lname='$lname'; This will come after you have retrieved the data from a form like this $lname = $_POST['lname']; On 10 February 2013 15:45, Jim

Re: [PHP-DB] PDO user question

2012-09-09 Thread Michael Stowe
How are you using the number? Probably the easiest way is to utilize PDOStatement::FetchAll() and then do a count() on that result set. - Mike Sent from my iPhone On Sep 9, 2012, at 11:42 AM, Stefan Wixfort wrote: > Hi Jim > >> I've had some success with querying using pdo and prepared s

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Michael Stowe
ng(0) "" returned for both. Thanks, Mike On Tue, Mar 13, 2012 at 10:53 AM, Gu®u wrote: > No Michael, your code is also not working. What you have understood is > correct. let me explain it to others too. > > If variable twitter and facebook are empty don't echo anyth

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Michael Stowe
>From looking at your code, the issue is that your if statements are checking for the same criteria as your else statements, meaning that if the string is empty ("") the if statements will be triggered, and since the if statements are true, the elseif statement will not be. Or if the string isn't

Fwd: [PHP-DB] Select from multiple tables

2012-03-01 Thread Carl Michael Skog
-- Vidarebefordrat meddelande -- Från: Carl Michael Skog Datum: 1 mars 2012 17:12 Ämne: Re: [PHP-DB] Select from multiple tables Till: Kranthi Krishna It seems to me that you are mixing two semantically different things(board_entries and schooltypeentries, both related to

Re: [PHP-DB] Connecting PHP to MySQL on Windows - RESOLVED

2011-01-10 Thread michael manning
> BR > > Gavin > > On Fri, Jan 7, 2011 at 4:18 AM, michael manning > wrote: > > > Hi, > > > > I swapped out 'localhost" for '127.0.0.1' in the url but this had no > > effect. > > > > I had a look at my hosts file

Re: [PHP-DB] Connecting PHP to MySQL on Windows

2011-01-06 Thread michael manning
127.0.0.1 localhost ::1 localhost and so this seems fine as well. cheers Mike On Fri, Jan 7, 2011 at 1:25 PM, Daniel Brown wrote: > On Thu, Jan 6, 2011 at 21:12, michael manning > wrote: > > Hi Daniel, > > When testing with the CLI, netstat shows: > [snip!] &g

Re: [PHP-DB] Connecting PHP to MySQL on Windows

2011-01-06 Thread michael manning
:49 AM, Daniel Brown wrote: > On Thu, Jan 6, 2011 at 01:13, michael manning > wrote: > > Hi, > > > > I have installed MySQL 5.1.52, Apache 2.2.15 and PHP 5.3.2 on my Windows > > Vista computer. > > The MySQL works fine with the command line client and I ha

[PHP-DB] Connecting PHP to MySQL on Windows

2011-01-05 Thread michael manning
Hi, I have installed MySQL 5.1.52, Apache 2.2.15 and PHP 5.3.2 on my Windows Vista computer. The MySQL works fine with the command line client and I have tested the Apache and PHP and it appears fine when I test this with the phpinfo() function. There is just one exception - I cannot connect to a

[PHP-DB] how is this line a security risk?

2008-09-23 Thread michael
I get an error stating that this line in my code is a security risk when I code it. require_once($PLUGINS_DIRECTORY."forum/forum.php"); here is what the explanation is: include() or analogous is used with variable argument this can be dangerous since variables are in many cases controlled by

[PHP-DB] Wrong results with ORDER BY DESC

2008-05-28 Thread Michael Kelly
Hey all. I installed Apache and PHP onto my computer to use for testing about six days ago, and have had MySQL installed for a few weeks before. It all works fine, except for certain queries PHP gets very odd and inconsistent results back. Here's an example. This query, in both PHP and through

Re: [PHP-DB] parameters not working under PDO

2007-10-31 Thread Michael Preslar
Check $parts.. print_r($parts) and make sure its 1) an array 2) contains 2 values On 10/31/07, Chris Curvey <[EMAIL PROTECTED]> wrote: > It's quite possible that I'm missing something obvious here. The > following code fragment does not return any rows, but if I take out the > parameters and repl

Re: [PHP-DB] Updating 2 Databases from a single form

2007-09-27 Thread Michael Preslar
On 9/27/07, Derek <[EMAIL PROTECTED]> wrote: > Hello, > > I was wondering if there is anyway to first connect to two databases > simeltaneously. (both reside on the same server) . After connecting, I have > a single form that I want to use to update data to 2 different tables, both > tables are in

Re: [PHP-DB] Store more than 1 piece of information in a single variable

2007-08-03 Thread Michael Preslar
First.. You're using mysql_fetch_array when you wanted mysql_fetch_assoc.. .. select user_id from whatever .. and then $row = mysql_fetch_array($res) .. youd have a $row[0].. mysql_fetch_assoc would allow $row['user_id'] Secondly.. You can use one query to select all the info.. select e107.user_i

[PHP-DB] Re: mysql_real_escape_string

2007-02-17 Thread Michael Weaver
$web_site array which could then be looped through: for($i = 0; $i < count($web_site);$i++) { $web_site[$i] = mysql_real_escape_string($web_site[$i]); } Hope this helps and is what you are looking for Best regards, Mike Weaver -- Michael Weaver Founder/Chief Facilitator Dyna

[PHP-DB] Compare a given value with multiple values field

2006-09-16 Thread Michael Gargiullo
Using 'like' is your best bet. With multiple condition, you could restrict the return set further. Is there a way to restructure your table? I don't know what the data represents, but you could use a field per list item( you could then index it t get very fast results). You could also use 'l

RE: [PHP-DB] can you use php to connect to both FileMaker and MySQL simultaneously

2006-04-17 Thread Michael Scappa
I've never done it, but assuming there is a connector for filemaker, there is no reason you shouldn't be able to. -Original Message- From: Tami Williams [mailto:[EMAIL PROTECTED] Sent: Monday, April 17, 2006 3:14 PM To: php-db@lists.php.net Subject: [PHP-DB] can you use php to connect to

Re: [PHP-DB] Passwords

2006-03-10 Thread Michael Crute
On 3/10/06, Micah Stevens <[EMAIL PROTECTED]> wrote: > On Friday 10 March 2006 7:09 am, Michael Crute wrote: > > On 3/10/06, Dusty Bin <[EMAIL PROTECTED]> wrote: > > > One thing to remember, is that the password function is MySQL's way of > > > storing

Re: [PHP-DB] Passwords

2006-03-10 Thread Michael Crute
If(sha1($password) == $storedPassword) { >... >} > HTH... Dusty Just a note, I would never compare passwords like that, you should put sha1($password) in your SQL string as a condition and check to see if any rows where returned. -Mike --

[PHP-DB] Very Tricky PHP Array.

2006-03-06 Thread Michael Acs
Hi there, I have one arrray: $field_vals There are three values in the array, however two are multi-dimension array. i.e: $field_vals[base] -> Array ( [0] -> 1 [1] -> 2 ) $field_vals[make] -> Array ( [0] -> 5 [1] -> 7 [2] -> 8 ) $field_vals[qty] -> 1 I have a MySQL with a table (part) for the d

Re: [PHP-DB] Displaying Unix Timestamps as human readable dates / times?

2006-02-15 Thread Michael Crute
uld get the date displayed like 03.03.01 (for the 3rd March 2001). > Or is that incorrect? > Any tips greatly appriciated. > > > On 15/2/06 14:28, "Michael Crute" <[EMAIL PROTECTED]> wrote: > > > On 2/15/06, Alex Major <[EMAIL PROTECTED]> wrote: > >

[PHP-DB] Re: [PHP] pg_fetch_object

2005-09-23 Thread Michael Fuhr
("SELECT 'foo' AS val"); $obj = pg_fetch_object($result, 0, 'Foo', array("test")); var_dump($obj); pg_close(); The above code produces the following output: DEBUG: Foo(test) object(Foo)#1 (1) { ["val"]=> string(3

[PHP-DB] Re: Problem with mysql_connect(...)

2005-09-19 Thread Michael Louie Loria
tions again. Try checking as if it was a fresh install of PHP5 php5apache2.dll is for PHP5 and probably you httpd.conf stills contains php4apache2.dll Michael Louie Loria -BEGIN PGP SIGNATURE- Comment: Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8 Comment: Public Ke

RE: [PHP-DB] Losing the ability to connect to Oracle database

2005-04-20 Thread Michael Caplan
Leo, Please let me know how that works for you. I don't remember the specifics (if we where testing using plogon, nlogon or just logon), but we did try and implement that fix and it didn't work for us. Thanks, Michael -Original Message- From: Leo D. Geoffrion [mai

Re: [PHP-DB] Losing the ability to connect to Oracle database

2005-04-20 Thread Michael Caplan
a show stopper, and it appears that there are a few other big ones lying around... Michael -Original Message- From: Leo D. Geoffrion [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 8:27 AM To: php-db@lists.php.net Subject: [PHP-DB] Losing the ability to connect to Oracle datab

[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread Michael Stassen
The short answer is, download the php source and add --with-mysql=/your/path/to/mysql to your build options. The long answer is in the directions in the php manual <http://us4.php.net/manual/en/install.unix.php>. Michael GH wrote: I am still new to the PHP scene could you tell me

[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread Michael Stassen
rrent mysql client library. See the manual for more <http://dev.mysql.com/doc/mysql/en/old-client.html>. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed er

Re: [PHP-DB] Re: PHP vs ASP

2004-11-27 Thread Michael Gargiullo
On Sat, 2004-11-27 at 19:57 +0800, javagen wrote: > asp is not safe because asp only run in windows. > "Matthew Perry" <[EMAIL PROTECTED]> ÐÊ > news:[EMAIL PROTECTED] > > I need some ammo to convince my boss not to use ASP but use PHP instead. > > Appeal to his budget. php + mysql (Both will run on

[PHP-DB] Re: Optimize Query Output

2004-11-20 Thread Michael Stassen
, ', P.FirstName) = @name, '', @name:= CONCAT(P.LastName, ', ', P.FirstName) ) AS 'Name', A.AttID, S.SessionDate, A.Present FROM Attendance A, Sessions S, Participants P WHERE S.SessionID = A.Session AND P.Part_ID = A.Participant ORDER BY P.LastName, P.FirstName, S.SessionDate; Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: oci8 cannot connect after restarting DB

2004-11-18 Thread Michael Caplan
with the fix sitting commented in the current code) or abandond the oci8 library all together for PDO when it hits the streets (which will be some time). Best, Michael -Original Message- From: John Lim [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:42 AM To: [EMAIL PROTECT

[PHP-DB] oci8 cannot connect after restarting DB

2004-11-16 Thread Michael Caplan
this be a non issue?) Thanks, Michael

[PHP-DB] multiple returned lob resource being overwritten in oci8

2004-11-15 Thread Michael Caplan
{ var_dump($message->load()); } with the output being: clob4 clob4 clob4 clob4 In this example the lob resources are overwritten when you loop through the result set the first time around, resulting in all fetched lobs returning the value of the last lob in the result set. The question is: is this an oci8 bug or just how things have to be done? Thanks, Michael

[PHP-DB] Please point me in the right direction.......

2004-11-10 Thread Michael Cortes
oint me to the correct mailing list as I don't wish to start an inapropriate thread. Thank you. -- Michael Cortes Fort LeBoeuf School District 34 East Ninth Street PO Box 810 Waterford PA 16441-0810 814.796.4795 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: htt

[PHP-DB] Re: More help with restore server

2004-11-05 Thread Michael Cortes
just php/mysql) where I was able to solve a problem by skipping the rpm and just compiling from source. Has anyone else found this to be the case? On Wednesday 27 October 2004 02:42 pm, Michael Cortes wrote: > Here is another situation I find myself in. I did a rm -rf /var/* installe

[PHP-DB] More help with restore server

2004-10-27 Thread Michael Cortes
-7.3.6.i386.rpm and I get "package php-devel-4.1.2-7.3.6 is already installed" so I rpm -q php and i get "php-4.1.2-7 Something seems obviously wrong. I f anyone has ideas, I would welcome them. -- Michael Cortes Fort LeBoeuf School District 34 East Ninth Street PO Box

Re: [PHP-DB] gdbm locking problem

2004-10-25 Thread Michael Jeung
roblem surfaces. I also tried using just the "wl" mode, with the same result. Is there any problem between the interaction of gdbm and php and FreeBSD? I am using php 4.3.8, and FreeBSD 4.10.1 Thanks! Michael Jeung -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] gdbm locking problem

2004-10-25 Thread Michael Jeung
ite lock on the file! (using dba_open) \n"; } Here is the problem: When I run Script 1 and then Script 2 (while Script 1 is running), both scripts claim to have a writer lock on research.db. This doesn't seem right. What am I missing? I'm running both of the scripts in t

Re: [PHP-DB] mysql results with limit

2004-09-04 Thread Michael Gale
Excellent ... thanks that is exactly what I wanted. Michael. On Sat, 04 Sep 2004 20:21:46 -0600 Doug Thompson <[EMAIL PROTECTED]> wrote: > Michael Gale wrote: > > Hello, > > > > Right now I have a mysql select statement with the LIMIT option > > of 500

[PHP-DB] mysql results with limit

2004-09-04 Thread Michael Gale
back AWAY from the computer, your geek rights have been revoked !!! Michael Gale Slackware user :) Bluesuperman.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mac and mysql

2004-08-31 Thread michael
nk command line you think of the old dos prompt. What does the Mac have that will give us command line access? Again, please excuse my ignorance, but here is an opp to educate those of us stuck in a MS POV. Thank you in advance. Michael -- PHP Database Mailing List (http://www.php.net/) To uns

[PHP-DB] end of line

2004-08-29 Thread michael
Hi. I'm trying to find a simple way to allow a client to update a "notes" page on her site whenever she wants. I created a form which allows her to save a few paragraphs to a mysql table. What I want to do, though, is write her paragraphs to an html page so others can see her words. Is there a w

Re: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Michael Cortes
return. Does anyone know what ctrl seqence is line feed? Thanks On Thursday 19 August 2004 09:49 am, Michael Cortes wrote: > That didn't work. Here's why. This is not a dos file. It is a unix file > but when dumping the data from my db, some fields had a trailing CR and LF. &g

Re: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Michael Cortes
[filename], and you should be all set. > > -Mensaje original- > De: Michael Cortes [mailto:[EMAIL PROTECTED] > Enviado el: Thursday, August 19, 2004 1:36 PM > Para: [EMAIL PROTECTED] > Asunto: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB > > Howe

[PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Michael Cortes
/replace/g). But I cannot get the ^M in the string. If I actually hit it reads as a return; if I type ^M using the shift-6 then it looks for the actual characters. Can anyone help? -- Michael Cortes Fort LeBoeuf School District 34 East Ninth Street PO Box 810 Waterford PA 16441-0810

Re: [PHP-DB] I'm not getting any mailing list messages

2004-08-12 Thread J-Michael Roberts
Well, it's working over here. I think it just had to do with the list being quiet at the moment because I don't recall seeing any new posts in a while. --JMR Chip Wiegand wrote: I just subscribed to the list yesterday and have yet to receive any messages from the list. Any ideas? -- -- PHP

Re: [PHP-DB] Intellectual property rights

2004-08-09 Thread Michael Gale
decide to take this further ... which should not be to hard with the M$ people. Michael. On Mon, 9 Aug 2004 19:03:24 -0400 "Vincent Jordan" <[EMAIL PROTECTED]> wrote: > This is a bit off topic however it may be something people here have or > will have the unpleasant opportu

[PHP-DB] mysql auto increment

2004-07-12 Thread Michael Gale
, -- Michael Gale Network Administrator Utilitran Corporation -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] table locking ... not required ?

2004-07-09 Thread Michael Gale
Yes .. it is ok - the data that I allow to get updated like this is not that important and when a update is made it would be two people entering the same data anyways. It is just for contact info for people in the db ... like there current phone or address if it changes. Michael. On Fri, 9

[PHP-DB] table locking ... not required ?

2004-07-08 Thread Michael Gale
multiple users tried to insert data at the same time. For the UPDATES ... what would have it in theory two people hit the UPDATE button at the exact same time ? Would one just over write the other ... cause that is fine ? So do you think I need to lock tables ? Michael. -- PHP Database Mailing

Re: [PHP-DB] Storing Date in mysql

2004-07-08 Thread Michael Gale
Thanks ... I can't believe I missed that in the docs ... now I feel like knob. Michael. On Thu, 8 Jul 2004 14:17:38 -0300 "Pablo M. Rivas" <[EMAIL PROTECTED]> wrote: > Hello Michael, > token_date must be a DATE FIELD... > > http://dev.mysql.c

[PHP-DB] Storing Date in mysql

2004-07-08 Thread Michael Gale
(`token_utuser_id`,`token_name`) ) TYPE=MyISAM; So in the token_date field I am storing the date in the following format from PHP: date("d/m/Y") which creates the following entry "05/07/2004" (example). I would like to know fro the list is ... is this the best way to store the da

[PHP-DB] DB connections ?

2004-07-05 Thread Michael Gale
two where separate. Any comments ... Michael. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to take Backup ?

2004-07-01 Thread Michael Gale
Hello, Have a look at mysqldump .. it is used for backing up tables and database. Example mysqldump --add-drop-table -c testdatabase -h 127.0.0.1 -u mysqlbk --password=mysqlbk > testdatabase.bk Michael On Thu, 1 Jul 2004 21:26:27 -0700 (PDT) Rinku <[EMAIL PROTECTED]> wrote:

[PHP-DB] perfornance with POST or db check ??

2004-06-30 Thread Michael Gale
e original owner and compare that with the owner value of the select box OR should I do another db select to see if the field changed ??? I was thinking that passing a string would have less of a performance impact ? then db activity. ? Michael -- PHP Database Mailing List (http://www.php.

[PHP-DB] mysql and indexes

2004-06-16 Thread Michael Gale
columnname1 columnname A 6623NULLNULL Could the multiple index cause a problem ? I am trying to speed up a DB query ? Michael. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL persistent connections

2004-06-13 Thread Michael Gale
query then persistent connections would not be worth it. Plus with persistent connections I have heard most people have issues with hitting the too many open connections limit. Because the connections are not being closed or reused. Michael. On Fri, 11 Jun 2004 11:38:37 -0400 Radek Zajkowski &l

Re: [PHP-DB] Re: mail() function and AOL users

2004-05-19 Thread J-Michael Roberts
This is something I've been dealing with for a little too long. AOL has a big list of methods they use to block what they think are spam. Some of these things are: - Reverse DNS Lookups: If you don't have an entry, your mail is dumped - Mail Formatting: If the format of your message is not RFC C

Re: [PHP-DB] question on

2004-05-13 Thread Michael Forbes
Interesting idea. Since I'm convinced that javascript is the bastard offspring of Bill Gates, Larry Ellison, and Baalzebub, can I sue too? :) Hengameh wrote: Well I am suing Java script to capture the selected item and make it the value of my input box. But my problem is how to access this info

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-13 Thread Michael Forbes
I'm glad you found a solution to your problem-- how big a stick did it require? I actually learned a LOT just reading that thread (although I'm an Access guru who came to PHP/MySQL by way of conversion to zealotry, I've never used PHP against an Access back-end). Many thanks to those who cont

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-13 Thread Michael Forbes
I'm glad you found a solution to your problem-- how big a stick did it require? I actually learned a LOT just reading that thread (although I'm an Access guru who came to PHP/MySQL by way of conversion to zealotry, I've never used PHP against an Access back-end). Many thanks to those who cont

[PHP-DB] Re: upload files into MySQL database

2004-05-11 Thread Michael Forbes
I've not run into this problem before, but the solution seems obvious: replace your filename spaces with underscores, or get rid of them completely. -Mike Forbes Phpdiscuss - Php Newsgroups And Mailing Lists wrote: Hello, I have problem for downloading files from MySQL database. Although I st

Re: [PHP-DB] Edit with notepad

2004-05-11 Thread Michael Forbes
Why not just provide them with two different links to the document-- one version includes the tag, the other doesn't. -Mike Forbes Ng Hwee Hwee wrote: hi, header("Content-type: application/vnd-ms.word"); is not what my customers want. They may or may not want to save it in their harddisk.. but

[PHP-DB] Re: Dynamic Email Address in an HTML table

2004-05-09 Thread Michael Forbes
Two alternatives: One is to store the entire string "" in your field. The other is to just store the field, but concat the string together when you echo/print it. i.e.,: print ""; Phpdiscuss - Php Newsgroups And Mailing Lists wrote: Hello, I have a page displaying the results of a query fr

[PHP-DB] Re: SQL question!

2004-05-03 Thread Michael Forbes
What you wrote will give you the list of users who also happen to have comments. What you really want is more like this: SELECT Users.ID, Users.UserName, Comments.Description FROM Users LEFT JOIN Comments ON Users.ID = Comments.UserID; (note that you'll need to have the UserID foreign key in you

Re: [PHP-DB] - Delete records in an Access DB

2004-05-03 Thread Michael Forbes
. -Original Message- From: Michael Forbes [mailto:[EMAIL PROTECTED] Sent: Monday, May 03, 2004 07:00 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] - Delete records in an Access DB Nope. Access' version of SQL is a slight bit different from ANSI SQL. All he needs to do in his statement i

[PHP-DB] Re: The usual problem

2004-05-03 Thread Michael Forbes
If your ID is an autoincremented field, try not including it in your insert statement. I.E.: $sql = "INSERT INTO underskrifter (type, navn, epost, tid, ip, domain, sted) " . " VALUES ('$_POST[type]', '$_POST[navn]', '$_POST[epost]', '$tid', '$ip', '$host', '$_POST[sted]' );" -Mike Forbes Ma

Re: [PHP-DB] - Delete records in an Access DB

2004-05-03 Thread Michael Forbes
Nope. Access' version of SQL is a slight bit different from ANSI SQL. All he needs to do in his statement is change it to this: $query="DELETE * FROM Test_Table WHERE name='franco';"; (notice the wildcard in there-- Access isn't smart enough to realize that the deletion of any information in

RE: [PHP-DB] Displaying Date from Value in MySQL DB

2004-04-20 Thread Michael Scappa
Add an AS to your statement ... ditoevents.eventdate,DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y') AS eventdateformatted, ditoevents.eventtime ... then $row[eventdateformatted] should contain the date in the way you want it. -Mike -Original Message- From: Tyler Replogle [mailto

[PHP-DB] Odd behavior

2004-04-03 Thread Michael Lewis
Okay, problem solved. I've been looking at the code for so long that it was too obvious to see. The "or die" was the culprit. Just a reminder that one should watch cutting and pasting. Thanks to anyone who used any brain time on this. Michael -- PHP Database Mailing List (htt

[PHP-DB] odd behavior

2004-04-03 Thread Michael Lewis
words, it works the way it's supposed to. I was running 4.3.5 and upgraded to 4.3.6rc1 this morning and the problem still exists. If anyone could shed any light on this I would greatly appreciate it. Thanks, Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-22 Thread Michael Flanagan
ite so stupid as when I'm trying to be quite so smart! Thanks for sticking with me on this one. Michael -Original Message- From: Robert Twitty [mailto:[EMAIL PROTECTED] Sent: Sunday, February 22, 2004 6:38 PM To: Michael Flanagan Cc: Php-Db Subject: RE: [PHP-DB] MS SQL 'C

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-22 Thread Michael Flanagan
= $result->getMessage() . $result->getDebugInfo (); return FALSE; } return $result; } -Original Message- From: Robert Twitty [mailto:[EMAIL PROTECTED] Sent: Sunday, February 22, 2004 2:49 PM To: Michael Flanagan Cc: Php-Db Subject: RE: [PHP-DB] MS SQL 'Cha

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-21 Thread Michael Flanagan
So, is this a PEAR problem? If not, what am I doing wrong? If so, how can I get around this? Thanks! Michael -Original Message- From: Frank M. Kromann [mailto:[EMAIL PROTECTED] Sent: Saturday, February 21, 2004 7:40 PM To: Php-Db Subject: RE: [PHP-DB] MS SQL 'Changed database c

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
Hi Robert, I've seen your name on a few of the ODBTP posts. You're one of the developers of same, yes? Are you familiar with the 'Changed database context' message? Do you know for sure that ODBTP handles that correctly? Thanks. Michael -Original Message- From: R

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
severity levels, and their interplay with MS SQL Server?? Thanks. Michael -Original Message- From: Frank M. Kromann [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 5:07 PM To: Michael Flanagan Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MS SQL 'Changed database context' e

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
don't work? mssql.min_error_severity = 11 mssql.min_message_severity = 11 Michael -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 12:44 PM To: Michael Flanagan Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MS SQL 'Changed database context&

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
ELECT statement I'm getting the message on is the second query in my script. The other query is to the same db; in fact, it uses the exact same $db connection object. Any ideas on getting PHP to ignore this info message? Thanks again. Michael -Original Message- From: Adam Voigt [mai

[PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
e so much, but php treats this as an error, and doesn't execute my query. I'm running php 4.3.3 for Windows; the SQL Server and web server are on the same machine. I'm using PEAR:DB for the database access. Thanks. Michael Flanagan voice: (1) 303-674-2691 fax: (1) 603-963-0

[PHP-DB] Re: php5/MySQL 4.1.1 connection error

2004-02-09 Thread michael
I have done the same thing... but still get "Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client" So beside copying the libmySQL.dll's to the System32 folder and the settings in the .ini... Should'nt there be more files to loca

[PHP-DB] Re: php to mysql client problem.

2004-02-09 Thread michael
I've since used different combinations and discovered that I can access the database as long As I don't use Passwords... I guess it is the Webserver and not the Sql server causing the problem... Michael G. Tracey wrote: This is my setup: Not really worried about security. W2kPro w\s

[PHP-DB] php to mysql client problem.

2004-02-07 Thread Michael G. Tracey
thinking yes, but since copying the new files to the same directory overwrote all the others, is this the client version for all servers currently?? If not how do I force it to update. I have all the servers working. I don't really at this point want to delete anything. Michael G. Tracey

[PHP-DB] connection problem??

2004-02-03 Thread Michael G. Tracey
ent does not support authentication protocol requested by server; consider upgrading MySQL client" I dropped the same version as before. Cannot remember if I specified another "authentication protocol" or how I did it. Michael G. Tracey

Re: [PHP-DB] Mail Function

2004-01-30 Thread J-Michael Roberts
Your script actually connects to an SMTP server and sends the email? If this is the case, you can have your script look for success/error messages returned by the server when it sends - unless you're delivering to an AOL address. AOL accepts everything you throw at it and then sends back a not

[PHP-DB] Re: [PHP] Oracle + PHP

2004-01-30 Thread Michael Mauch
_TIME LC_COLLATE LC_MONETARY LC_MESSAGES LC_PAPER LC_NAME LC_ADDRESS LC_TELEPHONE LC_MEASUREMENT LC_IDENTIFICATION LC_ALL Some parts of Apache/Oracle/whatever-else apparently has trouble with locales. Regards... Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Truncated fields

2004-01-21 Thread Michael Lewis
John, I'm getting much more than 255 characters. The field is not varchar but a text field. I've looked into FREETDS as the most likely source of the problem but haven't found anything yet. Michael > Michael Lewis wrote: > > > I'm having a problem with retrieving

[PHP-DB] Truncated fields

2004-01-21 Thread Michael Lewis
d/or has anyone else had this problem? Thanks. Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PhP 5.0, Mysql4.11,Apache2.0.48

2004-01-19 Thread Michael G. Tracey
try sometime this week. I want to use MySQL to access some MS-Access databases from a program I use at work [With ODBC]. The manual says support is built in to PhP for MySQL. But I thought it was'nt any longer. Michael G. Tracey ___ Join E

Re: [PHP-DB] oracle compilation with php

2004-01-07 Thread Michael Mauch
php oci8 or oracle options. > Thanks for the quote below, I will then want to look more to > the oci8 calls then. Unfortunately, neither oci8 or oracle php > option let me compile, due to the respective missing header files. Yes, Oracle's installer is fun. Regards...

[PHP-DB] mssql and resource handling

2003-12-16 Thread Michael Lewis
RESS is comes back as RESOURCE OBJECT #12, the second time as 0. When I look in the session file, it is zero. Help! How can I pass this variable and its contents so they are usable to the next web page? Thanks in advance. Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Killing MSSQL Query

2003-12-02 Thread Michael Lewis
I am looking for a way to kill my current MSSQY query from an PHP script. For example, I have a page where the user picks some selection criteria, the script then constructs aa MSSQL query and executes it, 5 minutes into it the user decides, "Forget about it" and presses a button (ideally) to kill

Re: [PHP-DB] Access db

2003-11-20 Thread Michael Mauch
Luke Van Blerk wrote: > I'll probably just extract the data with an access to mysql script and run > it on mysql. This is probably the best approach if you have access to Windows machine. If not, <http://freshmeat.net/projects/mdbtools/> might help. Regards...

[PHP-DB] Re: Where To Go For Newbie Help?

2003-10-30 Thread Michael Mauch
Johnradio wrote: > where can i go to get total beginner's help? <http://www.php.net/manual/> - look especially at the FAQ section and of course at the sections that you are interested in (Installation, Language Reference, you name it). Regards... Michael --

RE: [PHP-DB] RE: Need help Get/send Variabel to another window

2003-10-10 Thread Michael Scappa
I'm guessing this is html? Parent.opener.formname.formfield.value = this.value; Michael Scappa -Original Message- From: Jeremy Shovan [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 12:24 PM To: 'agus supriatna'; [EMAIL PROTECTED] Subject: [PHP-DB] RE: Nee

  1   2   3   4   >