[PHP-DB] php bulletin/dicussion board
Hi, can anyone recommend a good php discussion/bulletin board thats free, as I need to choose one and have been over whelmed by the variety available. Cheers Tom Hodder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] mail function
check that you have either specified [mail function] ; For Win32 only. SMTP = mail.myserver.com ; For Win32 only. sendmail_from = [EMAIL PROTECTED] or the sendmail path here; ; For Unix only. You may supply arguments as well (default: 'sendmail -t -i'). ;sendmail_path = /usr/bin/sendmail otherwise mail cannot send mail at all. -Original Message- From: Travis Cannell [mailto:[EMAIL PROTECTED]] Sent: 14 August 2001 03:27 To: [EMAIL PROTECTED] Subject: [PHP-DB] mail function hi all, I cant seem to get my mail function to work. OK so i am a noob, that might have something to do with it. I am using a script I found called the HTML Mime Mail Class, which does everything i need except actually send the mail. I am guessing that there is some config problems, but i am not sure. Even when i try and use the mail() function i get a server error. So i guess that my problem is that my return address is messed up. Does it have to be my own domain, or the domain that the server is running on? Can i set the return address as a hotmail account, or do i need my own server mail program? And is there anything that i need to config in the php.ini file? Thanks for helping, T P K Cannell -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] SELECTS from multiple tables
Hi, If I do a select from multiple tables like so SELECT * FROM, candidates, clients, jobs WHERE candidates.ID = clients.candidate_ID etc etc i then do $row = mysql_fetch_array( $results ) or die(mysql_error() ); is there any way to explicitly reference table columns ie [candidates.ID] in the result set like you can in ASP. As due to poor table column naming, there are numerous column name duplications across the tables and it would take ages to add the SELECT candidates.ID as canID, client_ID as cliID to the queries. Regards Tom Hodder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] How to tell if a mysql table is locked
I have a crontab job that locks a mysql table as it needs to process the information in it only once. But subsequent scripts don't timeout, they just sit and wait. Is there any way of telling if a mysql table is locked? Thanks Tom Hodder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] mail problem with ... Unbalanced ''
Hi, sorry if this is slightly off topic but I thought someone might have some idea of the problem. I am using the mail function like so; mail( $to, $subject, $this-mime ); where the arguments have the following values; print '$to = '.$to.\n; print '$subject = '.$subject.\n; print '$this-mime = '.$this-mime.\n; $to = Tom Hodder [EMAIL PROTECTED] $subject = htrheht $this-mime = This is a MIME encoded message. --=_ab31b28377a78eb2ae3ca4c36b9262ec Content-Type: text/plain Content-Transfer-Encoding: base64 RW50ZXIgeW91ciBQTEFJTiBURVhUIG5ld3NsZXR0ZXIgaGVyZS5FbnRlciB5b3VyIFBMQUlOIFRF WFQgbmV3c2xldHRlciBoZXJlLkVudGVyIHlvdXIgUExBSU4gVEVYVCBuZXdzbGV0dGVyIGhlcmUu RW50ZXIgeW91ciBQTEFJTiBURVhUIG5ld3NsZXR0ZXIgaGVyZS5FbnRlciB5b3VyIFBMQUlOIFRF WFQgbmV3c2xldHRlciBoZXJlLkVudGVyIHlvdXIgUExBSU4gVEVYVCBuZXdzbGV0dGVyIGhlcmUu DQoNCg0KDQpFbnRlciB5b3VyIFBMQUlOIFRFWFQgbmV3c2xldHRlciBoZXJlLkVudGVyIHlvdXIg UExBSU4gVEVYVCBuZXdzbGV0dGVyIGhlcmUuRW50ZXIgeW91ciBQTEFJTiBURVhUIG5ld3NsZXR0 ZXIgaGVyZS5FbnRlciB5b3VyIFBMQUlOIFRFWFQgbmV3c2xldHRlciBoZXJlLkVudGVyIHlvdXIg UExBSU4gVEVYVCBuZXdzbGV0dGVyIGhlcmUuDQoNCg0KRW50ZXIgeW91ciBQTEFJTiBURVhUIG5l d3NsZXR0ZXIgaGVyZS5FbnRlciB5b3VyIFBMQUlOIFRFWFQgbmV3c2xldHRlciBoZXJlLkVudGVy IHlvdXIgUExBSU4gVEVYVCBuZXdzbGV0dGVyIGhlcmUuRW50ZXIgeW91ciBQTEFJTiBURVhUIG5l d3NsZXR0ZXIgaGVyZS4= --=_ab31b28377a78eb2ae3ca4c36b9262ec-- this generates a return email with the following contents... The original message was received at Sun, 05 Aug 2001 19:48:50 +0100 - The following addresses had permanent fatal errors - [EMAIL PROTECTED] [EMAIL PROTECTED] - Transcript of session follows - ... while talking to mail.globalgold.co.uk RCPT To:[EMAIL PROTECTED] [EMAIL PROTECTED] 553 [EMAIL PROTECTED] [EMAIL PROTECTED]... Unbalanced '' I would be grateful if anyone could shed some light on this problem.. Cheers Tom Hodder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] cancel 20010723135436.90722.qmail@pb1.pair.com
What was all that about~?? -Original Message- From: Christian St-Pierre [mailto:[EMAIL PROTECTED]] Sent: 23 July 2001 16:02 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] cancel [EMAIL PROTECTED] This message was cancelled from within Mozilla. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] NEXT - PREVIOUS coding
rough and readysomething like this should work... $pagesize = 20; $page = $page ? $page : 1; $pages = ceil(mysql_num_rows( $results ) / $pagesize ); mysql_data_seek( $results, ($page - 1) * $pagesize ); while( ($row = mysql_fetch_object( $results )) ( $counter++ $pagesize) ) { // print rows of data etc etc } if( ($page 1) ) { print a href=?page=.($page + 1).Next/a; } if( ($page $pages) ( $pages 1 ) ) { print a href=?page=.($page + 1).Next/a; } -Original Message- From: Pranot Kokate [mailto:[EMAIL PROTECTED]] Sent: 16 July 2001 09:40 To: [EMAIL PROTECTED] Subject: [PHP-DB] NEXT - PREVIOUS coding hi.. friends i have a database (mysql) in which their r many records. Through PHP i want them to display on the page. Main requirement is that there should be a NEXT - PREVIOUS facility. So if there r 20 records and suppose only 10 should show up on scren at a time, then a NEXT link should be visible which could show the remaining 10 records. Their can be n no. of records. Pls help. Kind Regards, Pranot -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Re: enum !!
First normal form (1NF), A table in which the intersection of every column and record contains one, and only one, value. -Original Message- From: Hugh Bothwell [mailto:[EMAIL PROTECTED]] Sent: 16 July 2001 19:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: enum !! McShen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... how do i store multiple data in one field? i have a table like this +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | test | enum('a','b','c') | YES | | NULL| | +---+---+--+-+-+---+ insert into test values('a','b','c'); doens't work. please help Your query is mixed up; 'test' is the field name, not the table name, and I think you want to put the values into three separate records, not one... Try INSERT INTO tablename ( test ) VALUES ( 'a' ), ( 'b'), ('c'), (''); This should get you four records, with 'test' values of a, b, c, and null. If you want to store more than one value in the same record, you should be looking at sets, not enums. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Submiting forms to mySQL
You can use the TARGET attribute of the form that would be in the edit,delete,submit frame to make the main page process the form variables. ie clicking on submit in the edit frame would send the vales var1=ffefevar2=gfregr, etc etc, to the main frame. alternatively you could use the javascript onSubmit events to manage which form gets what. Regards Tom -Original Message- From: James Wharton [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 20:36 To: [EMAIL PROTECTED] Subject: [PHP-DB] Submiting forms to mySQL I would like to have a three frame webpage. The data entry would be in the main frame while the edit delete and submit buttons would be in another frame. Is this possible? I thought that you could only submit things between the form/form tags. (not things in different html or php files) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] perl fork() in PHP?
Can I do something similar to the perl fork() in php and if so, does anyone know of any examples of this. regards Tom Hodder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] imap problem
Hi, It's likely that you need to enable imap support, if you are using win32 this is relatively simple, all you have to do is get the dll from the php website and uncomment the lines from the extensions section of the php.ini file. If you are using unix, then you have to recompile php with the --imap flag (I think, something like that) although I had no end of trouble getting this to work, Regards Tom Hodder -Original Message- From: vipin chandran [mailto:[EMAIL PROTECTED]] Sent: 20 June 2001 18:54 To: [EMAIL PROTECTED] Subject: [PHP-DB] imap problem Hi, I am developing an email reader for IMAP/POP3. But I am getting the following error when trying to excute the file. I have removed the comment from the IMAP extensions in the php.ini. Fatal error: Call to undefined function: imap_open() in conn.inc on line 6 Contents of conn.inc is as below : ? $username = whoosh_vc; $password = crossroads; $mailserver = {pop.postmark.net/pop3:110}INBOX; $link = imap_open($mailserver,$username,$password); ? Please help. Thanx in advance. vipin chandran [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] php notepad
UltraEdit www.ultraedit.com cool software -Original Message- From: Sharmad Naik [mailto:[EMAIL PROTECTED]] Sent: 18 May 2001 12:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] php notepad Hi, I have recently fineshed my project in php I want to document it. Can anyone tell me an editor that highlights the code of PHP ? and another question off the way is can i get drivers anywhere for an Epson stylus Color 480 printer -Regards -- The secret of the universe is @*í!'ñ^#+ NO CARRIER ___ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]