MYSQL :: Search My Site

Search From Web Site
I have a simple search function. Just an input field and a submit button that should search a table in mysql.

I do some regexp stuff in mysql so i use the REGEXP syntax but you don't have to bother about that, since we'll just asume that the user have input "x y z" in the search field.

Problem 1
I have three fields in a mysql table that i want to search. The simplest way I came up with to do this was:

SELECT * FROM table WHERE CONCAT_WS(' ',field1,field2,field3) REGEXP 'x y z'

But this won't work if field1 = z, field 2 = y and field3 = x .
How can I achive this? It's quite impossible to ad an OR statement for every possible combination of x, y and z. (perhaps I will need to search more fields in a go in the future)... Can I change the regexp to be able to match words in any combination?

Problem 2
How do I set up an index in mysql for the kind of search mentioned above? Is it usable to have an index on field1, field2, field3 if you're going to do a concatenation on them anyway?

SIte Search Engine
I am currently working on a site which visitors can submit & search links to various resources. I am trying to set up an advanced search feature (similar to google) and I have several ENUM Fields within the table that I want visitors to be able to check or uncheck within the search.

I also have a username table and would like to be able to measure the popularity of a link so that I can have rankings for different types of resources and count the numbr of times a user submits a link, which user submits which link, number of times a user clicks on a link etc. I am v. new to database design and am not sure whether the ENUM fields should be in a seperate table or whether to keep it as it is: Code:

Site Down
Need help figuring out ohow to unlock tables.
Everytime I try a repair with my Web Host Manager my whole site freezes up.
I have one table that is "in use" a sessions table.
I can use putty and get to the
>Mysql prompt but I am lost from there...
Is there a way to repair or fix this? I have tried using phpmyadmin and cpanel and neither work, they just time out....
what command should I use?

Huge Site
I wonder if MySQL should work with tables having milions of rows, e.g. you have image uploading site and you store daily around thousands of photos and regularly querying them. What are the techniques of this? Is it possible to do this with mysql? Do you know some books, articles about this? I thought about indexing or caching(of course if possible) and I want to learn something about this.

Connect To My Db From Any Site
Can I connect to my db (via php scripts, etc) FROM a client's website ??

Web Site Form
I want to have a form on my website, almost like a feedback form but not for feedback. It will be for getting info from customers. It will simply be about 30 fields that will need to post to a database. How hard is this with mysql? How would I do this on the web page? Is there a certain language I would need to use? Also is it possible to get an email everytime a record is added via the web form?

MySQL On A Web Site
I am working on a web page that is currently using a MySQL database to manage our product inventory on our web site.The problem is that I am not the person who developed the web page, but it is now my responsibility. I am going to continue using the existing database, but the management process of a MySQL database on a web server is a new process for me.I am going to assume that I should be using the phpMyAdmin tools to interface with the database, but the php programming is new to me, as well.

I'm a fast learner, so what I'm really looking for is a bit of direction in how I can improve or reconfigure the output for the end-user.Anyway, I don't know if I have provided enough information, but if any of you guys can point or steer me in the direction that would make me an educated contributor to these forums, I would appreciate the introductory patience.

Multilingual Site
like...should i just have a base price and calculate the rest when needed?

i use php, mysql and mod_rewrite

Connect My Site
Im trying to connect my webpages to the MySql database that i have as part of my hosting account, ive dropped a MySqldump file into the database and have been trying to connect my site to the database but im somewhat confused about how to do this, i understand ive got to use a little bit of code to make the connection but where do i place that code? and do i place it on every webpage, im trying to put together GET variables so that when someone clicks the "Buy"
link it should then make the billing popup appear, but mainly at the moment my main confusion is about actually what to insert and where, in order to make the connection between my pages and the database

Remote Site.
i jus completed my first database site and ready to upload. but need to know 2 things.
1. where exactly is the database? ive got my site in the inetpub.. is the database in here C:Program FilesMySQLMySQL Server 4.1 ?
2. how do i upload it along with the site? is there just 1 file to upload or is there lots... ?

