update query confusion

'? * title VARCHAR * text TEXT I need the date col to remain the same, what am I doing wrong? Much thanks... - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CeQ3HpvrrTa6L5oRAp4KAKCeXaGZg7U2GK9HvSvincd+hZytFgCgqG3l

Re: update query confusion

ignores the update for efficiency.) *You explicitly set the TIMESTAMP column to NULL. HTH! Sure does, cheers Jay. - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CfkZHpvrrTa6L5oRAlgCAJ47bPK5shotAZek3a8p7Fw8ZqoyFACgq8JV

duplicate entries mystery

, user, pass); mysql_select_db(dbmt); $result=mysql_query($qry); As you can see, there is nothing special there... So what would cause it to insert *2* records? Many thanks... - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: duplicate entries mystery

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Nick Wilson declared I'm having some weirdness when inserting from the php api, I do not get the same results if I use the mysql server directly. Here is the code: Please disregard. It appears to be some bizzare Apache/http thing

use of substring()

tried this sql: SELECT date, SUBSTRING(text, 0,30) as description FROM table WHERE id = '2'; to no avail. Could someone please explain what I *should* be doing? Many thanks... - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: use of substring()

anyway. Here is what I've get: You have an error in your SQL syntax near 'desc FROM news ORDER BY date ' at line 1 That comes from exactly what you have above, it works without the 'as desc' part but then I have no way to get at it? Cheers... - -- Nick Wilson // www.tioka.com -BEGIN

Re: use of substring()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Nick Wilson declared You have an error in your SQL syntax near 'desc FROM news ORDER BY date ' at line 1 Ooops, reserved word! Works great ;-) Any way to add something to it like or should I do that in my php? Many thanks

Order by date

See what I mean? I can't beleive there is nothing that can be done with sql about this but I can't seem to find anything that will tell me how to do it so a little pointer would be smashing. Many thanks... - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version

Re: Order by date

; $qry.=FROM $this-table ; $qry.=WHERE module = '$module' ; $qry.=ORDER BY date ASC; Thanks very much for the help! - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: Order by date

? - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE819tsHpvrrTa6L5oRAkUjAJ0WsLUYpOkKmWAwvn08m8ewQ6cgMQCcDxoq iOgEUaj2XvG3trF/nWqQXt4= =Uh1r -END PGP SIGNATURE

Re: Re: Order by date

/ I do. Many thanks Victoria :-) sql - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81+GXHpvrrTa6L5oRAuMXAJ0clmtEYrYscsNlNgCktrN5AlPDfwCffgWS bfCr8rkBNl4YwtNo7TAbbWY= =/rKf -END PGP SIGNATURE

Access denied irregularities

; } $db=mysql_select_db($this-db) or die (can't select db); return TRUE; } Many thanks for any help :-) - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81ls

Re: Access denied irregularities

' error. - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81n36HpvrrTa6L5oRAsTCAKCmYg8C6gO98Ci95gUJFFDP29KIGgCgh3AF nA5VXs3zxNVcnd4HsLB6cS8= =dTXx -END PGP SIGNATURE

Re: Access denied irregularities

because as I said, I can connect sometimes and not others. - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81oh/HpvrrTa6L5oRApPXAJ4uZhnlEh1uVOUva5QJRXtFq8H82ACfedLj ss8aXzi5/Spgwn2migqqnW4= =HVzX -END PGP SIGNATURE

lost root password trouble

: (running on Linux) service mysqld stop /etc/init.d/mysqld --skip-grant-tables // no joy /usr/libexec/mysqld --skip-grant-tables // no joy service mysqld --skip-grant-tables start // no joy I'd appreciate a little help :-) - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE

Re: lost root password trouble

with databases from /var/lib/mysql' and just hangs any ideas? thanks james.. - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ztUxHpvrrTa6L5oRAlCrAKC3HOrhNL2XkeUB68EHuYExKzPMIQCdGdji khY4FsLiU4JeTj03OJzjNKw= =1fV6 -END PGP

Re: lost root password trouble

prompt. It is not hung. Just hit enter. Nope, it's hung, I get nothing and not even CTRL-C will stop it, I have to physically close the terminal. - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: lost root password trouble

questions though: * how will I tell where the db's are and how to point it at 'em? * where will I find the error log? Apologies for being so clueless, but many thanks for all the help... - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: lost root password trouble

databases in /var/lib/mysql? yep, they sure are... - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD4DBQE8zuxFHpvrrTa6L5oRAglVAJ4tYxwBLjKVO6LPF1TP9XXh9PfUkwCVGY4t BPPTG3iJQ4w9RzYxuGMbGg== =LuRo -END PGP SIGNATURE

Re: lost root password trouble

:-) - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8zvREHpvrrTa6L5oRAqv1AJ9/HX1j7setmC/ykfa9ztpYHAG/BwCfc3OV 0GmeQOSKsptbIvavH9wzsVY= =naLf -END PGP SIGNATURE

