| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> hello, any1 online?
<1> me
<0> can you help me with something?
<1> depends
<0> Warning: Cannot modify header information - headers already sent by (output started at /home/lightnin/public_html/galerie/zen/functions-db.php:19)
<0> any idea why is this?
<2> u put something like echo , print before sessin start
<1> find that file (functions-db.php) and see what's on line 19
<2> or headre locatin
<3> murtz: try GROUP BY, ORDER BY or subqueries
<1> S1ckb0y: group by what?
<0> if ($const_webpath == '\\' || $const_webpath == '/') $const_webpath = '';
<0> is at 19 :D
<0> im a php noob
<0> sorry
<0> no.. sorry: echo "MySQL Error: Could not connect to the database server.<br />";
<1> S1ckb0y: mysql 4.0 is primitive = no subqueries...
<0> does that mean .. i cofigured it wrong?
<1> probably
<0> hmm
<1> look for the user / p*** of mysql
<2> can u help me with this ? http://pastebin.com/703322 i'm trying to update childs recursive, the problem is how to p*** column name to the procedure
<3> murtz : then you'll probably have to use php arrays and order the items yourself
<1> S1ckb0y: hmm... its a 1000+ rows query so it will be to slow... thanks anyway
<1> have to go to slee. ty for help. bye
<1> *sleep
<2> http://pastebin.com/703322
<2> http://pastebin.com/703346 pls help me understand mysql stored procedures
<0> yeah
<0> configured it wrong
<0> thans
<0> thanks
<0> later
<2> hello anybody here ?
<4> yah
<3> yup
<3> hey devil
<4> any1 care for some strawberries ?
<4> hello
<3> do you know if i can declare pure mysql variables outside procedures?
<3> hhehe
<4> you asked that earlier, i didnt know, because i havent used it before
<4> www.mysql.org :d
<3> did i ?
<4> also my best friend google
<4> yeap
<3> hmm
<2> yes u can declare session variables using @ symbol @x="Hello"
<4> System Up Time: 2 Days, 6 Hours, 41 Minutes, 16 Seconds
<2> SET @x="Hi";
<2> SELECT @x;
<2> result: HI
<2> i
<3> ahh
<3> just like mssql then
<3> thx
<3> im not sure what you're trying to do with that procedure micha
<2> glad 2 help u , guse someoane helpe me too
<3> what is wrong with it?
<2> i'm trying to update child with value updated in parets, it's a recursive prcedure, but not that is my question
<2> i'm trying to figure out hou to update with parameters
<3> maybe devil knows more about that
<2> i read about prepared statements ,
<2> i prepare a statement then execute it
<3> im more of the practical / visual type :P i code everything on my own but im pretty bad at fixing other people's errors :|
<2> ok,let's say i want to write a procedure that does this : UPDATE table1 SET _variable_column_name = _variable_column_name + _variable_value WHERE fieldx = 1; haow can this can be done within a procedure ?
<3> hmm i dont know sorry
<3> u should have fixed column names and have another column to store the dynamic name
<2> from what i read, on mysql.com manual, there is no other way than usin PREPARE, EXECUTE .. statement, that stores query then execute it
<3> ive never used those, sorry
<2> is a new feature of mysql , stored procedures, me neither use it, just want to know how, is a good way to optimise aplicatins, hece all queryes are on the server, reduces network traffic
<3> Fatal error: Call to undefined function mysql_connect()
<3> :/
<4> rofl
<4> apache + php on localhost ?
<3> yeah
<3> and mysql
<4> go to php.ini
<4> search mysql
<3> i did
<3> yes
<4> you`ll see a ;
<3> i uncommented the line
<4> at the begining on the line
<4> ok
<4> restart apache
<4> ;)
<3> extension=php_mysql.dll
<3> did
<4> right click
<4> still doesnt work ?
<3> nope
<4> try php.ini from /windows
<4> ;)
<3> hmm?
<3> C:\WINDOWS\php.ini
<4> some php installations planted my ini in %systemroot%
<4> start, run -> systemroot
<4> %systemroot%*
<3> its C:\WINDOWS
<4> yep
<4> look if theres a php.ini file there
<4> and edit that one
<3> its the one
<4> :)
<3> i added the .dll to the extension dir
<4> worked ?
<3> nope
<3> Fatal error: Call to undefined function mysql_connect()
<4> erm, not after restarting apache ?
<3> nope
<4> stop and start apache
<3> maybe my dll is bad
<4> nope, stop and start again your apache
<4> after you see it has stopped
<4> it takes about 20 seconds or so
<3> ahh
<4> to be sure, stop it than start again
<4> because it had happened to me
<4> to not restart properly
<3> hmm
<3> still nothing
<4> do a local search of php.ini, i think this had happened to me before
<4> dont remember how i made it work
<3> nope, only one file
<4> :-??
<5> does anyone of you guys know how to use FULLTEXT indexing?
<4> duno for sure, never used it... you can describe it
<3> d00d
<3> can u send me ur my_sql.dll ?
<3> php_mysql.php
<4> i dont have installed
<4> on localhost
<4> i think i have it on a cd
<3> hmm
<4> yay
<4> my crawler`s almost done
<4> i mean its on its way to gathering about 2190,156,268 Downloads
<4> 190,156,268* Mirrors
<4> :D
<4> i`ll make my own download site..
<3> whoa :)
<4> crawled softpedia.com before but lost the database...
<3> heh :P
<4> btw you know softpedia.com right ?
<3> nope
<4> check it :) it helps
<4> soon it will be on it-reactor.com
<4> i have to build a cms
<4> tomorrow...
Return to
#mysql
or
Go to some related
logs:
#AllNiteCafe
#teens
#chatzone
farsi funy
lamaazi
#chatzone
#c
tal monti
dOn´T sTaB oN gRaSS, sMoKe iT!
#php
|
|