Re: [PHP-DB] Hello

Welcome Rodrigo! Start checking php.net for object/clasess check out this mirror site of php.net http://php.oregonstate.edu/manual/en/ref.classobj.php By the way I don't know if we have from Brazil here... M. Mamedov - Original Message - From: Rodrigo Kochenburger [EMAIL PROTECTED]

Re: [PHP-DB] method question

I am looking to create a comp-time calculator of sorts using PHP/MySQL. I am still in the learning process of how all of this works. I want to be able to create a web interface where my employee can login and enter her comp-time as she works extra. I also want to be able to have an admin

[PHP-DB] ...request synchronization error...

Hi , Does anyone know what could be the reason for an 'request synchronization error' ? It occurs after calling ibase_fetch_assoc(). The same thing going on with ibase_fetch_object() and ibase_fetch_row(). The resultset is being delivered correctly by ibase_query(). The SQL-String (SELECT)

[PHP-DB] Re: php mail() question

--- Actually I start a PHP script from the cron task that runs every 5 minutes using PHP CGI executable version. I just process upto 100 bounced messages per run avoid hogging the database server and blocking the POP3 mailbox for a long time, as this is not a prioritary task. --- Right, how do

[PHP-DB] Get Names of columns of a table

Hi, is there a PHP function that wil return the names of the columns for a given table? Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Get Names of columns of a table

http://www.php.net/mysq_list_fields hth Jeff Shaun

Re: [PHP-DB] Creating temp tables in MSSQL

Hi Frank. When does this table get deleted? when the DB connection closes or does one have to run a process to clear the temp tables? Thanks, Matt On Tue, 2003-12-16 at 17:29, Frank M. Kromann wrote: Hi, Any table that starts with # is a temp table. You can use create table #mytemp (...)

Re: [PHP-DB] Creating temp tables in MSSQL

Thanks for your response Frank, but this is still driving me nuts and making me look like a moron at the same time (-: This simplified query: $query = SELECT distinct convert(varchar(36),a.traineeID) INTO #tempdata1; $query .= FROM tblSignIn_trainee a; $queryresult = MSSQL_QUERY($query,$cn) or

Re: [PHP-DB] Get Names of columns of a table

From: [EMAIL PROTECTED] is there a PHP function that wil return the names of the columns for a given table? http://www.php.net/mysq_list_fields Note: The function mysql_list_fields() is deprecated. It is preferable to use mysql_query() to issue a SQL SHOW COLUMNS FROM table [LIKE 'name']

[PHP-DB] List-Unsubscribe

__ This communication is intended for the use of the recipient to whom it is addressed, and may contain confidential, personal, and or privileged information. Please contact us immediately if you are not the intended recipient of this communication, and do not copy, distribute,

[PHP-DB] Retrieve data and column names from a table

Hi, I need to retrieve the data and column names from a single row in a table, i.e. 'SELECT * FROM Table WHERE Field_ID = 1' How can I get PHP to show the data and the column names? With reference to my earlier post and the replies I can't use DESCRIBE in conjunction with SELECT and I don't want

Re: [PHP-DB] Retrieve data and column names from a table

On Wed, Dec 17, 2003 at 07:43:50PM -, Shaun wrote: I need to retrieve the data and column names from a single row in a table, i.e. 'SELECT * FROM Table WHERE Field_ID = 1' Maybe something like this: $result = mysql_query (SELECT * FROM Table LIMIT 1,$db); $my_row = mysql_fetch_array

[PHP-DB] Search Query

Dear all, i need help with my search query statement.. what is wrong with my code? snip $word = split( , $keyword); $num_words = count($word); $word_str = ; $criteria = ; for ($i=0; $i$num_words; $i++) { if ($i) $word_str .= and colName