chris said:
Just out of interest, could you re-run the test using persistent connections?
change mysql_connect to mysql_pconnect..
In doing so, the overall results dropped from a tenth of a second
difference between both methods to three-one-hundredths of a second
difference. In other words
On 4/3/06, tedd <[EMAIL PROTECTED]> wrote:
> chris said:
>
> >Time. Opening a db connection is time consuming. There are many levels
> >involved (making the connection, authentication, etc).. Even worse if
> >the connection is over tcp/ip because that overhead comes in on top as
> >well.
>
> I repl
chris said:
Time. Opening a db connection is time consuming. There are many levels
involved (making the connection, authentication, etc).. Even worse if
the connection is over tcp/ip because that overhead comes in on top as
well.
I replied:
Have you timed it?
Maybe I'll do that tomorrow.
John Nichel wrote:
Jasper Bryant-Greene wrote:
I never close connections; PHP does that for me and has never caused
any problems doing that. I don't see it as sloppy programming, it is a
documented feature that PHP closes resources such as database
connections at the end of the script.
It
Jasper Bryant-Greene wrote:
I never close connections; PHP does that for me and has never caused any
problems doing that. I don't see it as sloppy programming, it is a
documented feature that PHP closes resources such as database
connections at the end of the script.
It's extremely sloppy
On Sat, 2006-04-01 at 21:57, Jasper Bryant-Greene wrote:
> Robert Cummings wrote:
>
> >> Of course, it wouldn't exactly be a rewrite to make it close the
> >> connection at the end of every script before PHP did, if I'm proven
> >> wrong and it one day is necessary. I'd only need to change the da
Robert Cummings wrote:
On Sat, 2006-04-01 at 21:39, Jasper Bryant-Greene wrote:
Robert Cummings wrote:
There's smart lazy programming, and sloppy lazy programming. I don't
trust anything magical in PHP. Most of us are familiar with the magic
quotes and global vars fiascos *LOL*. But hey, if yo
On Sat, 2006-04-01 at 21:39, Jasper Bryant-Greene wrote:
> Robert Cummings wrote:
>
> > There's smart lazy programming, and sloppy lazy programming. I don't
> > trust anything magical in PHP. Most of us are familiar with the magic
> > quotes and global vars fiascos *LOL*. But hey, if you can squeez
Robert Cummings wrote:
On Sat, 2006-04-01 at 20:48, Jasper Bryant-Greene wrote:
Yeah, e.g. I have a database objects layer that means I only write SQL
in classes, everything else is just calling object methods. I create the
database object at the start of every script but that doesn't
necessar
On Sat, 2006-04-01 at 20:48, Jasper Bryant-Greene wrote:
>
> Yeah, e.g. I have a database objects layer that means I only write SQL
> in classes, everything else is just calling object methods. I create the
> database object at the start of every script but that doesn't
> necessarily open the da
Robert Cummings wrote:
On Sat, 2006-04-01 at 20:15, tedd wrote:
It would be interesting to actually run a script that opens,
retrieves, and inserts data -- let's say 50k times. What's the time
difference between one open, 50k retrieves/inserts, and one close--
as compared 50k opens retrieve/in
On Sat, 2006-04-01 at 20:15, tedd wrote:
> >Time. Opening a db connection is time consuming. There are many levels
> >involved (making the connection, authentication, etc).. Even worse if
> >the connection is over tcp/ip because that overhead comes in on top as
> >well.
>
> Have you timed it?
>
>
Time. Opening a db connection is time consuming. There are many levels
involved (making the connection, authentication, etc).. Even worse if
the connection is over tcp/ip because that overhead comes in on top as
well.
Have you timed it?
It would be interesting to actually run a script that open
At 11:07 AM +1200 4/2/06, Jasper Bryant-Greene wrote:
tedd wrote:
> > > I always close the connection right after my
> > query -- force of habit. It's like leaving the
> > toilet seat up, it's only going to get you into
> > trouble.
>
> So you close it after every query and then re-open i
On 4/2/06, tedd <[EMAIL PROTECTED]> wrote:
> > > > > I always close the connection right after my
> >> > > query -- force of habit. It's like leaving the
> >> > > toilet seat up, it's only going to get you into
> >> > > trouble.
> >> >
> >> > So you close it after every query and then re-open
tedd wrote:
> > > I always close the connection right after my
> > query -- force of habit. It's like leaving the
> > toilet seat up, it's only going to get you into
> > trouble.
>
> So you close it after every query and then re-open it later for the
> next query? I don't see that as a go
> > > I always close the connection right after my
> > query -- force of habit. It's like leaving the
> > toilet seat up, it's only going to get you into
> > trouble.
>
> So you close it after every query and then re-open it later for the
> next query? I don't see that as a good idea.
>
On 4/1/06, Anthony Ettinger <[EMAIL PROTECTED]> wrote:
> On 3/31/06, chris smith <[EMAIL PROTECTED]> wrote:
> > On 4/1/06, tedd <[EMAIL PROTECTED]> wrote:
> > > At 10:30 PM +0200 3/31/06, Martin Zvarík wrote:
> > > >Hi,
> > > >I was wondering why is it necessary to use
> > > >mysql_close() at t
On 3/31/06, chris smith <[EMAIL PROTECTED]> wrote:
> On 4/1/06, tedd <[EMAIL PROTECTED]> wrote:
> > At 10:30 PM +0200 3/31/06, Martin Zvarík wrote:
> > >Hi,
> > >I was wondering why is it necessary to use
> > >mysql_close() at the end of your script.
> > >If you don't do it, it works anyways, d
On 4/1/06, tedd <[EMAIL PROTECTED]> wrote:
> At 10:30 PM +0200 3/31/06, Martin Zvarík wrote:
> >Hi,
> >I was wondering why is it necessary to use
> >mysql_close() at the end of your script.
> >If you don't do it, it works anyways, doesn't it?
> >
> >MZ
>
> MZ:
>
> I always close the connection
At 10:30 PM +0200 3/31/06, Martin Zvarík wrote:
Hi,
I was wondering why is it necessary to use
mysql_close() at the end of your script.
If you don't do it, it works anyways, doesn't it?
MZ
MZ:
I always close the connection right after my
query -- force of habit. It's like leaving the
t
On 3/31/06, Martin Zvarík <[EMAIL PROTECTED]> wrote:
> Richard Lynch wrote:
>
> >On Fri, March 31, 2006 2:30 pm, Martin Zvarík wrote:
> >
> >
> >>I was wondering why is it necessary to use mysql_close() at the
> >>end
> >>of your script.
> >>If you don't do it, it works anyways, doesn't it?
> >
Richard Lynch wrote:
On Fri, March 31, 2006 2:30 pm, Martin Zvarík wrote:
I was wondering why is it necessary to use mysql_close() at the
end
of your script.
If you don't do it, it works anyways, doesn't it?
Yes, but...
Suppose you write a script to read data from one MySQL server
On Fri, March 31, 2006 2:30 pm, Martin Zvarík wrote:
> I was wondering why is it necessary to use mysql_close() at the
> end
> of your script.
> If you don't do it, it works anyways, doesn't it?
Yes, but...
Suppose you write a script to read data from one MySQL server, and
then insert it into
Hi,
I was wondering why is it necessary to use mysql_close() at the end
of your script.
If you don't do it, it works anyways, doesn't it?
MZ
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
PHP Mailer wrote:
Mark skrev:
[snip]
$query = "INSERT INTO users AVATARS WHERE id =$user_id '','$avname')";
mysql_query($query);s
[snip]
I am trying to insert the value of $avname into the users table, into
the avatar field.
I think what you are trying to do is coordinated a bit wrong, perh
ALUES ('$avname')WHERE id ='$user_id')";
As Nicolas said, it is important that you understand your abilities to
debug these queries by outputting them through simple commands such as
echo or even the php-mysql function mysql_error(); give these a try
Let us know how it work
On 3/27/06, Mark <[EMAIL PROTECTED]> wrote:
> I havnt even tried this query but i know its wrong can anyone help!
>
>
> ***
> include("header.php");
> include("connect.php");
>
> $comp_id = $_SESSION['comp_id'];
> $user_id = $_SESSION['user_id'];
>
> // Grab var
Mark a écrit :
I havnt even tried this query but i know its wrong can anyone help!
***
don't you need a session_start() somewhere ?
(or it's in the header.php or connect.php perhaps ?)
$comp_id = $_SESSION['comp_id'];
$user_id = $_SESSION['user_id'];
//
I havnt even tried this query but i know its wrong can anyone help!
***
**
I am trying to insert the value of $avname into the users table, into the
avatar field.
--
PHP General Mailing List (http://www.php.net/)
To unsu
Jason Gerfen wrote:
> I know this might be slightly off topic but I just upgraded
> PHP/MySQL/OpenSSL and Apache to the latest stable release for each
> project and so far so good. The one problem I am encountering is
> dealing with SSL and apachectl not accepting the comman
On Friday 24 March 2006 17:24, Jason Gerfen wrote:
> I know this might be slightly off topic but I just upgraded
> PHP/MySQL/OpenSSL and Apache to the latest stable release for each
> project and so far so good. The one problem I am encountering is
> dealing with SSL and apachectl n
I know this might be slightly off topic but I just upgraded
PHP/MySQL/OpenSSL and Apache to the latest stable release for each
project and so far so good. The one problem I am encountering is
dealing with SSL and apachectl not accepting the command 'apachectl
startssl' as it is d
The connection is successful but the data are not getting inserted into the
table. I need to insert all the words into the table.
When I change the insert statement with one insert at a time, I can insert
values to the database. For exampel:
$qure = "INSERT INTO dict VALUES (1,'apple')";
Do
I have given a task to create a site which is a clone of www.onelook.com.
As a first stage I have downloaded a list of English words (only words not
meaning)
in a text format. I have created a data structure in the mysql database. And
wrote the
following code to insert data into the table at
It gives you any error?
sathyashrayan wrote:
> I have given a task to create a site which is a clone of
> www.onelook.com.
> As a first stage I have downloaded a list of English words (only words not
> meaning) in a text format. I have created a data structure in the mysql
> database. And wro
- Original Message -
From: "Dan Parry" <[EMAIL PROTECTED]>
To: "'sathyashrayan'" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 21, 2006 6:19 PM
Subject: RE: [PHP] Inserting data at runtime (php,mysql)
conn denotes a constant where the value yo
P] Inserting data at runtime (php,mysql)
- Original Message -
From: "Dan Parry" <[EMAIL PROTECTED]>
To: "'sathyashrayan'" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 21, 2006 6:12 PM
Subject: RE: [PHP] Inserting data at runtime (php,mysql)
>
On 21/03/06, sathyashrayan <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Dan Parry" <[EMAIL PROTECTED]>
> To: "'sathyashrayan'" <[EMAIL PROTECTED]>;
> Sent: Tuesday, March 21, 2006 6:12 PM
> Subject: RE: [P
- Original Message -
From: "João Cândido de Souza Neto" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 21, 2006 5:54 PM
Subject: [PHP] Re: Inserting data at runtime (php,mysql)
It gives you any error?
No the data are not getting inserted.
--
PHP General Ma
Yes it is a error.Thanks.
- Original Message -
From: Dave Goodchild
To: sathyashrayan
Sent: Tuesday, March 21, 2006 6:16 PM
Subject: Re: [PHP] Inserting data at runtime (php,mysql)
Yes, but it should be $conn, not conn. There is no $ in front of the variable
name
- Original Message -
From: "Dan Parry" <[EMAIL PROTECTED]>
To: "'sathyashrayan'" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 21, 2006 6:12 PM
Subject: RE: [PHP] Inserting data at runtime (php,mysql)
[snip]
$conn=mysql_connect(&quo
- Original Message -
From: "Thorsten Suckow-Homberg" <[EMAIL PROTECTED]>
To: "sathyashrayan" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, March 21, 2006 6:00 PM
Subject: Re: [PHP] Inserting data at runtime (php,mysql)
The connection is successful but t
ua Webtech Ltd
http://www.virtuawebtech.co.uk
-Original Message-
From: sathyashrayan [mailto:[EMAIL PROTECTED]
Sent: 21 March 2006 12:20
To: php-general@lists.php.net
Subject: [PHP] Inserting data at runtime (php,mysql)
I have given a task to create a site which is a clone of www.onelook.com.
As a first stage
Yup. Thats the problem. I'm running 4.0.21. Thanks.
--
Kevin Murphy
Webmaster - Information and Marketing Services
Western Nevada Community College
www.wncc.edu
(775) 445-3326
On Mar 16, 2006, at 4:48 PM, Miles Thompson wrote:
At 08:41 PM 3/16/2006, Kevin Murphy wrote:
Anyone want to poi
Kevin Murphy wrote:
Anyone want to point me to why this isn't working:
$hr_query = "select dp_lname,dp_fname,dp_id
FROM dir_all
WHERE dp_id NOT IN (SELECT sup_id FROM dir_title2)
ORDER BY dp_lname";
There are two tables, dir_all (the main list of everyone) an
At 08:41 PM 3/16/2006, Kevin Murphy wrote:
Anyone want to point me to why this isn't working:
$hr_query = "select dp_lname,dp_fname,dp_id
FROM dir_all
WHERE dp_id NOT IN (SELECT sup_id FROM dir_title2)
ORDER BY dp_lname";
Anyone want to point me to why this isn't working:
$hr_query = "select dp_lname,dp_fname,dp_id
FROM dir_all
WHERE dp_id NOT IN (SELECT sup_id FROM dir_title2)
ORDER BY dp_lname";
There are two tables, dir_all (the main list
Hi gang:
Miles said:
Why are we still chasing this thread?
No need to pursue this thread anymore -- I'll just address the
statements put to me.
Why does he even have to see gaps? Just present the info, unless he
wants to see the ID.
Miles, I think that's the best solution I've heard t
Barry:
I realize that relational dB's are out if one does this -- and -- I
fully understand why.
That's the reason when I started this thread I made it clear that I was
NOT talking about a relational dB but rather a simple flat file.
What I find interesting in all of this exchange -- howe
At 08:57 AM 3/6/2006, tedd wrote:
What I find interesting in all of this exchange -- however -- is
that everyone agree's renumbering the "id" of a dB is something you
don't do, but no one can come up with a concrete (other than
relational) reason why.
It's simply -- concretely -- inefficient
On 3/6/06, Jim Moseby <[EMAIL PROTECTED]> wrote:
> >
> > What I find interesting in all of this exchange -- however -- is that
> > everyone agree's renumbering the "id" of a dB is something you don't
> > do, but no one can come up with a concrete (other than relational)
> > reason why.
>
>
>
> If y
At 10:56 AM 3/6/2006, tedd wrote:
As such, if you don't renumber, then the only thing left is to use a
timestamp, I guess.
[/snip]
No, if you have gaps you can still step through sequentially, like 14,
15, 18, 19, 20...
It's the gaps that are the problem.
I have no problem understanding why
>
> What I find interesting in all of this exchange -- however -- is that
> everyone agree's renumbering the "id" of a dB is something you don't
> do, but no one can come up with a concrete (other than relational)
> reason why.
If you don't care that a given record may have a different, unpr
On 3/6/06, Dusty Bin <[EMAIL PROTECTED]> wrote:
> Another point to consider, is that Tedds method of renumbering the rows,
> *may* not preserve the original sequence. I have not checked the mysql
> source, but if some delete activity has occurred in the table, then
> there will be holes in the dat
Another point to consider, is that Tedds method of renumbering the rows,
*may* not preserve the original sequence. I have not checked the mysql
source, but if some delete activity has occurred in the table, then
there will be holes in the data, in some circumstances, inserting
further records to t
tedd wrote:
Well it seems you output it via PHP so count it extern in PHP.
And changing ID values is a "no-go!"
You will never have any relation possibilities if you alter the ID
fields.
In short. You mess everthing up with it.
There are count functions in MySQL that gives you the counted row
[snip]
That's the reason when I started this thread I made it clear that I
was NOT talking about a relational dB but rather a simple flat file.
What I find interesting in all of this exchange -- however -- is that
everyone agree's renumbering the "id" of a dB is something you don't
do, but no o
Miles Thompson wrote:
I hope the following will be helpful, and it is a bit of a rant ..
thank god someone ranted on this already :-)
I wasn't feeling up to it but it's also one of those cases that you can't
help but speak out. ;-)
--
PHP General Mailing List (http://www.php.net/)
To unsubscr
Well it seems you output it via PHP so count it extern in PHP.
And changing ID values is a "no-go!"
You will never have any relation possibilities if you alter the ID fields.
In short. You mess everthing up with it.
There are count functions in MySQL that gives you the counted rows
or output it
tedd wrote:
As such, if you don't renumber, then the only thing left is to use a
timestamp, I guess.
[/snip]
No, if you have gaps you can still step through sequentially, like 14,
15, 18, 19, 20...
It's the gaps that are the problem.
I have no problem understanding why there are gaps in a dB
On Monday 06 March 2006 07:56, tedd wrote:
> So, I'm still trying to find a simple way around this problem. Either
> I renumber the "id" field OR provide an external counter to present
> to the user. I don't see any other solutions, does anyone?
>
> Thanks.
>
> tedd
I haven't followed this thread
As such, if you don't renumber, then the only thing left is to use a
timestamp, I guess.
[/snip]
No, if you have gaps you can still step through sequentially, like 14,
15, 18, 19, 20...
It's the gaps that are the problem.
I have no problem understanding why there are gaps in a dB and
dealing
[snip]
>You must have a column that is sequential in some way. An
>auto-incremented column, timestamp, or some other device that will
allow
>you to step through regardless of gaps in sequence. If you do not have
>such a column then you could add one.
You see, now that's the problem. If you have a
Gustav:
In any event, I just tested your claim on my host and I was able to
renumber 50,000 records in less than 1/2 second. Even though I
tried it several times, the results were never above 0.47 seconds.
If I was dealing with a database that was accessible to others,
then I would either loc
- Original Message -
From: "tedd" <[EMAIL PROTECTED]>
To:
Cc: "Gustav Wiberg" <[EMAIL PROTECTED]>; "Robert Cummings"
<[EMAIL PROTECTED]>
Sent: Sunday, March 05, 2006 12:58 AM
Subject: Re: [PHP] Mysql Rows
Hi:
Gustav said:
No, may
I'm thinking of getting an iBook for reasons not really to do with
webbing but really need to do occasional php/mysql stuff to
justify the expense. I believe that they all come with an Apache
testing server installed and wondered if anyone had any success
with getting php/mysql/phpMy
On Sun, Mar 05, 2006 at 08:01:07AM -0500, tedd wrote:
> R O B said:
>
> >That Rod guy, he's such a card! I'd add something, but Jay has already
> >covered my list in a more recent email than this one to which I'm
> >responding :)
>
> jblanchard (who I think is Rod) said:
>
> >A SQL question on a
[snip]
R O B said:
>That Rod guy, he's such a card! I'd add something, but Jay has already
>covered my list in a more recent email than this one to which I'm
>responding :)
jblanchard (who I think is Rod) said:
[/snip]
I am definitely not Rod.
[snip]
For sake of argument, let's agree that renum
On 3/6/06, tedd <[EMAIL PROTECTED]> wrote:
> R O B said:
>
> >That Rod guy, he's such a card! I'd add something, but Jay has already
> >covered my list in a more recent email than this one to which I'm
> >responding :)
>
> jblanchard (who I think is Rod) said:
>
> >A SQL question on a PHP mailing l
R O B said:
That Rod guy, he's such a card! I'd add something, but Jay has already
covered my list in a more recent email than this one to which I'm
responding :)
jblanchard (who I think is Rod) said:
A SQL question on a PHP mailing list usually gets more than ribbing. ;)
No harm done -- I
On 3/5/06, Paul Jinks <[EMAIL PROTECTED]> wrote:
> Hi everyone
>
> I'm thinking of getting an iBook for reasons not really to do with
> webbing but really need to do occasional php/mysql stuff to justify the
> expense. I believe that they all come with an Apache test
On Sat, 2006-03-04 at 18:58, tedd wrote:
> Hi:
>
> Rod said:
>
> >*LOL* I knew those MySQL people shouldn't have made the ALTER TABLE
> >syntax available to just anyone. Gun --> foot --> *BLAM*. I hope to God
> >you never get your hands on a real database with millions of entries.
>
> I'm glad th
[snip]
I'm glad that you were amused. Considering that I was talking about a
flat dB, then you have already shot yourself in the foot if your
"real database" is in the millions of entries and is flat. I hope to
God that normalization may be something you consider in your next
database design.
[
[snip]
my reasoning for needing the users number in a database is this...
i am going to be doing a lottery type thing where i grab a random number
between 1 and the result of mysql_num_rows($result)... that is the
reason
the gaps matter. the while loop didn't work for me so if anyone could
help
m
urray @ PlanetThoughtful"
> <[EMAIL PROTECTED]>; "Anthony Ettinger" <[EMAIL PROTECTED]>
> Sent: Saturday, March 04, 2006 2:29 PM
> Subject: Re: [PHP] Mysql Rows
>
>
> >
> > - Original Message -
> > From: "Robert Cummings"
Hi:
Gustav said:
No, maybe not when it's a small db, but when you try to delete
50.000 posts I have a strong feeling this would be very much slower
then if you don't alter table after each deletion.
First, I'm not deleting 50,000 records -- I dropping a table and
renumbering it.
In any ev
ttinger" <[EMAIL PROTECTED]>
Sent: Saturday, March 04, 2006 2:29 PM
Subject: Re: [PHP] Mysql Rows
>
> - Original Message -
> From: "Robert Cummings" <[EMAIL PROTECTED]>
> To: "tedd" <[EMAIL PROTECTED]>
> Cc: "PHP-General&quo
ttinger" <[EMAIL PROTECTED]>
Sent: Saturday, March 04, 2006 9:41 AM
Subject: Re: [PHP] Mysql Rows
> On Sat, 2006-03-04 at 09:14, tedd wrote:
> > planetthoughtful wrote:
> >
> > >But, too often I've seen people new to database design not liking
> &
Hi everyone
I'm thinking of getting an iBook for reasons not really to do with
webbing but really need to do occasional php/mysql stuff to justify the
expense. I believe that they all come with an Apache testing server
installed and wondered if anyone had any success with getting
php/
On Sat, 2006-03-04 at 09:14, tedd wrote:
> planetthoughtful wrote:
>
> >But, too often I've seen people new to database design not liking
> >'gaps' because 'user1' will have a unique id of '1', while 'user2'
> >will have a unique id of '6' because the records associated with
> >unique ids '2'
- Original Message -
From: "tedd" <[EMAIL PROTECTED]>
To:
Cc: "benifactor" <[EMAIL PROTECTED]>; "Murray @ PlanetThoughtful"
<[EMAIL PROTECTED]>; "Anthony Ettinger" <[EMAIL PROTECTED]>
Sent: Saturday, March 04, 2006
planetthoughtful wrote:
But, too often I've seen people new to database design not liking
'gaps' because 'user1' will have a unique id of '1', while 'user2'
will have a unique id of '6' because the records associated with
unique ids '2' through '5' were deleted during testing, and so on.
So,
I hope the following will be helpful, and it is a bit of a rant ..
The row number DOES NOT MATTER and is absolutely irrelevant. MySQL is a
relational database from which information is gathered by means of
comparing fields to key values. Even if you are using an auto-incremented
primary key
On 4/03/2006 5:36 PM, Anthony Ettinger wrote:
Yep, that's one good reason among many for using unique ids.
Thinking a
little about the OP's question, I could understand row order being
relevant in certain situations where you wanted to display something
like, "You were the 4
On 3/3/06, Murray @ PlanetThoughtful <[EMAIL PROTECTED]> wrote:
>
> >
> >> I have to agree with Anthony - why are you using row order to determine
> >> something relating to users? I couldn't follow your brief explanation
> >> above, and the fact that you're doing it sets off some soft alarm bells
I have to agree with Anthony - why are you using row order to determine
something relating to users? I couldn't follow your brief explanation
above, and the fact that you're doing it sets off some soft alarm bells
about the design of your application. Why is it important that there
shouldn't be
not be what is not acurate enough. thank you for you help. simple fix. i
> > should have caught it.
> > - Original Message -
> > From: "Anthony Ettinger" <[EMAIL PROTECTED]>
> > To: "benifactor" <[EMAIL PROTECTED]>
> &
.
- Original Message -
From: "Anthony Ettinger" <[EMAIL PROTECTED]>
To: "benifactor" <[EMAIL PROTECTED]>
Cc: "php"
Sent: Friday, March 03, 2006 3:52 PM
Subject: Re: [PHP] Mysql Rows
define $1 = 0 outside your loop.
i'm curious why you are relyin
thony Ettinger" <[EMAIL PROTECTED]>
To: "benifactor" <[EMAIL PROTECTED]>
Cc: "php"
Sent: Friday, March 03, 2006 3:52 PM
Subject: Re: [PHP] Mysql Rows
define $1 = 0 outside your loop.
i'm curious why you are relying on row-order in the database?
Typica
define $1 = 0 outside your loop.
i'm curious why you are relying on row-order in the database?
Typically you'd have a PRIMARY KEY auto_increment for something like
this.
On 3/3/06, benifactor <[EMAIL PROTECTED]> wrote:
> i need to find a way to find out what number of a row is in a database...
>
i need to find a way to find out what number of a row is in a database...
for example:
//this is the database
Username: Chuck Password: adsasa
Username: jimmy Password: adsf
Username: stewart Password: dfds
the information i need is what row jimmy resides on..
this is what i tried:
function i_
pment LAMP system.
Anytime I tried using packages some need seemed to force me back to
doing it by hand.
I guess it depends on what you are developing.. Most package systems
have the extensions available but not installed by default (eg
php-mysql, php-pgsql, php-imap etc).
So I guess my mor
Chris Lott wrote:
> Thanks for the advice-- I've run Linux without a GUI for a long time,
> so I'm quite familiar with hand compilations-- but I always wondered
> if I was just missing something with packaging systems that it seemed
> to REQUIRE hand-compilation to get a workable development LAMP
Thanks for the advice-- I've run Linux without a GUI for a long time,
so I'm quite familiar with hand compilations-- but I always wondered
if I was just missing something with packaging systems that it seemed
to REQUIRE hand-compilation to get a workable development LAMP system.
Anytime I tried us
On Tue, Feb 28, 2006 at 02:13:15AM +1100, David Tulloh wrote:
> Curt Zirzow wrote:
>
> >
> > Before I get into what distib to use there are a few things i'd
> > like to point out:
> >
> > 1) Avoid using the packaging system the OS provides for the
> > developement server. If you do, you
Curt Zirzow wrote:
> On Sat, Feb 25, 2006 at 01:41:06PM -0900, Chris Lott wrote:
>
>>I'm making the switch from Windows to Linux for mydesktop and
>>development environment and would greatly appreciate suggestions for
>>development tools on this platform. Ubuntu seems to be getting all the
>>press
Chris Lott wrote:
I'm making the switch from Windows to Linux for mydesktop and
development environment and would greatly appreciate suggestions for
development tools on this platform. Ubuntu seems to be getting all the
press, but suggestions about Linux distributions are welcome as well!
c
U
Chris Lott wrote:
I'm making the switch from Windows to Linux for mydesktop and
development environment and would greatly appreciate suggestions for
development tools on this platform. Ubuntu seems to be getting all the
press, but suggestions about Linux distributions are welcome as well!
c
J
On Sat, Feb 25, 2006 at 01:41:06PM -0900, Chris Lott wrote:
> I'm making the switch from Windows to Linux for mydesktop and
> development environment and would greatly appreciate suggestions for
> development tools on this platform. Ubuntu seems to be getting all the
> press, but suggestions about
801 - 900 of 3790 matches
Mail list logo
