#mysql
24 October 2007
Total 29 pages. You are browsing page 29/29.
First :: Prev :: [...] [25] [26] [27] [28] [29] :: Next :: Last
23:19 <****> in php?
23:20 <****> Describe how it's not working; is it sitting on the sofa watching daytime tv?
23:20 <****> or is it president of the united states?
23:20 <****> :)
23:22 <****> I am trying to use #url.pageID# to save the ID as a new file on the server, which isn't working, but if I take out SELECT LAST_INSERT_ID(); then it works but saves the wrong ID to a new file.
23:22 <****> in php?
23:22 <****> Repeating the question gives us no new information
23:22 <****> sorry, my bad
23:23 <****> I mean ShawnRisk
23:23 <****> And it's your fault, not your bad. Yuck.
23:23 <****> okay
23:23 <****> i thought you meant ShawnRisk? now i'm really confused
23:23 <****> I am confused
23:24 <****> ShawnRisk: are you using php?
23:24 <****> coldfusion
23:24 <****> then i cant help, but i will suggest that modern script languages never allow two mysql statements in one query
23:24 <****> ie mysql_query("statement1;statement2;")
23:24 <****> it just does statement1, and ignores 2
23:25 <****> yep that is true
23:25 <****> but there must be a way to make it so I can do two queries
23:25 <****> yea, do two queries seperately
23:26 <****> yes but that doesn't work
23:26 <****> then switch to php, because coldfusion appears to suck
23:26 <****> in php, you just say mysql_insert_id() and you're set
23:32 <****> I create a new user. Set the host to % but cannot connect over the network with it, I am usign ubuntu 7.04
23:32 <****> remote
23:32 <****> hmmm
23:33 <****> yes, I am trying to connect remote
23:33 <****> paste the exact error
23:33 <****> is error 2003
23:33 <****> _exact_ error
23:33 <****> the_wench has some advice on that, but I cannot recall the prompt.
23:33 <****> exact and complete error message
23:33 <****> !error
23:33 <****> !doesntwork
23:33 <****> *shrug*
23:34 <****> ki77a77: she's gone...
23:34 <****> oh
23:34 <****> x3rus: make sure the firewall allows it, and make sure your my.cnf is not disallowing remote access.
23:34 <****> !tell nils_ about doesn't work
23:34 <****> where did she go?
23:34 <****> Alrighty.
23:34 <****> Flabobo: codewise for that?
23:34 <****> we need a !tell for !tells
23:34 <****> excuse me
23:34 <****> !tell ebergen about !tell
23:34 <****> But I don't know a thing about that.
23:34 <****> !tell ebergen about the_wench
23:34 <****> Alrighty.
23:34 <****> ah
23:35 <****> archivist didn't pay is internet bill :)
23:35 <****> ki77a77: which option should I check on my.cnf
23:35 <****> x3rus: comment out bind-address references
23:36 <****> Flabobo: Can you provide code for mysql_insert_id()
23:38 <****> thanks, that did the work
23:38 <****> xerus: good news indeed
23:43 <****> hi.. helpme please.. need know password for root in mysql...
23:44 <****> SQL: reset root?
23:44 <****> dkr: rest root mysql not.. need know
23:44 <****> UserReg_CL: it's a FAQ, look at the manual
23:44 <****> UserReg_CL, try english
23:44 <****> ( iam have access to server )
23:45 <****> *sigh*
23:45 <****> UserReg_CL: you can't learn root's password. you have to reset it to something you know
23:45 <****> Erm what do you call it when you use a table between two other tables that only holds id:s? I need some help but don't really know what to search for :)
23:45 <****> ok thank
23:47 <****> trifler bridging table
23:48 <****> I heard of the term pivot table
23:49 <****> that's different
23:50 <****> I'm new to this but what I'm looking for is some pointers to how to present data in a "chain". First look in this table. then look in this table for the things linked together to it by the bridged table.
23:51 <****> star schema?
23:53 <****> trifler: this is the essence of relational databases. take a look at JOIN queries.
23:54 <****> http://www.wellho.net/solutions/mysql-left-joins-to-link-three-or-more-tables.html
--- Log closed Thu Oct 25 00:00:38 2007
Total 29 pages. You are browsing page 29/29.
First :: Prev :: [...] [25] [26] [27] [28] [29] :: Next :: Last