Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
7
Newest
 Teacher
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
1d
awarded  Teacher
Sep
3
comment Storing html in mysql text fields, or include files? (html formatted articles)
No worries. Always good to get input regarding coding patterns and such for better usability...
Sep
3
awarded  Scholar
Sep
3
accepted Storing html in mysql text fields, or include files? (html formatted articles)
Sep
3
comment Storing html in mysql text fields, or include files? (html formatted articles)
Thanks. I'm familiar with MVC. This platform does not use it though, but regardless of that, you answered my question.
Sep
3
comment Storing html in mysql text fields, or include files? (html formatted articles)
I would have to store some article data i a database either way because of accociated details (author, category, title, query url etc.) But was simply wondering if I should put the html-formatted article body in its own file, and request that file instead of having it directly in database?
Sep
3
awarded  Student
Sep
3
asked Storing html in mysql text fields, or include files? (html formatted articles)
Mar
12
asked is it bad practice to do a loop to see if a url parameter is set?
Oct
11
awarded  Tumbleweed
Feb
9
comment How can I push data from my local MAMP database to my remote database?
the remote server is where the site is stored online - Bluehost in my case. And there I have a database that is identical to the database locally on my machine - MAMP. When I update the database locally, I would like to somehow update the database online at the end of the day. The site is running against the database on Bluehost - which is what I refer to as "remote server". Did that clear things up a bit?
Feb
9
asked How can I push data from my local MAMP database to my remote database?
Jan
21
comment Would it be better to do a sepparate query instead of a left JOIN?
@ShlomiNoach, sorry about that..
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
Very well then. Knowing nothing was much better than knowing a litte. Everything was easier back then.. Anyway; Thanks for taking your time to reply. Helped a lot..
Jan
16
awarded  Commentator
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
Thanks Jon. But I have to ask, before I waste a whole lot of time with this one thing: No matter how I query - join tables together - I always get one record with type:ALL. Is this correct? Like the one in the image I've put in my question. The same happens when I try to query from the _rel_-tables, and joining the associated tables. The tags/raw_materials get eq_ref while the recipes is set to ALL. the _rel_-tables is set to ref and extra:using index. in both cases..
Jan
16
revised Would it be better to do a sepparate query instead of a left JOIN?
Tried out EXPLAIN
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
How would I expand an index to cover both fk_recipes_id and in_use?
Jan
16
comment Would it be better to do a sepparate query instead of a left JOIN?
How do I analyze a query? Never done something like that before, but would be interresting to know. As I mentioned; I'm primarly working in MySQL Workbench..
Jan
16
awarded  Editor