Hello,
I was wondering if I could save the result of a query in a pdf document. I
looked for any functions that might help, but I got confused because I
could not see how/where exactly to insert the necessary .dll's. I'd like
to do this (saving the output of a query) by using mysql installed on a
On Thursday 24 January 2002 12:34, [EMAIL PROTECTED] wrote:
> Hello,
>
> I'm storing image URLs in a varchar text field for items in my database.
> The problem is not all the items in the database have images, so when i do
> a query that displays multiple results some have images and some have the
Hello,
I'm storing image URLs in a varchar text field for items in my database. The
problem is not all the items in the database have images, so when i do a
query that displays multiple results some have images and some have the
nasty red Xs. Is there a way do some kind of IF statement. If the im
Zach wrote:
"I do generally find that the more brief I am in
describing an issue, themore likely I am to get a reply. Then details
can be given if needed, infurther correspondences."
I would like to disagree with this. I am only a newbie to php an
There are many columns of data in the table. The only column that I would
like to extract a value from is the password field (this is the key as
well). I do not have an AUTO_INCREMENT field. Although, I see how adding
that field could be of use by using it with the SELECT MAX() as you
mentioned.
>From the php manual:
int similar_text (string first, string second [, double percent])
This calculates the similarity between two strings as described in Oliver [1993]. Note
that this implementation does not use a stack as in Oliver's pseudo code...
where can i find the algorithm or pseudo
By "last record", do you mean the last was inserted into the database? If
so, look to MYSQL's auto_increment and last_insert_id().
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 23, 2002 2:08 PM
> To: Zach Curtis
> Cc: [EMAIL PROTECTED]
> Subje
Zach,
We're going back and forth on this and getting no where...
So far all you have informed us is that the table has one column, which contains a
bunch of passwords (I also
suggest that this is not really the case and there'll at least be some sort of userId
field - but you haven't
bothered t
Excellent. That is more efficient (one select statement) than what I was
trying to do.
Zach
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 2:20 PM
To: Zach Curtis; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of Records in Table
Selec
The key field is the password field, which is also the field that I would
like to retrieve for that last record.
Zach
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 2:08 PM
To: Zach Curtis
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of Re
Just got back from Newmarket. Yes they had 1 copy of the book and got
her to put it aside for me. Now it's down to some hard reading in my spare
time or even take it to work.
Thanks
---Original Message---
From: DL Neil
Hi,
I'm new to this group but so far it sounds good. I was just wondering if
there are chapters perhaps in Dallas to get together with other developers
and talk PHP?
Aamina
_
Do You Yahoo!?
Get your free @yahoo.com address at http://m
Select your password field, and whatever other fields you need
Use
-mysql_num_rows() to capture the number of rows returned
-mysql_data_seek() to position pointer on last row (remember indexing
starts at 0)
-mysql_fetch_row() or mysql_fetch_array(), your choice, to return the data.
O
SELECT * FROM mytable ORDER BY fielda DESC LIMIT 1;
- Original Message -
From: "Zach Curtis" <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>
Sent: 23 January 2002 20:49
Subject: RE: [PHP-DB] # of Records in Table
> The last record should be whatever the last record is in the tabl
Hello,
"Tomas V.V.Cox" wrote:
>
> El mar, 22-01-2002 a las 19:02, Manuel Lemos escribió:
> > Hello Lukas,
> >
> > Lukas Smith wrote:
> >
> > > FYI: there has been a lot of discussion about this project in the last
> > > couple months (especially december irrc) on the pear-dev mailinglist. So
> >
I believe these additional functions are only available in the CVS version
of PHP not the version you can download from the web site.
But I could be wrong (someone correct me!)
Oliver Cronk
-Original Message-
From: Duarte Costa [mailto:[EMAIL PROTECTED]]
Sent: 23 January 2002 15:35
To:
Zach,
How can this "last record" be identified? Is there a key field or something similar?
Again: We might need to see the table definition to answer this.
Please advise,
=dn
- Original Message -
From: "Zach Curtis" <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>
Sent: 23 Janu
AHAHAHHAHA
AHHAHAHAH
Dan
On Wednesday, January 23, 2002, at 02:19 PM,
[EMAIL PROTECTED] wrote:
> Dan,
>
>> Good, I'm glad it worked!!!
>>
>> I see a lot of people using mysql_fetch_array().
>>
>> Which is fine...But I'm more into Object Oriented programming...and
>> that's why I always
The last record should be whatever the last record is in the table. For
example, if there are 1000 records in the table which COUNT(*) will tell me,
how can I get the password for record 1000. The only thing I can do that
would probably work is two query statements, one selecting COUNT(*) and the
It does not. However, I could easily add this in if you have a suggestion
that would work. Ideally, I thought their would be a way to do this
operation in one select statement. Any thoughts?
Zach
-Original Message-
From: Jim Lucas [php] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Janua
and as they say "if we haven't got it in stock, we'll get it in for you..."
At Newmarket one of the staff is reasonably 'up' on computer books - the others tend
to take deep breaths and roll their eyes. Just in case, the ISBN is 0-672-31784-2 (but
that may have changed if a new edition has been
Dan,
> Good, I'm glad it worked!!!
>
> I see a lot of people using mysql_fetch_array().
>
> Which is fine...But I'm more into Object Oriented programming...and
> that's why I always use mysql_fetch_object()
hey this is a family show - but I guess 'what you do in the privacy of' ...
does the table have an autoincrement column?
Jim Lucas
- Original Message -
From: "Zach Curtis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 23, 2002 10:27 AM
Subject: [PHP-DB] # of Records in Table
> What syntax can I use to determine how many records are in a M
Zach,
> What syntax can I use to determine how many records are in a MySQL table and
> then retrieve the value of the field "password" for the last record? I tried
> using some combinations of COUNT(*) and LIMIT with no success.
SELECT COUNT(*) will answer the first part. What did you try that
i've just found that php 4.1.1 on my linux box is having issues with defines
and mysql:
i have two defines,
define("DB", mysql_connect($host,$user,$pass));
define("DB2", mysql_connect($host2,$user2,$pass2));
what i'm finding is that when i open the second connection with a define my
page takes f
Good, I'm glad it worked!!!
I see a lot of people using mysql_fetch_array().
Which is fine...But I'm more into Object Oriented programming...and
that's why I always use mysql_fetch_object()
Good luck!!!
Dan
On Wednesday, January 23, 2002, at 11:45 AM, [EMAIL PROTECTED] wrote:
> My
26 matches
Mail list logo