Re: [PHP-DB] getting data back when inserting

2004-12-01 Thread Aaron Todd
t you're looking for. Stefan > -Ursprüngliche Nachricht- > Von: Aaron Todd [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 1. Dezember 2004 17:01 > An: [EMAIL PROTECTED] > Betreff: [PHP-DB] getting data back when inserting > > I was wondering if somone might

[PHP-DB] getting data back when inserting

2004-12-01 Thread Aaron Todd
I was wondering if somone might be able to suggest a command to me...I am inserting data into a MySQL database that has an auto-incrementing primary field. When I insert the data I would like to somehow get the value of the auto-incrementing primary field. I thought I could just run a SELECT

Re: [PHP-DB] mysqldump

2004-11-09 Thread Aaron Todd
ql"; $command = "/home/virtual/site341/fst/usr/bin/mysqldump -u * -p* database > $filename"; echo $command; exec($command); Thanks for your post, Aaron "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Tuesday 09 Novembe

Re: [PHP-DB] mysqldump

2004-11-09 Thread Aaron Todd
; also ... I notice you have a space after the "-u" - should that be there? > David. > > On 10/11/2004, at 6:59 AM, Aaron Todd wrote: > >> I have created a PHP script that looks like: >> >> > $filename = "/var/www/html/db_backup_" . date(&qu

[PHP-DB] mysqldump

2004-11-09 Thread Aaron Todd
I have created a PHP script that looks like: $filename'); ?> For some reason this doesnt work and I cant figure out why. There is no error that comes back. When I run the mysqldump command from the server console it produces the file fine. I have read a few other posts out there about this

Re: [PHP-DB] Database Backup

2004-10-06 Thread Aaron Todd
?? Thanks, Aaron "Andrew Kreps" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Tue, 5 Oct 2004 16:33:08 -0400, Aaron Todd <[EMAIL PROTECTED]> > wrote: >> What is everyone doing to backup a MySQL database. Just in case...I'd >> l

[PHP-DB] Re: Session confusion

2004-10-06 Thread Aaron Todd
Stuart, I am fairly new to PHP, but it is my understanding that you have to run the session_start() command on every page that you want to be part of the session and to access the session variables. Here is a link of a tutorial about using sessions: http://www.phpfreaks.com/tutorials/41/3.php

[PHP-DB] Database Backup

2004-10-05 Thread Aaron Todd
What is everyone doing to backup a MySQL database. Just in case...I'd like to backup mine, but I was wondering if there was a way to do it without going to a page and clicking a button. Is there a way to run a php script on a time schedule and then push a backup file to an FTP server or somet

[PHP-DB] Ascending and Descending records

2004-10-05 Thread Aaron Todd
I have a page that shows data from a MySQL database in a table form. I'd like to give this page the ability to be able to sort a column when the user clicks on the header cell that contains the name of the column. I'd also like the ability to do both Ascending and Descending with the same link

[PHP-DB] Limiting records per page

2004-09-15 Thread Aaron Todd
I have written a script that will display the contents of a MYSQL database that starting to fill up. I would like to be able to only show about 20 records per page and then at the bottom of the page there will be buttons to move to the nest page which gets the next 20 records. I understand the

[PHP-DB] Insert Query PROBLEMS

2004-09-10 Thread Aaron Todd
I'm trying to run an INSERT query on my mysql database and it isnt working. Here is the query: $updatequery = "UPDATE `users` SET ('company','fname','lname','address1','address2','city','state','zip','phone','extension','fax','email') =

[PHP-DB] Zip Code Fields

2004-09-08 Thread Aaron Todd
Just curious, but what kind of field is everyone using to store a Zip Code. I set mine to Medium Integer with a max of 5 digits, but for zip codes that begins with 0 the 0 is knocked off. The only solutiuon I can think of is to make the field a text field. Does anyone have a better solution?

[PHP-DB] Re: sendmail

2004-08-04 Thread Aaron Todd
other troubleshooting that I can do to get more information on what I am doing? Thanks, Aaron "Manuel Lemos" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > On 08/03/2004 11:16 AM, Aaron Todd wrote: > > Is there any tweaking with mail()? > > > &g

[PHP-DB] Re: sendmail

2004-08-03 Thread Aaron Todd
. Any ideals on this? Thanks, Aaron "Aaron Todd" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > So far, I have been doing ok with PHP. I feel that I have picked it up > rather easily. But now I need some help. I am trying to use the sendmail > functions

[PHP-DB] Re: sendmail

2004-08-02 Thread Aaron Todd
Thanks to you both...Matt M. and Philip Thompson. Your suggestion of using the mail() function instead worked perfectly. Thanks again, Aaron "Aaron Todd" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > So far, I have been doing ok with PHP. I feel that

[PHP-DB] sendmail

2004-08-02 Thread Aaron Todd
So far, I have been doing ok with PHP. I feel that I have picked it up rather easily. But now I need some help. I am trying to use the sendmail functions to send data entered in a form to my email address. Currently its not working at all. I am getting a Fatal Error: Call to undefined functi

Re: Re[2]: [PHP-DB] Begining PHP...Have Questions

2004-07-19 Thread Aaron Todd
That explains it. I did look at the manual and it did show . instead of , It just didnt even hit me. One of those kick yourself mistakes. Thanks, Aaron "Pablo M. Rivas" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello Aaron, > > why are you using , instead of . ? > >

Re: [PHP-DB] Begining PHP...Have Questions

2004-07-19 Thread Aaron Todd
27;]} > > that will only return the row that matches both the username and > password - so if 1 row is returned it must be the login info. That'll > cut down on the PHP code you need to write. > > Aaron Todd wrote: > > >Jon, > > > >Thanks for the info. I

