ue, MySQL 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: Gn
his is current date when 'updating'?
* 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)
iD8DBQE9CeQ3HpvrrTa
-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
not that, at least not first 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?
C
ate' and the first 30 chars from 'text'
I've 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.explodi
-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
value\")";
mysql_connect("localhost", "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.explodi
s! How strange, the penny dropped whilst I was making a cup of tea and
I was sure I had it. Now I /know/ I do. Many thanks Victoria :-)
sql
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE81+GXHpvrrTa6L5oRAuMXAJ0clmt
not be needed as it is a
regular date column and mysql should sort it for me right?
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE819tsHpvrrTa6L5oRAkUjAJ0WsLUYpOkKmWAwvn08m8ewQ6cgM
ARY KEY(id)
)
and here is my select:
$qry="SELECT id, module, week, ";
$qry.="DATE_FORMAT(date, \"%d %m %Y\") as date, ";
$qry.="ektione, title, teacher_id ";
$qry.="FROM $this->table ";
$qry.=&quo
2003
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 SIGNATU
rivileges 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
d to user 'nick@localhost using passwore YES' error.
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE81n36HpvrrTa6L5oRAsTCAKCmYg8C6gO98Ci95gUJFFDP29KIGgCgh3AF
nA5
f(!$this->link_id) {
return FALSE;
}
$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
Can anyone help me
get it right?
many thanks everyone :-)
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE8zvREHpvrrTa6L5oRAqv1AJ9/HX1j7setmC/ykfa9ztpYHAG/BwCfc3OV
t; And of course - are your 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
ounds reasonable, 2 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---
gs
> >
> It just wrote that message over the command 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.explodingne
says 'starting mysqld daemon 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
27;ve done:
(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
-BEGI
ojects, Forums and
+Articles for website owners
- -- Nick Wilson -- |and designers.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE8c029HpvrrTa6L5oRAv0KAKCHcho4UkbYNGUEYEwz7A+4WGrDEwCffSRe
Xe8bDDQbSkUwyJn5a6m7RHs=
=m5b9
-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.e
ql_connect($host,
$user, $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+c3
-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
> >
other entry in author? I'll 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 SIGNATU
FLUSH
> PRIVILEGES?
Certainly have.
- --
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/da
cess
denied to user apache@localhost
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.
mand line but if I try 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 SIGNATU
d it to insert a new tip 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
-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.e
FLUSH
> PRIVILEGES?
Certainly have.
- --
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/da
cess
denied to user apache@localhost
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.
ql_connect($host,
$user, $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+c3
mand line but if I try 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 SIGNATU
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 0688
Fax:+45 3325 0677
Web:www.explodingnet.com
-BEGI
>
> I'm not sure I understand you recommendation, would kindly explain a
> little more?
>
> Much thanks...
>
> - --
>
> Nick Wilson
>
> Tel: +45 3325 0688
> Fax: +45 3325 0677
> Web: www.explodingnet.com
>
>
>
> -BEGIN PGP SIGNATURE-
>
d it to insert a new tip 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
-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
> >
other entry in author? I'll 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 SIGNATU
39 matches
Mail list logo
