Re: [PHP] php/mysql/phpMyAdmin on an iBook?

2006-03-04 Thread chris smith
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 testing server > installed and wond

Re: [PHP] Prepared statements

2006-03-04 Thread Julius Hacker
Anthony Ettinger wrote: > On 3/4/06, Julius Hacker <[EMAIL PROTECTED]> wrote: > >> One other thing: >> If I do the bind_param within the loop, it just works. >> >> The curious is that I have to prepared statements for this loop (one for >> inserting data and one for updating data) and the one fo

Re: [PHP] Prepared statements

2006-03-04 Thread Anthony Ettinger
On 3/4/06, Julius Hacker <[EMAIL PROTECTED]> wrote: > One other thing: > If I do the bind_param within the loop, it just works. > > The curious is that I have to prepared statements for this loop (one for > inserting data and one for updating data) and the one for updating data > works and that for

Re: [PHP] Prepared statements

2006-03-04 Thread Julius Hacker
One other thing: If I do the bind_param within the loop, it just works. The curious is that I have to prepared statements for this loop (one for inserting data and one for updating data) and the one for updating data works and that for inserting don't. Both statements are 100% valid. Julius Hacke

[PHP] [JOB] LAMP Developers, Los Angeles | 70-120k

2006-03-04 Thread Beau Gould
LAMP Developers, Los Angeles | 70-120k LAMP Developers needed at all skill levels for multiple Los Angeles clients for full time, on-site jobs ranging from 70-120k + full benefits. Candidates must be authorized to work in the United States and be local to the Los Angeles, CA area. * At leas

[PHP] [JOB] LAMP Developer, Washington, D.C. | 80k

2006-03-04 Thread Beau Gould
LAMP Developer, Washington, D.C. | 80k Candidate must have solid skills and experience in developing robust web applications, using object oriented programming languages and techniques, and possess database design and optimization skills. You will interact with clients, co-workers and managers.

[PHP] output Today's date

2006-03-04 Thread Paul Goepfert
Hi all, ls there anyway I can set the date to the timezone of the clients timezone? For example, if a person opens the web page at 3/6 12:01 EST and another person opens the same page at 3/5 10:01 MST I would like the date to be the above days on the client computers. I know everyone knows this

Re: [PHP] Mysql Rows

2006-03-04 Thread Robert Cummings
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

RE: [PHP] Mysql Rows

2006-03-04 Thread jblanchard
[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. [

RE: [PHP] Mysql Rows

2006-03-04 Thread jblanchard
[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

Re: [PHP] Mysql Rows

2006-03-04 Thread Robert Cummings
On Sat, 2006-03-04 at 17:34, benifactor wrote: > - Original Message - > From: "benifactor" <[EMAIL PROTECTED]> > To: "Robert Cummings" <[EMAIL PROTECTED]>; "tedd" <[EMAIL PROTECTED]> > Cc: "PHP-General" ; "Murray @ PlanetThoughtful" > <[EMAIL PROTECTED]>; "Anthony Ettinger" <[EMAIL PROTECT

RE: [PHP] LDAP confusion

2006-03-04 Thread jblanchard
[snip] > if(!$ds=ldap_connect("foo")){ > echo "did not connect"; > }else { > echo "connection successful"; > } > $un = "user"; > $upw = "pass"; > echo "connect result is " . $ds . ""; > ldap_set_option($ds, LDAP_OPT_PROTOCOL_VERSION, 3); > ldap_set_option($ds, LDAP_OPT_REFERRALS, 0)

Re: [PHP] Mysql Rows

2006-03-04 Thread tedd
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

Re: [PHP] Mysql Rows

2006-03-04 Thread benifactor
- Original Message - From: "benifactor" <[EMAIL PROTECTED]> To: "Robert Cummings" <[EMAIL PROTECTED]>; "tedd" <[EMAIL PROTECTED]> Cc: "PHP-General" ; "Murray @ PlanetThoughtful" <[EMAIL PROTECTED]>; "Anthony Ettinger" <[EMAIL PROTECTED]> Sent: Saturday, March 04, 2006 2:29 PM Subject: Re:

Re: [PHP] Mysql Rows

2006-03-04 Thread benifactor
- Original Message - From: "Robert Cummings" <[EMAIL PROTECTED]> To: "tedd" <[EMAIL PROTECTED]> Cc: "PHP-General" ; "benifactor" <[EMAIL PROTECTED]>; "Murray @ PlanetThoughtful" <[EMAIL PROTECTED]>; "Anthony Ettinger" <[EMAIL PROTECTED]> Sent: Saturday, March 04, 2006 9:41 AM Subject: Re:

[PHP] php/mysql/phpMyAdmin on an iBook?

2006-03-04 Thread Paul Jinks
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/mysql/p

Re: [PHP] Mysql Rows

2006-03-04 Thread Robert Cummings
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'

Re: [PHP] Mysql Rows

2006-03-04 Thread Gustav Wiberg
- Original Message - From: "tedd" <[EMAIL PROTECTED]> To: Cc: "benifactor" <[EMAIL PROTECTED]>; "Murray @ PlanetThoughtful" <[EMAIL PROTECTED]>; "Anthony Ettinger" <[EMAIL PROTECTED]> Sent: Saturday, March 04, 2006 3:14 PM Subject: Re: [PHP] Mysql Rows planetthoughtful wrote: Bu

Re: [PHP] Mysql Rows

2006-03-04 Thread tedd
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,

Re: [PHP] Mysql Rows

2006-03-04 Thread Miles Thompson
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