Member Avatar for SEOKRU

Hi,

I am triyng to create a very basic image catalog in a table

I have a DB with image source (src), and URL (herf) and id ,

I need to use a simple query with "order by random", but what now?

How do I connect the query result to the images?

Thanks.

Edited by kvprajapati because: Remove link. Do not mention, plug or refer to any product, service, or website you are affiliated with anywhere outside.
  • 2 Contributors
  • 1 Reply
  • 72 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by crishlay
Member Avatar for crishlay

Hi,

I am triyng to create a very basic image catalog in a table

I have a DB with image source (src), and URL (herf) and id ,

I need to use a simple query with "order by random", but what now?

How do I connect the query result to the images?

Thanks.

SELECT [ID], [src], [herf]
FROM [TableName]
ORDER BY NewID()

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.