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&quo

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

mote server or PHP 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:

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 07

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.ne

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]

Re: [PHP-DB] Database query

!= ""): //construct variable with sql statement elseif ($location !="" && $discipline == ""); //construct variable with sql statement else : // nothing selected endif; hth Jon -- Jon Farmer Systems Programmer, Entanet www.e

Re: [PHP-DB] Image Sizes

olve it but it only works when I physically hit the > refresh button on the browser. OK well can you show us the code? As you dont give much to go on. BTW you are posting to the wrong list you should use the PHP-General list as this list is for database issues. -- Jon Farmer Systems Programmer, Entane

Re: [PHP-DB] Image Sizes

ermining the screen 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

Re: [PHP-DB] MySQL table recovery.

se yet. > > Thank for any help, even 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 s

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&quo

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

Re: [PHP-DB] Flushing PHP output

call, then flush and they will display fine. 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 PROT

Re: [PHP-DB] Flushing PHP output

each flush it sends a new 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 Da

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

Re: [PHP-DB] image content in mail().

> Who can I send an HTML e-mail with a image with mail()? Can PHP encode the > image for This question has been covered many times on ths list check the archives http://groups.google.com/groups?q=&hl=en&btnG=Google+Search&meta=group%3Dphp .general Regards Jon --

Re: [PHP-DB] JOBS in mysql

Write a commandline php script to do the job you want and then add the following to your crontab assuming you are on unix of course */10 * * * * /path/to/script Regards jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send blank

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

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

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 PG

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] 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] 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] mkdir permission

change it myself, >is there a specific entry 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 Farme

[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