Jump to content

eisc0013

Members
  • Posts

    5
  • Joined

  • Last visited

eisc0013's Achievements

Rookie

Rookie (2/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  1. Never mind, thanks to a handy grouping feature I missed the second record that was making it appear data was coming from the wrong database (when it was actually coming from the correct DB).
  2. >$MYSQLDB = mysql_connect("localhost", "username", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db("SLVProspectsTest"); $inEmail = trim($_POST["EmailAddress"]); $query = "SELECT EmailAddress, UsrHash, AddressID FROM tblAddresses WHERE EmailAddress = '$inEmail'"; // run the query $qryResult = mysql_query($query); $qryNumRows = mysql_num_rows($qryResult); // Add Auditing information to DB $query = "INSERT INTO tblWebLogons (EmailAddress,DateLogon,Action) VALUES('$inEmail','$dtStamp','Successful Logon')"; // run the query $qryResult = mysql_query($query); mysql_close($MYSQLDB); The situation is that I have two databases on the account: SLVProspectsTest SLVProspects Test being naturally my test data set and the other being the live data. So while I'm typing away today I see that the listed code is SELECTing from SLVProspects and INSERTing into SLVProspectsTest, not a good thing! Key Info: The two databases have the same username and password. Naturally my goal is to have PHP and MySQL use the database in the mysql_select_db() call and only that database. Any help and insight is greatly appreciated.
  3. We're experiencing a new and unwelcome behavior at www.harpgamer.com/harpforum (Invision Power Board v.1.2). Users (including myself, an admin user on the IPB instance) can no longer put something like the following in a post... When the post is previewed, the following is returned (no successful preview): however, the following works just fine (I was just tinkering to see what was being 'blocked' note how all I did was mis-spell imageshack to imgshack. Any help on getting this back in order is greatly appreciated. Sincerely, Tony Eischens
  4. I've had good luck with PHP Mega Upload at a different host, have not tried it on any of my accounts here at TCH. If you get something working, please let us know.
  5. I would like the root page of my site to be default.php (or any other name with a .php extension if that is easier). How can I accomplish such a feat? Thank you.
×
×
  • Create New...