thmar

hey anyone help me with this plx. i'm doing a catalogue application loaning application. Supposingly, when i click on "Submit" button to submit my loan request, it will store the pending loan request in mySQL databse with a tablewith the following attributes: table name : loan_request table columns : "loan_no" (primary key), "grp_no" , "grp_name" , "loan_items" , "loan_quantity" , "loan_date"; I realise that this is not a working table structure because if i'm to have multiple items of different quantities, there will be a repeat of rows to be entered to database which is wrong. I cant come up with a normalised tables with these few columns, any suggestion?? Secondly, my another question is let say in my database, i got many loan request from many groups(grp) and are coming in at anytime of the day a new request comes in, how can i make it such that i got a link in my application let say "View loan request" link, i click on it and will automatically show me all the new loan request from the different groups?? thanks a million for any advice given because my dateline for this aplication is round the corner, in fact 4weeks from now, making me panic

temporary no codes have been done cox i'm oso stuck in other area of the application development

thanks for ur advice shaun I definitely going to try it out Cheers

I'm having a rather same scenerio here for weeks without getting a feasible solution, can any1 help me with this?? As i'm totally new to PHP, i tried many methods found online but got stuck at some stage e.g changing php.ini, using swiftmailer etc. So can any1 guide me along, assuming i jux installed my php and did nth to it...really apreciate it You see, i'm currently working on a web application which involve sending emails to user. I'm using windowXP SP2, with apache installed incorporate with MySQL as my server. Rite now my code for sending the mail is : <?php require_once "Mail.php"; $from = "Sandra Sender <sender@example.com>"; $to = "Ramona Recipient <recipient@example.com>"; $subject = "Hi!"; $body = "Hi,\n\nHow are you?"; $host = "smtp.yahoo.com"; $username = "smtp_username"; $password = "smtp_password"; $headers = array ('From' => $from, 'To' => $to, 'Subject' => $subject); $smtp = Mail::factory('smtp', array ('host' => $host,'auth' => true, 'username' => $username, 'password' => $password)); $mail = $smtp->send($to, $headers, $body); if (PEAR::isError($mail)) { echo("<p>" . $mail->getMessage() . "</p>"); } else { echo("<p>Message successfully sent!</p>"); } ?> As you can see, i'm trying to use yahoo as my external smtp mail server to help send my mail to my application end user. Any guidance plss??? tnx alot

I'm doing an web application,sort of a loaning equipment application, shopping cart in another word. Now, i'm stuck and figuring out an issue. My application flow is lyk dis. user apply loan->onClick submit button, a mail will be send to administrator to inform and in the mail, there is to be a link which allows the administrator to go straight into a page of my application to audit the stock(this is the step which i'm trying to figure it out) How am i suppose to do such that i can provide the link in the mail to go straight to 1 of the page in my application securely?? Can any1 help me with this tnx alot!! Cheers

hey, are you doing a application which require sending of mail to the user and you are making use of yahoo smtp to send the mail instead of having your own smtp server?? If that's the case, i'm having the same issue with u. i been looking for a solution for this for ages