[PHP-DB] php crash?

2003-11-28 Thread Peter
Hello, I have the following problem. When I SELECT something from the informix database, everthing works fine. When I try to insert something into the database php crashes. The code i use to do the insert is: $sql_save= "INSERT INTO tablename VALUES ('','".$editie."','".$datum_vandaag."','".$

[PHP-DB] Re: user input killing code

2003-12-02 Thread Peter
/function.stripslashes.php Peter "Redhat" <[EMAIL PROTECTED]> schreef in bericht news:[EMAIL PROTECTED] > I am still working on this DB entry page. I have a sort of content mgt > page that I have built where certain company people input data to be > displayed on a web page t

[PHP-DB] PHP on an Windows intranet with MSOffice-like templates

2004-11-16 Thread peter
I don't even know if this is possible, or if I'll have to go the route of .NET development to get this sort of functionality (I'm sure it's possible if I jump through enough hoops). But here's what I'm trying to accomplish... - users are all on a local intranet with access to a shared drive (no pr

RE: [PHP-DB] password encryption

2004-11-18 Thread peter
Quoting "Gryffyn, Trevor" <[EMAIL PROTECTED]>: > If you want to be cheesy, you can also use something like an MD5 has on > "dog" and get whatever it gets Then every time someone enters "dog" > it always ends up with the same MD5 hash. How is using MD5 cheesy? I've implemented exactly that so

[PHP-DB] Re: Simulating a FORM POST thing (HELP!)

2002-05-26 Thread Peter
"; print ""; ?> you get the idea I think PHP does have other funtions for file uplading though. "Georgie Casey" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Rite, when you see a web form, you know you can simulate the submit by > filling in the values in th

[PHP-DB] Re: Simulating a FORM POST thing (HELP!)

2002-05-26 Thread Peter
OTECTED]">news:[EMAIL PROTECTED]... > i'm getting an error message saying my BMP file i'm trying to convert isnt a > valid WBMP file? is dere a difference between BMP and WBMP? I just opened my > GIF file into PSP7 and and saved as a windows bmp. > > why isnt it w

[PHP-DB] Re: Simulating a FORM POST thing (HELP!)

2002-05-27 Thread Peter
y mode for images and stuff. "Georgie Casey" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > that function doest exist! > > "Peter" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAI

[PHP-DB] Converting Databases

2002-12-01 Thread peter
. Peter [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MYSQL Problems Please help

2001-10-04 Thread Peter
I am runing RH 7 Mysql (installed of RPM), Apache (compiled version) and PHP 4.0.4pl1 configure command './configure' '--with-xml' '--with-apache=../apache_1.3.19' '--enable-shared-pdflib' '--enable-track-vars' I am trying to connect to a mysql database using the following: "; $host = "localho

Re: [PHP-DB] compare php and perl

2003-03-20 Thread peter
pear.php.net and smarty.php.net Peter "Reality is that which, when you stop believing in it, doesn't go away". -- Philip K. Dick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] installing

2001-02-06 Thread peter paauwe
Hello, Got a major problem with seeing the result of my php scripts without uploading them to a server. I don't have a server myself. Do I need to have one or can I see my writen scripts and see the results directly in my internet explorer? thanks, ufo

[PHP-DB] Lets Fly

2001-02-20 Thread Peter Burgess
late last week. sounds sweet as __,,_ < ___/ / /-' /___/ Peter Burgess m2o Designs 151 Greville Street Prahran 3181 Melbourne Australia Ph: 03 9521 2553 Fx: 03 9529 4712 EM: [EMAIL PROTECTED] URL:http://www.m2o.com.au

RE: [PHP-DB] password generator

2003-12-10 Thread Peter Lovatt
Hi HTH Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473

[PHP-DB] Cookies with fopen

2003-12-10 Thread Peter Westergaard
reign webserver as credentials during the HTTP GET? Anyone done something similar? -P Peter Westergaard ICQ#: 10294457 [EMAIL PROTECTED] http://www.westergaard.ca http://courtly.livejournal.com ---TECHNOLOGY--- Human history becomes more and more a race between education and catastrophe.

RE: [PHP-DB] Remove all instances of a character....

2003-12-29 Thread Peter Lovatt
Does the ; need a backslash? UPDATE risk_corpdatacapture email = REPLACE(email,'\;','') Not sure but might be worth a try (back it up first!!) Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 December 2003 10:17 To: CPT John

RE: [PHP-DB] Checking for duplicate records before update?

2003-12-30 Thread Peter Lovatt
inserted then all is well, otherwise ask to resubmit I think this should still work with auto ids, but check. HTH Peter -Original Message- From: Jas [mailto:[EMAIL PROTECTED] Sent: 30 December 2003 22:32 To: [EMAIL PROTECTED] Subject: [PHP-DB] Checking for duplicate records before update

[PHP-DB] PHP Processing

2004-01-05 Thread Peter Westergaard
that I'm aware of, how would you best handle this dangerous potentiality? Suggestions? A humble request: Responses which begin with: "Don't use MySQL", please include a good affordable alternative? -P Peter Westergaard [EMAIL PROTECTED] ### ICQ#: 10294457 http://www.

RE: [PHP-DB] PHP Java problem

2004-01-13 Thread Peter Lovatt
type.php and see if this fixes it. Just a guess though, hope it helps Peter -Original Message- From: Donovan Hutchinson [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 20:49 To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP Java problem Hi, I've started putting together a site tha

RE: [PHP-DB] Update problems

2004-01-20 Thread Peter Lovatt
you need quotes around the name FirstName="$fname" otherwise it takes the value of $fname to be aa field name HTH Peter -Original Message- From: Kermit Short [mailto:[EMAIL PROTECTED] Sent: 20 January 2004 22:28 To: [EMAIL PROTECTED] Subject: [PHP-DB] Update problems

RE: [PHP-DB] Results with ledger stripes?

2004-01-25 Thread Peter Lovatt
h_array($mongo, MYSQL_NUM)) { if($bg=='#dd']) $bg='#ff' ; else $bg='#dd' ; echo "$mongorow[0]$mongorow[1]\n"; } echo ""; ?> And I'd like it to spit out something along these lines: domain1.com666.6 kbps d

RE: [PHP-DB] getting font size from browser

2004-01-30 Thread Peter Lovatt
e if (screensize <= 800){ window.location = 'index.php?screensize=800x600' ; } else { window.location = 'index.php ; } // --> this is on an opening page - which redirects to another page, passing parameters to php as it goes. HTH Peter -Original Message

RE: [PHP-DB] Question

2004-02-08 Thread Peter Lovatt
Hi I think it may be the { and } which are used in php if they are part of the data you are saving then try adding a \ => \{ and \} if not remove them. Peter --- Excellence in internet and open source softw

Re: [PHP-DB] Paging large recordsets

2004-02-13 Thread Peter Beckman
27;t researched how to do it in Mozilla or Netscape. Beckman --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ --

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Peter Beckman
th printing? I would assume that the ideal page > > size is not the ideal printed page size. oi vay! > > > > TIA > > > > > > - > > Do you Yahoo!? > > Yahoo! Finance: Get your refund fast by filing online >

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Peter Beckman
caching. Look to the manual for that. --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ ---

Re: [PHP-DB] newbie question

2004-02-13 Thread Peter Beckman
_timestamp() and date<(unix_timestamp()-(365*86400)) ... Documentation: http://mysql.com/date_sub (should redirect to http://www.mysql.com/doc/en/Date_and_time_functions.html) --- Peter Beckman

Re: [PHP-DB] User Authentication

2004-02-27 Thread Peter Beckman
ROM users WHERE > username='$username' AND password=md5('$password')"); --- Peter Beckman Internet Guy [EMAIL PROTECTED

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Peter Beckman
; Regards > Piotr Babula > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --- Peter Beckman

RE: [PHP-DB] MySQL Multi-DB Join

2004-03-18 Thread Peter Lovatt
assuming the dtaabases are on the same server $query = " select db1.table1.field from db1.table1, db2.table2 where db1.table1.field1 = db2.table2.field2 " $result = mysql_query($query,$conection) HTH Peter > -Original Message- > From: Rod Strumbel [mailto:[EMAIL P

RE: [PHP-DB] MySQL Multi-DB Join

2004-03-18 Thread Peter Lovatt
I think as you are specifying the db in the query you dont need to select it. If you do, mysql still uses DBs as specified in the query. Peter > -Original Message- > From: Rod Strumbel [mailto:[EMAIL PROTECTED] > Sent: 18 March 2004 15:14 > To: 'Peter Lovatt&#x

RE: [PHP-DB] Use of database

2004-03-27 Thread Peter Lovatt
Hi only users with the privileges will be able to access those pages. if you are using mysql 3.xx the link wont show for low privilege users (I think !) 4.xx seems to show the links, but you can still only access them if you have the right privileges HTH Peter > -Original Mess

Re: [PHP-DB] PDFLib

2004-04-05 Thread Peter Beckman
List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.co

RE: [PHP-DB] Double Submission into DB if Hit Refresh

2004-04-17 Thread Peter Lovatt
data. If the ID is already there, then do not add/update and send the user a message to say they have submitted the same transaction twice. HTH Peter > -Original Message- > From: Craig Hoffman [mailto:[EMAIL PROTECTED] > Sent: 18 April 2004 01:30 > To: [EMAIL PROTECTED] >

RE: [PHP-DB] Re: Using $_SESSION array for large number of variables. Any recommendations?

2004-04-25 Thread Peter Lovatt
also allows the user to switch machines or browsers - $_SESSION is linked to the browser. >From experience this works well. hth Peter --- Excellence in internet and open source software --- Sunm

RE: [PHP-DB] passing var array

2004-04-26 Thread Peter Lovatt
echo $_GET["some_var"] > -Original Message- > From: Sukanto Kho [mailto:[EMAIL PROTECTED] > Sent: 26 April 2004 09:34 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] passing var array > > > Hi, > > How to pass var array to other page? > > I use $_GET but when I echo it, it appear "array".

RE: [PHP-DB] converting scripts for register_globals=Off

2004-04-29 Thread Peter Lovatt
will also work. If it were a cookie value it would be $_COOKIE["id"] When register_globals is off $id will not be defined and only the above arrays will be usable. It is generally better practice to use the arrays anyway, so I would suggest using them all the time. HTH Peter

RE: [PHP-DB] The usual problem

2004-05-02 Thread Peter Lovatt
host' , '$_POST[sted]' ); "; mysql_query($sql) or die (mysql_error()); and see what you get Peter > -Original Message- > From: Mathias Hunskår Furevik [mailto:[EMAIL PROTECTED] > Sent: 03 May 2004 01:31 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] The usu

RE: [PHP-DB] RE: [tcphp] Hella fun project I'm about to throw at some tech college students

2004-05-02 Thread Peter Lovatt
Hi If the reformating is complex - ABVDFR Co is in the middle of the field - then php $bits = explode (" ", $FieldValue ) ; then each element of $bits is a word, making reworking it easier Just my 2p worth :) Peter > -Original Message- > From: Rafi Sheikh [mailto:

RE: [PHP-DB] Wrong table name - can it be fixed?

2004-05-17 Thread Peter Lovatt
Hi using phpMyAdmin enter the following into a sql box ALTER TABLE `16-05` RENAME `newname` ; HTH Peter > -Original Message- > From: Viorel Dragomir [mailto:[EMAIL PROTECTED] > Sent: 17 May 2004 09:54 > To: Martin E. Koss; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] W

[PHP-DB] Oracle Client Libraries for Linux

2004-06-14 Thread Peter Beckman
.jar How do I get connected from a remote PHP+Apache box to Oracle9i on linux? Beckman --- Peter Beckman Inter

RE: [PHP-DB] require function detail with example

2004-06-26 Thread Peter Lovatt
Hi assuming you want to check the variable in php you need gettype() http://uk2.php.net/manual/en/function.gettype.php the text box can only be done with javascript combined with an event eg If you need more on the javascript then a specialist javascript list would be better :) Peter

[PHP-DB] Re: Column Help Needed

2004-07-09 Thread Peter Westergaard
w close the table. echo ""; // and we're done! note, I didn't test this code. But it should do what you want. -- Peter Westergaard [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] fetch row DISTINCT

2004-07-09 Thread Peter Westergaard
Lars, One idea that occurs to me, and it's a tradeoff from Torsten's idea (which is to read the whole database, and parse out the unique rows), is to first execute your "SELECT DISTINCT distinct_col FROM table", and then walk through that, and for each one issue a "SELECT * FROM table WHERE distin

[PHP-DB] Re: Query help

2004-07-09 Thread Peter Westergaard
I think you want: "SELECT * FROM routes, users WHERE area='$area' AND style='$style' AND rating BETWEEN '[$rating1]' AND '[$rating2]' GROUP BY route ORDER BY rating ASC "; >From http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html "expr BETWEEN min AND max If expr is greater than or equal

[PHP-DB] Re: Query help

2004-07-09 Thread Peter Westergaard
Oh, and I assume you left out the part of the query where you bound tables routes and users? -P "Craig Hoffman" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "SELECT * FROM routes, users WHERE area='$area' AND style='$style' > BETWEEN rating='[$rating1]' AND rating='[$rating2]' GRO

Re: [PHP-DB] Re: $_SERVER['HTTP_REFERRER']

2004-07-09 Thread Peter Beckman
Hi Jeff, > > do a print_r($_SERVER) to see which other variables are available. Maybe one > of them will contain what you're looking for. > > Regards, Torsten > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: htt

Re: [PHP-DB] Table locking

2004-07-13 Thread Peter Westergaard
BY table2.orderid, table2.rowid Or something of that nature, as it suits you. Unless you have a HARD need to do it where the parent knows the children, it's just easier if the children know the parent. -Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql auto increment

2004-07-13 Thread Peter Westergaard
I've done exactly this for a really cheap-and-dirty instance where two people were doing bulk data entry into two different instances of a mysql table which would eventually be stitched together. by giving one a higher range, the data migration afterwords was very easy. Other than that, can't ima

[PHP-DB] Mysql and rollbacks

2004-07-13 Thread Peter Westergaard
I'm developing a site where I anticipate the need to make several updates to several forms, and I'll want to "commit" them all at once (i.e. if there's a failure with any of the transactions, I'd like to be able to back out to before I started). Is there a decent way to do this with PHP and Mysql?

[PHP-DB] Re: Mysql and rollbacks

2004-07-13 Thread Peter Westergaard
... or, am I barking up the wrong tree with Mysql, and should I change database platforms? (You'll never convince me to give up PHP though. muahaha. Except for sql-level stored procedures where necessary, that is). -P -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: htt

Re: [PHP-DB] Mysql and rollbacks

2004-07-14 Thread Peter Westergaard
> I was about to suggest the same, the latest builds of MySQL have theese > functions from what I knew... I think youll find what you need there. Thanks, Kim. Any stable and fairly affordable hosts out there using these latest builds? Mine is back a few, no transactional functionality that I can

[PHP-DB] Re: Debian & mssql_init

2004-07-14 Thread Peter Westergaard
"Damien Babilon" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > the mssql_connect function work right, but php give me back this message when I try mssql_init: > Fatal error: Call to undefined function: mssql_init() in /var/www/eurogsmtest/test.php on line XX Shouldn't you use mssql

[PHP-DB] Re: Hold System

2004-07-14 Thread Peter Westergaard
Could I get a plain-language explanation of the process of a 'hold'? I'm not entirely clear what is happening, and what an 'expiry' means in the context of the hold and what a '#1 position' would represent for a student. -P -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visi

Re: [PHP-DB] Re: Hold System

2004-07-14 Thread Peter Westergaard
I guess I'm still not grasping... Who creates the temporary "I'm-trying-to-place-you" link between coordinator and student? The system automatically, or the coordinator manually? What is a "#1 position"? How does a student get there? Who or what places them there? How do they leave that posit

Re: [PHP-DB] Re: Hold System

2004-07-14 Thread Peter Westergaard
Ah, now I think I understand. Thank you. > 2. A Coordinator can only hold a student while in the #1 position for a > certain amount of time. (I don't have a problem with calculating the > time.The problems are: > A. What do I do with the record once there hold has expired? > B. Also what do I do

Re: [PHP-DB] Re: Hold System

2004-07-15 Thread Peter Westergaard
> In the example of Bob, Mary and Barbara that I gave in my last post. If > Bob cancels his hold and I reset date_held for mary to the current date, > so that she has adiquite time to place her student. If I do that this > will put Barbara into the #1 position because she has now put a hold > bef

[PHP-DB] Re: PHP Max execution time

2004-07-15 Thread Peter Westergaard
"Lisi" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am running a script (called through a browser) that checks entries in a > table one at a time. As the table has grown, the script takes longer to run > than is allowed - 30 seconds. Of course, I have to ask... is there absolut

[PHP-DB] Re: Restrict account access to single user

2004-07-15 Thread Peter Westergaard
> In other words, how do we prevent two users from using the same password to access the same account at the same time? There are a few strategies I'd consider... each has plusses and minuses. 1) Lock to one IP. Keep a table with the most recent IP address, and the most recent access time. Any

[PHP-DB] Re: session_start

2004-07-15 Thread Peter Westergaard
"Steve Butzel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > It appears that Apache/PHP still thinks the session.save_path is /tmp, even > though I changed this in php.ini-recommended and php.ini-dist. **What am I > doing wrong?** Have you changed it in the version of php.ini which

Re: [PHP-DB] oracle error ORA-12154

2004-07-16 Thread Peter Beckman
pc)(KEY=extproc))) > (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aleph0))) > > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zed2.mdah.state.ms.us)(PORT=1521))) > Services Summary... > Service "aleph0" has 1 instance(s). > Instance "aleph0", status

