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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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!
  15. nemini

    Populating DD box from array

    Not feeling too bright! it has to be obvious but... I am trying as per the code example to populate a DD box from an array the box picks up the correct number but each value reads "array" instead of the array value if ($quantity==1) { $q=array(1=>"1"); }; if ($quantity==2) { $q=array(1=>"1"...
  16. nemini

    Shopping Cart Script

    I do not see it as cart A) display sections and sub sections, have an icon that shows something is needed it that section or sub section (if too many pages use pagination) or even if is really really returning too many items then only show the desired items Although I like the idea of showing...
  17. nemini

    Square thumbnail php

    Could you explain, if you set $h to $w you should get a square img but how will you keep the relationship between H & W if you first do not crop it?
  18. nemini

    date to timestamp

    Thanks, you are indeed correct!
  19. nemini

    date to timestamp

    Thanks, I did not figure that out so I tested with $reg_time= date("G-i-s-m-d-Y",$regTime); and ketp the zeros in $timestamp= mktime(0,0,0,10,9,2007); Next added G-i-s value to $timestamp The final result is now as expected. However it sounds quite a long procedure to reach the desired result...

Part and Inventory Search

Back
Top