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 Chriss Miller 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
-
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. >>> -
-
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? -
Deleting account logic
Thanks all, then I will post in MySQL but will report the results here in order to finish documenting that thread -
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 &... -
Deleting account logic
I simply love it, did not think about it, simplier! Thanks -
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... -
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) ) { {... -
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... -
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>"; } -
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... -
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... -
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... -
Populating DD box from array
vacunita, Thank you, yes you are indeed correct!
