Phone Puzzler

2001-09-17 Thread Chris Thorpe
This is something that has me stumped.. I have a table as follows EndAEndB A B A C B C C D A E D E Imagine this as a table that describes potential links across a phone network. Now supposing I wish to connect from point A to point

Re: problem with count (*) max (*) min (*)

2001-09-07 Thread Chris Thorpe
It would appear that you are putting spaces between Count and the bracket which as far as I can tell will not work hence try count(*) etc... Chris Thorpe - Original Message - From: "Antonio Ortega Sancho" <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[E

Getting the pass mark

2001-09-05 Thread Chris Thorpe
e to count the passes and a second : SELECT COUNT(*) AS total WHERE test=x; to count the total?????? Chris Thorpe Consultronics Europe Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manua

Going mad over query

2001-09-03 Thread Chris Thorpe
moment it just appends to the end of Table A sorry if this is a dumb ass question!! I have scoured the manual etc, but cannot find how to include the reference to table A's id field as well! PLEASE HELP ME ! Chris Thorpe Consultronics Europ