[PHP-DB] Auto inserting a database with dates

2003-03-01 Thread Chris Payne
Hi there everyone, Is there a quick and easy (HAH :-) way of doing the following: I have a DB and a table with id, date etc . now what I need is to create 3 years of entries for the date in advance of the system going live (Rather than while they use it - hard to explain why but necessary).

Re: [PHP-DB] undefined function: mysql_pconnect()

2003-03-01 Thread Paul Burney
on 3/1/03 12:16 AM, Cameron at [EMAIL PROTECTED] appended the following bits to my mbox: > I'm new to this stuff, so you have to excuse me if I seem dense. I can't > get MySQL base operation from PHP 4.22 under RedHat Linux 8.0. I get the > following error when trying to use mysql_connect(). >

Re: [PHP-DB] Creating MySQL Entry Forms

2003-03-01 Thread Paul Burney
on 3/1/03 2:00 PM, Jeremy N.E. Proffitt at [EMAIL PROTECTED] appended the following bits to my mbox: >> What's wrong with PhpMyAdmin? > It has to be HTML based, it can't install on the server. Well, you can't administer MySQL with HTML pages. You need PHP pages that generate HTML pages. PHPMyA

RE: [PHP-DB] Code to send user info to database

2003-03-01 Thread Michelle Whelan
I have a website that is hosted by Yahoo! Web Hosting which supports PHP with MySQL. The db is already created, so there's no problem there. The problem I am having is knowing what code to write for my form entries so that the info entered by a user can be sent to my db named "users" and then

RE: [PHP-DB] Code to send user info to database

2003-03-01 Thread Michelle Whelan
I have a website that is hosted by Yahoo! Web Hosting which supports PHP with MySQL. The db is already created, so there's no problem there. The problem I am having is knowing what code to write for my form entries so that the info entered by a user can be sent to my db named "users" and then

RE: [PHP-DB] redirect

2003-03-01 Thread Kurth Bemis (List Monkey)
At 04:33 PM 3/1/2003 -0500, Jeremi Bergman wrote: www.php.net/round find the answer there, you will :-) ~kurth Nevermind, I found the answer, and why it wasn't working. Now I was wondering how I can format a number to be a currency? Like if $totalprice = 14.343 have it print 14.34. thanks --

RE: [PHP-DB] redirect

2003-03-01 Thread John W. Holmes
> Nevermind, I found the answer, and why it wasn't working. Now I was > wondering how I can format a number to be a currency? Like if > $totalprice = 14.343 have it print 14.34. Number_format() or printf() ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your

RE: [PHP-DB] redirect

2003-03-01 Thread Jeremi Bergman
Nevermind, I found the answer, and why it wasn't working. Now I was wondering how I can format a number to be a currency? Like if $totalprice = 14.343 have it print 14.34. thanks -Original Message- From: Jeremi Bergman [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 2:13 PM To

[PHP-DB] redirect

2003-03-01 Thread Jeremi Bergman
How can I redirect a user to a specific page if they are already "authenticated"? if ($SESSION_Authenticated) { //code here to redirect; } thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Creating MySQL Entry Forms

2003-03-01 Thread Jeremy N.E. Proffitt
It has to be HTML based, it can't install on the server. - Original Message - From: "Leif K-Brooks" <[EMAIL PROTECTED]> To: "Jeremy N.E. Proffitt" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 9:37 PM Subject: Re: [PHP-DB] Creating MySQL Entry Forms > What's

Re: [PHP-DB] Making Join

2003-03-01 Thread Daniel Harik
Paul Burney wrote: > on 2/28/03 3:15 PM, Daniel Harik at [EMAIL PROTECTED] appended the > following bits to my mbox: > >> Thank You for your reply, but the problem is that users may have many >> photos, and i need to get only one, i use folllowing sql: >> SELECT users.username, photos.file FROM u

Re: [PHP-DB] Making Join

2003-03-01 Thread Daniel Harik
Mark wrote: > > --- Daniel Harik <[EMAIL PROTECTED]> wrote: >> > > Hello, >> > > >> > > I have 2 tables users table, that stores user info, and photos >> table, >> > > i want to select all users with one photo form photos table, >> but i don't >> > > want it to be photos * users = result. >> > >

RE: [PHP-DB] RE: [PHP] Random not working?

2003-03-01 Thread Dennis Cole
You might try getting the random number before the query. -Original Message- From: Rich Gray [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 8:37 PM To: Frank Keessen; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] RE: [PHP] Random not working? > Hi All, > > I'm trying t

Re: [PHP-DB] RE: [PHP] Random not working?

2003-03-01 Thread Frank Keessen
Thanks guys for the info; I will speak to my ISP! Have a nice weekend! Regards, Frank - Original Message - From: "Rich Gray" <[EMAIL PROTECTED]> To: "Frank Keessen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 2:36 AM Subject: [PHP-DB] RE: [P

[PHP-DB] RE: [PHP] Random not working?

2003-03-01 Thread Rich Gray
> Hi All, > > I'm trying to get a random record each time this script runs; > Only it's giving me everytime the first record back.. No random at all.. > > // generate and execute query > $query = "SELECT stedenid, naamstad, stadomschrijvk FROM steden > ORDER BY RAND() LIMIT 1"; > $result = mysql_qu

Re: [PHP-DB] Random not working?

2003-03-01 Thread Doug Thompson
This recent thread from the mysql list explains a lot about the problem. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:15034 hth, Doug On Sat, 1 Mar 2003 12:24:57 +0100, Frank Keessen wrote: >Hi All, > >I'm trying to get a random record each time this script runs; Only it's giving me >everytim

RE: [PHP-DB] undefined function: mysql_pconnect()

2003-03-01 Thread Julien Wadin
Could you post your entire script to see what's wrong ? -Message d'origine- De : Cameron [mailto:[EMAIL PROTECTED] Envoyé : samedi 1 mars 2003 6:17 À : [EMAIL PROTECTED] Objet : [PHP-DB] undefined function: mysql_pconnect() I'm new to this stuff, so you have to excuse me if I seem dense.

[PHP-DB] undefined function: mysql_pconnect()

2003-03-01 Thread Cameron
I'm new to this stuff, so you have to excuse me if I seem dense. I can't get MySQL base operation from PHP 4.22 under RedHat Linux 8.0. I get the following error when trying to use mysql_connect(). "Call to undefined function: mysql_pconnect()" I don't have any other PHP running on the box, oth

[PHP-DB] Random not working?

2003-03-01 Thread Frank Keessen
Hi All, I'm trying to get a random record each time this script runs; Only it's giving me everytime the first record back.. No random at all.. // generate and execute query $query = "SELECT stedenid, naamstad, stadomschrijvk FROM steden ORDER BY RAND() LIMIT 1"; $result = mysql_query($query) or