I would try replacing:
echoi by ; echo ($albumby[xoops_artist.artist]); echoibr;
with this:
echoi by ; echo $albumby[artist]; echoibr;
or even better this(notice the dots instead of different echos and the
single qoutes):
echo'i by '.$albumby[artist].'ibr';
I would say that you have a
thx.
Dan Koken [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Jj Harrison wrote:
I know how to delete stuff from a db.
Now I want to delete all the earliest entires from the database except
the
latest 75 entries.
Is it easy or hard?
I would say
Hi!
I´ve got a simple question:
I´m running PostgreSQL on SPARC-Solaris 8. Now I want to use PHP4 with this
database, e.g. a kind webinterface that reads data from the database.
But PHP can´t connect to PostgreSQL. I know now that I compiled PHP wrong.
But what are the exact compiling options
How, using the group by and where statments can I return the percentage of
something?
ie:
pid| oid| uid |
1 |2 |1
1 |2 |1
1 |2 |1
1 |1 |1
would return
oid | percent
2| 75
1| 25
Thx,
--
JJ Harrison
[EMAIL PROTECTED]
Plz ignore this. found it after more searching...
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
Jj Harrison [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
How, using the group by and where statments can I return the percentage of
something?
ie:
pid|
Hi JJ. I know we all should do what you did, but I've seen this kind of
mails quite a lot lately in these lists. I'm sure that many of you, like
me, keep these mails for further reading and reference... it would be
nice if you also state what was the answer to your original question. I
mean, if
I am populating a dropdown list from a database. This is working
fine with one minor glitch... For some reason, the first entry in the
database does not seem to be getting populated into the list. I do not see
anything wrong, and was hoping that someone else might be able to spot a
I am populating a dropdown list from a database. This is working
fine with one minor glitch... For some reason, the first entry in the
database does not seem to be getting populated into the list. I do not see
anything wrong, and was hoping that someone else might be able to spot a
Thanks for the answers. This has resolved my problem.
-Original Message-
From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 11:21 AM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Dropdown list question...
- Original
I'm using mysql_fetch_array (with mysql_query) to retrieve data and very
simply display it in an HTML table, which has been working fine up until I
started fetching data from a TEXT column that has greater than 255
characters in it. I can see in my database that all the data is there, but
On Tuesday 30 July 2002 02:41, Steve Bradwell wrote:
Sorry to repost but I typed in the wrong sql statement in my previous post.
For some reason the below statement is not working. Can anyone tell me why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE
now() AND
Ya I checked and the manual said that with a version 3.23 or higher you can
use + and - signs instead of the date_add subtract. Either way it just
returns null.
Ever tried somthing like this?
Thanks,
Steve.
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Monday,
Once again...
ALTER TABLE table1 AUTO_INCREMENT = 500
Dan
On Monday, July 29, 2002, at 10:44 PM, [EMAIL PROTECTED] wrote:
rite,
my primary key column (id) is set to auto_increment as usual which is
very
handy. But when I delete a row, the auto_increment just keeps
incrementing
why, is this question asked a lot??? anywa, thanks, i was gonna try
something like that from something i read in the mysql manual, but it only
mentioned it passing and didnt give an example or anything.
tanx
Daniel Brunner [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
Yeah, it's asked a lot!!
And I've always answered that question( it's not the only question I
answer!!! )
But Good Luck!! And your welcome!!!
Dan
On Monday, July 29, 2002, at 10:51 PM, [EMAIL PROTECTED] wrote:
why, is this question asked a lot??? anywa, thanks, i was gonna try
Op dinsdag 30 juli 2002 05:44, schreef Georgie Casey:
So I've 2 questions
INSERT TABLE id values('');
leave it empty
1) Can the next auto_increment value be 'set' by a SQL query
2) Can I get a SQL query to INSERT INTO the first 'hole' it finds in the ID
column??
I don't think so. You can
On Mon, 29 Jul 2002 20:44:54 -0700
Georgie Casey Georgie Casey [EMAIL PROTECTED] wrote:
rite,
my primary key column (id) is set to auto_increment as usual
which is very
handy. But when I delete a row, the auto_increment just keeps
incrementing
and there's this 'hole' left where I deleted
I would like to have the same page (test.php) have different text in it
depending on a database entry.
which is easy enough. but I want it to be on the fly. example list would be
created on the fly depending on databse entries.
which ever entry was picked (lets say STLT) it would open up my
Firstly, don't cross post unless the question *really* has to do with both (in this
case, it should be just db).
Secondly, your id field should only be used as a reference to a row (not showing order
of record). Auto increments are exactly that, the rdbms will take care of creating the
rite,
my primary key column (id) is set to auto_increment as usual which is very
handy. But when I delete a row, the auto_increment just keeps incrementing
and there's this 'hole' left where I deleted the row!
Apart from this looking ugly, it poses another problem. In my PHP script
where I can
i assume this is a simple question...
how can I SELECT * FROM 2 different tables in the same query, ORDER BYing
the 'hits' column, which both tables have.
eg, 2 tables i have are similiar and i want to merge them and then select
everything ordering by hits
--
PHP Database Mailing List
See if your database supports the UNION clause...
On Mon, 29 Jul 2002, Georgie Casey wrote:
i assume this is a simple question...
how can I SELECT * FROM 2 different tables in the same query, ORDER BYing
the 'hits' column, which both tables have.
eg, 2 tables i have are similiar and i
Hi.
On Mon 2002-07-29 at 14:41:30 -0400, [EMAIL PROTECTED] wrote:
Sorry to repost but I typed in the wrong sql statement in my previous post.
Ah. Okay.
For some reason the below statement is not working. Can anyone tell me why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10
I'm writing a web application in PHP to do referee scheduling for soccer
games. For each game (a single row in a table) I have a cell for
referee. The cell stores an integer that I can do a join on with another
table of people. I need a way to prevent people from being able to
schedule themselves
Steve,
For some reason the below statement is not working. Can anyone tell me
why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE
now()
AND ORDER_NO = '5' AND EDIT_LOCK 0;
-EDIT_LOCK is a MySQL (ver 3.23.49-max) time field, allows nulls, default
is
NULL.
If this
Jefferson,
I'm writing a web application in PHP to do referee scheduling for soccer
games. For each game (a single row in a table) I have a cell for
referee. The cell stores an integer that I can do a join on with another
table of people. I need a way to prevent people from being able to
Thank you that did exactly what I was looking for.
Thanks
Jefferson Cowart
[EMAIL PROTECTED]
Support Open Instant Messaging Protocols
http://www.petitiononline.com/openIM/petition.html
-Original Message-
From: Ryan Fox [mailto:[EMAIL PROTECTED]]
Sent: Monday, July
Sorry to repost but I typed in the wrong sql statement in my previous post.
For some reason the below statement is not working. Can anyone tell me why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE now()
AND ORDER_NO = '5' AND EDIT_LOCK 0;
-EDIT_LOCK is a MySQL (ver
28 matches
Mail list logo