Re: limiting a select

2002-03-30 Thread Chris Adams
CT * FROM $theTable LIMIT ($limitBegin, $ limitEnd) "; /* selectAllSQL is a string. to test echo "selectAllSQL = $selectAllSQL'; */ $r = mysql_query($selectAllSQL); Hope this helps: Chris -- Chris Adams Cypress Lake Studios Hypermedia, Quicktime, and Internet Design http:

Re: Database Design Question

2002-03-28 Thread Chris Adams
ngle row in the list entry table and a "DELETE FROM linkingTable WHERE listEntryID=$whatever". You probably would not have to sacrifice speed for flexibility: in small tables (<200 records with an index) this type of operation takes less than .001 of a second on my (shared) server