It would appear that I should check if anyone else has answered a question
first! And get some more sleep!
Sorry!
Ollie
-Original Message-
From: olinux [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2002 20:05
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] arrays and email
The other thing y
Something I have created for a project recently (note that I use my own db
wrapper functions - just substitute the dbconn(), dbquery(), dbnumrows() and
dbresult() for your database functions - e.g. mysql_connect() for mysql,
ms_sql_connect() - look them up in the PHP manual however as I am not sur
BJ,
A simple "while" command should do it. Try something
like this:
print("\n");
$qry = "SELECT artist_id, artist FROM $db";
$res = mysql_query($qry) or die(mysql_error());
while($data = mysql_fetch_array($res))
{
print("$data[1]\n");
}
print("");
That should do the trick for ya!
Best,
John
I have two fields artist_id, artist. How do I put the contents of "artist" into a
dropdown list.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PR
Well i hope someone will be able to give me a solution...
Here s my problem:
I'm working with a hudge mysql table (about 15 columns and 100 rows...)
in fact i ve got to count the number of couples `ncompte`/`naffaire` in the
table and finaly calculate the number of couples that appear once,
On Wednesday 30 January 2002 09:48, [EMAIL PROTECTED] wrote:
> Hello,
> I have this query:
> if ($cat){
> $result = mysql_query("SELECT * FROM table WHERE $cat=1",$db);
> if ($myrow = mysql_fetch_array($result)); {
> do {
> I use a link on the menu to call th
Hi. Have a question:
I've tried using the odbc_columns() function to get a list of columns in an
access database connected via an ODBC System DSN.. However, I haven't had
much luck in trying to use it. The manual page doesn't really cover much
about it, and I noticed a few comments posted there
Hi everyone:
is it possible to use one connect to access two database in postgreq,
because i would like to use subquery to do same search. on the fly in
postgreq must faster a lot than evaluate in php code...
A, B belong to different database...
sql : select * from A in ( select * B)
Vincen
On Thu, 31 Jan 2002, DL Neil wrote:
> Garry,
> I regret to say that I can't see an immediate answer.
>
> > CREATE TABLE breeding (
> > rec SMALLINT(4) UNSIGNED AUTO_INCREMENT,
> > sire SMALLINT(4) UNSIGNED,
> > dam SMALLINT(4) UNSIGNED,
> > paired DATE,
> > split DATE,
> > num_offspr
Garry,
Could you please explain (define) in one sentence(paragraph) what end
result you want. It might be possible to handle it in one SQL statement.
Miles Thompson
At 09:54 AM 1/30/2002 +1100, Garry Optland wrote:
>On Wed, 30 Jan 2002, DL Neil wrote:
>
> >
> > Can I request some db-speak plea
Garry,
I regret to say that I can't see an immediate answer.
> CREATE TABLE breeding (
> rec SMALLINT(4) UNSIGNED AUTO_INCREMENT,
> sire SMALLINT(4) UNSIGNED,
> dam SMALLINT(4) UNSIGNED,
> paired DATE,
> split DATE,
> num_offspring TINYINT(1) ZEROFILL,
> PRIMARY KEY (rec)
> );
>
> >
Hello,
I have this query:
if ($cat){
$result = mysql_query("SELECT * FROM table WHERE $cat=1",$db);
if ($myrow = mysql_fetch_array($result)); {
do {
I use a link on the menu to call this query()
This returns a large result set that I would like to span accros
On Wed, 30 Jan 2002, DL Neil wrote:
>
> Can I request some db-speak please? You already have a tbl (or more).
> So let's start by asking for the table definitions
The table definition is as follows:
CREATE TABLE breeding (
rec SMALLINT(4) UNSIGNED AUTO_INCREMENT,
sire SMALLINT(4) UNSIGNED,
I'm trying to use Berkeley DB db2 files with PHP persistent connection dba_popen. When
I try persistent connections with dba_open then sometimes I don't get reads working &
I never get insert/replace working. Without persistent connections reading & writing
work fine.
Has anyone else gotten p
i did something like that once. I passed the session variables using an encrypted
query string ( could be using a hidden input, anyway i think it is a good idea to
encrypt the value).
I didnt like it because of the unnecesary use of a second server, but i'm sure
sometimes you just have to go
The other thing you could do is populate a string of
emails and add the BCC header to your mail() function.
This way everyone's email will not be seen by all
other recipients.
Check out the docs at www.php.net for this one
a better way to build the string would probably be:
while ($row = mysql_
Hi kevin,
Seems like in your while loop, you are not populating your list array
correctly with all the emails you have.
Try to have a count value and populate the array list accordingly such as:
$count = 0;
while ($row = mysql_fetch_row($result))
{
$real_name = $row[1];
$
Hi Hayan
Thechnically yes - for instance you could send it as a form hidden input.
But I wonder whether there is sense in it.
regards
Ivo
"Hayan Al Mamoun" <[EMAIL PROTECTED]> wrote in message
000401c1a8a9$838d4ee0$5e00a8c0@cybernation">news:000401c1a8a9$838d4ee0$5e00a8c0@cybernation...
> Dear
I'm working on an application that will allow someone to view all attendees
for a specific webinar that my company is hosting. I want to allow the user
to send one group email to all participants scheduled for that particular
webinar.
After I connect to my database my code looks like this:
\n";
Problem: hosts "http://www."; and "https://secure."; of the same domain need
to work with the same browser session_id. This is a
login/authenticate/redirect scenario. In this case the session data store
is a common MySQL database, so the issues of /tmp sharing, NFS, etc. are set
aside. My
The traditional Data Warehouse way to solve this is to have a second table
of dates. The table might look like:
DateTable
---
dayID int,
myDate datetime
And you add all the particular columns that you might ever want to search
on, like:
month int,
year int,
da
On Tuesday 29 January 2002 21:15, Markus Lervik wrote:
> On Monday 28 January 2002 18:42, Jason Wong wrote:
> > > $page behaves just fine :
> >
> > [snip]
> >
> > > page: 2 <- yup, it's incrementing, all right...
> > > nr_pages: 230
> > >
> > > Whack! Doesn't work any more... It's starting to dri
On Monday 28 January 2002 18:42, Jason Wong wrote:
> > $page behaves just fine :
> [snip]
> > page: 2 <- yup, it's incrementing, all right...
> > nr_pages: 230
> > Whack! Doesn't work any more... It's starting to drive me mad.
> Me too. Post the full code so we can all revel in this madness!
Dear all, I was wondering, can session variables be transfered across
multiple hosts, i.e. if I send a request from http://host1/page1.phtml, to
http://host2/page1.phtml where I started the session by SessionRegister() or
some other way and I gave the variable VAR1 some value, then I went back
wit
hi, I have a RedHat distribution installed with mysql. Now I would like also
to connect to my AS400 with database DB2, via ODBC unificated functions...
but these functions are not defined, probably because the PHP installed was
not compiled for DB2 support.
Does anyone know how to recompile PHP fo
Janet,
MySQL (and indeed all multi-user databases) has a feature called "Locking". What this
means is that whilst many
users/clients may access a database, apparently simultaneously, when one (or more) is
updating the data in some
way, everyone else is kept locked-out for the duration. Hopefull
Wow Garry,
I know that I like to kick-start my brain by getting 'into' a list problem/challenge
in the (London) mornings,
but today I'm completely beaten. Thanks for the broad explanation, which is probably
quite meaningful, but I'm
not into breeding (could that statement be misunderstood?) and
On Monday 28 January 2002 18:42, Jason Wong wrote:
> > $page behaves just fine :
> > page: 2 <- yup, it's incrementing, all right...
> > nr_pages: 230
> > Whack! Doesn't work any more... It's starting to drive me mad.
> Me too. Post the full code so we can all revel in this madness!
All righ
28 matches
Mail list logo
