[PHP-DB] Connect to MySQL from different computer
Hello- I was wondering how do I connect to a MySQL database, using php, when php and MySQL are on two separate computers? Thanks, Jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] easy db question
hello everyone- I'm running MySQL 3.23.27-beta with php 4.04pl1. What I am wondering is I have an auto incrementing field and if I delete all the entries in the table with this field the incrementing doesn't start over. For example, if I insert 6 records for the first time into this table the auto incremenator gets set to 6 for the last position. Now, if I go and delete all 6 of these entries and then insert 6 more after the deletion the auto incrementing starts off at 7 and goes through 12. I'm just curious if there is a way around this so that if all the records are deleted the auto incrementing field will start back at 1. Thanks, Jay Paulson Developer, Web Technologies Viatel, Inc. http://www.viatel.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] simple sql question
Hello- I'm running MySQL and php and when I run the query below I don't get any return rows. As you can see I search for events that are happening between a certain date. The "startDate" field is type DATE in MySQL and the date in the database that should be returned in "2001-03-27" but I'm not getting any results. select * from events where startDate='2001-03-01' and startDate'2001-01-04' Any help on what I could be doing wrong would be great! Thanks, Jay Paulson Developer, Web Technologies Viatel, Inc. http://www.viatel.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] installing MySQL with PHP4.0.3pl1
Hello everyone- I'm trying to get MySQL to work with php, however I'm running php on a WinNT box and I was wondering if I needed to install MySQL in a specific location on the hard drive? The reason I as is that when I try to connect to a database I create in MySQL in php it doesn't find any database. I'm totally lost on this and don't have a clue as what to do. Any help will be greatly appreciated. Regards, Jay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]