Battled a headache all day so did relatively mindless programming: added data entry fields to the new book entry page. For now, it’s got all the fields from the resource table so it can be a generic data entry page.

continue reading.....

I am teaching a Dreamweaver workshop this evening so I have to head out soon but wanted to post links to two more database queries that I’ve developed.

Author/Resource: Lists the authors and resources
Resource/Author: Lists the resources and authors
I struggled with the author query (even though I had already successfully created the resource query) because I [...]

continue reading.....

I am coding every chance I get and moving right along on the project (but oh is there PLENTY of work still to do). The basic data entry pages are done. I am going to just create a generic resource entry page that includes all the fields in the resource table. Later [...]

continue reading.....

The URl for Noter has changed slightly to http://www.simplykaren.org/noter/noter.php

continue reading.....

I have gotten past several hurdles to have at least a skeleton of a functioning database. You can add quotes related to resource and also add notes related to either quotes or resources. I’m also working on the page design and thinking about other things I want to add like a “show quotes” [...]

continue reading.....

Hard to believe it’s been two weeks since I posted anything at all but it’s not for lack of work. I decided I needed some academic work so have been reading about php. I have tinkered with the database, adding fields based on RefWorks. I have also added a page for adding [...]

continue reading.....

With just a little code review help from my husband, I was able to go to bed last name knowing that my database is working! I was able to use PHP to write to my lookup table and then do simple searches on authors, keywords, and types. I have a long list of [...]

continue reading.....

So, I have been coding every spare minute although the weather is beautiful so I took some time off yesterday afternoon and this afternoon. But I’m back at it because I feel like I am so close but I need to step back a minute and consider my issues:
I decided to call the project [...]

continue reading.....

I managed to devote more time this afternoon and have not only a database to show for it but two php pages that display information. The first one queries just the resource table for titles. The second one queries both the resource and the author tables to display titles with their authors. [...]

continue reading.....

A fruitful two hour work session! I created tables and learned to do elementary joins. I understand how to make joins between two tables that have a one to one relationship. Now I need to figure out how to query in order to get all the quotes and notes associated with a resource. [...]

continue reading.....