[PHP-DB] odbc under windows

2002-11-29 Thread Hacook
Hi all, I have an apache server with PHP 4.2.3 on it that works perfectly. How can i install the odbc drivers ? Thanks, Hacook -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Find value in array

2002-11-29 Thread Wilmar Perez
Hello guys I'm trying to find a value which is into an array inside another array (hope it makes sense). The code: $query = "select cat_code from authorxcat where author_code=$mod_author"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_array($result); $query_aux = "sel

[PHP-DB] Database Connections

2002-11-29 Thread Bill Arbuckle, Jr.
I have a general question concerning databases in php. More specifically, what is the general consensus on maintaining a connection. Some of this is more than likely my ignorance. My connection stuff goes something like this ... $db = mysql_connect("localhost", "stuff", "pw") or die("Could Not

Re: [PHP-DB] Database Connections

2002-11-29 Thread Marco Tabini
I think that generally PHP closes any non-persistent connections for you when you leave your script, so that it's not necessary to clean up after your script is done. You can create persistent connections, but in a high-traffic site they tend to become a resource problem after a while--and your se

[PHP-DB] Wierd php/mysql problem...

2002-11-29 Thread Alex Moen
Hey all... Here's one that really has me stumped. I have a Cobalt RAQ 550, with MySQL and PHP 4.0.6. I also have phpMyAdmin installed, for ease-of-use for our customers to set up their databases. This works pretty well, although I have found what I consider to be a bug with it but it does n

[PHP-DB] mysql_select_db() and mysql_query()

2002-11-29 Thread Dan Martin
A friendly error message advised me that "mysql_db_query" is deprecated and to use "mysql_select_db() and mysql_query()". but I can't seem to get past this return in the Browser: "Parse error: parse error in c:\program files\apache group\apache\htdocs\crup_hs_local\result.php on line 58". I think

Re: [PHP-DB] mysql_select_db() and mysql_query()

2002-11-29 Thread Beth Gore
Hi Dan, Dan Martin wrote: group\apache\htdocs\crup_hs_local\result.php on line 58". I think I don't understand the basic syntax. /*$result = mysql_db_query($dbname,$sql);*/ /*mysql_db_query is deprecated; use mysql_select_db() and mysql_query()*/ $result = mysql_select_db($dbname) or die(mysql_

[PHP-DB] Date Question

2002-11-29 Thread Chris Payne
Hi there everyone, I've never really used the date functions beyond getting it to store the current date in a db. I have a dilema in that I need to get all the days in the current month and all the days in the next month (whatever the next month is depends on the current month the script was ran)

Re: [PHP-DB] Date Question

2002-11-29 Thread Jason Wong
On Saturday 30 November 2002 12:30, Chris Payne wrote: > Hi there everyone, > > I've never really used the date functions beyond getting it to store the > current date in a db. > > I have a dilema in that I need to get all the days in the current month and > all the days in the next month (whatever