Building A 1 Page Site?
I have a couple of review site and I'm thinking of building a new one, but along the lines of a 1 page (well, maybe 2 or 3) site. I think the database is pretty basic and the queries dead simple (okay, except for the "I'm thinking about")*, but I'm concerned about 2 things.

1 - site simplicity and fast page loads
2 - some duplicate content

The reviews will have 2 separate text fields.

One will be a description written by me .. unique text.

Another will be a review = customer comments supplied by an affiliate .. duplicate content.

Each text field (description and review) will be up to 10k in size. The database records will also have fields for : name, image link, affiliate link, and a few more .. very brief. Probably a total of 10 fields.

What Im wondering:

1 - what problems should I watch out for, if any, by adding this much text. *I'm thinking about making the first query show up to 10 or 20 items with just maybe the first 30 or 40 words of each text field plus a thumbnail; and then a link in each that would produce a single page with the full text and larger image.

2 - I'm a little concerned that I may get a duplicate content penalty. Will having it in a database help? I'm pretty sure I could put the 'echo' in an iframe and the iframe in a directory and exclude SE bots from that directory with robots.text .. does that make sense?

Finally, there are hundreds of items so I plan on breaking them into categories to keep the menus a reasonable length .. and using javascript to to show an *items* menu when the *category* menu is selected. So should I go ahead and use AJAX to query the database?

Compute Time On Site
I have moderators and i need to compute their time spend on site. I have table moderators_actions(mod_id,action_date). I make up to count sum periods of time between moderate_actions, but only them which are shorter than 5 minutes(if it is longer than 5 minutes I assume the moderator made a break in his work).

My queries:

1. The query finds for each moderators_action next action of this moderator, and time between the action. Choose only shorter than 5 miunutes.

One Database For Site And Forum?
I have a site and a forum and I want to use one database for them, so when somebody registers in the site - to be registered automatically in the forum.
Is this possible and if it is - how?

AIX 5.1 Binary From UCLA Site?
I wonder if anyone would share your experience with the binary download from the UCLA library? I am thinking of an AIX 5.1 box (32 bit) first. If things go well, and if manager allows, I'd like to try another box (AIX 5.1, 64 bit). It'd be nice to hear a success story before taking the jump.

Also, is UCLA's binary the same as the one at mysql.com site? If different, in what way? Is one of them 64bit and the other 3 2bit? Or are they both 32 or 64 bit?

Porting A MySQL Site
I am creating a site here on my local machine, mainly to learn Mysql and php. I am using Mysql 4.1.10, php4, apache 2.0 and windows xp home. After I get an appplication built and running well, what am I going to have to do to make it run on the internet?
Will I simply have to change all occurances of 'locahost' to 'mydomain.com' ?

Cms Site Lo My Local Server
i'm having problem running my cms in my local server, i've downloaded our company sms from our remote webhosting server and tried running it in my local server but a lot of errors popped-up? like:
in index: Notice: Undefined index: pagsanjan_cookie in C:Program FilesApache GroupApache2htdocspagsanjanindex.php on line 568

and what's worst is as i logged in try to modify contents through its php cms alot of errors would pop up like: Notice: Undefined index: fcategory in C:Program FilesApache GroupApache2htdocspagsanjanDynamiclist.php on line 65

Notice: Undefined variable: sqlstring_temp in C:Program FilesApache GroupApache2htdocspagsanjanDynamiclist.php on line 118

Building My First Database Driven Site.
Before I begin, can I just state I have never installed anything on Linux server, so I am very new to this...

Okay at the mo I have and using MYSQL version 3.23.58 on my Linux Sever, incase this is important, heres the details of my server: WEB SERVEUR
Platform : Small - Fedora Core 3
Control panel : Plesk 100
Config : AMEN 2400 - AMD Athlon XP 2400+ Disk: 80 Gb - Memory: 512 Mb

OK, I need to upgrade to the latest MYSQL version. So far, I have downloaded "mysql-standard-5.0.24a-linux-i686.tar" and unpacked the file uner /usr/local

