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?
"GROUP BY" in arrays
Well i'm looking to do something i usually could do easily using COUNT and GROUP BY if it was a sql query... But this time i'm working with an array...so i have an array that looks like thisCode:
Select all entries from database that include a phrase
I have a database of clubs - one of the categories is meeting time and placeI would like to have a page that looks something like this:Monday:club1club2club3Tuesday:club1club2club3etc.and each club is
Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the return button from my preview view. the information is lost in all the textarea's. Any clue what I
check if string contain only a-z/A-Z
Is where any way to check if string contains only a-z/A-Z, without writing an array with all possible letters and then looping it.Code: $available = array('a', 'b', 'c, 'd'); //write a-zfor
Selecting an "empty" date formated field
How do you select an "empty" date field? I've tried the few ways I can think.
CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones I could give a try? I was going to script one but what I want it for was confusing me when I was
C problem struct and string
Hi guys,This is my first post and I'm hoping the experts here can help me solve my problem.- I'm trying to create a linked list in C and the codes look like this:#include "stdio.h"#include
TimeStamp Column Problem...
I'm mad at my self and thinking I'm a little retarded. It just be some one mistake I'm missing here. I coded my self a forum, when you reply to a topic, the topic's TimeStamp column is supposed to
list files from folder, only one for each date
I have many files in a folder and wish to only list one of each datethese are the file names.date format (dd/mm/yyy)abc - 12-01-2009 - something.pdfabc - 12-01-2009 - something else.pdfabc -
Calling variables
I want to call this to my website but it doesn't display what I want it to,Code: <h5>Edit Subject: <?php echo $sel_subject['menu_name']; ?></h5>If I change
