[PHP-DB] Problems with MySQL inserts

the script in case you want to check it out.. Any ideas anyone? Thanks Jon Jon Farmer Systems Programmer Entanet International Ltd www.enta.net Tel 01952 428969 Mob 07968 524175 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

RE: [PHP-DB] mkdir permission

in the ini file that allows permission for this? No. It's because the user account that the webserver is running under has no permissions to create a new directory there. You need to chown or chmod to correct this. Regards Jon Jon Farmer Systems Programmer Entanet International Ltd www.enta.net Tel

RE: [PHP-DB] Re: Show abbreviated article

NO! This will return the first 20 characters from the field not the first 20 words. To do that you need to use a regexp in the SQL or explode the result in php and use the first 20 elements of the array! Regards Jon Farmer Systems Programmer Entanet International Ltd www.enta.net Tel 01952

RE: [PHP-DB] query question

The only way i could think of doing this is to loop through $result and assign the rows you want to keep to a new array. -- Jon Farmer տլ Systems Programmer, Entanet www.enta.net Tel +44 (0)1952 428969 Mob +44 (0)7968 524175 PGP Key available, send blank email to [EMAIL PROTECTED

RE: [PHP-DB] query question

See http://www.php.net/manual/en/ref.array.php You will need a multi-dimensional array if your resultset has more than one field Regards Jon -- Jon Farmer տլ Systems Programmer, Entanet www.enta.net Tel +44 (0)1952 428969 Mob +44 (0)7968 524175 PGP Key available, send blank email to [EMAIL

Re: [PHP-DB] Re: log out

You need to capitalize the 'L' in Location (HTTP headers are case-sensitive). Wrong... you can use header(location: index.php); just fine... Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send blank email to [EMAIL

Re: [PHP-DB] Creating a file using php

- Original Message - Polite: Well its easier to post and get a reply rather then me going and serching fo it.;) Easier for who? Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send blank email to [EMAIL

Re: [PHP-DB] Need help with duplicate entries

Use a Select Distinct. query. See www.mysql.com/doc for more info -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send blank email to [EMAIL PROTECTED] - Original Message - From: Chris Payne To: [EMAIL PROTECTED

RE: [PHP-DB] Excel to Mysql

Is it possible to migrate data into a table in MS Excel to MySQL? Export to csv from excel and the mysqlimport command is your friend Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key

Re: [PHP-DB] Flushing PHP output

javascript command to update the header telling the user what domain it is checking at the moment. Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key -- PHP Database Mailing List (http

Re: [PHP-DB] Flushing PHP output

. Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [PHP-DB] query to check valid emails

No this will not do what the original poster requested it will be something like the following select * from table where email regexp ^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$; Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob

Re: [PHP-DB] JOIN Very SLOW...

I would suggest changing COUNT(*) to COUNT(properties.PropertyID) Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key - Original Message - From: Martin E. Koss [EMAIL PROTECTED

Re: [PHP-DB] MySQL table recovery.

if it's forget it, no way... If this was a transaction then you can rollback if not then forget it Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key - Original Message - -- PHP

Re: [PHP-DB] Image Sizes

size. You cant do this with PHP. You need to use a client side script (javascript) to determine the screen res and then pass that pack to PHP either through the query string or a form post. Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP

Re: [PHP-DB] Database query

Sorry the second elseif statement should have ended with : not ; -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key - Original Message - From: Jon Farmer [EMAIL PROTECTED] To: [EMAIL PROTECTED

Re: [PHP-DB] Run php page automatically

it's better to do something like 0,10,20,30,40,50 * * * * /usr/bin/php -q /home/you/yourscript.php /dev/null or even */10 * * * * /home/you/yourscript.php /dev/null with the first line of you php script being #!/path/to/php -q -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] Problem with mail function

Hi Faye Maybe I shouldn't be trying to send that many emails at a time. I am on apache using mysql and php... -- put the line set_time_limit(0); at the top of your PHP script Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key

[PHP-DB] Re: [PHP] Connecting from PHP to MySQL on another Server

to MSSQL Server? See above answer. Also you have any TCP/IP overhead to add on. Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] 1 query or 2 queries

Yes, Do a join on the two tables and only pull the book data from the first record. -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key - Original Message - From: George Pitcher [EMAIL