[PHP-DB] MSSQL Identity Column

Hello, I need a way to tell if a specified column is an identity column or not. All PHP seems to be able to tell me is the name, type and size of the field. any help would be appreciated thanks, >-< Sean Finkel Webmaster - R

Re: [PHP-DB] Uploading file into database

Hi, ok, first of all make sure your form tag is like : The ENCTYPE is important! Next, make sure you have a field like: type="file" is important! This will present a browse button for the user to browse their drives something like this seems to work - drop the addslashes if it is not a bin

[PHP-DB] oracle 8i client/ PHP 4.0.4pl1 breaks

Here's the scoop: Goal: to connect apache 1.3.19/PHP to remote Oracle server. Background: I downloaded Oracle 8.1.7 and installed the default Client configuration. Machine is an SMP Mandrake 7.0 Linux 2.2.14. PHP is 4.0.4pl1. Synopsis: I configure and make php even with the cleanest co

Re: [PHP-DB] sessions and page has expired warning

Here, I think you may be over - using session variables a bit...have not used them in php, as I have version 3, which doesn't support them. However, by day I am an ASP developer, and article after article I read warns about session variables! They are great, but can hog memory, especially if

Re: [PHP-DB] MSSQL + IIS

If you are speaking of Microsoft SQLServer, there are some lists that specialize in this product at http://www.sqlteam.com Also - try www.4guysfromrolla.com and asp101.com hope this helps a little, Phil J. "André M.S.\" > How can i use MSSQL + IIS? > i´m having some problems... > > tks > > --

Re: [PHP-DB] connection to database

If you connect with pg_PConnect(), connection will be there until web server dies unless user is using CGI. (PostgreSQL backend will be there until then) That's the idea of persistent link, so that user can avoid connection setup for every db connection. However, PostreSQL connects db relatively f

[PHP-DB] MSSQL + IIS

How can i use MSSQL + IIS? i´m having some problems... tks -- 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]

Re: [PHP-DB] access Rows

Many of the DBMS's allow you to choose which row to fetch. Eg with MySQL, you can use mysql_data_seek() (see http://www.php.net/manual/en/function.mysql-data-seek.php) Similar equivilents exist for ODBC, MS SQL etc. Eg: odbc_fetch_row($result, $rownumber); What is it about row 5 for example tha

Re: [PHP-DB] access Rows

Hi, If you exactly know which row you want you could use LIMIT yourRow, 1. If you copy the RS into an array first you would have to use a while statement aswell, or not? Cheers Johannes ""Mike"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 9b4e4n$gmh$[EMAIL PROTECTED]">news:9b4e4n$gmh$[EMAIL PROT

Re: [PHP-DB] add php to apache

>./configure --with-php=../php > or more complicate... More complicated. You really should check www.devshed.com you can find more on how to install MySQL, PHP and Apache. Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] add php to apache

Can I add to the actual serveur apache? With somthing like this: ./configure --with-php=../php or more complicate... Franky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To c

Re: [PHP-DB] substring_index Part 2

At 11:53 AM 4/12/2001 -0500, you wrote: >Thanks for the help on the earlier ?. Now that I have the select statement >working I can't get any results displayed. You can't print what you haven't asked for. > $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM > news",$db) or die

Re: [PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()

>Such patience! You waited nearly 7 whole minutes before reposting your >message! > >I don't run MySQL, so I'm not sure... but it looks like you probably don't >have MySQL support in your version of PHP. Try: > >phpinfo(); >?> Also, include some more code.. Or even better, check out some of t

Re: [PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()

Such patience! You waited nearly 7 whole minutes before reposting your message! I don't run MySQL, so I'm not sure... but it looks like you probably don't have MySQL support in your version of PHP. Try: ...and see if it says you do. At 12:44 PM 4/13/01 -0400, franky wrote: >I'm trying to

[PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()

I'm trying to connect to mySQL DB by Web page and when I use mysql_connect() this append: Fatal error: Call to unsupported or undefined function mysql_connect() thanks! Franky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] Fo

[PHP-DB] Fatal error: undefined function mysql_connect()

I'm trying to connect to mySQL DB by Web page and when I use mysql_connect() this append: Fatal error: Call to unsupported or undefined function mysql_connect() thanks! Franky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] substring_index Part 2

on 4/12/01 9:53 AM, Mike Baerwolf ([EMAIL PROTECTED]) wrote: > $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM > news",$db) or die ("Invalid Query"); > if ($myrow = mysql_fetch_array($result)) { > > do { > > printf("%s\n", $myrow["headline"]); > printf("%s\n", $myrow["body"])

Re: [PHP-DB] date_format for Oracle

At 10:12 PM 4/11/01 +, Richard Crawford wrote: >This isn't strictly a PHP question, I suppose... but is anyone aware of a >date_format function for Oracle comparable to MySQL's date_format() function? I'm not familiar at all with MySQL nor its date_format() function, but Oracle has two f

Re: [PHP-DB] build drop-down pick from MYSQL table

on 4/12/01 8:40 AM, Quentin Krengel ([EMAIL PROTECTED]) wrote: > I have found examples of building a dropdown list, and have found examples of > reading a mysql table, but am looking for examples of creating a drop-down > list with the results of a mysql query. Ie, I have an admin screen where >

[PHP-DB] substring_index Part 2

Thanks for the help on the earlier ?. Now that I have the select statement working I can't get any results displayed. $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM news",$db) or die ("Invalid Query"); if ($myrow = mysql_fetch_array($result)) { do {

[PHP-DB] build drop-down pick from MYSQL table

I’m very new to PHP (coming from shell programming) and have a very easy question… :-) I have found examples of building a dropdown list, and have found examples of reading a mysql table, but am looking for examples of creating a drop-down list with the results of a mysql query. Ie, I have an ad

[PHP-DB] access Rows

I want to be able to access the rows of a resultset,but I want to specify which ones.(Lets say $row[5]).Do I have to copy the RS into a seperate array first?Most examples enumerate with "while" statements.I dont want to do that. Thanks Mike P [EMAIL PROTECTED] -- PHP Database Mailing List (ht

RE: [PHP-DB] element in the SELECT query

pg_numrows will only bring back the number of results in the resultset. you could try: a. a query using distinct to bring only the vlaues you want. b. (better) a query using an aggregate function like count and then access the count var from your resultset. like: select count(id) as idcount f

RE: [PHP-DB] connection to database

wow. another postgresql user ! i use pg_connect to connect as well, including the connect script as an 'if not connected then connect' type of thing. the connection is killed and memory from queries freed up when the script finnishes. incidently, i used pconnect for a while but found that connec