Is the query failing when you run it?
----- Original Message -----
From: Bob Bennett <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 31, 2001 9:25 AM
Subject: [FreeTrade-dev] followup to; other php applications
(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
_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev
