SimonJM
Contributing User
Devshed Regular (2000 - 2499 posts)
- Join Date
- March 10th, 2006
- Last Activity
- Today 04:39 AM
-
Older Activity
-
For a start you seem to be missing the actual part where you execute the query held in the string :)Today, 04:39 AM2 replies | 22 view(s) -
A key is an index, just a different term for the same thing. I'm a little surprised a table does not have an index as most tables have, at the...Today, 04:31 AM11 replies | 148 view(s)
-
That's good news! And is the index problem resolved?April 16th, 2014, 07:03 PM11 replies | 148 view(s)
-
Where they created (however you did it) with the database shut down, or using a product that understands open databases? I suspect a lot will depend...April 16th, 2014, 10:41 AM11 replies | 148 view(s)
-
Losing data is bad ... you may have manged to get a similar effect by exporting the table before doing the truncation, etc.April 15th, 2014, 04:37 PM11 replies | 148 view(s)
-
If you do a show create table (there may be other ways) you sghoudl see what indexes are defined on the table. My suggestion, as the error implies a...April 15th, 2014, 09:12 AM11 replies | 148 view(s)
-
No idea which 'is better', but stylistically (to me) as well as logically (for me) the first - the while (true) is better.April 15th, 2014, 09:11 AM3 replies | 88 view(s)
-
Most of what I found suggested concurrency problems, issues caused upgrade from earlier mySQL versions and/or disk space (or rather lack thereof!)...April 15th, 2014, 07:20 AM11 replies | 148 view(s)
-
Tidied up a bit and with consistent indents, can you see any paths through the php that could be wrong or provide no output? Hints - what would...April 13th, 2014, 03:31 PM9 replies | 188 view(s)
-
Um ... 'has the PHP disabled' .. and 'the PHP is blank' ... er, just what are you expecting to happen?April 13th, 2014, 01:33 PM9 replies | 188 view(s)
-
If you are IN the mysql command line client (with a mysql> prompt) then you don't need to type mysql anything! 'All' you need do is connect to your...April 13th, 2014, 11:27 AM4 replies | 215 view(s)
-
Horrible indentation for a start. Where does the variable email_b suddenly come from? Why do you have a "is not set" condition with a 'blank' code...April 13th, 2014, 11:25 AM9 replies | 188 view(s)
-
SimonJM replied to a thread Getting rid of undefined variable errors from queries that return no results in PHP DevelopmentWhat I mean is: zero could be seen as there being no entries for those criteria used in the WHERE condition, or it could mean that there are entries...April 11th, 2014, 04:06 AM7 replies | 264 view(s)
-
SimonJM replied to a thread Getting rid of undefined variable errors from queries that return no results in PHP DevelopmentIt all depends on what you need - is zero a valid indicator of 'not having any entries'? You do realise that if you return more than one row in the...April 9th, 2014, 05:48 AM7 replies | 264 view(s)
-
SimonJM replied to a thread PHP code to pass selected checkbox for comparison with MYSQL database in PHP DevelopmentAs a passing point, once you get to fixing all the security issues, the sytntax for the 'IN' keyword is IN (value1,value2,...) As you look to have...April 8th, 2014, 07:23 AM9 replies | 278 view(s)
-
Having multiple instances of the same thing (such as different versions) is possible, indeed often very simple. All you need ensure is that...April 8th, 2014, 07:16 AM3 replies | 155 view(s)
-
Answered in the cross-postApril 7th, 2014, 02:26 PM3 replies | 155 view(s)
-
It is telling you that $data is not point to the object thingy of a valid mySQL query return. To me that imples the query is failing. A quick look...April 1st, 2014, 06:04 PM3 replies | 196 view(s)
-
Pretty much my thoughts (less the caching aspect). A SHOW CREATE TABLE is better than DESC, as it will show actual INDEX definitionsApril 1st, 2014, 06:01 PM2 replies | 127 view(s)
-
At which point, can we see a SHOW CREATE TABLE for each table?March 30th, 2014, 03:19 AM4 replies | 197 view(s)
-
Have you tried the SELECT from the mySQL command line (or from within phpmyadmin or some other gui)? In essence, are there any error messages?March 28th, 2014, 10:42 AM4 replies | 197 view(s)
-
You are almost there - each link table will have but one doctor id and one speciality id and your query (when properly constructed) will return, for...March 27th, 2014, 01:44 PM2 replies | 145 view(s)
-
Never really had to bother about that and not noticed the 'lazy updating'. I suspect the data is in memory, waiting to be written out to the file at...March 26th, 2014, 03:35 AM1 replies | 336 view(s)
-
I think (know?) I was an idiot -you'll need to GROUP BY Run as well - so GROUP BY `End Date`, RunMarch 25th, 2014, 10:35 AM3 replies | 174 view(s)
-
By saying 'for each day' says you will want to look at GROUP BY as that will allow you to use various aggregate functions such as SUM(). The...March 25th, 2014, 04:56 AM3 replies | 174 view(s)
-
I wholly agree, but at least it does touch upon cryptography ;)March 23rd, 2014, 08:25 AM7 replies | 469 view(s)
-
Not very php-based ;)March 23rd, 2014, 06:06 AM7 replies | 469 view(s)
-
SimonJM replied to a thread Am I nuts? Way too old? A little too old? (this one is different than the others) in Dev Shed LoungeIt sounds like you have a goal. My only conern would be over your ripping yourself away from the cloested halls of academe and actually taking that...March 20th, 2014, 05:08 AM9 replies | 457 view(s)
-
SimonJM replied to a thread Am I nuts? Way too old? A little too old? (this one is different than the others) in Dev Shed LoungeYou sound sane and intelligent enough to either know if you are just being a 'big kid' and acting out a dilettante's fantasy, or to react in a proper...March 19th, 2014, 04:51 PM9 replies | 457 view(s)
-
SimonJM replied to a thread Am I nuts? Way too old? A little too old? (this one is different than the others) in Dev Shed LoungeNo worries - one of the cardinal crimes that will tend to put people off responding is 'bumping' your own thread. After the little dig, done in good...March 19th, 2014, 11:12 AM9 replies | 457 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
How to combine sha-1 and md5
March 7th, 201404:14 AMUser / Points
You gave -10 toComment
Off topic and cross-posted -
Thread / Date
The Milestone Posting Thread
February 18th, 201402:33 PMUser / Points
You gave 12 toComment
No Comment Made -
Thread / Date
Issue with POST. Is it an array or not?
February 14th, 201408:44 AMUser / Points
You gave 0 toComment
Not just me 'scared' by all this? ^_^ -
Thread / Date
Authenticate and delete member photo.
January 7th, 201403:05 AMUser / Points
You gave 200 toComment
How very true. I have had to arrange recovery of *multiple* files for a user. FOllowed 30 minutes later by the same request as he'd done it again, by mistake. Again! -
Thread / Date
Persistent data. Completely persistent data.
December 31st, 201308:06 AMUser / Points
You gave 387 toComment
Nicely put -
Thread / Date
I am lost with how to use function value in another function
December 22nd, 201306:26 PMUser / Points
You gave 23 toComment
Nice to see someone listening to sage advice
-
Thread / Date
I am lost with how to use function value in another function
December 22nd, 201306:25 PMUser / Points
You gave 23 toComment
Rep by proxy -
Thread / Date
The Milestone Posting Thread
December 18th, 201304:27 AMUser / Points
You gave 286 toComment
No Comment Made -
Thread / Date
Need details please?
December 4th, 201309:38 AMUser / Points
You gave 198 toComment
Rep by proxy
-
Thread / Date
The Milestone Posting Thread
November 2nd, 201311:31 PMUser / Points
You gave 173 toComment
No Comment Made
Latest Reputation Received 167716 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Incorrect key file for table 'vendors'; try to repair it
April 16th, 201406:10 PMUser / Points
You recieved 173 fromComment
No Comment Made -
Thread / Date
-bash: ./g3-from-scratch.csh: Permission denied
March 20th, 201402:29 PMUser / Points
You recieved 173 fromComment
No Comment Made -
Thread / Date
Loops In Python
March 5th, 201406:25 PMUser / Points
You recieved 173 fromComment
The colon is all. -
Thread / Date
Issue with POST. Is it an array or not?
February 13th, 201409:54 AMUser / Points
You recieved 173 fromComment
Interesting -
Thread / Date
Help Speeding up query
February 11th, 201411:18 AMUser / Points
You recieved 173 fromComment
Simon took the time to help me understand what I was missing and narrow down my issue. -
Thread / Date
String manipulation
February 2nd, 201405:45 PMUser / Points
You recieved 173 fromComment
No Comment Made -
Thread / Date
How to check if I have read/write errors?
January 30th, 201408:07 AMUser / Points
You recieved 173 fromComment
No Comment Made -
Thread / Date
Shell Script(simple problem)!!! [moved from PHP]
January 7th, 201403:41 AMUser / Points
You recieved 173 fromComment
Thanks. -
Thread / Date
Preserving battery life?
January 2nd, 201402:59 AMUser / Points
You recieved 173 fromComment
No Comment Made -
Thread / Date
How to check which users have access to root and su command
December 11th, 201303:32 PMUser / Points
You recieved 173 fromComment
No Comment Made
