Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by nemini

  1. nemini

    Deleting account logic

    There are no problems in mixing both emgines however one should pay attention to the following <<< // from manual for best results, you should not mix different storage engines within a transaction with autocommit disabled. >>>
  2. nemini

    MySQL DB: Combo MyISAM and InnoDB is it doable, safe?

    I am in a situation where I need to implement InnoDB transaction capability. But this will call for ALTER a few tables of a DB previously set exclusively with MyISAM table engine. Is there any problem to foresee while operating a DB with a mixed table engine combo made of MyISAM & InnoDB?
  3. nemini

    Deleting account logic

    Thanks all, then I will post in MySQL but will report the results here in order to finish documenting that thread
  4. nemini

    Deleting account logic

    Yes you are correct, I use MySQL and will have to alter some tables from myISAM to InnoDB I might post to MySQL but it will spread out the thread for now the real simple last question becomes: Is there any problem to foresee while operating a DB with a mixed table engine combo made of MyISAM &...
  5. nemini

    Deleting account logic

    I simply love it, did not think about it, simplier! Thanks
  6. nemini

    Deleting account logic

    In a member driven environment I offer to the members the opportunity to delete part of or their whole account The process is quite involving Deleting/updating/inserting in six tables Opening and deleting from a video repository Opening and deleting from an img gallery As is it works fine But...
  7. nemini

    COUNT, try simplifying a query

    Your query ex made me think and I made it working, thanks. $result2 = $db->query(" SELECT COUNT( aaaa ) AS cnt, COUNT( bbbb ) AS cnt2 FROM xxxxx WHERE productId = '6' AND customer_id = '$id' "); $check=$db->num_rows($result2); if($check >0 ) while ($row=$db->fetch_array($result2) ) { {...
  8. nemini

    COUNT, try simplifying a query

    Thank you, my biggest problem is that I may not use (*) reason is (Sorry, I should have precised) I need actually to select and count two different cols from the table with the same condition (productId and customer_id) then I will compare which col/rows is equal or non equal to the other one so...
  9. nemini

    COUNT, try simplifying a query

    The following should work (I suppose) but is resulting in empty result $result2 = $db->query(" SELECT productId FROM xxxxx WHERE productId = '6' AND customer_id = '$id' "); $check=$db->num_rows($result2); if($check >0 ) { $check1=$result2['COUNT(productId)']; echo"check1: $check1<P>"; }
  10. nemini

    foreach with single element

    I found my error The rest of the script is under the influence of a quantity that I got from $aaa=$_FILES[‘image_file’] which was reading all components of the file (5) although I was passing only one img Not a good idea to do as I did! Be sure (if testing for a quantity) to check for only a...
  11. nemini

    foreach with single element

    On a few hundred of lines I call a foreach quite a few times (Checking img file) It works fine in a multiple files environment But if the user enters only one element then the foreach runs one too many time and adds an empty element How could I go around that problem, do I have to set a switch...
  12. nemini

    PHPMAILER

    What comes in mind first is: Is the server setup to allow for outside communications, or does not accept mail from the IP you try to access. Are you running fedora? if so add to the Kernel command line selinux=0 BTW is fsockopen enabled on your account? I did a search and that pretty much...
  13. nemini

    PHPMAILER

    Try this, using an alternate port includes/phpmailer/class.smtp.php - set var $SMTP_PORT = 2525; includes/phpmailer/class.phpmailer.php - set var $Port =2525;
  14. nemini

    Populating DD box from array

    vacunita, Thank you, yes you are indeed correct!

Part and Inventory Search

Back
Top