Jump to content

I-AM-OBODO

Members
  • Content Count

    361
  • Joined

  • Last visited

Community Reputation

1 Neutral

About I-AM-OBODO

  • Rank
    Advanced Member

Contact Methods

  • AIM
    funkyfel
  • MSN
    funkyfela
  • Yahoo
    funkyfela
  • Skype
    chidi.james

Profile Information

  • Gender
    Male
  • Location
    Nigeria
  • Interests
    Computer, Playing Video Games, Learning
  1. I-AM-OBODO

    Database not connecting again!!!

    Will do. Thanks
  2. I-AM-OBODO

    Database not connecting again!!!

    Thanks all. Seen the problem. It was from an a file i included. It was obsolete. Uses mysql instead of mysqli. Problem resolved. Thanks
  3. I-AM-OBODO

    Database not connecting again!!!

    ok. Will do. Thanks
  4. I-AM-OBODO

    Database not connecting again!!!

    Dont know if its off or on (live) but on my local server everything is working just fine
  5. I-AM-OBODO

    Database not connecting again!!!

    Its showing just blank page
  6. Hi all. My database just stopped connecting? I have tried everything i could but no way! When i login to the page, it shows just blank page. So i started trying to figure out what could be the problem by disabling some included files. Then i discovered the problem is from my database connection. I re-uploaded the files and still not working (still blank) What could have happened and what can i do? I even went as far as creating the database connection inside the page to see if it will work but still no way! Thanks
  7. I-AM-OBODO

    Sending mail from multiple table

    Yeah. I know PHPMailer will save resource, that is what i initially planned to use but the loop is where i have problem so i just decided to use the mail() function. How will the loop look like?
  8. I-AM-OBODO

    Sending mail from multiple table

    Thanks
  9. I-AM-OBODO

    Sending mail from multiple table

    Was thinking there's a way i could do a select and send mails instead multiple sendmail
  10. Hi guys, Whats the best way of sending mails from multiple table? This is what i did, but i feel there should be a better way of doing it cos sometime it delivers and sometimes it doesn't (don't know why though). Thanks $subj="New Sign up Notification"; $header="MIME-Version: 1.0" . "\r\n"; $header .="Content-type:text/html;charset=UTF-8" . "\r\n"; $header .="From: GOODGUYS<noreply@yoyo.com>"; //TABLE 1 $t1 = "table1"; $stmt = $pdo->query(" SELECT t1_email, t1_name FROM $t1 "); while($rows = $stmt->fetch(PDO::FETCH_ASSOC)){ $t1_name = $rows['t1_name']; $t1_email = $rows['t1_email']; $t1_msg =" <html> <body> <h3>Subject: News</h3> <p> Hi $t1_name, <br> This is a message to you blah blah blah </p> <p> Thank you.<br> </p> </body> </html> "; mail($t1_email,$subj,$t1_msg,$header); } //TABLE 2 $t2 = "table2"; $stmt = $pdo->query(" SELECT t2_email, t2_name FROM $t2 "); while($rows = $stmt->fetch(PDO::FETCH_ASSOC)){ $t2_name = $rows['t2_name']; $t2_email = $rows['t2_email']; $t2_msg =" <html> <body> <h3>Subject: News</h3> <p> Hi $t2_name, <br> This is a message to you blah blah blah </p> <p> Thank you.<br> </p> </body> </html> "; mail($t2_email,$subj,$t2_msg,$header); } //TABLE 3 $t3 = "table3"; $stmt = $pdo->query(" SELECT t3_email, t3_name FROM $t3 "); while($rows = $stmt->fetch(PDO::FETCH_ASSOC)){ $t3_name = $rows['t3_name']; $t3_email = $rows['t3_email']; $t2_msg =" <html> <body> <h3>Subject: News</h3> <p> Hi $t3_name, <br> This is a message to you blah blah blah </p> <p> Thank you.<br> </p> </body> </html> "; mail($t3_email,$subj,$t3_msg,$header); }
  11. I-AM-OBODO

    Update Column with unique value

    Thanks. I have updated the column. But my question now is what will be best to generate a random number to avoid duplicate? or should something; if duplicate entry, regenerate a another code. something of that nature. just asking.
  12. I-AM-OBODO

    Update Column with unique value

    Thanks. will try that out. how do you mean assigning value of a counter?
  13. I-AM-OBODO

    Update Column with unique value

    Thanks
  14. I-AM-OBODO

    Update Column with unique value

    Thanks. But it seems you don't understand what i want or trying to say. But i guess i will just have to start creating the table afresh. The only issue i have now is that if mt_rand doesn't guarantee uniqueness, how can one create/generate a unique id then outside the primary key? Thanks all the same
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.