I'm new to this list, and new to mySQL but used SQL with DB2 years ago, so here goes my try at answering this: have you tried select count(*) as your_variable_name From etc .etc.etc.
Anne ----- Original Message ----- From: "Mark Worsdall" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Tuesday, October 30, 2001 7:43 PM Subject: HOW do I return the results of a count to a variable > Hi, > > I want to alter this statement so it returns the number of records. > > $prep = "SELECT COUNT(*) FROM go.objectives WHERE subjects_id='1' AND > subjectHeadings_id='2' ORDER BY displayOrder"; > > $sth = $dbh->prepare($prep); > > $sth->execute; > > So what I need to do is add the COUNT statement into the above and then > return the number of records but how? > > MySQL table query > > > M. > -- > Work:- postmasterAThinwick.demon.co.uk WEB:- http://www.hinwick.demon.co.uk > Work:- mworsdallATshaftesburysoc.org.uk REPLACE AT with @ > Home:- hinwickATworsdall.demon.co.uk WEB:- http://www.worsdall.demon.co.uk > Shadow:- webmasterATshadow.org.uk WEB:- http://www.shadow.org.uk > > --------------------------------------------------------------------- > 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
