[PHP-DB] MonetDB PHP Apache

2006-04-25 Thread monetdb
LS, The MonetDB open-source database project, a novel and fast SQL XQuery engine, has several core developers, but we greatly feel the miss of someone experienced in further developing/maintaining the MonetDB PHP library. If you are an experienced hacker in PHP modules at C level, and have

[PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread Skip Evans
Hello all, I'm brand spanking new to the list and have a quick question. I was under the impression that addslashes() would handle single quote marks in INSERT statements, but when I execute the following: $sql=UPDATE images SET orderno=$orderno, url='.addslashes($url).',

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread dpgirago
Skip Evens wrote: Hello all, I'm brand spanking new to the list and have a quick question. I was under the impression that addslashes() would handle single quote marks in INSERT statements, but when I execute the following: $sql=UPDATE images SET orderno=$orderno,

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread Skip Evans
Hello David all, No, neither mysql_escape_string or mysql_real_escape_string worked. Yes, I am using MySQL, should have said that, sorry. But anyway, even with both of these functions, the data in the string containing the single quote as in Don't Look is still being truncated at the

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread Stut
Skip Evans wrote: I was under the impression that addslashes() would handle single quote marks in INSERT statements, but when I execute the following: $sql=UPDATE images SET orderno=$orderno, url='.addslashes($url).', banner=$banner,caption='.addslashes($caption).' WHERE imageID=$imageID;

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread Martin Alterisio
1) Check that the string is not being truncated because of the column length 2) If you're seeing this data being truncated in the html output of your site, check if it isn't being caused by outputing the data without properly encoding special html characters. 3) . dunno 2006/4/25, Skip

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread John Hicks
Martin Alterisio wrote: 1) Check that the string is not being truncated because of the column length 2) If you're seeing this data being truncated in the html output of your site, check if it isn't being caused by outputing the data without properly encoding special html characters. 3) .

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread Skip Evans
Martin Alterisio wrote: 1) Check that the string is not being truncated because of the column length This was not it. 2) If you're seeing this data being truncated in the html output of your site, check if it isn't being caused by outputing the data without properly encoding special html

[PHP-DB] Sheduled task for Php-MySql script

2006-04-25 Thread Nur_Adman
Hi all, I have some php scripts that i have to run automatically at 5.00am (on Windows platform). I am using MySql. I've tried using Scheduled Task and Cron, and i converted the extension files to .bat format. But always error on functions mysql_connect,mysql_query,and other DBS functions. I

Re: [PHP-DB] Sheduled task for Php-MySql script

2006-04-25 Thread chris smith
I have some php scripts that i have to run automatically at 5.00am (on Windows platform). I am using MySql. I've tried using Scheduled Task and Cron, and i converted the extension files to .bat format. But always error on functions mysql_connect,mysql_query,and other DBS functions. I don't

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread Martin Alterisio
2006/4/25, Skip Evans [EMAIL PROTECTED]: Martin Alterisio wrote: 1) Check that the string is not being truncated because of the column length This was not it. I was sure it wasn't but the first rule of debugging says never discard a possible cause, no mather how dumb it may seem 2) If