On Sun, 30 Jun 2002 20:21:18 -0400
Chris Payne "Chris Payne" <[EMAIL PROTECTED]> wrote:
> Hi there everyone,
>
> I have my id field auto incrementing (Of course) and I have a
> utility
> that allows me to remove items from it, the problem is when I
> remove
> something the items after it keep t
You should not rely on the autonumber as a sorting method. You should use it
as a reference. I see you have two easy options (there may be more, but this
seems suitable).
1. Get the SQL to pull a random record (requires mySQL 3.23.x or higher)
SELECT * FROM tblName ORDER BY RAND() LIM
That's the way auto_increment works. You'll have to make the field
an int (no auto_increment) and supply a record id yourself on insert.
On Mon, 01 Jul 2002 08:21:18 +1200, Chris Payne wrote:
> Hi there everyone,
>
> I have my id field auto incrementing (Of course) and I have a utility
> that
make sure there are no "#" chars in there, unless you have commented lines
out (as below)
# commented line
in phpMyAdmin that is a comment, and the way it reads, if there's a # on a
line, it comments from there onwards (from memory)
HTH
Beau
// -Original Message-
// From: Chase [mailt
Hi there everyone,
I have my id field auto incrementing (Of course) and I have a utility
that allows me to remove items from it, the problem is when I remove
something the items after it keep their IDÂ’s leaving a gap in the ID.
For example, say I have 1-10 in the ID field and I remove number 8,
On 30-Jun-02 Peter J. Schoenster wrote:
> On 30 Jun 2002 at 11:24, Lisi wrote:
>
>> 1) Storing the passwords using some form of encryption, ...
>
>> This seems to me to be preferable,
It is nothing that you can suggest or prefer. In this word it sounds
I can do if I want. You have to / you mu
I want to be able to update a file on my server (which can be accessed
through FTP). My question is how do I go about accessing it? Do I have to
use the ftp_connect(); functions or can I just go about with something like
this:
---
// This doesn't w
On 30 Jun 2002 at 11:24, Lisi wrote:
> 1) Storing the passwords using some form of encryption, which can be
> reversed and the password can be emailed to the user.
> This seems to me to be preferable, since they don't have to change
> their password whenever they forget it. However, are there se
On Sunday 30 June 2002 03:15, CrossWalkCentral wrote:
> Using PHP
>
> I need some help running and AVG qery
>
> the syntax is as follows
>
> $results=sql_query("Select AVG(rate) from MYTABLENAME where id=$id",$dbi)
>
> This works but I am not sure how to get is value into a variable.
Assuming you
On Sunday 30 June 2002 09:06, CrossWalkCentral wrote:
As this has nothing to do with DBs it should be posted to the php-general
list.
> When using this fucntion listed bellow with the HTML headder
What function? And what HTML header?
> the email sent does not show the FROM in the FORM filed i
Hi
Retrieving lost passwords is a lot less hassle than a setting up a new one,
for the user. IMHO a job site would be better with more convenience and less
security.
So I would go for option 1 - encrypt / decrypt
If you were storing very sensitive information then go for option 2.
Peter
I know there's been discussion on the list before on this topic, but I'm a
little fuzzy on the details.
I want to create a site where users can create an account online, and then
log in to search job postings. I want to store their user info and
password in a database. I need a way for them t
12 matches
Mail list logo