[PHP-DB] Re: Begining PHP...Have Questions

2004-07-19 Thread Aaron Todd
ve password2. I believe it does. But If I put password1 in the form and the program checks to see if it is equil to password2 it should echo the error. You may be able to tell, but I am getting really confused by this. If anyone can help with this I would really appreciate it. Aaron &

Re: [PHP-DB] Begining PHP...Have Questions

2004-07-19 Thread Aaron Todd
name will > no longer work, you have to use $_POST['username']. Search the php > lists for lots more discussion on this matter. > > For more on superglobals: > http://www.php.net/manual/en/language.variables.predefined.php > For the list archives, click the "Archiv

Re: [PHP-DB] Begining PHP...Have Questions

2004-07-19 Thread Aaron Todd
ng > $_POST['username'] and not $username. (i'm assuming it's on given your code) > > Jon > > Aaron Todd wrote: > > >I am just starting out with PHP and I have created a simple login program > >that is supposed to check users input with a mysql database

[PHP-DB] Begining PHP...Have Questions

2004-07-19 Thread Aaron Todd
I am just starting out with PHP and I have created a simple login program that is supposed to check users input with a mysql database. I am doing 5 verifications before the program is completed...Check for the Submit button, check for a valid email address(which is the username), check for a valid

Re: [PHP-DB] Re: REG_BADRPT error

2004-07-19 Thread Aaron Todd
y use Perl Compatible Regexes as > I understand them better. Try: > > if(strlen($pass) < 6 || !preg_match('/[a-z]/i', $pass) || > !preg_match('/[0-9]/', $pass)) { > //bad password > } > > On Mon, 19 Jul 2004 11:10:47 -0400, Aaron Todd <[EMAIL PROTECTED]>

[PHP-DB] Re: REG_BADRPT error

2004-07-19 Thread Aaron Todd
I am still trying to get the hang of it. Any help will be appreciated. Thanks, Aaron "Aaron Todd" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > I am getting an REG_BADRPT error when I use ereg. > > The line of code that errors is: >

[PHP-DB] REG_BADRPT error

2004-07-19 Thread Aaron Todd
Hello, I am getting an REG_BADRPT error when I use ereg. The line of code that errors is: if (!ereg('^(?=.*[0-9]+.*)(?=.*[a-zA-Z]+.*)[0-9a-zA-Z]{8,}$', $pass)){ I got this regex from regexlib.com and tried to impliment it, but no matter what I do it always returns the error. I did a google