This is where I am stuck, I have no idea what to do next.. I need help for someone never done this before, preferbally a guide like... STEP by STEP, type this,

Linking Site To MySql Database
I have bought the PHP and Database book and have created a database [windows](saved under the default directory under Program FilesMySql...) and I have created a server. How do I link the website (localhost - same PC as one with MySQL) with the database or is it done automatically?

Transfer A Data Base To My Site
i've create a data base with phpmyadmin in my computer and now I want to put it in my site...it's possible to do it? And how?

Create Php Site From Existing Database
I have been contacted by one of my clients to construct a knowledge bank based on their ms access database. I have successfully converted the ms access database to MySQL using the GUI conversion tools supplied by MySQL.com . I am wondering, and I don't know whether this is the right site to do this, if I can easily create a php site based on the database tables that have been converted.

Capitilised Words (values Within Site)
I have have changed servers for my website and when I reuploaded my database backup some text within my site is capitalised. The text that is in highercase seems to be values for example the words I have noticed are SOME, TO, FROM etc it seems to be the same words.

here is another example: "This is Kidderminster's 4th annual Rock Festival, this YEAR taking place ON 28th September 2007, FROM 6:30pm until Midnight AT Kidderminster Town Hall IN the West Midlands."

Has anyone ever come across anything like this before? If I hav backed up wrong or imported wrong please could you provide steps with the DBtools program.

Db On Live Site And Replica On Development PC
I have a Db on my live site, I use DW to manage the site and phpMyAdmin to
manage the mySQL Db, and I'd like to do the following:

1. Replicate the Db on my Dev PC, to modify then reset the live version on
the site to match it.

2. Set phpMyAdmin config to look at the PC version of the Db when developing
and the Live version when its up on the site.

Hope these make some sort of sense - just new to the world of php and mySQL
(actually an MS developer).

MySql 5 On Hoster's Remote Site
I set up an application using Flex, C# web services and MySql 5. On localhost the app works fine. No problems.

However, when I uploaded the site to our hosters, C# can't find MySql db. I followed all the same directory structures layout as on the original.

Using MySql Maestro as my tool I can connect to the remote MySql db.

Database Design For Ecommerce Site
I am looking to design an ecommerce site with categorised products.
Once built, I want my client to be able to add additional categories and be abel to add their products into their chosen category.Would I be best displaying this dynamnically after creating a table with the products category names in it or doing it static?
Also, if I wanted to show a different header / meta tags for weach category how would I best tie this in?

Dating Site Zip Code Distance Question
I'm doing a few tests with a table of 10,000 bogus users and i'm comparing their zip codes against the the user searching and figuring out the distance using the formula you can find in these forums. Problem is that it is slow...especially when I'm joining other tables to the query.

Is there a better way of doing this? Maybe I should just search using the Metro area instead of the zip code. That would make quicker I think since there are far fewer metro areas than zip code entries.

How Do I Change The Date Of A Post On My Forum Site?
Hi, I have started a forum site with a couple of friends. The forum runs on xoops using php 4 with a mysql (4) database. I accidently deleted a few posts. No problem there because I had a copy of the text and posted it again. But the problem is the date and time - obviously it shows the date of the new post and not the date of the deleted one. As I am a newbie still experimenting with mysql and php, I'd sure appreciate your help.

Summary:
=======
I need to change the date of a post in the mysql database. I access the database using phpmyadmin.

Preoblemwith Displaying Utf8 Chars In Web Site
I have the following problem: I have a database entries with cyrillic characters and I cannot display them in my website (instead I get "?????"). I have set the files for the website in utf-8 character encoding and all the static characters in the web site are show as they should. The according table is in utf8_general_ci encoding and all the system character-/collation- variables are in utf8/utf8_general_ci encoding.

I would be very thankful for some help!

P.S.
character set client utf8
character set connection utf8
character set database utf8
character set filesystem binary
character set results utf8
character set server utf8
character set system utf8
collation connection utf8_general_ci
collation database utf8_general_ci
collation server utf8_general_ci

