Re: [PHP-DB] How do I keep the selected showing...

2001-03-03 Thread Brett
riable"].'" selected'.$HTTP_POST_VARS["variable"].'/option'; ? or add to each option: if ($HTTP_POST_VARS["variable"] == 'option value')echo 'selected'; example: option value="value" ?if ($HTTP_POST_VARS["variable"] == 'option value')echo 'selected

[PHP-DB] my sql text query

2001-03-09 Thread Steve Brett
when the table was already populated and when try to read it i get errors saying the index is not defined ... if i change it to varchar(255) there is no problem ? can anyone help ? Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be cont

FW: [PHP-DB] Using selected fields

2001-03-12 Thread Steve Brett
-Original Message- From: Steve Brett Sent: 12 March 2001 11:40 To: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Using selected fields I have a similar security setup in the app i'm working on at the moment, but attack from a slightly different angle. i have two tables, one that stores

RE: [PHP-DB] Using text files instead of a DB

2001-03-14 Thread Steve Brett
]] Sent: 13 March 2001 18:57 To: Steve Brett; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Using text files instead of a DB Sir, you did NOT follow the link I mentioned: http://intercession.net/specialoffers. This offers the web-hosting at %59.40 for the year. Instead you followed the link on http

[PHP-DB] File Optimisation

2001-03-14 Thread Steve Brett
? Thanks in advance, Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or de

RE: [PHP-DB] what is connection id?

2001-03-14 Thread Steve Brett
AFAIK the connection id is a used by the server to identify the correct connection. if it reset itself there would be duplicate connections. e.g. user 1 connects and gets connection 1. user 2 connects and gets connection 2. then disconnects. if the connection index was reset user 2 would get

RE: [PHP-DB] File Optimisation

2001-03-14 Thread Steve Brett
. Creating javascript functions for even the smallest inline feature such as mouseovers. Regards Mark -Original Message- From: Steve Brett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 4:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] File Optimisation I have

RE: [PHP-DB] File Optimisation

2001-03-15 Thread Steve Brett
. :-) -Original Message- From: Mal McKay [mailto:[EMAIL PROTECTED]] Sent: 14 March 2001 17:12 To: Steve Brett Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] File Optimisation I wouldn't know about flushing the buffer. Another approach would be changing to ADO. This being an intranet, i'd assume

RE: [PHP-DB] Expires Pages

2001-03-20 Thread Steve Brett
this should work ... in the top of the page, before any other headers are sent ?php header ("Ex-pires:Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // al-ways modified header ("Cache-Control: no-cache, must-revalidate"); //

RE: [PHP-DB] problems configuring php and postgres - call to undefined function

2001-03-20 Thread Steve Brett
get the postgrtesql source code and untar then run ./configure etc etc on postgresql then run ./configure in php as ./configure --with-pgsql=/path/to/untarred/source/files e.g. postgresql source untarred to /usr/src/postgresql php configure options are: ./configure

RE: [PHP-DB] problems configuring php and postgres - call to und efined function

2001-03-20 Thread Steve Brett
DIR. this did not work when i compiled. pointing at the source did. i tried pointing php at both dirs to no avail. -Original Message- From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 16:09 To: Steve Brett Subject: RE: [PHP-DB] problems configuring php and postgres

RE: [PHP-DB] problems configuring php and postgres - call to und efined function

2001-03-20 Thread Steve Brett
March 2001 16:09 To: Steve Brett Subject: RE: [PHP-DB] problems configuring php and postgres - "call to und efined function" Well, you just didn't point PHP at the right place then. On Tue, 20 Mar 2001, Steve Brett wrote: it wouldn't compile without it. really. ---

RE: [PHP-DB] Yet more strings

2001-03-21 Thread Steve Brett
i've had similar problems with mysql. postgres seems happy with having quotes around data pulled back as associative arrays like $data = $result["userid"]; and from using mysql it sometimes likes it that way and sometimes without. the syntax for the string is right as long as the string

RE: [PHP-DB] Select where date is in period

2001-03-22 Thread Steve Brett
. like the highlander. so if $checkdate was 2001-03-22 then the query would look like this to the db: select * from plant.eqpt where date_online ='2001-03-22' AND date_offline ='2001-03-22' order by type,size i haven't used between on dates but it is valid SQL. good for ranges of numbers. Ste

RE: [PHP-DB] Select where date is in period

2001-03-22 Thread Steve Brett
i think i also used = to indicate 'equal or greater to than' instead of = like you have ... Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this me

[PHP-DB] classes and sessions

2001-03-26 Thread Steve Brett
? Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this me

Re: [PHP-DB] Indexing help

2001-03-27 Thread Steve Brett
replies below: ""M. Verheijen"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Dear reader, A newbie mysql/php-question here! I've filled a mysql-database with about 1600 records. All these records contain items which are on sale on a website. Every row contains

RE: [PHP-DB] get_browser()

2001-03-27 Thread Steve Brett
i use get_env("HTTP_USER_AGENT") to log browser types and it works fine. to be hones i didn't know about the get_browser function ... user agent suplies loads of info though about browser, platform etc. Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confident

RE: [PHP-DB] Editing DB entries via form

2001-03-27 Thread Steve Brett
use isset($checkbox) where $checkbox is the name of the check box on the page that processes the form. Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this me

RE: [PHP-DB] ecommerce - storing as an array or temporary record

2001-04-02 Thread Steve Brett
there is an excellent tutorial with a coded example of a shopping cart using sessions. http://www.phpbuilder.com/columns/evert2816.php3 only takes small mods to extend it so you can delete from cart as well. Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confide

RE: [PHP-DB] Keeping Variables

2001-04-02 Thread Steve Brett
session_register("cr"); and then read the manual page on starting sessions etc ... Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message

RE: [PHP-DB] Targeting frame in PHP

2001-04-06 Thread Steve Brett
have a look at target= Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not

RE: [PHP-DB] Robust OO Shopping Cart 4 sale - oh please ....

2001-04-10 Thread Steve Brett
the wonderful thing about open source is that generally you are speaking to people that are FAR more qualified and FAR cleverer. you remind me a lot of someone (and i can name a lot of developers) who has something and is convinced that they are immediately superior because of this 'something'

RE: [PHP-DB] Robust OO Shopping Cart 4 sale

2001-04-10 Thread Steve Brett
apologies to the group. B. i completely agree with what you say. -Original Message- From: B. van Ouwerkerk [mailto:[EMAIL PROTECTED]] Sent: 10 April 2001 13:08 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Robust OO Shopping Cart 4 sale No that is not what I said. If you go

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

2001-04-10 Thread Steve Brett
I'm rooting for PostgreSQL to become the open source app that ate Oracle. MySQL will never be capable of that, but I don't think it needs to be. There will always be a niche for small, quirky apps that have just enough functionality to get the job done and keep the learning curve

RE: [PHP-DB] images

2001-04-11 Thread Steve Brett
i'm pretty sure i read somewhere that is you use sessions php will not allow an url that contains a path to a file typed in the address bar ... may be wrong though ... and apologies once again for the shopping cart debacle yesterday. some poeple were complaining and rightly so. i received a

RE: [PHP-DB] OBDC date problems

2001-04-11 Thread Steve Brett
i think you need SELECT * FROM news WHERE fdate = '$date' AND tdate = '$date' the dates have to be single-quoted in your query string i generally use $query = "SELECT * FROM news WHERE fdate = '".$date."' AND tdate = '".date."'"; this may not be the best way and i would really appreciate it

RE: [PHP-DB] calling a column into a popup

2001-04-23 Thread Steve Brett
becky the code below is spot on (nearly) stick it on a form that calls itself change the option name= to option value= and when you refresh the form $company will contain the comany name. you can also use selected in the folowing manner $regs = pg_Exec($conn, select region_id,

RE: [PHP-DB] Include File Syntax

2001-04-26 Thread Steve Brett
hi kat, the include files are simply a way for repetitive code (like a connection to a db) to be inserted into your pages. the syntax for the files is the same as any php script and it is added to the page at the point that you include it. the format is include (page_name.php); the pages

RE: [PHP-DB] Query problem cont'd..

2001-04-26 Thread Steve Brett
ok. try this. ahven't tested it though ... form name=thisForm action = ?php print $PHP_SELF ? ?php // to dump out the months $months = Array(January, February, March, April, May, June, July, August, September, October, November, December); echo 'select name=sortMonth

RE: [PHP-DB] PHP problem

2001-04-30 Thread Steve Brett
user something like this: the thing you're looking for is the SELECTED bit of the select drop down ... echo 'select name=month onChange=document.thisForm.submit()'; $months = Array(January, February, March, April, May, June, July, August, September, October, November, December); for ($x=1; $x

RE: [PHP-DB] Select statements - A Quest !!!

2001-04-30 Thread Steve Brett
i worked at a particularly PC bank once ... Kaizen was the management philosophy and means 'never ending horizon' or words to that effect ... maybe their get Kaizen points per department ... sounds lovely, :-) Steve -Original Message- From: Bob Hall [mailto:[EMAIL PROTECTED]]

[PHP-DB] creating a downloadable file ...

2001-05-02 Thread Steve Brett
hi, i have a table that is populated from a database. the only problem with it is that the table is quite large. i'd like to give the user to the option to download the file in csv format ... can anybody point me in the right direction ? Steve Brett Internal Development tel: 4251 EMIS Ltd

RE: [PHP-DB] *.xls

2001-05-08 Thread Steve Brett
i'd also be interested in this ... i have some code that will create .csv files for download, whihc is the way i normally do it. Steve -Original Message- From: Aivar Annamaa [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 13:02 To: [EMAIL PROTECTED] Subject: [PHP-DB] *.xls Hi

RE: [PHP-DB] urgent postgresql date problem ...

2001-05-09 Thread Steve Brett
=;} } } } Steve -Original Message- From: Steve Brett [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 09:39 To: php-db@lists. php. net (E-mail) Subject: [PHP-DB] urgent postgresql date problem ... hi, i've got a really annoying problem with php. i need to generate

RE: [PHP-DB] *.xls

2001-05-09 Thread Steve Brett
/txtCodeId.11898/lngWI d.1/qx/vb/scripts/ShowCode.htm Adaran (Marc E. Brinkmann) wrote: Hi Steve Brett, Wednesday, May 09, 2001, 12:24:02 PM, you wrote: Steve could you send me the specs for the excel format ? Steve Steve Best thing would be to post it here, or a link at least. I think

RE: [PHP-DB] *.xls

2001-05-09 Thread Steve Brett
Function Table List of Ptg's Steve Brett wrote: it's VB ? -Original Message- From: Hans-Werner Guth [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 14:32 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] *.xls Hi, ...write to an XLS file without DLL's

RE: [PHP-DB] No MySQL-Link resource supplied

2001-05-11 Thread Steve Brett
the link will be the link you set up to connect to mysql, or the resource id as php refers to it (i think) you'll have something like $link=mysql_connect(...) as below [example from manual] ?php $link = mysql_connect (localhost, username, secret) or die (Could not connect);

RE: [PHP-DB] Date formats from Postgres

2001-05-11 Thread Steve Brett
use $date=(d/m/Y,strtotime(value_from_db)); strtotime will convert a string value to a timestamp. Steve -Original Message- From: Sean Weissensee [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 11:13 To: PHPDB Subject: [PHP-DB] Date formats from Postgres I am reading a data

[PHP-DB] Date formats from Postgres

2001-05-11 Thread Steve Brett
into a timestamp. any suggestions ? Sean Weissensee IT Manager Ion Solutions www.ionsol.com.au Steve Brett Internal Development tel: 4251 EMIS Ltd. Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated

RE: [PHP-DB] User Permissions

2001-05-24 Thread Steve Brett
we use sessions and then include a general script to check they are logged in and then in individual areas use an if ($seclevel == 1) approach. obviously register $seclevel and any other security levels , codes etc. or, depending on the db, have a look at grant and revoke and set permissions at

RE: [PHP-DB] characters - URGENT!!!

2001-05-24 Thread Steve Brett
i'm sure this is taken car od in the php string handling functions. couldn't you 'clean' them up prior to when you insert them ? steve -Original Message- From: Selvin Sakal [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 12:44 To: [EMAIL PROTECTED] Subject: [PHP-DB] characters -

RE: [PHP-DB] How do I backup my MySQL database? asks a Newbie.

2001-06-21 Thread Steve Brett
get mysql front, install it and then choose export tables to file. i've found mysql-front to be a really good tool for adminisrating mysql dbs Steve -Original Message- From: Dan Eskildsen [mailto:[EMAIL PROTECTED]] Sent: 21 June 2001 10:15 To: [EMAIL PROTECTED] Subject: [PHP-DB]

RE: [PHP-DB] mysql client compression with php?

2001-06-22 Thread Steve Brett
have a look at ob_start(ob_gzhandler) which will compress the page and then send it, expecting the client to decompress it on arrival. this is all handled transparently so you don't need to worry about the decompression. i found it very slightly slower but enormous reductions in network

RE: [PHP-DB] 1 is not a valid PostgreSQL link resource

2001-06-22 Thread Steve Brett
i think this could also be your query failing. if you have an invlaid sql staement you'll get the same error. Steve -Original Message- From: Carlos Estala [mailto:[EMAIL PROTECTED]] Sent: 21 June 2001 18:03 To: [EMAIL PROTECTED] Subject: [PHP-DB] 1 is not a valid PostgreSQL link

[PHP-DB] PhpDEV

2001-06-23 Thread Brett Shaw
www.oosha.com/phpdev/index.php3 Ive had some great response to the site but not as much as id hoped if you have any ideas please email them to me and ill implement them -- [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] mysql errors .... or php errors ????

2001-06-28 Thread Steve Brett
i know this may not be stricktly php but ... soemtimes when i return queries from mysql to php i get errors like 'invalid index test assumed 'test' in test.php at line 13' can't remember the exact syntax but that's the general idea. if i quote the var when i reference it the error goes

RE: [PHP-DB] Adobc error

2001-06-28 Thread Steve Brett
you need to find adodb.inc.php and then check that the path in the include statement on line 7 in adodb.inc.php is pointing at the correct path. Steve -Original Message- From: Wilmar Pérez [mailto:[EMAIL PROTECTED]] Sent: 27 June 2001 23:48 To: PHP List Subject: [PHP-DB] Adobc

RE: [PHP-DB] mysql errors .... or php errors ????

2001-06-29 Thread Steve Brett
the code wasn't mine. it was a drop in message board. Steve -Original Message- From: Jason k Larson [mailto:[EMAIL PROTECTED]] Sent: 28 June 2001 11:12 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] mysql errors or php errors Another thought came to mind. These

RE: [PHP-DB] Need a shopping cart

2001-07-12 Thread Steve Brett
check out the session cart on phpbuilder.com it stores all the cart stuff as session vars so you can use any db Steve -Original Message- From: Jeff @ HookedOnThe.Net [mailto:[EMAIL PROTECTED]] Sent: 12 July 2001 02:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] Need a shopping cart

RE: [PHP-DB] Order by unix timestamp

2001-07-12 Thread Steve Brett
-Original Message- From: Andreas Iwanowski [mailto:[EMAIL PROTECTED]] Sent: 12 July 2001 16:09 To: [EMAIL PROTECTED] Subject: [PHP-DB] Order by unix timestamp How can i fix the problem that the records are ordered by unixtime, beginning with the newest record ? order by

Re: [PHP-DB] upload problem ...

2001-07-13 Thread Steve Brett
Xsarus Internetdiensten Holland [EMAIL PROTECTED] - Original Message - From: Andre P. [EMAIL PROTECTED] To: Steve Brett [EMAIL PROTECTED] Cc: php-db@lists. php. net (E-mail) [EMAIL PROTECTED] Sent: Monday, June 25, 2001 6:17 AM Subject: Re: [PHP-DB] upload problem ... Steve,

[PHP-DB] www.oosha.com/phpdev/

2001-07-15 Thread Brett Shaw
Oosha.com's PhpDEV has got a mailing list if you would like to joing please see below: - To subscribe to the mailinglist, simply send a message with the word 'subscribe' in the Subject: field to the -request address of that list To: [EMAIL PROTECTED] Subject: subscribe To subscribe to the

[PHP-DB] escape char hell ....

2001-07-16 Thread Steve Brett
hi, i've got myself into a bit of a mess. i have a database with approx 4000 records (mysql) and when i populated the database i was given 4000 text files with the product name as the file name and the description of the product as the contents. so i set up a text field in the table to hold

[PHP-DB] Re: Error 127

2001-07-19 Thread Steve Brett
the only time i've had this (not sure if it was 127) but i couldn't get the properties etc was after i named a table with a name that was a keyword. check the list in the docs as the list is quite long. i called mine 'returns' doh! Steve Cami [EMAIL PROTECTED] wrote in message [EMAIL

Re: [PHP-DB] Error 127

2001-07-19 Thread Steve Brett
you know i did this last week and can't remember the functions is used. i had exactly the same problem but had to dump the records as plain text files. i used get_html_translation_table . if you look at the example in the compiled html help file for php there is a section of code that uses this

[PHP-DB] Re: PHP, Apache PostgreSQL

2001-07-23 Thread Steve Brett
php is not compiled with postgresql support. Steve Sean McCoy [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... When I execute a pg_connect() in a .php file, I get an error indicating that the function is not defined... That's because, in the Apache error log

[PHP-DB] Re: retrieving special characters from MySQL

2001-07-23 Thread Steve Brett
pull it out then use stripslashes() as you display it ... Steve Andrew [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, I'm having trouble getting special characters out of MySQL using php 4.06. I add a field like McDonald's from PHP and in mysql client I

[PHP-DB] Re: Session with php and mysql problem!

2001-07-31 Thread Steve Brett
session_start(); should do it on the second page Steve Koutsogiannopoulos Karolos [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello all... i have the following script which checks a username and pass from a db and if it is correct it starts a session..

[PHP-DB] Re: Application dev w/ PHP MySql

2001-07-31 Thread Steve Brett
i was really gonna try and answer this for you then it struck me that you've got quite a way to go in terms of your position relating to database design and so on. so... i'd sugest you read up a bit on the logic of the way you are trying to implement your database and theink about the logical

[PHP-DB] Re: Problem compiling pgsql and php (Semi OT)

2001-07-31 Thread Steve Brett
ok . i've had this problem and fixed it thus: --with-pgsql=/path/to/unzipped/files e.g. --with-pgsql=/usr/src/postgresql7.1.1/ and it works, and has done for the last seven months. rasmus bit my head off though when i suggested it though so sh. Steve Matt Williams [EMAIL PROTECTED]

Re: [PHP-DB] Another SELECTING problem :-(

2001-08-09 Thread Steve Brett
Dave Watkinson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... PS This is for a web page, so it's PHP related!!! :-) -Original Message- From: Dave Watkinson Sent: 09 August 2001 12:51 To: PHP-DB List (E-mail) Subject: [PHP-DB] Another SELECTING problem

[PHP-DB] Re: fopen function

2001-08-10 Thread Steve Brett
use rewind() to set the file pointer to the beginning of the file. check out the filesystem functions in the help manual, there are loads of useful functions. Steve Nathan Cavicchi [EMAIL PROTECTED] wrote in message

[PHP-DB] Re: VERY strange erro

2001-08-13 Thread Steve Brett
Piotr Dubla [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... I have a script which accessed a database (MySQL) and reads and wrties things to it. The first time I run the script everything runs 100% but then if I re-run it it gives me Fatal error: Unsupported operand types in

Re: [PHP-DB] Newbie: Modify - Delete entries

2001-08-20 Thread Steve Brett
if the fields are static i.e. name: phone number: etc etc have a look at using while and foreach to dump your stuff out. should save you a fair chunk of code. Steve Sg [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Thank you Kate! I'll try that, but I may

Re: [PHP-DB] Newbie: Modify - Delete entries

2001-08-20 Thread Steve Brett
doh! sorry re-read your code. pls ignore last post. Steve Steve Brett [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... if the fields are static i.e. name: phone number: etc etc have a look at using while and foreach to dump your stuff out. should

Re: [PHP-DB] Re: interbase or postgres

2001-08-20 Thread Steve Brett
daddy or chips, daddy or chips apologies to non-uk readers go with postgresql. it's superb. we use at at work and have had nine months service with no unplanned downtime. fast and reliable and great php support - gets my vote every time. now if only i could persuade my company to stop paying

[PHP-DB] please, please can we stop this kind of thing ..... !

2001-08-20 Thread Steve Brett
you know, i've been reading/contributing to this board for a few months and every now and again i see posts from B and now it's really getting up my nose. people come here to find answers. i still come here asking questions. i am totally sick of your RTFM answers, i knew the answer to this

Re: [PHP-DB] please, please can we stop this kind of thing ..... !

2001-08-20 Thread Steve Brett
PROTECTED] wrote in message 001a01c1297c$08a04810$[EMAIL PROTECTED]">news:001a01c1297c$08a04810$[EMAIL PROTECTED]... -Original Message- From: Steve Brett [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 2:53 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] please, please can

Re: [PHP-DB] please, please can we stop this kind of thing ..... !

2001-08-20 Thread Steve Brett
my point exactly Yes. But being a newbie is a lame excuse for NOT searching the manual. who made you king of the castle ? Steve Marcel Walter [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]. com... Hmmm @B: In future... everything you send to me will go to /dev/spammer ...

Re: [PHP-DB] please, please can we stop this kind of thing ..... !

2001-08-20 Thread Steve Brett
sorry, my last post was aimed at B. van Ouwerkerk, not Marcel. Steve Marcel Walter [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]. com... Hmmm @B: In future... everything you send to me will go to /dev/spammer ... -Original Message- From: B. van Ouwerkerk

[PHP-DB] Re: Postgresql/PHP backend error

2001-08-21 Thread Steve Brett
i'd trt trawling the newsgroups - started to do it for you but got zillions of results back. try postgresql.org for starters ... Steve Nigel Gilbert [EMAIL PROTECTED] wrote in message news:p05100314b7a6fc817874@[192.168.123.1]... I have PHP 4.06, Postgres7.1 and Apache on a Solaris server.

[PHP-DB] Re: Query construction

2001-08-21 Thread Steve Brett
select count(distinct(category)) as number_of_posts from posts; should do it. Steve Russ Michell [EMAIL PROTECTED] wrote in message news:SIMEON.10108211219.F@k1c. anglia.ac.uk... Hi there people: I have a MySQL table consisting of category names among other things. I would like to be able

[PHP-DB] Re: Slightly OT - maybe just SQL not php

2001-08-21 Thread Steve Brett
update table1 set field1=CONCAT('N',field1); should work, haven't tested it though. Steve George Pitcher [EMAIL PROTECTED] wrote in message 00e101c12a13$2db49880$[EMAIL PROTECTED]">news:00e101c12a13$2db49880$[EMAIL PROTECTED]... Hi all, I have a MySQL table with approx 350,000 records (US

[PHP-DB] Re: Photo Album Schema

2001-08-22 Thread Steve Brett
that would generally work on the assumption that many photos can belong to many albums. possibly a bad thing. table 1 -userid (primary key) -username -password -album_title -creation_date table 2 -photoid (primary key) -photo (jpg or gif) -date -photo_title -description

[PHP-DB] Re: OT (slightly): recommended procedure for backing up Postrgesql 7.0.3

2001-08-24 Thread Steve Brett
you can set up a job using cron that pg_dumps the date anywhere you need. we use an automounted dir that links to a windoze server ... Steve Brad Hubbard [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Well, the subject really says it all. What procedures are

[PHP-DB] Re: OT (slightly): recommended procedure for backing up Postrgesql 7.0.3

2001-08-24 Thread Steve Brett
| gzip /backup/edb-backup_$backdate cp /backup/edb-backup_$backdate /var/autofs/misc/ecalnet/ are the contents of the file dumpit. this creates a gzipped dump of the database with a name of edb-backup_200108240730 for example, then copies it to another directory. HTH Steve Steve Brett [EMAIL

[PHP-DB] Re: pg_exec question.

2001-08-24 Thread Steve Brett
i don't thing 99% sure that it can be done. you can decalre a transaction and then [begin statement 1statement 2statement n commit] [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello, I'm new with PHP and PostgreSQL, and can't find a solution to the

Re: [PHP-DB] PHP development with PostgreSQL

2001-08-24 Thread Steve Brett
i use postgresql at work and the reson we chose it baove mysql (which i also use for developement @ home) was scalability. from our investigations mysql does not scale well wehn having 100+ users. BUT before i start a pointless debate on the merits of either both DB's seem to have 'converged'

[PHP-DB] Re: Zend IDE anyone?

2001-08-24 Thread Steve Brett
I have used the Zend IDE for php dev and found it to be superb. unfortunately the company i work for takes an age to get license agreements arranged so our eval period had run out. it's very easy to set up - try the eval version first. Steve Grant Boggs [EMAIL PROTECTED] wrote in message

[PHP-DB] Re: Zend IDE anyone?

2001-08-24 Thread Steve Brett
in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Steve Brett [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have used the Zend IDE for php dev and found it to be superb. unfortunately the company i work for takes an age to get lic

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

2001-08-30 Thread Steve Brett
SELECT distinct(students.fname), courses.title AS course FROM students, courses, course_enrolments, groups, locations, staff WHERE (students.studentID=course_enrolments.studentID AND course_enrolments.courseID=courses.courseID) AND (students.groupID=groups.groupID) AND

[PHP-DB] Re: postgresql groups and users

2001-09-05 Thread Steve Brett
Michiel Lange [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... for my application in php I connect with a postgresql database. In this database I have made users and groups, where 1 user can be the member of many groups (n on m relation)

[PHP-DB] Re: Newbie Help: Searching

2001-09-06 Thread Steve Brett
have 2 vars $Tech and $Admin and then chnage you SQL so it says: $Query = SELECT * FROM enet WHERE TechContact LIKE '%$Tech%' AND AdminContact LIKE '%$Admin%'; Steve Devon [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... $Query = SELECT * FROM enet WHERE

[PHP-DB] Re: db's war

2001-09-18 Thread Steve Brett
i've used postgresql and mysql on linux platforms (mysql on windoze) and have been really suprised by mysql. i must admit thought that postgresql is far more complex and more powerful. although i haven't used db2 or oracle in anger i can certainly see postgres making gains in the near future ...

[PHP-DB] Re: sessions in PHP

2001-09-25 Thread Steve Brett
http://www.phpbuilder.com/columns/ good articles on sessions Steve Nirat [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... can anyone guide me to using sessions in PHP i've tried it a lot of times but its not working. any help tutorials would be helpful... --

[PHP-DB] Re: mysql_fetch_array() doesn't work

2001-09-25 Thread Steve Brett
there doesn't look to be any problem with the code you've shown. it would be helpful, however, if you included the full error including the line and the lines surrounding this point as the error probably lies in previous code. Steve Web User [EMAIL PROTECTED] wrote in message

[PHP-DB] Re: Apache 2

2001-09-26 Thread Steve Brett
the INSTALL file in the php dist have short and verbose instructions from install on linux and it is extremely good. Steve Mike Dolan [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Does anyone know of a good tutorial/walkthrough on how to get apache2, mysql,

[PHP-DB] Add Record to DB and Return Auto_Increment ID?

2001-10-21 Thread Brett Conrad
auto_increment id. I could use an Insert statement and then a Select statement to find out what id was added for the record, but that seems a little inefficient. Any ideas? Thanks for any help. Much appreciated, Brett -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] Re: what's a GOOD starting HOURLY rate for a PHP/MYSQL job?

2001-11-09 Thread Steve Brett
I'd also be interested in what people are charging as I'm thinking of setting up as a contractor myself and it would be nice to have a 'ball park' figure of what the going rate is ... Pls mail replies to [EMAIL PROTECTED] Ta, Steve Leo G. Divinagracia III [EMAIL PROTECTED] wrote in message

[PHP-DB] Re: Problem with special characters

2001-11-09 Thread Steve Brett
I have code at work that encodes and decodes escape chars when inserted into mysql or displayed as html. Can't remember the syntax exactly but I did use htmlentities and then array_flip on the way out. There is an example in the php help file. Found it. I love it when PHP can do stuff like this

[PHP-DB] Re: php, oracle and ascii characters

2001-11-09 Thread Steve Brett
Dan, This sorts out your problem completely. htmlentities() will encode the data as it is inserted into the database and get_html_translation_table will help you translate it so it can be viewed in the browser. Have a look at the manual page for the get_html_translation_table function displayed

Re: [PHP-DB] Problem with special characters

2001-11-09 Thread Steve Brett
There is a solution posted on the original thread. PHP already has functions to deal with this problem. str_replace is a waste of time. Steve Natalie Leotta [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... I would recommend that you try something like str_replace and replace all of

[PHP-DB] Re: what's a GOOD starting HOURLY rate for a PHP/MYSQL job?

2001-11-09 Thread Steve Brett
many thanks, this may sound totally dumb but where do you find your work ? is it via word of mouth or do you advertise etc ? Steve Tim Foster [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'd also be interested in what people are charging as I'm thinking of

[PHP-DB] Re: Newbie Question

2001-11-09 Thread Steve Brett
have a look at get_html_translation_table() in the php manual. there is an example of conversion of all special chars so they can be inserted into the database as text (i.e. £pound) and a cool way of 'decoding' them if you need to write them to a file. A Browser wil interpret them correctly when

[PHP-DB] Noob questions...

2002-10-02 Thread Brett Lathrope
can set up and finally c) allows me to work from a client on MySQL DB on my Web Host? Thanks Brett -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] The noob is back! About this directory security...

2002-10-03 Thread Brett Lathrope
in through the browser (if that makes sense). You guys keep talking about this chmod command...but I'm using WS-FTP LE and all I get is Owner, Group, and Other with the options to set Read, Write and Execute for each. And I've read that I should be 2 directories down? Thanks guys. Brett -- PHP

[PHP-DB] Displaying a single picture...

2002-11-12 Thread Brett Lathrope
I have several thumbnail images spread out in my website. I thought it would be cool to write a single PHP script so that when they click on the thumbnail, the name of the larger pic would be passed to a PHP script that displays it on its own page...I don't even care about a link back, they can

[PHP-DB] I just wanna say...

2002-11-15 Thread Brett Lathrope
responses. Thanks! Brett -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] The noobest of questions...

2002-12-08 Thread Brett Lathrope
How do you load a standard web page from PHP. I thought, from what I read, that is was with fopen() ... but its not working for me. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

  1   2   >