I would try replacing:
echo" by "; echo ($albumby[xoops_artist.artist]); echo"";
with this:
echo" by "; echo $albumby[artist]; echo"";
or even better this(notice the dots instead of different echos and the
single qoutes):
echo' by '.$albumby[artist].'';
I would say that you have a coloumn cal
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
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 I
Hello, Jan.
You wrote 29 èþëÿ 2002 ã., 11:56:50:
"./configure --with-pgsql"
JF> But what are the exact compiling options I have to use?
Read for details:
http://www.php.net/manual/en/ref.pgsql.php
www.pskov.ruwebmaster|programmer|DBA
www.invest.pskov.ru
www.education.pskov
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]
www.tececo.co
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:
>
>
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 yo
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
prob
- Original Message -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 29, 2002 7:12 PM
Subject: [PHP-DB] Dropdown list question...
> I am populating a dropdown list from a database. This is working
> fine with one minor glitch... For some r
> 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 Message
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
mysql_fe
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, Jul
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
> increment
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 PRO
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
> som
but you said this problem was the holes, what happnes when you fill an
auto_incement number in a 'hole' then the next number exists... does it
skip the next number(501) because it exists or does it give an error saying
duplicate entry for primary key???
It just seems to make sense to me that you'
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
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 whe
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 templa
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
increme
Any ideas how to generate a unique serial number that you can check that
it's valid..
Thanks...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 (http:
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 am not sure what exactly you mean. If you are talking about a regular
query then:
SELECT tblTable1.hits, tblTable2.hits FROM tblTable1, tblTable2 ORDER BY
tblTable1.hits;
If you are talking about combining the two tables so that all your 'hits'
are in one column then there are a few
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
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.
>
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, Ju
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 3
33 matches
Mail list logo