Re: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Peter Beckman
http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --- Peter Beckman Internet Guy [EMAIL PROTECTED]

Re: [PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Peter Ellis
rgive me my coding errors. Take a look at the Filesystem section of the PHP manual for information on the fopen/fwrite() commands, and the MySQL section for more information on MySQL commands in PHP. Hope this helps a little more in solving the puzzle. -- Peter Ellis - [EMAIL PR

Re: [PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Peter Ellis
Whoops -- the fclose() statement refers to $result when it should refer to $handle. My bad for not at least spot checking the message before hitting send! -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Mon, 2004-08-09 at 20

Re: [PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Peter Ellis
atter what. Perhaps that's more a matter of semantics than PHP programming itself :) As for the difference between = and LIKE, you are correct -- I just don't typically use LIKE for any of my database work, so I forget there's a difference every once in a while :) Thank you for the

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

2004-08-12 Thread Peter Ellis
nothing's been sent to it? This is not a heavy traffic list. I get maybe 4-5 messages a day from this one. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Thu, 2004-08-12 at 12:02 -0700, Chip Wiegand wrote: >

RE: [PHP-DB] How to forward a POSTed form to another server and catch the return for further processing

2004-08-15 Thread Peter Lovatt
hi this should do the trick Peter // this is the script to pass the post onto $server_to_post_to = 'http://www.test.com/somescript.php'; $url = parse_url($server_to_post_to); unset($request_data) ; //run through the data POSTed to this server and build a new POST reques

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

2004-08-18 Thread Peter Ellis
doc/ Good luck! -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Tue, 2004-08-17 at 23:03 -0400, [EMAIL PROTECTED] wrote: > I finally got my PHP5 installation to support MySQL and now this. When I try > to edit anything on

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

2004-08-18 Thread Peter Ellis
This isn't the appropriate list to direct this question to. I suggest one of the MySQL help lists or a careful reading of the documentation, which tells you exactly what you need to know. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis |

Re: [PHP-DB] No Cookies file created on Client

2004-08-18 Thread Peter Ellis
as it needs to be sent with headers and putting it too far down (in my experience) can cause problems with setting the cookies. 4) is the browser configured to accept cookies from that site? You can block some sites and not others. 5) this isn't really a database question :) -- Peter Elli

Re: [PHP-DB] Tricky MySQL / php Script

2004-08-18 Thread Peter Ellis
I assume you mean the 1052367746 portion of that URL? Am I right? If so: $id = basename($photoid, ".jpg"); That would work, I think, if you just wanted the numeric portion of the path. Not sure if this is what you want. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development

Re: [PHP-DB] Tricky MySQL / php Script

2004-08-18 Thread Peter Ellis
Ach, and the light bulb goes on. Sorry, wasn't really thinking about it completely earlier. Here's a less dimbrained suggestion: could you encode the user ID as part of the filename itself? Like, for instance, write the script so that it would read something like: blah.jpg.215 and strip off th

Re: [PHP-DB] Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Peter Ellis
er Installation). -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Fri, 2004-08-20 at 11:50 -0400, [EMAIL PROTECTED] wrote: > When I have a html page with an embedded php method behind a button, when I click > the button I can'

Re: Fwd: [PHP-DB] Q

2004-08-22 Thread Peter Ellis
ssuming a particular behavior from that function. By default, mysql_fetch_array gives you an array with *numerical* indices, not indices with field names. If you're having trouble outputting an array, you can (and should) always do a print_r($array) to see what the index and actual values are.

Re: [PHP-DB] Global Peace output

2004-08-22 Thread Peter Ellis
What errors are you getting? We can't help if we don't know what's wrong in the first place. Turn your PHP error reporting on (assuming it's a PHP error). -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On S

RE: [PHP-DB] Help, i'm really desperated

2004-08-25 Thread Peter Lovatt
Hi php runs as the same user as apache. Depending on any other security/system issues you could set apache to run as postgres. Otherwise why not connect to postgres using the php functions and write the text file using php? You might also be able to su to postgres. HTH Peter > -Origi

Re: [PHP-DB] Text area

2004-08-26 Thread Peter Ellis
I suspect your return result looks something like "; } I'm aware of the other replies to this message, but I'm being literal and assuming you want that exact string returned, regardless of other alternatives. HTH. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Develop

RE: [PHP-DB] Webpage response to selection & $_POST

2004-08-29 Thread Peter Lovatt
T) to see exactly what is being returned. If this does not fix it try posting the code that handles the response and we will try and help. Peter > -Original Message- > From: Philip Thompson [mailto:[EMAIL PROTECTED] > Sent: 30 August 2004 00:12 > To: [EMAIL PROTECTED] > S

Re: [PHP-DB] Clicking on the Picture

2004-08-30 Thread Peter Ellis
Yes. It's called image mapping. Do a Google search. This isn't PHP related. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Tue, 2004-08-31 at 15:07 +1200, Feroz wrote: > Hi, > > I have a Diagram that

Re: [PHP-DB] Re Displaying Text From A Data File

2004-09-04 Thread Peter Ellis
If it were a database, this would make sense. He's asking about a text- based file. This isn't really a database issue -- there's a lot of what are called "fortune scripts" out there that do exactly what you want. Do a search on Google. -- Peter Ellis - [EMAIL

Re: [PHP-DB] php Form Validation help

2004-09-06 Thread Peter Ellis
>3 ) { > > print 'Please enter your Area Code (EX. 77662)'; > > } > > > See comment on string length above. > > > I am still new with PHP, any help would be appreciated. Below is the code I > have sofar: > > Hope this helps. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] error on count()