Re: MySQL off-the-shelf product

and +Articles for website owners - -- Nick Wilson -- |and designers. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8c029HpvrrTa6L5oRAv0KAKCHcho4UkbYNGUEYEwz7A+4WGrDEwCffSRe Xe8bDDQbSkUwyJn5a6m7RHs= =m5b9 -END PGP SIGNATURE

Re: visualizing my queries

in the content table), and then you'll know if the author exists or not. Hope someone gives a better solution! No, I think you're right, Query the 'author' table first and eiter insert into both or just 'content' using the authors id. Cheers... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325

permissions problem

to do the same from a php script I get 'Access denied for user: '@localhost' .. Can somebody please tell me what to do? Many thanks... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: permissions problem

What next Paul? Much thanks BTW -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: permissions problem

. - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZbGfHpvrrTa6L5oRAmGHAJ4i/zpcnuo+l9NZedwdRi1s923tVACfV2v/ YUD5rUO5rge/dadTNFfbN0c= =n7Zo -END PGP SIGNATURE

visualizing my queries

be using PHP for the front end. I don't need tecnical help (yet) just a hand seeing how I might plan the code. Many thanks in advance - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: visualizing my queries

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Diana Soares declared On Wed, 2002-02-06 at 11:22, Nick Wilson wrote: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio My question is: If I enter

Re: permissions problem

, $pass); Is that what you mean? BTW er... I have your book here :) - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZaNXHpvrrTa6L5oRAiPrAJ435aYGm+c3twUrFMzLHfVB+qMkeQCfXGHM

Access denied to apache@localhost

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql Hi all I've just set up and the latest problem I have getting started is that 'Access denied for user: apache@localhost' msg. How can I put that right? - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com

Access denied to apache@localhost

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql Hi all I've just set up and the latest problem I have getting started is that 'Access denied for user: apache@localhost' msg. How can I put that right? - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com

permissions problem

to do the same from a php script I get 'Access denied for user: '@localhost' .. Can somebody please tell me what to do? Many thanks... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: permissions problem

, $pass); Is that what you mean? BTW er... I have your book here :) - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZaNXHpvrrTa6L5oRAiPrAJ435aYGm+c3twUrFMzLHfVB+qMkeQCfXGHM

Re: permissions problem

What next Paul? Much thanks BTW -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: permissions problem

. - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZbGfHpvrrTa6L5oRAmGHAJ4i/zpcnuo+l9NZedwdRi1s923tVACfV2v/ YUD5rUO5rge/dadTNFfbN0c= =n7Zo -END PGP SIGNATURE

visualizing my queries

be using PHP for the front end. I don't need tecnical help (yet) just a hand seeing how I might plan the code. Many thanks in advance - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: visualizing my queries

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Diana Soares declared On Wed, 2002-02-06 at 11:22, Nick Wilson wrote: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio My question is: If I enter

Re: visualizing my queries

in the content table), and then you'll know if the author exists or not. Hope someone gives a better solution! No, I think you're right, Query the 'author' table first and eiter insert into both or just 'content' using the authors id. Cheers... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325

Re: Re: visualizing my queries

wasn't sure that my DB design wasn't flawed, I was expecting someone to say 'well if you want to do that you need to design like this..' No matter. I'm not sure I understand you recommendation, would kindly explain a little more? Much thanks... - -- Nick Wilson Tel: +45 3325 0688

Re: visualizing my queries

the AuthId is known, 'part two' can take place, and the tip written to the content tbl. Thus two tasks: (1) deal with the author 'issue', and (2) save the tip. Fantastic, thanks for taking time out to help me, very much appreciated and you're right of course. - -- Nick Wilson Tel:+45 3325