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. £>£) and a cool way of
'decoding' them if you need to write them to a file. A Browser wil interpret
them correctly when the
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 thinkin
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 al
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 b
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
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
nextval is a function found in postgres databases and is used to seed the
value of a serial(auto increment) that is normally used as a key.
other uses are select currval(serial) to get the current value and select
setval(serial,value) to set the vlaue on the fly.
much more info can be found in t
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,
> mys
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
008501c1459e$5
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...
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 ... t
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
"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)
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 (staff.staffID=cours
t;[EMAIL PROTECTED]> wrote 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.
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
[
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' ov
i don't thing <99% sure> that it can be done.
you can decalre a transaction and then [begin 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
> following problem. I'd l
| 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
"Ste
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 a
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_tit
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 record
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 b
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
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 Ouwerker
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
Rudel" <[EMAIL 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
>
you're there already.
have an if statement on mail.php:
if (isset($posted_info))
{
// send mail here
// do db insert here
} // end of if
Steve
"Jack" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Dear all
> I was trying to get a user input form to inse
have a look at date_format() in mysql.
there is quite a few date format functions that will allow you to format
dates coming out of mysql.
DATE_FORMAT(date,format)
Formats the date value according to the format string. The following speci
ers
may be used in the format string:
%M Month name (Ja
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 also
daddy or chips, daddy or chips
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 micro$oft
Steve
"Jarek
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
>
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
"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 typ
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
001001c1210f$900f6a80$0e7398cd@thadius">news:001001c1210f$900f6a80$0e7398cd@
"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
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 PROTECTE
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 flo
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 sess
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
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 erro
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
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 PROT
> Hi all',
> I have a mysql_query that reads:
>
> $testResult = mysql_query("SELECT * FROM login_table where Pass =
> password('$password')") or die ("ouch");
>
is $password the var that stores the password ? i don't understand why you
have password('$password')
$testResult = mysql_query("SELEC
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 the
ther eis no problem connecting to the db every page unless you have problems
that are discussed at postgresql.org regarding persistant connections.
i used them had problems with zillions of postmasters starting.
use the following and include it in the pages that need db access.
Steve
"Cornel
x27;, but 'move_uploaded_file'.
>
> Ready...
> Daniel Kieviet
> Xsarus Internetdiensten
> Holland
> [EMAIL PROTECTED]
>
>
> - Original Message -
> From: "Andre P." <[EMAIL PROTECTED]>
> To: "Steve Brett" <[EMAIL PROTECTED]>
> -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 ?
orde
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 car
if libphp4.so is not there then php is not compiled properly. or apache has
not been complied pointing at libphp4.so.
apache config line should look something like this
$ ./configure --prefix=/www --activate-module=src/modules/php4/libphp4.a
have a look at the install doc for php (there's a bri
a more efficient way to do this would be to create many to many
relationships betwewen tables that store titles, refs etc.
> -Original Message-
> From: Sandis Jerics [mailto:[EMAIL PROTECTED]]
> Sent: 05 July 2001 11:38
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Suggest Table Structu
you could also use nl2br()
nl2br
(PHP 3, PHP 4 )
nl2br -- Inserts HTML line breaks before all newlines in a string
Description
string nl2br (string string)
Returns string with '' inserted before all newlines
-- no point reinventing the wheel
Steve
> -Original Message-
> From:
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.
>
> T
this will do the redirect
echo'';
content=X will set the delay in seconds.
Steve
> -Original Message-
> From: Jennifer Arcino Demeterio [mailto:[EMAIL PROTECTED]]
> Sent: 28 June 2001 04:10
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] delay script
>
>
> hello!
>
> does anyone knows ho
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
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 awa
take out the db connection and include it seperately in your page
then make $connection global in your function.
or do a if (!$connection) then ($connection=blah blah blah...)
Steve
> -Original Message-
> From: Shahmat Dahlan [mailto:[EMAIL PROTECTED]]
> Sent: 26 June 2001 07:55
> To: s
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 li
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 traffi
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-D
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 -
php needs to be recompiled and add the line --with-pgsql
or install mysql. out of the two (i work with postgresql so i am pretty
biased) i would def go with postgresql.
steve
> -Original Message-
> From: Chadwick Rolfs [mailto:[EMAIL PROTECTED]]
> Sent: 23 May 2001 22:33
> To: [EMAIL PR
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
i've ust downloaded html kit which is free and superb.
Steve
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 18 May 2001 14:47
> To: Sharmad Naik; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] php notepad
>
>
> On 18 May 2001, at 17:17, Sharmad Naik wrote:
i always use:
print "".$values."";
sometimes i can get away without splitting the string but generally i find
it easier to do it this way ...
p.s. if there are any rules i'm not aware of as to the format of strings
including values from db's i'd be really grateful if someone could point
them ou
hi,
maybe a better way to do it would be to use tempnam
$fname=tempnam("/www/htdocs/edb/tmp","CSV");
$fp= fopen($fname,"w+");
$filename=basename($fname);
create a var with todays dats in it and then set that as the second
parameter of tempnam.
this will generate unique filenames including the d
t;
> but with no success.I am not sure how to convert the database variable
> into
> a timestamp.
>
> any suggestions ?
>
> Sean Weissensee
>
> IT Manager
> Ion Solutions
>
> www.ionsol.com.au
>
Steve Brett
Internal Development
tel: 4251
EMIS Ltd.
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
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]
Steve
> -Original Message-
> From: Rankin, Randy [mailto:[EMAIL PROTECTED]]
> Sent: 10 May
nstant
> Operand Tokens - Classes
> Operand Tokens - Base
> Control Tokens
> Function Operators
> Reserved Ptg's
> Scanning a Parsed Expression
> Excel Function Table
> Command Equivalent Function Table
> List of Ptg's
>
> Steve Brett wrote:
&
gt;
> visit:
>
> http://www.planet-source-code.com/xq/ASP/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
export data from database to
> Excel format. We have specyfication of the excel file format,
> and we are
> trying
> to generate binary file bite by bite, but we have problems
> with borders
> and frames.
> Maybe someone hes experienced similar problems?
>
> best regard
;}else{$instdate=" ";}
}
if ($output==2)
{
if (!pg_fieldisnull($lastv,0,0)){$lastvisit =
gmdate("d/m/y", strtotime($lastvdets[0]));}else{$instdate="";}
}
}
}
Steve
> -Original Message-
> From: S
etch_array($lastv,0);
$lastvisit = gmdate("d/m/y",strtotime($lastvdets["start_date"]));
}
}
the code is returning $lastvisit at 08-05-01 in all cells ...
Steve Brett
Internal Development
tel: 4251
EMIS Ltd.
&quo
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
>
>
>
SESSIONID?topicID
>
> I am banging away, the 4 books i have on Php are useless when
> it comes to
> session and there usage.
>
> Thanks for the help
>
> Dave C
>
> "Steve Brett" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">ne
try
session_register("topidID");
without the $
Steve
> -Original Message-
> From: DC [mailto:[EMAIL PROTECTED]]
> Sent: 02 May 2001 13:54
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Sessions ???
>
>
> Hi All
> I have a ? about setting a session.
>
> I have a functions.inc file and a
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
EMI
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]]
> Se
user something like this:
the thing you're looking for is the SELECTED bit of the select drop down ...
echo '';
$months = Array("January", "February", "March", "April", "May", "June",
"July", "August", "September", "October", "November", "December");
for ($x=1; $x <= count($months); $x++)
ok. try this.
ahven't tested it though ...
?".$months[$x-1]."\n";
}
echo ' ';
?>
then something like (pref before the dump of months)
will be
populated when the form refreshes and then isset() will say it has a value
and drop inside to create the query. that way you avoid an expe
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 t
do you have XML support installed ?
i don't realy know if you need it but you might ...
Steve
> -Original Message-
> From: Kelvin [mailto:[EMAIL PROTECTED]]
> Sent: 25 April 2001 18:38
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] WML vs PHP and MYSQL
>
>
> Hi,
>
>I am trying t
becky the code below is spot on (nearly)
stick it on a form that calls itself change the ';
echo 'Choose a Region';
for ($s=0; $s<$numregs; $s++)
{
$reglist = pg_fetch_array($regs,$s);
echo''.$reglist["region
pg_numrows will only bring back the number of results in the resultset.
you could try:
a. a query using distinct to bring only the vlaues you want.
b. (better) a query using an aggregate function like count and then access
the count var from your resultset.
like:
select count(id) as idcount f
wow. another postgresql user !
i use pg_connect to connect as well, including the connect script as an 'if
not connected then connect' type of thing. the connection is killed and
memory from queries freed up when the script finnishes.
incidently, i used pconnect for a while but found that connec
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
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 doze
i just thought i'd share some more of mr st jean's comments
last post on this topic. promise.
Steve
> -Original Message-
> From: Rick St Jean [mailto:[EMAIL PROTECTED]]
> Sent: 10 April 2001 16:15
> To: Steve Brett
> Subject: RE: [PHP-DB] Robust OO Shoppin
>
> 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
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 want go somewhere else. That is the rule of
> business. I find that most open source doesn't have great
> support either,
as i said earlier ... maybe it's the way you ask ... ?
> and a company that charges for something will have more
> features that I
> want/need because if not t
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' th
i've just read the rest of the mails and must admit i am more than dismayed.
the shopping cart is SIMPLE, and if you can be bothered is easy to set up
and code.
>store want. They do not support the number of operating systems that we
>do, and are no where near as easy to install.
what operat
you can get a free (and better) shopping cart from php builder
got to http://www.phpbuilder.com/columns/evert2816.php3
Steve
-Original Message-
From: Rob Wheeldon [mailto:[EMAIL PROTECTED]]
Sent: 10 April 2001 05:00
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Robust OO Shopping Cart 4 s
AFAIK all resources are freed when the script ends so there's no real reason
to free up the memory. Unless of course you have loads of queries on a long
script ...
Steve Brett
Internal Development
EMIS Ltd.
"Privileged and /or Confidential information may be contained in this
m
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 co
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 (or
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
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 messag
1 - 100 of 123 matches
Mail list logo
