Unique Image Query

3 Message(s) by 2 Author(s) originally posted in php sql

From: Steve

Date: Thursday, August 23, 2007

Hi,

I am having trouble achieving the outcome I am looking for with a mysql
query

1. <database, information science> A user's (or {agent}'s)
	request for information, generally as a formal request to a
	{database} or {search engine}.

	{SQL} is the most common {database query language}.

	2. <character> {question mark}.

	(1997-04-09)

.

The query below pulls information from two tables: profile_images and
name_list.

It pulls 6 random

1. Unpredictable (closest to mathematical definition); weird.
	"The system's been behaving pretty randomly."

	2. Assorted; undistinguished.  "Who was at the conference?"
	"Just a bunch of random business types."

	3. (pejorative) Frivolous; unproductive; undirected.  "He's
	just a random loser."

	4. Incoherent or inelegant; poorly chosen; not well organised.
	"The program has a random set of misfeatures."  "That's a
	random name for that function."  "Well, all the names were
	chosen pretty randomly."

	5. In no particular order, though {deterministic}.  "The I/O
	channels are in a pool, and when a file is opened one is
	chosen randomly."

	6. Arbitrary.  "It generates a random name for the scratch
	file."

	7. Gratuitously wrong, i.e. poorly done and for no good
	apparent reason.  For example, a program that handles file
	name defaulting in a particularly useless way, or an assembler
	routine that could easily have been coded using only three
	registers, but redundantly uses seven for values with
	non-overlapping lifetimes, so that no one else can invoke it
	without first saving four extra registers.  What {randomness}!

	8.  A random hacker; used particularly of high-school students
	who soak up computer time and generally get in the way.

	9.  Anyone who is not a hacker (or, sometimes, anyone not
	known to the hacker speaking).  "I went to the talk, but the
	audience was full of randoms asking bogus questions".

	10.  (occasional MIT usage) One who lives at Random Hall.  See
	also {J. Random}, {some random X}.

	[{Jargon File}]

	(1995-12-05)

images where the name_list.id matches the
profile_images.vref but also checks that the 'class' field

<data, database> An area of a {database} {record}, or
	{graphical user interface} {form}, into which a particular
	item of data is entered.

	Example usage: "The telephone number field is not really a
	numerical field", "Why do we need a four-digit field for the
	year?".

	A {database} {column} is the set of all instances of a given
	field from all records in a {table}.

	(1999-04-26)

from name_list is
equal to '5'.

$index_thumbs = mysql_query("SELECT DISTINCT * FROM profile_images,
name_list
WHERE profile_images.vref = name_list.id AND name_list.class = '5'
ORDER BY RAND() LIMIT 0,6");This is working fine for pulling 6 random images that meet those
requirements but I'd also like to to make the profile_images.vref /
name_list.id UNIQUE

<language> A {portable} {job control language}.

	["The UNIQUE Command Language - Portable Job Control",
	I.A. Newman, Proc DATAFAIR 73, 1973, pp. 353-357].

	(1994-11-22)

as there are multiple images for each each
name_list.id - So therefore I'd like to return 6 unique images from 6
id's in the name_list rather than having cases where multiple images show up
from one name_list.id

I'm hoping this is going to be a simple adjustment to someone who knows what
they're doing :)

Thanks in advance.

Steve

From: J.O. Aho

Date: Thursday, August 23, 2007

wrote in message:

I'm hoping this is going to be a simple adjustment to someone who knows what
they're doing :)You could try to GROUP BY on name_list.id.--

//Aho

From: Steve

Date: Thursday, August 23, 2007

wrote in message:

I'm hoping this is going to be a simple adjustment to someone who knows
what
they're doing :)
You could try to GROUP BY on name_list.id.
--

> //Aho

Next Message: href in mysql databse

Blogs related to Unique Image Query

Unique file name
Each client may have any number of documents scanned, so I would like to store the images with filenames that describe the client number and a unique sequence for that client, for example Client1234-001.tif, Client1234-002.tif, ...

Copyright your Hologram
It may, however, be noted that the ROC’s formal registration process takes a few months, various clarifications/ visits, and there is practically no possibility of any prompt search query etc. India is signatory to the Berne Convention ...

Create Drupal Module
All of your module's files must be prefix 'phonedir'. Your drupal configuration file must be placed at: /usr/local/apache/htdocs/drupal/sites/default/settings.php Please edit settings.php to add MySQL connection to the aother database: ...

Default Root Password in Infrant (now Netgear) ReadyNAS "RAIDiator"
Even if the root password is unique per device (due to the MAC address being part of the hash), it cannot be considered as secret. First, if the NAS device is on the local LAN, one can easily query the MAC address with an ARP request. ...

PHP-MySQL Interview Question - 2
Q:90, What is SQL Injection in PHP security? A:90, SQL injection attacks are extremely simple to defend against, but many applications are still vulnerable. Consider the following SQL statement:. This query is constructed with $_POST, ...

MySQL General :: RE: Show certain information on index page.
php my_db_sel(); $query_count = "SELECT count(*) FROM phplist_listuser WHERE listid = '1' "; $display = mysql_result(my_query($query_count),0,0); echo $display; ?> FREE Unique Image Hosting.