Re: update query confusion
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Jay Blanchard declared > other column changes value. (Note that an UPDATE that sets a column to the > value it already has will not cause the TIMESTAMP column to be updated, > because if you set a column to its current value, 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: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CfkZHpvrrTa6L5oRAlgCAJ47bPK5shotAZek3a8p7Fw8ZqoyFACgq8JV 3XjDcGjY6BgrcWc0zKg35Bo= =qTFK -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update query confusion
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all I can't work out why this query is also updating a TIMESTAMP col? UPDATE news SET title = 'new title', text = 'new text' WHERE id = '4' The table is very simple: * id INT * date TIMESTAMP // this 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) iD8DBQE9CeQ3HpvrrTa6L5oRAp4KAKCeXaGZg7U2GK9HvSvincd+hZytFgCgqG3l YZDx9hSDdpYUPRT0Yj70qc8= =Ne/Y -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 guys... - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CRzkHpvrrTa6L5oRAgKNAJ98YLjkRYdsLXVtSKljHYIUV6I3GgCfXIum cqkHx0R0xn1mQod72CnzFTg= =+q47 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: use of substring()
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Julie Meloni declared > Start with position 1. > > SELECT datefield, SUBSTRING(textfield, 1, 30) as description FROM > tablename WHERE id = 2; Hi again Julie and thanks for 'cross list' help! The problem is 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? Cheers... - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CRrxHpvrrTa6L5oRAg87AKCYM0MrVcnX3X9ZvMOW6Ncm47EnCQCbBO+J t0TWKjK81rSD9mc/lfWed/s= =6q25 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
use of substring()
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having a spot of bother with the SUBSTRING() function, I don't think I understand it properly... I have a table (for example) with three cols 'id' | 'date' | 'text' I want to return just 'date' 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.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CRXfHpvrrTa6L5oRAoS9AKC064XvuD46+UcbV9V+jLMYNOCQrACfY9WX eKfDM1z+wx6niPo1uPx7Bek= =RpXZ -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, I've no idea what's going on but a subsequent test with an incrementing session var shows the page to be loading itself twice with no apparent reason? Sheesh, as if life wasn't tough enough? - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CLLnHpvrrTa6L5oRAvMgAKCOSag7vZYiX30df03fC0Ms2NDVIACeNWNh ELce2zqZEx7pq1By0N+RKCk= =L2bL -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
duplicate entries mystery
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi everyone, 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: $qry="INSERT INTO news VALUES(NULL, NULL, \"a value\", \"b 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.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CJKuHpvrrTa6L5oRAmbbAJ9iE9dFziSckl7CBIjDDyYZLYV6uwCeKkcK 9RNFZNtyG1VoVM0WauuFcz8= =6Vio -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Order by date
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Victoria Reznichenko declared > NW> and here is my select: > > NW> $qry="SELECT id, module, week, "; > NW> $qry.="DATE_FORMAT(date, \"%d %m %Y\") as date, "; > > The result of DATE_FORMAT() function is a string. So, in ORDER BY > clause is used string 'date'. That is why you get "wrong" sorting. Use > another alias for your date column, it should help you, i.e.: Yes! 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+GXHpvrrTa6L5oRAuMXAJ0clmtEYrYscsNlNgCktrN5AlPDfwCffgWS bfCr8rkBNl4YwtNo7TAbbWY= =/rKf -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Order by date
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Jay Blanchard declared > If the date is in the format above you can select a substring > +++ > | field1 | rDate | > +++ > | 1 | 2002-03-01 | > | 2 | 2002-03-03 | > | 3 | 2002-03-05 | > | 4 | 2002-03-07 | > | 5 | 2002-03-11 | > +++ > > mysql> select substring_index(rDate, "-", -1) as Day > -> from tblDate1 > -> order by Day; Thanks, but as I understand it this should 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) iD8DBQE819tsHpvrrTa6L5oRAkUjAJ0WsLUYpOkKmWAwvn08m8ewQ6cgMQCcDxoq iOgEUaj2XvG3trF/nWqQXt4= =Uh1r -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Order by date
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Victoria Reznichenko declared > NW> I've been searching for a solution to the following: > > NW> Is there an easy way to order by date ( - MM - DD), at the moment my > NW> results are coming back with the *day* ordered but not the whole date > NW> like this: > > NW> 02 02 2002 > NW> 03 03 2005 > NW> 18 02 2003 > > NW> See what I mean? > > What is your column type? Why you don't use ORDER BY your_date_column > in the SELECT statement? It should work, but I can say you exactly > because I don't know your table structure. The other causes of wrong > result might be that something is not correct in your SQL statement. Right. here is the db schema: Feel free to berate me if I'm missing the obvious :-) CREATE TABLE iaadiplom_timetable ( id INT NOT NULL AUTO_INCREMENT, module ENUM('0', '1', '2', '3', '4', '5'), week VARCHAR(255) NULL, date DATE NOT NULL, ektione VARCHAR(255) NULL, title TEXT NULL, teacher_id INT NULL, PRIMARY 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.="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) iD8DBQE819AVHpvrrTa6L5oRAtj2AJ9CFMVEZEyBZKxy7zhOoSmMDAWUrwCfelhu UbSqDCWAxbYSgmGA2/u6OL8= =qD2+ -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Order by date
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all I've been searching for a solution to the following: Is there an easy way to order by date ( - MM - DD), at the moment my results are coming back with the *day* ordered but not the whole date like this: 02 02 2002 03 03 2005 18 02 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 SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE815hbHpvrrTa6L5oRAtdGAJ9MhgAcbdHqQnBJpfRPHGCf3msHvQCeLq0S qL5vUD6SumKXFFL/mOnhp/0= =k44P -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Gurhan Ozen declared > Make sure that the user + host combination you are giving has privileges > in the MySQL server you are trying to connect. You may wanna check user > table in the mysql database. Well, there must be privileges 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- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Egor Egorov declared > "Access denied" error occurs when you have no required privileges to > connect to the MySQL server. You gave incomplete error message and I > can't give you detailed answer. Please, check the following > link, you can find description of this error there: > http://www.mysql.com/doc/A/c/Access_denied.html Yes, I've already been there. No luck. the problem seems to be on/off part of the time it is okay and at other times not. It is just a regular 'Access denied to user 'nick@localhost using passwore YES' error. - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81n36HpvrrTa6L5oRAsTCAKCmYg8C6gO98Ci95gUJFFDP29KIGgCgh3AF nA5VXs3zxNVcnd4HsLB6cS8= =dTXx -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm getting intermittent 'Access denied' errors when running a php script to admin a mysql db. I've looked in the manual but cannot work out why I can connect in some parts of the script and not in others Perhaps there is some common 'gotchas' you might let me know about? Here is the code I use to connect: function _db_connect() { if(!$this->link_id) { $this->link_id=mysql_connect($this->host, $this->user, $this->pass); } if(!$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 PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81ls+HpvrrTa6L5oRAp0nAJwLLRlGpFV6ZQndPhqqF1+pW6w2MwCeK+H8 bsslUwVkhNA+8vVU/8S4qTc= =jhe5 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: lost root password trouble
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then James Carrier declared > It's OK Nick - it started. It's just writing that to the terminal > window. Hit enter to get the command prompt back (or ctrl-c if that > doesn't work). Ahhh,,, what a donkey (me not you) of course it 'hangs' lots of stuff does that, like gimp for ex. Well, I'm in !! Now I'm having trouble updating the user table :-( GRANT ALL PRIVILEGES ON * TO root IDENTIFIED BY 'my_password'; Read the manual, read my book, still a clueless twat. 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 0GmeQOSKsptbIvavH9wzsVY= =naLf -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: lost root password trouble
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then James Carrier declared > Do you have permissions over the mysql directories? Certainly do. > Can you start safe_mysqld as root? (purely for problem solving > purposes ;) Yep, well at least before it 'hangs' > 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 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: lost root password trouble
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Gurhan Ozen declared > Are your databases in /var/lib/mysql ?IT is trying to startup with reading > databaseses from that path but i think it can't.. > Also check the error log file to see what's going on. Sounds 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- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8zt8VHpvrrTa6L5oRAhMQAJoDtxov9xnC8kYbFALTIeOpjlcQjQCgp6Jk eGxwc0SRfhFZlBAP7j8eJ6g= =SuNx -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: lost root password trouble
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Gerald Clark declared > >Well, that's certainly progress of sorts :-) > >It's just 'hanging' now. It says 'starting mysqld daemon with databases > >from /var/lib/mysql' and just hangs > > > 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.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8zt6gHpvrrTa6L5oRAr9tAKCgye3ZUwPUPFiDTDRrKjdDe36KvACfU11m k/uExiiLSXzwOa6Odcdnyv8= =21I4 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: lost root password trouble
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then James Carrier declared > It'll be something like: > > /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables Well, that's certainly progress of sorts :-) It's just 'hanging' now. It 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 khY4FsLiU4JeTj03OJzjNKw= =1fV6 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
lost root password trouble
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi everyone, I have searched the archives and read the manual but am at a loss as to how to get my root password back (or change it) The trick appears to be to start mysqld with --skip-grant-tables but I can't seem to do it. Here is what I'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 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8zsnVHpvrrTa6L5oRAlV8AJ49K4qam8eUlJRJVflSNxIohhZ5ZQCfeDyt ZyaEmEOvoQQZ1KUpffdIino= =+qj5 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL off-the-shelf product
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Demirchyan Oganes-AOD098 declared > Would someone know of off-the-self MySQL product that will contain latest MySQL server in it? Something like 3.23.46a max-nt and above. I don't care what it's bundled with, PHP or perl. I just need to use the features of MySQL only. The reason I need it, is for FDA (Food and Drug Administration) standards approval. Try nusphere.com, I believe they might have what you're after. - -- - --- www.explodingnet.com |Projects, Forums 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- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZlDPHpvrrTa6L5oRAsjIAKCp0x7OCWIXFNCQdN7EW791BdzwggCfYev/ av1niWOnWkk0w4rmwJp/5LY= =6a0R -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared > Note that the message doesn't include a user name in front of the '@'. > > Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_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+c3twUrFMzLHfVB+qMkeQCfXGHM 2GcGatSYMx2pQo7kXUjWx58= =1N7q -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 a 'tip' and put myself as the author, when > > /I/ come to write another tip how do I make my query avoid putting > > another entry in author? I'll be using PHP for the front end. > > You can always use INSERT for the "content" table and REPLACE for the > "author" table. I don't think that would work as it will change the AuthId and effect any other 'tips' I've written. Each author should have one entry in 'author' and as many in 'content' as tips they have written. Am I talking rubbish? - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YRkMHpvrrTa6L5oRAuIwAKCt3FSi5j7NYOAKvcUujYsKoDFJ3gCffbBS f/vX8OWqQGBa6EzVCdeDq8c= =fZBS -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm planning a *very* simple DB to place tips on small biz websites on. I'm having a little trouble conceptualizing how it might work. My schema runs like this: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio 'section' will be an enum field containing 3 values, the rest is self explanatory. My question is: If I enter a 'tip' and put myself as the author, when /I/ come to write another tip how do I make my query avoid putting another 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 SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YRHcHpvrrTa6L5oRAhqgAJ4gRJBvjf/bkAWVaP/3rGtNcEvzSgCfe43q eUYlWvn+VzfMQ8RqfjgkiuY= =OwBR -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared > Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' > table, and have you deleted the entries for user='' and run 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/dadTNFfbN0c= =n7Zo -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
* and then Paul DuBois declared > >BTW > >er... I have your book here :) > > Ah. Well, in *that* case, check p429 and pp464-465. You may be getting > bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access 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.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having a spot of bother with permissions (i think) I just set up MySQL for private developement at home with PHP and created a db 'mydb' and granted all privs to nick@localhost Now, I can 'USE mydb' from the command 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 SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZZO4HpvrrTa6L5oRAv4RAJ9duXHJqZfzZ9Oqe35I0rDvclHdIACePmJ+ hCYzY9nxo9GCX0lCNF4S+kk= =Tzyb -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Diana Soares declared > No. You're right! > Unless you generate your own AuthId (with date, not auto-incremented), i > think you will have to do a SELECT in the "author" table to get his ID > /you will need 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 the authors id. Cheers... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YSgqHpvrrTa6L5oRArpCAKCtiMCqjzvX/RzyYGHI47FdAU+bywCfVkuV T6+05Nf+cHGRDOtbJB77hfY= =g0fB -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZlDPHpvrrTa6L5oRAsjIAKCp0x7OCWIXFNCQdN7EW791BdzwggCfYev/ av1niWOnWkk0w4rmwJp/5LY= =6a0R -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared > Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' > table, and have you deleted the entries for user='' and run 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/dadTNFfbN0c= =n7Zo -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
* and then Paul DuBois declared > >BTW > >er... I have your book here :) > > Ah. Well, in *that* case, check p429 and pp464-465. You may be getting > bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access 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.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared > Note that the message doesn't include a user name in front of the '@'. > > Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_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+c3twUrFMzLHfVB+qMkeQCfXGHM 2GcGatSYMx2pQo7kXUjWx58= =1N7q -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having a spot of bother with permissions (i think) I just set up MySQL for private developement at home with PHP and created a db 'mydb' and granted all privs to nick@localhost Now, I can 'USE mydb' from the command 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 SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZZO4HpvrrTa6L5oRAv4RAJ9duXHJqZfzZ9Oqe35I0rDvclHdIACePmJ+ hCYzY9nxo9GCX0lCNF4S+kk= =Tzyb -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then DL Neil declared > > > > > > > > > > My question is: If I enter a 'tip' and put myself as the author, when > > > > > /I/ come to write another tip how do I make my query avoid putting > > > > > another entry in author? I'll be using PHP for the front end. > > > Starting with the author: either the author already exists in the > table (SELECT=successful), in which case his/her AuthId needs to be > ascertained and fed to 'part two'; or the author's details are not 'on > file' and therefore must be INSERTed (and the AuthId noted...'part > two'). > > Once 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 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YVKSHpvrrTa6L5oRAowcAKCwDeTodQtamgUfuxXVpYtiJi4FQACghP9w Bl/cpWlrX0jVLET3HH+DHEM= =2z22 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then [EMAIL PROTECTED] declared > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > * and then DL Neil declared > > Recommendation: treat the (possible) addition to the author tbl as one task, and >the (required in both cases) > > addition to the content tbl as a separate task. > > Well I /hadn't/ tested as I 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 > Fax: +45 3325 0677 > Web: www.explodingnet.com > > > > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.0.6 (GNU/Linux) > > iD8DBQE8YSrUHpvrrTa6L5oRAjPbAJ49v60120MPRfX8E+JU8fcUBDoLQwCfbXTK > yeovHQHKDTL1YC9UJmFm3Io= > =4dRK > -END PGP SIGNATURE- - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YSuQHpvrrTa6L5oRAtuTAKCNM8iACmK4AJwezAi9uab6L0icbACfSpcM 8v0NnIMtKsHCURK/Ji9qJqg= =KNhq -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Diana Soares declared > No. You're right! > Unless you generate your own AuthId (with date, not auto-incremented), i > think you will have to do a SELECT in the "author" table to get his ID > /you will need 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 the authors id. Cheers... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YSgqHpvrrTa6L5oRArpCAKCtiMCqjzvX/RzyYGHI47FdAU+bywCfVkuV T6+05Nf+cHGRDOtbJB77hfY= =g0fB -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 a 'tip' and put myself as the author, when > > /I/ come to write another tip how do I make my query avoid putting > > another entry in author? I'll be using PHP for the front end. > > You can always use INSERT for the "content" table and REPLACE for the > "author" table. I don't think that would work as it will change the AuthId and effect any other 'tips' I've written. Each author should have one entry in 'author' and as many in 'content' as tips they have written. Am I talking rubbish? - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YRkMHpvrrTa6L5oRAuIwAKCt3FSi5j7NYOAKvcUujYsKoDFJ3gCffbBS f/vX8OWqQGBa6EzVCdeDq8c= =fZBS -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
visualizing my queries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm planning a *very* simple DB to place tips on small biz websites on. I'm having a little trouble conceptualizing how it might work. My schema runs like this: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio 'section' will be an enum field containing 3 values, the rest is self explanatory. My question is: If I enter a 'tip' and put myself as the author, when /I/ come to write another tip how do I make my query avoid putting another 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 SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YRHcHpvrrTa6L5oRAhqgAJ4gRJBvjf/bkAWVaP/3rGtNcEvzSgCfe43q eUYlWvn+VzfMQ8RqfjgkiuY= =OwBR -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php