Ask a Question related to Dreamweaver AppDev, Design and Development.
-
TheRapidGroup #1
Problem with SQL Statement/Sort Function
Hey everyone, I am inserting a drop down menu that will allow a user to sort
the database result on my page. The problem is, i'm not sure where to add the
sort command in my SQL query. Below is a sample of my query, if anyone knows
what and where I should insert this statement I would be most greatful! SQL
query: mysql_select_db($database_localconn, $localconn); $query_clockset =
'SELECT sku, manufacturer, item, smallpic, price FROM clocks ORDER BY smallpic
DESC'; $query_limit_clockset = sprintf('%s LIMIT %d, %d', $query_clockset,
$startRow_clockset, $maxRows_clockset); $clockset =
mysql_query($query_limit_clockset, $localconn) or die(mysql_error());
$row_clockset = mysql_fetch_assoc($clockset); Here are the links in my drop
down menu: '?sort=price'>Price '?sort=manufacturer'>Manufacturer
'?sort=item'>Item Name '?sort=sku'>SKU
TheRapidGroup Guest
-
Why i am not able to sort the amount columns havinglabel function in a datagrid?
Hi I am not able to sort the amount column in a datagrid which has a label function for currency fomatter. Thanks -Pooja -
Ado sort error-Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose key length is unknown or exceeds 10 KB.
Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose key length is unknown or exceeds 10 KB. hi, guys i have asp... -
Sorting algorithm(s) used by PHP's sort function
Does anyone know what sorting algorithm(s) -- quicksort, mergesort, radix sort, etc. -- does PHP use internally in its sort function? -
[Q] Safari, Javascript and sort function
Hello, I'm looking for a script to sort a html table. On the web, I found a lot of js scripts to do that but none working with Safari. Someone... -
Function much slower than same statement.
Hi all: I am facing stunning performance results with a user defined function. This is the story: I have a function that basically performs a...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
