- Original Message -
From: Fotwun [EMAIL PROTECTED]
To: Jason Wong [EMAIL PROTECTED]; Fotwun [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, August 21, 2001 4:24 AM
Subject: RE: [PHP-DB] E-Commerce - Integrating Sessions With Charging
Processes That rePOST
How, code wise do I
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.
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. Most
of
the time all works as expected. Occasionally I get an database
error:
I think you are better to post your problem in PostgreSQL
On Sybase the following script:
create table #temp_table (
a varchar(10),
b numeric identity
)
insert into #temp_table (a) values (1234)
insert into #temp_table (a) values (234)
insert into #temp_table (a) values (134)
insert into #temp_table (a) values (124)
insert into
Hi there people:
I have a MySQL table consisting of category names among other things.
I would like to be able to construct a query that tells me the number of times a
unique category
name occurs in the table:
//Table 'posts' from command-line
mysql explain posts;
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
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
Damn!!
That'll be it..
I'm running phpMyAdmin 2.1.0 , php.4.0.3pl1 and MySQL 3.22.32
Then again I don't get an error message from your query..???
Perhaps it has to do with the query being embedded, that is *where* it's embedded:
$totalsql = SELECT category,COUNT(*) FROM $Tpostings GROUP BY
I always love that feeling when you beat a problem that refuses to go away.
So do I - but I aint beaten it yet! :-(
I'm still getting '2' as being the number of posts in each category when '2' is
actually only the
number of posts in *one* of the categories...weird-huh?
Cheers.
Russ
On Tue,
At 1:44 PM +0100 8/21/01, Russ Michell wrote:
I always love that feeling when you beat a problem that refuses to go away.
So do I - but I aint beaten it yet! :-(
I'm still getting '2' as being the number of posts in each category
when '2' is actually only the
number of posts in *one* of the
Okay I have it now!
while ($row = mysql_fetch_array($result)) {
$name = $row['name'];
$dc = $row['datecreated'];
$nameinurl = urlencode($name);
//Get total posts for each category
$totalsql = SELECT COUNT(category) AS total FROM $Tpostings WHERE
Hi,
When doing a select of the form
SELECT blah FROM blah WHERE blah=blah AND blah=blah;
is there any way of doing it with an OR ie;-
SELECT blah FROM blah WHERE blah=blah OR blah=blah;
or any other way in which I could do something similar?
thanks in advance
lee
--
PHP Database
Help!,
Can any one point out web hosting companies that will give me PHP and
PostgreSQL support
for an affordable price?
Marco Gaiani
Marco A. Gaiani
Editorial Comitee
www.entomotropica.org
mailto:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
Hi,
I use PHP 4.0.6 with iODBC and Apache 1.3.20 on a Linux System to connect a
MS SQL-Server Database on a Windows NT 4 System.
For example, the query SELECT * FROM test works successfully. But when I
try to add a ORDER BY clause in this statement like SELECT * FROM test
ORDER BY name the
Can someone tell more about OciPLogon.
I know that OciLogon is used frequently but the connection to the DB is
shared amongst the pages so as in the common way where every page in a site
uses one pair user/password use the only channel. When one script makes
commit it commits all, so if two
I want to make a photo album that will have users who sign up
to create an album and then have the albums open to the public.
I was thinking of doing it like this but I've never done a relational
database before so if anyone thinks of anything I should change
please let me know. Thanks.
Jeff Oien
This has been done. see http://www.photopoint.com
This is a free service available to the public.
rick
Richard Emery
Excel Communications, Inc.
IT Sr. Project Manager
(972) 478-3398
(972) 944-0542 (pager)
There is no trying...
There is only Do or Not Do
-Original Message-
From:
Thanks for the suggestion but this is a personal project to be used
for learning and as a place for friends to post photos with only the features
that we all want.
Jeff Oien
This has been done. see http://www.photopoint.com
This is a free service available to the public.
rick
Richard
I would suggest that you do not store the photos in the database. Rather,
store the directory/ file name where each photo is located on the weberver.
This should decrease access speeds and reduce size of DB.
have fun with this project. It sounds like a good start.
Richard Emery
Excel
Rick: I don't see any .php tags there... plus just because someone
else has done it doesn't mean he can't do it as well =)
Jeff: The only critique I would give from the description you have
given us thus far is the fact that you appear to be storing the photo
in the DB.
The biggest bottleneck
I should have said photo_filename. That was what I intended to do.
Would you suggest one directory for all photos or separate directories
for each user?
Jeff Oien
Rick: I don't see any .php tags there... plus just because someone
else has done it doesn't mean he can't do it as well =)
Going to disagree there... I'd use a seperate dir for each user,
identified by their id. You can keep the original filename then for each
uploaded picture. If two users have a family.jpg then you won't end up
with any collisions. Something like:
photos/1/family.jpg
photos/2/family.jpg
I vote for one directory to simplify the programming side of things. What do
you guys recommend for the filename convention?
Would you let users determine it or would you force them into something like
a primary key?
Anthony Carlos
-Original Message-
From: Rick Emery [mailto:[EMAIL
I suggested a naming scheme, but as I think about it
that may be overcomplicating things.
You may want to, instead, create a directory for each user
with their name. This has several benefits. The first is that it
is an easy way to avoid conflicts. If Rick and I both upload
an image
I'm going to play Devil's advocate a little bit more here.
Lets say user #1 uploads 1family.jpg, and user 11 uploads family.jpg.
1 . 1family.jpg == 11family.jpg
11 . family.jpg == 11family.jpg
You run into stuff like this anytime you let users upload files of any
sort.
Justin Buist
Trident
I think this idea is an excellent one, if your going for 1 huge directory.
Store the original filename in the DB and the uniquely generated filename,
so that you know what file to load and can display a meaningful filename to
the viewer. Personally I'd go with seperate directories, but that's
Well said, Justin.
I still would have to go with the scheme of:
/photos/$UserID/$Category (?)/$FileName
- Jonathan Hilgeman
www.SiteCreative.com
Justin Buist [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]..
.
I'm going to play Devil's advocate a little bit more
That is a good point. I see two obvious answers.
Instead of
id . filename
he could use
id . + . filename
(or any non alphanumeric character instead of +)
first running the filename through an ereg
to strip any non-alphanumeric characters.
The other is to require that the first character
in
- Original Message -
From: Hugh Bothwell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 21, 2001 12:23 PM
Subject: Re: [PHP-DB] Photo Album Schema
Sheridan Saint-Michel [EMAIL PROTECTED] wrote in message
036e01c12a62$22947200$[EMAIL
Hello,
We desperately need someone who is knowledgeable in PHP 3 and 4, and MySQL
databases
for a quick job that might take 1-2 hours.
We have a small site that needs its code fixed. The code is PHP based
and is on the Gamespy servers. The code is already done for the most part,
but just
Hello,
Anthony Carlos wrote:
Here's what I'm using to do paged queries in Oracle:
$min = minimum of range of records
$max = maximum of range of records
$field_list = the fields from the table separated by commas
$table = the table from where you're selecting
$where_clause and $order_by
I'd rather do it like this (but I'm not sure it's ok...)
table 1
-userid (primary key)
-username
-password
-album_title
-creation_date
table 2
-photoid (primary key)
-photo (jpg or gif)
-date
-photo_title
-description (limited length)
table 3
-userid (primary key)
-photoid (primary
Hi everybody !
I'm looking for someone who could help me to translate some pages of my
pages...
I'm french and it would be great if my website was available in english too
:o)
Presently, I work on it and I'd like to email someone who would tell me if
there are some mistake in what I've written.
If you post the English website site, then folks can look at it and send
suggestions to you.
rick
Richard Emery
Excel Communications, Inc.
IT Sr. Project Manager
(972) 478-3398
(972) 944-0542 (pager)
There is no trying...
There is only Do or Not Do
-Original Message-
From: tatare
That's interesting. I haven't had to do too many queries with lots of
computed columns. I'll defer to you and double check my queries. On the
other hand, I have not run into any problems with truncated column data.
With regards to the server side cursors, why not send an anonymous PL/SQL
block?
hi:
I have 2 tables, lesson and lesson_gle, where lesson
holds lesson data and lesson_gle holds repeating data
that are how the lesson correlates to various state
standards (one lesson can have many
correlations)...one particular lesson may have a math
correlation as well as a language arts
Hello everyone--
I keep getting an error with MySQL when I try to Update or Insert a record
into my database. The error message is as follows:
MySQL said: Table 'zone' is read only
I went and checked the files and set the permissions on them so that they
were read and write only but that
Quoting Andrey Hristov [EMAIL PROTECTED]:
Can someone tell more about OciPLogon.
I'm sure Theis will add to this but here goes... :)
I know that OciLogon is used frequently but the connection to the DB
is
shared amongst the pages so as in the common way where every page in a
site
uses
Ok... we have an Oracle Server running on a remote Sparc 220R system.
We then have an Ultra 5, which has a Sparc processor in it. We have RedHat
Linux running on the Ultra 5. So thats Linux on Sparc (not i386).
Is it possible to communicate with the remote oracle database using this set
up?
Hello,
I use PHP 4.0.6 with mySQL 3.23.40 and I have the error
2008 (client run out of memory) performing this query :
select i2f.item_id, i2f.value, f.id from features as f, item2feature as i2f,
items as i where i.scat_id = '244d713abba5f2ffb8d0ba8c858111ef' and i.id =
i2f.item_id and f.id =
40 matches
Mail list logo