I have a web app (mySQL and PHP) which allows people to create an item with up to 200 records which I store in a single table. Any user subscribing to that item will be pulling up to 4 records from the original 100 records each time they load a page. Sometimes the 4 records are chosen randomly and could take many selects to get 4 correct records.
I expect thousands of items to be created, which could lead to millions of records and thousands of millions (I think they call them billions) of selects.
Will this approach scale or should I be creating new tables for each set of records? This could lead to thousands of tables on the DB. Any problems there?
Auto fill in input value based on User_ID
Hello,I'm looking form some input on the following problem.User loads page -> page loads values from database and inputs them in boxes -> user edits input boxes -> new values
Problem with HTTP Caching...?
Hi there, im trying to implement caching. But it doesn't always work.I post it here because there is no Client-Side HTTP topic...Code: private function setLastModified ($aTimestamp) {
Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacingAt present my file looks like this 3 Caxxxan Maxxxet Waxxxxe Axxxxxxy Co.Kildare but after the double spacing, I
PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page will use code to pull information from a database and display it on the page in a formatted way.Code:
Match stored value with the current value in a loop
Hello,I have a MySQL db were I store articles in.I have a form to fill these articles, and in that form I can select images who are stored into a directory. Selecting the images works good but the
Varible in trigger - refering to correct schema
Hello
help with this code please?
Hello,I am trying to build a remote upload script for my image hosting site.I am using $_GET for testing purposes.this would be the url you would visit:Code:
IIS on 2003 anon access disabled issue
I have an IIS server that belongs to a domain, and anonymous access is turned off for all my sites. Users that belong to the 'WebUsers' domain group are granted access to these sites. The issue is
Adding Outlook 2007 items via file upload
I am looking for a way to be able to attach an Outlook item (an email message) in an ASP.NET 3.5 application. Similar to when in Outlook and sending an attachment, you can select either a file, or an
CE 7.1 and External GIS integration
Hi All,