Setting Server Variables On A Hosted Site
I want to change my MySQL server variable to ft_min_word_len = 1; and get have it not read the stopword file (ft_stopword_file). This is running on my website's webhost. It is already running and I believe they have the access to the config files..

I tried setting it through a query, and while I can view all the server variables, trying to set them to anything gives me an "unknown variable" error. (I don't think I have access to mysqld, just queries and trying to convince my host that they are the ones to change this...)

Version Number Of Mysql On Active Web Site
how to tell the version of mysql I am using? I'm not technical and the person who installed this is nowhere to be found. But I do have access to the server. It is a 5.x on win2k.

Site User To A Paid Member? Database Design HELP
I am currently working on a website where there are 2 types of users. The regular site user and a paid member. I am trying to figure out the best way to design the database (mysql) without redundancy issues.

The site user can eventually become a paid member but a member does not necessarily have to be a regular site user (in terms of category). Information stored on a site user - first name, last name, address etc. The userID being the primary key. The member pretty much the same thing but new info will be memberID, join date, expiry date, status (pending, active, expired).

I thought the easiest way to do this was to have separate tables. Do you think the best way?

My thoughts are: When the regular site user becomes a member then store the userID in the members table.

The issue I am faced with is how to store the other pieces of information. The address is not mandatory for the site user but is mandatory for the member. So, if the site user has an address then store it in the member table? that's redundancy there. Then a member do not necessarily have to be a site user in the sense of storing the info in that table.

Design issues to think about
- activation of membership once a confirmed payment has been received - Client is using Paypal.
-What if the user clicks on membership and the user is also a site user?
-What if the user is logged in as a site user and clicks membership?

I would greatly appreciate your design recommendations.

PHP And MySQL Update Makes Our Site Behave Badly
our web host updated their php and mysql version to 5, and now our website is behaving badly theres no one going to visit it. This is what happens, if a page has to query 10 times before everything is done, sometimes the "error connecting to database" show after the 3rd query, sometimes at 5, sometimes at 7. sometimes it loads the page just as it use to be.

what the hell am i suppose to do? their technical support is nothing but a html page on the site, no support whatsoever!

we'll shift host in a month, but we need this sorted out fast,

Pull Data From 2 Database Tables Into 1 Table On My Site.
I got 2 tables: a dev_tasks and a task_history table. The task table has to record information about the task I am working on AND the history table is for the task history logs. I am trying to display info from both tables into 1 table on my site.

Most of the info will come from the dev_tasks table BUT i want to dedicate on column of the displayed info for the latest log made to the task_history table.

The common column to both tables is the 'taskid' column.

What would the query look like to pull the info from both tables, knowing that the taskid is common to both and that I want to display the last log per tasks from the task_history table?

A Seprate Database For PHPBB Or Merge The Tables With The Site?
I have a databse for the main website that will contain ~15 tables. Are there advantages/disadvantages to merging the phpBB tables with the one from the site or seprating the tables sets in 2 different databases?

Making Site Login Add Users To Phpbb Database Table
I have a login script for my site that I got off the net and was planning to use, but, I also wanted to make it so that when a user signed up thru the registration form it would also add them to the phpbb database's table. It wasn't discussed heavily from where i got the script but from what was mentioned the encryptions differ which results in a rejected login. Code:

Search: Remove Quotes From Database For Search
I am making a book site and currently in the database are book titles likes "John's Trip" and "Peter's new bike". I have a search function where the customer can type in "Peter's" and it will bring up everything with "Peter's" in it.

But i was wonderind is there any way i can search for "Peters" and "Johns".

Store Web Site Club Registration Data (was "MySQL Question")
I am working on a website for a club. One thing that they want included in the site is a way for people to register online for the club and their services and for this information to be put into a database for the owners to view. Is this something that I can do with MySQL?

Random Password Vs. User Created Password For Site Login
Are there any security issues or other concerns that make one preferable? The client is pushing for user created passwords.

I'm mapping out the basic functionality and front-end for a MySQL/PHP back-end that will be completed by a third party. I'm a novice to MySQL but familiar with PHP and their interaction. Mainly looking for anything to support one method over the other.

I Have A Search Form To Search Through The DB.
I have a DB with 50,000 entries. I have a search form to search through the DB. If the recno=30123456 and you search the recno, you get that one file. what if i want a query that searches alll recno's that contain 30?? Can I do that using mysql or do I need to program that in my java app?

Best Way To Search
I am a little confused on the best way to search a mySQL database with PHP.

Which is better?
1. Search with LIKE and a trimmed term

SELECT * FROM tablename WHERE field1 LIKE "%$trimm%" OR field2 LIKE "%$trimm%" OR field3 LIKE "%$trimm%" ORDER BY field1 DESC
2. Using mySQL's 'match against'

Search WHERE SUM
What would be the proper way of generating a query like the following;

SELECT id FROM sales WHERE SUM( totalsales) <= '20000' GROUP BY id;

Assuming the table looks like this;
Sales:

Id| totalsales| monthyear
1 | 100| 2003-09
1 | 10000| 2003-08
1 | 2000| 2003-07
2 | 30000| 2003-05
3 | 10000| 2003-06
3 | 10000| 2003-05

I want the query to return id 1 and 2 as the sum of their totalsales is
smaller then 20000.

DB Search
I am working a search tool for users to find members based on First Character of lastname.
How can I have mysql or PHP only look at the first character of the string?

Search
I have an ASP page that searches a database. Although the entire database is searched, I use a filter on certain fields. The below filter (I could only use a little bit for the post to work)is for a field [LEDef_ActiveInd] that has either the number 1 or 2 or the text of true or false and it works and returns all "LEDef_ActiveInd" that carries the value of true.
..strQS = ..strL & "...LEDef_ActiveInd+true nd all+" & Trim(strR)

What I would like to do is also filter a field [LEDef_Cd] which has text data such as "10-Name" or "40-Name", etc. I need a filter/code that would return the results of all the "10-Names".

My SQL Search
I'm currently using the following mysql statement to perform a search. Right now it is only returning the results which are found in the description field. How do I modify this statement so that it is searching

the following fields: company_name, product_name, description.

SELECT product_id, company_name, product_name, url, description
FROM product, company
WHERE product.product_id = company.company_id AND description regexp
'#FORM.query#

Search
i have several tables. they have some fields in common, but some different ones.

table 1

id author title journal year
1 brown java computing 2005
2 black sql database 2000

table 2

id author title publisher year
1 brown c++ pen 2006

how do i search both tables for i.e. author ? the author can exist in only the one table or both. so if i search brown i get:

id author title journal year
1 brown java computing 2005

id author title publisher year
1 brown c++ pen 2006

if i search black i just get :

id author title publisher year
2 black sql database 2000

Search
I have a search box on my site which works fine but I would like to improve. at the moment it will not return a result for a two word search unless those words are adjacent ie red box but not for return for red big box I would like to make it give results for multiple word searches when the:

words are found
In this order

all words in search adjacent
all words in search (not neccesarily adjacent)
any of the words

I assume the following tells it what to look for and how to display results (I hope so any way) Code:

Search Box
I am trying to have a search box on every web page in the site - like everybody seems to have these days, anyway, according to DW help the search page results holds the key to how it searches the database, but the trouble I am having is what to put in the sql box for the query?

I know SELECT * FROM table will select everything and I know SELECT * FROM table WHERE location = 'town' ORDER BY price etc,etc. But what I need to know is how to have the results page display one set of results if a user enters one topic in the search box and another set of results if something else is entered. And if there is nothing to display, how do you configure that?

SQL To Use For Search
I am creating a script that searches the table "sites" in the database "actionhostsearch".

I have a column in my table called "keywords" and i want to check that against my entered text, I am currently using LIKE but don't get a good result, is there a way I can refine it?

The keywords are space separated, but i want it to search like multiple keywords. Is there anyway of doing this or would i have to separate the keywords out using php?

Search My Site

All my documents and archives are in mysql database. How do i setup that i can search my website?

All my documents and archives are in mysql database.
How do i setup that i can search my website?