2004-09-07 Thread Peter Ellis
You need to pass the functions a variable to work with because you've specified parameters. Try: $okuan = orderquantity($una); Ditto for the other function call. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Tue, 20

Re: [PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread Peter Ellis
Well, this is from the "why reinvent the wheel" department -- have you looked at htdig://? http://www.htdig.org/ Might save you some work. Just a thought :) More constructive replies regarding actual code are forthcoming, I'm sure. -- Peter Ellis - [EMAIL PROTECTED] Web Design

Re: [PHP-DB] Please help

2004-09-08 Thread Peter Ellis
What are the variables $sql and $sql_ext set to? The query format is fine. It's probably in your variables. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Wed, 2004-09-08 at 12:29 -0700, Stuart Felenstein wrote: > I

Re: [PHP-DB] error of check box form

2004-09-08 Thread Peter Ellis
In addition, please send your messages once and only once. I have two copies of the same e-mail, both sent to the list successfully with two different replies to both messages. You're more likely to get help if you post and wait for a reply to your original message. -- Peter Ellis - [

RE: [PHP-DB] Please help

2004-09-08 Thread Peter Lovatt
HI try $result = mysql_query($sql . " " . $sql_ext . " limit 0,1") or die("Invalid query".mysql_error()); which will give more detail on the error. HTH Peter > -Original Message- > From: Stuart Felenstein [mailto:[EMAIL PROTECTED] > Sen

RE: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Peter Lovatt
Hi try $db = mysql_connect("localhost", "myuser","mypassword") - without it you are not submitting a password Peter > -Original Message- > From: Christian Schlaefcke [mailto:[EMAIL PROTECTED] > Sent: 24 September 2004 13:31 > To: [EMAIL PROT

Re: [PHP-DB] Short Names

2004-09-25 Thread Peter Ellis
t you wrote and why... Hope this helps. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Sat, 2004-09-25 at 14:23 -0700, Cole S. Ashcraft wrote: > Is it considered bad / sloppy to define the short names of varibales at >

[PHP-DB] PHP versions - Development server & live server...

2004-10-13 Thread Peter Borcherds
What do I need to be looking out for with regard to conflicts? Thanks! Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] PHP versions - Development server & live server...

2004-10-13 Thread Peter Borcherds
Hi Robby, Thanks for the swift reply! Okay, so it should be fine to install the 4.3.9 version then - okay...now I assume I should hold-off on the 5.0.2 release then...? -Original Message- From: Robby Russell [mailto:[EMAIL PROTECTED] Sent: 13 October 2004 22:01 To: Peter Borcherds Cc

Re: [PHP-DB] PHP versions - Development server & live server...

2004-10-13 Thread Peter Borcherds
installed - "Robby Russell" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Peter, Yes, if you build PHP5 code, it's very possible it will not work o

RE: [PHP-DB] PHP versions - Development server & live server...

2004-10-14 Thread Peter Borcherds
I don't recall installing any optimising or encrypting extensions?? Are they perhaps installed with mySQL? How do I reinstall them, that is assuming I need them? -Original Message- From: M Saleh EG [mailto:[EMAIL PROTECTED] Sent: 14 October 2004 03:24 To: Peter Borcherds Cc: [

RE: [PHP-DB] Problem with script

2004-11-02 Thread Peter Lovatt
Try echoing the actual query being run. It will give you more info to work with. Peter > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 02 November 2004 16:42 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Problem with script >

RE: [PHP-DB] save as you type

2004-12-12 Thread Peter Lovatt
You could use JavaScript onblur executes when the user leaves the box, and will submit the form HTH Peter > -Original Message- > From: Matthew Perry [mailto:[EMAIL PROTECTED] > Sent: 12 December 2004 05:12 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] save as yo

RE: [PHP-DB] forgetting to close db connection

2004-12-12 Thread Peter Lovatt
hosts. Hope this gives a clearer picture. Peter > -Original Message- > From: Matthew Perry [mailto:[EMAIL PROTECTED] > Sent: 12 December 2004 15:23 > Cc: [EMAIL PROTECTED] > Subject: [PHP-DB] forgetting to close db connection > > > On my forms

RE: [PHP-DB] Re: HTTP Auth for PHPMyAdmin

2004-12-22 Thread Peter Lovatt
set auth type to cookies Peter > -Original Message- > From: Mark Benson [mailto:[EMAIL PROTECTED] > Sent: 22 December 2004 10:55 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: HTTP Auth for PHPMyAdmin > > > Martin Norland wrote: > > >What do you m

RE: [PHP-DB] Help in learning PHP and MySQL

2004-12-31 Thread Peter Lovatt
enable it, edit php.ini - find the reference to php_mysql.dll and remove the ; which comments it out ) Peter > -Original Message- > From: Novice Learner [mailto:[EMAIL PROTECTED] > Sent: 31 December 2004 03:35 > To: php-db@lists.php.net > Subject: [PHP-DB] Help in learnin

RE: [PHP-DB] Security Question

2005-01-16 Thread Peter Lovatt
t the login page on a non secure server but post the form to a secure server. Peter > -Original Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent: 17 January 2005 02:46 > To: php-db@lists.php.net > Subject: Re: [PHP-DB] Security Question > > >

RE: [PHP-DB] Security Question

2005-01-17 Thread Peter Lovatt
Hi The page/form will be requested over a non secure connection. When the form is submitted the browser establishes a secure connection to the server and then sends the data, so the data is sent securely. Peter > -Original Message- > From: Micah Stevens [mailto:[EMAIL PRO

RE: [PHP-DB] i am lost (php warning)

2005-01-18 Thread Peter Lovatt
* FROM cm_customer WHERE email='$user'"); if you add an error trap it makes this knd of thing easier to spot $sql_query = mysql_query("SELECT * FROM cm_customer WHERE email='$user'") or die(mysql_error()); HTH Peter > -Original Message-

RE: [PHP-DB] last record

2005-01-24 Thread Peter Lovatt
hi using mysql as you describe is probably the most elegant and efficient way to do it is there a reason for asking php to do it? Peter > -Original Message- > From: neil [mailto:[EMAIL PROTECTED] > Sent: 25 January 2005 03:12 > To: php-db@lists.php.net > Subject: [PHP-

  1   2   3   4   5   6   >