> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 25, 2002 9:51 AM > To: Mysql maillist > Subject: script > > > Hi All. > I have written a SQL script that should retrieve all the rows from a > table that match a value given as parameter by the user. > > The script is something like: > > SELECT TEST_NAME AS NAME, TEST_DATE > FROM TEST > WHERE TEST_NAME=NAME; > > where NAME is the parameter the user should give.
Is NAME both the parameter and the column alias? Your query looks to me like SELECT something FROM atable WHERE something=something Adolfo --------------------------------------------------------------------- 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