Acute Chaos

Thanks. When you are a novice it is impossible sometimes to weigh through opinion to make a decision. Only solid experience, failures and successes get you there and some failures you can't afford! I've read so many articles and been through so many forums and everyone seems to contradict each other with opinions instead of straight out facts. Your link had some good info and also linked to another one that helped a bit. Thanks again.

Advice please. I am setting up a new machine here and I can't remember which to download. What information do you need to be aware of to know whether to install 'non thread safe' or 'thread safe'. I did some googling but didn't find anything that was clear. And is 5.3 good to go or should I stick with 5.2. Thanks in advance for your input!

Thanks folks. I was hoping I could just pull all the emails out, throw them in an array, and send out the email that way. That sounds like what you guys did Doug? But I gotta give them other options to. I'll look into your options hippy and see if I can save myself some work. Appreciate it!

Hey all - I have a member site I am building (PHP/MYSQL). I have an email address for each member in the database. I want to be able to send out emails to all of them at once but don't know how to go about it. I will contact the host to ensure that we can do this volume of outgoing at one time. (about 5,000) Can this be done simply enough with a personalized script or should I look to a predone service? What I'd like to do specifically: In the admin site I put together the administrator can add/edit/delete members etc. I would like to be able to offer another link "Email Members'. The option would take them to a page where they add the content of the email to a field and any attachment they might have and a 'send' button. I tried to google help on this but I wasn't getting any of the help I need. Thanks for your time and insight!!

Thanks PFMaGiSmAd! I really appreciate the help. Once explained well I totally see the issue and it is working perfectly now. It is remedial but when you are at my level (and age...) things don't always stand out. I'm getting there thanks to folks like you and Zanus taking the time to spell it out for noobs like me. There's lot I can help others in but not this! lol NOTE: xyph if you are so far above someone that responding to their posts leaves you with nothing but the need to belittle and get frustrated that we aren't all as great as you, you should consider just skipping over posts as 'glaringly obvious' as mine and stick to saving the world with bigger problems. This forum and the contributors have been a brilliant help to me as I try to find my through php and mysql. Today is the first day I really feel like I ran into a knob. Thanks again for all the help guys!

Thanks Zanus - Makes sense now. I appreciate the clarity. I did what you said and my error is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1 There are three pages working here: The form page, the exe page, and the final destination page when successful. I don't see anything wrong at the beginning of any of the pages. Form page and destination pages have the same first few lines: <?php session_start(); ?> <!DOCTYPE... The exe page that I've been posting code from - first few lines: <?php session_start(); require_once('config.php'); $errmsg_arr = array(); Any ideas? Thanks.

I am very new to this and am using tutorials and examples to get me going, so nothing is 'pretty obvious' to me at this point. That is why I am here looking for help. This code is a reworked example I was experimenting with in a tutorial. I understand most of what I have going here but there are a few lines I don't - I assume @mysql_free_result($result); and $result = @mysql_query($qry); are the suppressors you are refering to? Either way I am still looking for help to fix my problem. Anyone? Thanks!

I posted problems earlier and I got them working except for one issue... When this code runs it puts the information into the database perfectly but the user gets a returned error message saying the final query failed. I can't figure out why it says it failed when it worked?! I am building a member site that members must register at before using. I have already in the db - their firstname, lastname and an id number (unique number). The plan is to have them supply their first name, last name, id number, email address and password when they register and authenticate who they are with the information I already have. If they have all three bits of information matching the database we add the email address and password they supply and send them to the log in page. This is what I have: if($login != '') { $qry = "SELECT fname, lname, login FROM user WHERE fname='$fname' AND lname='$lname' AND login='$login'"; $result = mysql_query($qry); if($result) { if(mysql_num_rows($result) != 1) { $errmsg_arr[] = 'This didn't work try again'; $errflag = true; } @mysql_free_result($result); } else { die("Query failed - 1"); } } if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: register-form.php"); exit(); } // $qry = "INSERT INTO user (email, password) VALUES ('$email', '".md5($_POST['password'])."')"; $qry = mysql_query("UPDATE user SET email='$email', password='".md5($_POST['password'])."' WHERE login='$login'"); $result = @mysql_query($qry); if($result) { header("location: register-success.php"); exit(); }else { die("Query failed - 2"); } It is the 'query failed - 2' that is displayed after the form is submitted but... the information updates in the db perfectly. The register-success.php has no code to counter anything. At this point is just says great you made it here. (except i don't lol) Please help me! thanks.

OK! so I am good and past that hurdle. The query works but when I get to the next step where the extra bits of info I am gathering are to be inserted into the database I get "Query failed here2". $qry = "INSERT INTO user (email, password) VALUES ('$email', '".md5($_POST['password'])."')"; $result = @mysql_query($qry); if($result) { header("location: register-success.php"); exit(); }else { die("Query failed here2"); } Other than the fact I haven't separated the login in info and the other info into two separate tables yet... Should this not work? Thanks!! Both sets of code together: if($login != '') { $qry = "SELECT fname, lname, login FROM user WHERE fname='$fname' AND lname='$lname' AND login='$login'"; $result = mysql_query($qry); if($result) { if(mysql_num_rows($result) != 1) { $errmsg_arr[] = 'this doesn't work try again'; $errflag = true; } @mysql_free_result($result); } else { die("Query failed here1"); } } if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: register-form.php"); exit(); } $qry = "INSERT INTO user (email, password) VALUES ('$email', '".md5($_POST['password'])."')"; $result = @mysql_query($qry); if($result) { header("location: register-success.php"); exit(); }else { die("Query failed here2"); } Thanks for any help. If I can get past this... I'm almost there!

I might have to rethink this whole thing... I am reallllly new to this and I'm trying to put together this going through tutorials and examples I can find online. I am starting with three bits of information about a member in the database to begin with before any registration has begun as I am creating something for a specific group. When they come to register at the site I was going to use that information to verify who they were before allowing them to continue with the registration. So this part of the code was to authenticate the user before updating the database with a couple other require bits of info in the registration form. Is there an obvious thing I'm missing here? tx

Ok but regardless of my lack of coding knowledge here (which is extensive - the lack that is...) If it returns only the records then if the three fields match up successfully it should return 1 record, right? So if I change this to == 1 - that should work right? thanks

God help me, I can't even get the syntax right today to echo out the results. I'm such a noob.

If the fname, lname and id the user fills into the form match what is in the database I want this to go on to the next bit of code but... even though they are a match I am getting the error message that 'this doesn't work try again'. if($login != '') { $qry = "SELECT fname, lname, login FROM user WHERE fname='$fname' AND lname='$lname' AND login='$login'"; $result = mysql_query($qry); if($result) { if(mysql_num_rows($result) != 3) { $errmsg_arr[] = 'this doesn't work try again'; $errflag = true; } @mysql_free_result($result); } else { die("Query failed"); } } Is my !=3 wrong? I figure this should return 3 rows, no? So if the result doesn't equal 3 then something went wrong and the code shouldn't continue. That was my logic. Where have I gone wrong!!?? Thanks for any help!

I am in no way qualified to give advice on coding as my time spent here is getting help But - I found this example very helpful and have learned a lot from it. http://phpsense.com/php/php-login-script.html Good luck - there is a lot to learn as I have found in the last few months!

cool - thanks again