[PHP-DB] problems whenever changing data in database using PHPMyAdmin.

2002-09-02 Thread Kasper
... I was wondering for quiete a while about the subject to get it accurat enough concerning the problem I'm really having. I have my MySQL database runing, my site is running and fetching the data from the database without any problems. I can access PHPMyAdmin without any problems aswell, I can

[PHP-DB] noobie db: oracle?

2002-09-02 Thread :B nerdy
ive been using mysql my whole php life. i recently got oracle trial db. how does it weigh against mysql? is there a website really benchmarks them both against each other, practically? cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] mssql: insert a record and return the auto increment ID

2002-09-02 Thread Heiko Mundle
I insert a new record with PHP into my MS SQL Server database. The key is defined with auto_idINT IDENTITY(1000,1) NOT NULL, how do I get the new id to use it in PHP? To insert the record I use this code: $sSql = INSERT INTO myTable (time_in ) VALUES (

[PHP-DB] gettin records from today, yesterday, etc.

2002-09-02 Thread andy
Hi there, I am wondering how to get recors out of a mysql db from yesterday, last week and last month. I did write a small php hack but this does not work properly. I did this: ### switch ($ts){ case 1: // today $timestamp =

Re: [PHP-DB] Re: What's wrong with this code?

2002-09-02 Thread Shoulder to Shoulder Farm
Sorry all, my mail program has been sending messages to the sender. Sorry...Taj Jean-Christian Imbeault wrote: Shoulder To Shoulder Farm wrote: mysql_query(INSERT INTO prod VALUES ( 'Name', 'ShortDesc', 'LongDesc', 'PriceOZ', 'PriceLB', 'URLOZ', 'URLLB', 'IMG') VALUES ('$_POST[Name]',

Re: [PHP-DB] Re: What's wrong with this code?

2002-09-02 Thread David Balatero
Try concencating (however you spell it) the variables...i try not to put arrays inside of strings, rather i do the following below. Oh yeah, and you have two things that say VALUES (...) ...maybe ive missed this over the years, but i thought you put the fields inside parenthesis without anything

Re: [PHP-DB] gettin records from today, yesterday, etc.

2002-09-02 Thread Jed Verity
Hi, It would better and far easier to use PHP's date functions, specifically getdate() and date(). Check out the documentation here: http://www.php.net/manual/en/function.getdate.php HTH, Jed On the threshold of genius, andy wrote: Hi there, I am wondering how to get recors out of a

[PHP-DB] RE: [PHP] help, array values echoed as Array on loop!

2002-09-02 Thread victor
Ok, if I change $ID_arr[] to $ID_arr I think it gives me what I want. - Victor www.argilent.com -Original Message- From: Victor [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 3:39 PM To: 'PHP' Subject: [PHP] help, array values echoed as Array on loop! I have tried both

RE: [PHP-DB] RE: [PHP] help, array values echoed as Array on loop!

2002-09-02 Thread victor
Ok, wrong mailing list! - Victor www.argilent.com -Original Message- From: victor [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 3:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] RE: [PHP] help, array values echoed as Array on loop! Ok, if I change $ID_arr[] to $ID_arr I

[PHP-DB] [mysql] freeing resources

2002-09-02 Thread :B nerdy
what would happen if i do not use mysql_free_result() and mysql_close() for my scripts. i presuming it doesnt leak memory. if so, then why not just forget about them, and let the automatic freeing thingie's do the work? cheers -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] mandrake server

2002-09-02 Thread rdelgar
I am new to Linux. I am setting up a web server to facilitate PHP, MySQL commerce development and then use it in the future to host a site. Mandrake 8.2 Standard edition is currently being installed. Do I need the pro suite edition or what? What is the best web server set up? Sincerely,

[PHP-DB] PHP Not Working

2002-09-02 Thread Matthew C. Tedder
PHP is not working on my Mandrake Beta 4. It is installed, any reasons why this might be? It worked right after installation in previous version of Mandrake. Matthew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [mysql] freeing resources

2002-09-02 Thread Adam Royle
Yes, PHP is very cool, and handles memory management for you. mySQL resultsets and connections are cleaned up once the page has finished executing (is in manual). The reason why you would want to use these functions is if you have a script that does not finish (such as one that handles port

[PHP-DB] Re: PHP Not Working

2002-09-02 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... PHP is not working on my Mandrake Beta 4. It is installed, any reasons w= hy=20 this might be? It worked right after installation in previous version of= =20 Mandrake. Matthew WILD GUESSNot correctly configured in apache?/WILD