#mysql - Sat 21 Apr 2007 between 00:15 and 00:44

NY Lost Funds



mnguyenI want to find all tuples with all path attributes that start with http://www.kairoschurch.org/beta, i tried SELECT * FROM `menu` WHERE path='http://www.kairoschurch.org/beta*' but it didn't work
how do i do that?
CapriSkyepath attributes?
mnguyen*attribute
CapriSkyepath attribute?
mnguyenCapriSkye: so a column in a table... where the column name is path.
zilly6mnguyen try LIKE
IAW9761hi folks
the_wenchDont forget the bots
SteveLSorry... ok, the Products contain a distinct ID. I would like to combine all three columns in to a single row and run a frequency stat on it.
statistic
zilly6frequency statistic? how oftern 3, 7, 6 occur?
XgcSteveL: Columns are already in rows.
zilly6like lets take an example of each user can upload his own css sheet
musyaok
zilly6it's ok to store it in the db, but it would be a great idea to cache the css file
in addition
because that way you don't need to do php->mysql->php->html->apache
musyahows caching any differnt? or what does it do?
oh
zilly6cache would be like this, when the css markup is submitted the storing would take it, write it to a file and place it in a directory and record the path
musyaok, well say if i want to have only one index.php site, and the rest of the content is loaded from a database so the user doesnt have to load everything again, sort of like joomla...its a CMS.
zilly6all thats left is the user's page (that uses the css) is requested and in the <link> that grabs the css it grabs the file directly
you keep saying the user doesn't have to load everything again
that's not possible
on the client (firefox/ie) user is always reloading
cms don't work completely like you're saying,
they do store page info into a db
musyaso then why does joomla store everything in a DB?
zilly6but there's a lot of (unneccessary) complex code to pull those pages out
rycarI have two tables. the first with a primary key and a boolean. The second with a list of some of the primary keys in the first table. I want to change the booleans in the first table if they are listed in the second table. How do I do this?
zilly6joomla stores pages into a db, of course, but it's not the best method
musya, what is your end goal
musyajust too not have a bunch of .php files lying around
and eventually i want to be able to create an editor the edit the page
kind of like joomla does
zilly6musya, that's not your end goal, what site are you building?
rycar what information do you have?
rycar you just want to loop through the table in the second list and update the first table?
musyawell any site really,

Page: 2 9 16 23 30 

IrcArchive

NY Lost Funds