fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
You really need to read more about mysql -- these questions imply that you really shouldn't be scripting blindly.
-
Ask Joomla for help about Joomla.
-
Huh?
-
Then they are not really identical, now, are they?
-
Problem with moving textboxes, checkboxes, textarea to MySQL
fenway replied to thief425's topic in MySQL Help
Sorry, TLDR -- what's the actual problem? You can't save to mysql? -
Are you really asking us what "case-insensitive" means?
-
FULLTEXT is funny -- depends how common these phrases are.
-
supplied argument is not a valid MySQL result resource? Help
fenway replied to decneo's topic in MySQL Help
The refman is your friend. -
supplied argument is not a valid MySQL result resource? Help
fenway replied to decneo's topic in MySQL Help
Then read up on the mysql_* functions in the php refman -- it seems to be igonring you. -
No, it doesn't -- just wait until you input has a comma, or you have "John" and "Johnson".
-
I'm not sure I follow -- (a) you're only asking for "theID" -- don't know what it is -- and (b) check how many matching records actually exist.
-
It's called a JOIN.
-
Huh? Dump the recordset.
-
Don't store delimited values in a single field.
-
The sticky has some great resources on various hierarchical table design considerations.
-
Problem with multiple mysql calls on a static php class
fenway replied to jesbin's topic in MySQL Help
This has to do with php's mysql functions, not the mysql server. -
I always use the equivalent of an activity column on every table that contains client data -- I can always backup or archive off-line.
-
STR_TO_DATE() works too.
-
That's a bad idea -- not thread-safe -- use auto-increment as suggested earlier.
-
A and C are identical.
-
No -- one table of answers, linked to question_id.
-
Problem with multiple mysql calls on a static php class
fenway replied to jesbin's topic in MySQL Help
I see no errors posted. -
Then you're still printing another header somewhere.
-
Why not a LEFT JOIN, then?
-
Um, a user_id column?