Jump to content


Photo

PHP and Mysql


  • Please log in to reply
1 reply to this topic

#1 gusmacker

gusmacker
  • Members
  • Pip
  • Newbie
  • 9 posts
  • LocationGrand Rapids, Michigan

Posted 08 November 2003 - 03:49 AM

Here is what I want to do, now I will ask the experts if it is possible.

What I want to do is do a query such as

SELECT aff from `table`

then I what the uniq of that so if there are 10 that say abc in it and 15 that say fff in it I want it to just return abc and fff 1 time not their respective amounts of records.

Kevin
[php:1:09d88d0ab6]<? [br]if ($SKYDIVING == "NO") { [br]$LIFE = EMPTY; [br]} else { [br]$LIFE = "FULL OF JOY"; [br]?> [br][/php:1:09d88d0ab6]

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 08 November 2003 - 05:29 AM

You can use this query to do the same

SELECT distinct aff from `table`

Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users