Let's say I have a long list of names. I've pulled this list of names from the database, and I want to alphabetize them and split them into separate pages basd on that. I have idea as to how to do it for letters a-z, but how would I do it for names that start with special characters?
2 1415 ak1dnar 1,584
Recognized Expert Top Contributor
If you want to display them in alphabetical order why you worrying about special characters? And Strange, this is the first time I heard about "Names with Special Characters"! are you talking about some kind of user names?
If you want to display them in alphabetical order why you worrying about special characters? And Strange, this is the first time I heard about "Names with Special Characters"! are you talking about some kind of user names?
I should have made myself clearer. I want each letter of the alphabet to have its own page, with just words beginning with that letter on that page. That I've already figured out how to do, using query_string and everything. But now, if I want to check names that begin with a special character like let's say a bracket, I have to do file.php?[. And of course, that only shows the names beginning with "[". I want one page for all words beginning with ANY special character. How would I achieve that?
And no, these are not user names.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: somaBoy MX |
last post by:
This may be a stupid question, but what is the easiest way to sort a mysql
resultset?
For example I have a resulset containing a colomn 'product_name_english' and
'product_name_french' and want to sort the result on one of these colums
based on a language parameter.
I know how to do this in a query ("ORDER BY") but how can I do this after
the query has been executed?
|
by: sandy |
last post by:
Hi All,
I am a newbie to MySQL and Python. At the first place, I would like to
know what are the general performance issues (if any) of using MySQL
with Python.
By performance, I wanted to know how will the speed be, what is the
memory overhead involved, etc during database specific operations
(retrieval, update, insert, etc) when MySQL is used with Python.
|
by: Greg Schiedler |
last post by:
Ok so I'm a MySql newbie.
I have a DB that I need to pull out only selected username(s) that end on
secected pattern(s).
Original Query all usernames.
$q = "select $cols from RADONLINE $orderby";
|
by: P. Emigh |
last post by:
By default in more recent versions, Access forms keep users' last sort
request in the "orderby" property. That can slow things down
considerably, especially when the last user has chosen a non-indexed
field.
I have put in a lot of
OrderBy = ""
code in OnOpen form events. Being able to disable that "service"
(seems like more and more Microsoft insists on helping when we don't
need or want the help) would be a much more efficient...
|
by: Dutchy |
last post by:
Hi there,
After spending several hours trying all I could imagine and search for in
Google I gave up. In a continuous form I want to sort the choosen column by
clicking the header (label) of that column. I even want to sort up and down
if one clicks again on the same header. No problem so far, all works well
for one column. Now I want to sort on the first choosen column ASC or DESC
and additionally on a second column ASC.
I use the...
| |
by: fecket |
last post by:
The following code is used in my db to change the sort order of the
report to various fields. I want to take this one stage further and
use maybe a Case Select to give 2 or 3 different options to sort the
report.
Is ther any way I can adress the report name as is used in strDocName
and strSQL so instead of having
Reports!.OrderBy = strSQL
|
by: tim otero |
last post by:
I should be able to figure this one out, but it's late:
I'm trying to sort a report by two fields. I can do it easily if I
hard-code the fields. However, I want to get user input and store the
input in variables, which would then be used in the OrderBy method.
Right now it looks like this and is not working:
rptMember.OrderBy = strfield1, strfield2
What am I doing wrong? Any help would be greatly appreciated.
|
by: alex.kemsley |
last post by:
Hi guys,
I have the following sql statemant to search a mysql database that gets
if values from a form with combo box's in.
SELECT * FROM hottubs, manufacturers WHERE manufacturers.manid =
hottubs.manid AND hottubs.type = '%s' AND hottubs.dimlength <= '%s' AND
hottubs.dimwidth <= '%s' AND hottubs.dimhight <= '%s' AND
hottubs.seatsto <= '%s' AND hottubs.shape = '%s' ORDER BY
$thesearchtype_search.
|
by: jenson |
last post by:
<?php
/*
* Created on Apr 13, 2007
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
require_once 'init.php';
$con=mysql_connect("localhost","root","");
$dbc=mysql_select_db(test,$con)or die("Database select error:" . mysql_error($con));
|
by: pbd22 |
last post by:
Hi.
I really need some advice on fine-tuning a stored procedure
that is the meat of the search logic on my site. Customers
are allowed to save searches, which dumps the search logic
in a table called SavedSearches for later access to the search.
My problem started with the ORDERBY condition used for zipcode
searches. The condition did something like:
"order by CASE WHEN userID=67 THEN 1 WHEN userID=103 THEN 2 WHEN
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |