(My subscription to the list isn't contacting me directly, so I've been checking these
through the site and haven't been replying to the thread )
Anyway to follow-up on my question of other php/mysql apps: ( I realize this isn't a
pure freetrade project question, so I apologize in advance for any distraction from
the theme here, I am just wondering if I shouldn't stick with FreeTrade or look
elsewhere)
I have been working on a trimmed-down version of freetrade since I am familiar with
it. I can practically do everything I need with what I've done but there are some
questions and concerns (valid or not ?) about the table structures for maintenance etc.
I'll give you (Kevin & Nick) some other info about what I'm trying to do.
We are migrating about 35,000 html pages into mysql records and these 35,00 records
are broken down across all 50 States. Even though I have read that mysql will handle a
million records without a problem, the is concern that we should have a separate table
for each states' records rather than the one large (item) table that freetrade uses.
I was trying to have a "parent" table (listing all 50 states) that would then take you
into the specific state table to retrieve the records for just that State. (rather
than a department table that takes you through to one large item table).
Creating the tables is no problem & I replicated the department table structure into
50 state tables and input the data, but I'm more of a "configurer" than a php
programmer and I don't have the background to rewrite the queries in the department
files to recognize & follow this structure. I may be close or I may be a mile off ???
$department = intval($department);
file://show sub-departments
$Query = "SELECT ID, Name, Graphic, Description ";
$Query .= "FROM department "; (this would be the equivalent of the parent table with
the 50 state titles)
$Query .= "WHERE Parent=$department ";
$Query .= "ORDER BY DisplayPrecedence, Name ";
$DatabaseResult = mysql_query($Query, $DatabaseLink);
while($DatabaseRow = mysql_fetch_object($DatabaseResult))
{
(I know this needs to change but I'm not getting it)
print("<A HREF=\"" . ScreenURL("department") . "&department=$DatabaseRow->ID\">");
Again, I understand if this falls outside of the intent of the FT list, but I thought
I would throw it out there anyway.
Thanks Bob B
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev
