[PHP-DB] MSSQL 6.5 IIS6 PHP 5

I recently wrote a simple web script to execute a few queries against an old MS SQL 6.5 server. I developed the script on my XP box running IIS5 any user can run the script with out a problem. However when I moved it to the production box running IIS6 domain admins can run the script anyone else

Re: [PHP-DB] CURL and process not finishing

Hi Are you running this as CLI or from your web-server? If the latter, use phpinfo() and check the max_execution_time isn't causing you problems. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] CURL and process not finishing

[EMAIL PROTECTED] wrote: - Original Message - From: chris smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Friday, January 05, 2007 12:08 PM Subject: Re: [PHP-DB] CURL and process not finishing On 1/5/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I

[PHP-DB] Syntax Error

Can anyone help me figure out what is wrong with this syntax. Thanks. list($qh,$num) = dbQuery(SELECT password AS passwd1, $DATABASE_PASSWORD_FUNCTION('$password') AS passwd2 . FROM $USER_TABLE WHERE username='$username'); $data = dbResult($qh); -- PHP Database Mailing List

Re: [PHP-DB] Syntax Error

Hi is the syntax error reported for the php or the SQL? Better yet, supply the actual error message, so we can see for ourselves Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Syntax Error

JD wrote: Can anyone help me figure out what is wrong with this syntax. Thanks. list($qh,$num) = dbQuery(SELECT password AS passwd1, $DATABASE_PASSWORD_FUNCTION('$password') AS passwd2 . FROM $USER_TABLE WHERE username='$username'); $data = dbResult($qh); No need to repost your

[PHP-DB] MYSQL REGEXP question

Hello, i am try to make a regular expression work, but keep getting an error message does anyone know how i can make it work? The query is: SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])'; So it has to match each starting 'b' and all the b's pf following words. But now followed by a v(line end)

Re: [PHP-DB] MYSQL REGEXP question

Your code states: Match: one of the following letters: -,b,|,^,b negative look ahead one of these: -,v,$,|,v Which isn't what you're looking for. Remember the negating '^' only works at the start of a [] list. And '$' only means line-end if it's outside [], inside it stands for the '$'

Re: [PHP-DB] CURL and process not finishing

Hi leaving me with the question: what does max_execution_time relate to? is it more like a maximum time without activity. max_execution_time is the time php gets to execute code. From the documentation: The maximum execution time is not affected by system calls, stream operations etc.

Re: [PHP-DB] mysql rereading result set (fetch_assoc)

christine wrote: Hi, I would ask which way is more efficient and save time? Save each row to array or mysql_data_seek(0) ? Probably mysql_data_seek(0). That just resets the mysql pointer back to the start and so it doesn't re-run the query or anything like that and doesn't take up any extra

Re: [PHP-DB] mysql rereading result set (fetch_assoc)

Hi Hi, I would ask which way is more efficient and save time? Save each row to array or mysql_data_seek(0) ? That totally depends on which resources are more valuable to you. The array will likely use more memory but be faster to process. While mysql_data_seek(0) would probably use no