Query question

375 Contributor

I have a database full of information And I use part numbers to find / query the results on the page I have made now.. However I am in need of a new type of query and I am not 100% sure how to come about this…

Here is the goal.

I have a set of part numbers in the database that are 90-10000 to 90-99999

I need a query that will search JUST those part numbers and then Display.. The displaying part I am sure I can get on my own… I will post the code as I go but I am in need of telling the php that you need to look for these PART NUMBERS first then display this information about them from the selected columns.

Could anyone help me start this query?

Jul 3 '07 #1

Subscribe Reply

1046

kovik

1,044

Recognized Expert Top Contributor

MySQL has both a SUBSTR()/SUBSTRING() function and a REGEXP clause that would be of use to you.

Jul 3 '07 #2

Chrisjc

375

Contributor

MySQL has both a SUBSTR()/SUBSTRING() function and a REGEXP clause that would be of use to you.

eh? Well I guess I should be a little more specific in what I am looking to do.

It is when a USER CLICKS a link it will LOAD a new page that must trigger the QUERY and search for those part-numbers 90-10000 through 90-99999 only and then display the found results in the rows across...

so if my database looked like this

PARTNUMBER DESC DESC2 PRICE
90-10420 Cleaner All filters 20.00

so if that was all that was in there.. it would just display that.... on the screen.

I just don't know how to structure it to LOAD the page and Trigger a QUERY to take place.... I believe if I can get that I will have no issues with it calling the COLUMNS I will need after... I just haven’t known something this advanced before.

and when I say find any part number from 90-10000 to 90-99999

I mean all the numbers possible in between those 2 part numbers.

Any Ideas? Anyone?

Jul 3 '07 #3

kovik

1,044

Recognized Expert Top Contributor

Oh. I thought you wanted part of the number.

When you use the ORDER BY clause, MySQL automatically orders the rows numerically and alphabetically. You could combine that with the BETWEEN clause to retrieve all of those table rows between those two values, and use the part number as the id.

Jul 3 '07 #4

Similar topics

3398

Fine tuning this sql-query. help!

by: majsen | last post by:

Hi, I have problem running this query. It will time out for me... My database are small just about 200 members. I have a site for swaping appartments (rental). my query should look for match in a triangle. Like this member A -> B->C A give his appartment to B. B gives his appartment to C and finally C gives his appartment to A Soo my...

Microsoft SQL Server

3241

Query performance question on a large table

by: Együd Csaba | last post by:

Hi All, how can I improve the query performance in the following situation: I have a big (4.5+ million rows) table. One query takes approx. 9 sec to finish resulting ~10000 rows. But if I run simultaneously 4 similar queries it takes nearly 5 minutes instead of 4 times 9 seconds or something near of that. here is a sample query: select ...

PostgreSQL Database

14116

Pulling the Record Number into a Query - Attempt 2

by: John Ortt | last post by:

> I have a table of dates in ascending order but with varying intervals. I > would like to create a query to pull out the date (in field 1) and then pull > the date from the subsequent record (and store it in field 2). > > I would like to run a query that returns all the data in the table plus the > record number, in a similar sense to the...

Microsoft Access / VBA

3071

Filling question ID automatically by using query or VBA

by: Ekqvist Marko | last post by:

Hi, I have one Access database table including questions and answers. Now I need to give answer id automatically to questionID column. But I don't know how it is best (fastest) to do? table before rowID answID qryrow questionID datafield 1591 12 06e 06e 06e question 1593 12 06f 06f 06f question 1594 12 answer to the question 06f

Microsoft Access / VBA

3377

1 SP with dynamic input parameters and multiple rows as the source of the query

by: serge | last post by:

How can I run a single SP by asking multiple sales question either by using the logical operator AND for all the questions; or using the logical operator OR for all the questions. So it's always either AND or OR but never mixed together. We can use Northwind database for my question, it is very similar to the structure of the problem on the...

Microsoft SQL Server

4829

Use Select Query variable against a table and return value to same select query

by: jjturon | last post by:

Can anyone help me?? I am trying to pass a Select Query variable to a table using Dlookup and return the value to same select query but to another field. Ex. SalesManID SalesManName AT Alan Time

Microsoft Access / VBA

2029

Help trying to limit the results on a 3-table query?

by: mmitchell_houston | last post by:

I'm working on a .NET project and I need a single query to return a result set from three related tables in Access 2003, and I'm having trouble getting the results I want. The details: Question ------------ QuestionID QuestionText Question_MediaTypeID

Microsoft Access / VBA

31158

Query for Month

by: Stan | last post by:

I am working with Access 2003 on a computer running XP. I am new at using Access. I have a Db with a date field stored as mm/dd/yyyy. I need a Query that will prompt for the month, ie. 6 for June, and will return all records in that month.

Microsoft Access / VBA

2058

How to use a saved cross-tab query in a report?

by: Richard Hollenbeck | last post by:

I am very sorry about the (almost) re-post, but you will see that my first question wasn't very clear; I have another question I posted this morning called, "in DAO: Run time error 3061 Too few parameters...." I have read many articles on the web about how to make a dynamic report based on a cross-tab query. But for some reason mine never...

Microsoft Access / VBA

3478

duplicates query help & strategy for update queries with SetWarnings = False

by: ARC | last post by:

Hello all, So I'm knee deep in this import utility program, and am coming up with all sorts of "gotcha's!". 1st off. On a "Find Duplicates Query", does anyone have a good solution for renaming the duplicate records? My thinking was to take the results of the duplicate query, and somehow have it number each line where there is a duplicate...

Microsoft Access / VBA

7666

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7584

Changing the language in Windows 10

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...

Windows Server

8108

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7951

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

6260

AI Job Threat for Devs

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...

Career Advice

5484

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

2083

transfer the data from one system to another through ip address

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

C# / C Sharp

1201

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

925

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General