Is it possible with mySQL to get results when the spelling is not exactly correct. E.g. a visitor fills out the field with Amstrdam (note that the "e" is missing). Is there a function fo...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
i am new to mysql/php , i want to query last 10 result from mysql database, can anyone help me with the command?
sarath
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi
i have installed mysql 5 on windows server 2003 and when i want to connect to the database throgh my script it gave me this error
Warning: mysql_pconnect() [function.mysql-pconnect]: Client...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Can some one help me here
Im trying to use this session based logon class from PHP Classes site its working great and now i want to incorporate my users database to allow users and employee...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Can some one help me here
Im trying to use this session based logon class class from PHP Classes site its working great and now i want to incorporate my users database to allow users and em...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I want to replace a character "/" with ⁄ in my database, is there any option to do that.
Its like : "this/is/a test line"
and after replacement it should looks ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I want to replace a character "/" with ⁄ in my database, is there any option to do that.
Its like : "this/is/a test line"
and after replacement i...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
And YES its connected to mysql DB i need help (a fix) ASAP thanks
<?
$sql = "UPDATE `games` SET `sponsor` ='$WebsiteURL' WHERE `gameid` =$GameID LIMIT 1";
$result = mysql...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
The following query only reads the first character of a comma separated list stored in a field of the records being queried.
The varchar field in table d named "display" holds 1,4
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Probably a very simple question but can't make it work.
In a db, I'be got letters comma separated: a,b,c,d...
Each set of letters has a name. ex:
setname = first set / letters = f,c,d,r,h...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
This is in reference to thread -
http://www.sitepoint.com/forums/showthread.php?t=409120
I am looking for a way to do the clients as well. there has to be a way to update the windows vers...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a table which has these columns:
voterID | voteeID | grade (between 1 and 10)
I will be calculating the average grade for each votee whenever someone looks up the votee. To save my s...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Am having a problem with a query, strangely ...
PHP Code:
SELECT *
FROM table1 AS mt
LEFT JOIN table2 AS pt ON mt.p_id = pt.p_id
WHERE my_field = 'somevalue'
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
On my site I have a query that searches through 1,7 million. The php-file with the query takes a bit of time to load. Is it possible to show some sort of progress-bar during this time?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
How could I do a query like this:
PHP Code:
SELECT * FROM employees WHERE sex='female' AND haircolor='*'
Where * is supposed to mean 'all records in thi...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
I have a few SQL questions..i was hoping you guys could help with!
Example: I have 3 tables, one which is a series of id's, and the other 2 which contain data:
talbe: contacts_...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi All,
I have the following code:
SELECT tbl_products.product_id,
tbl_products.product_MerchantProductID,
tbl_prdtscndcats.scndctgry_ID,
tbl_prdtscndcats.scndctgr...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi
i have a table and i have added a new field 'downloads' with datatype 'text; at the end of the table. the table was already having records. when i run this on my local machine having window...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am not able to get ahold of the data I want to display properly.
First a little background information.
I have tried to setup a database layout that will allow me to run statistics on an...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
In an effort to try and clean up some of the old junk post in the forums, we are going to start pruning some of the spam and introduction folders that provide no value or use to the forums. This may a...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I made a bad form with a form creation app in a hurry. Now I have a table that is nearly useless.
The form was meant to record teams for an upcoming volleyball tournament. I provided inputs ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I'm running a PC with Windows XP pro, VS2005 professional edition, and MySQL 5.0.24a.
I downloaded the VS Plugin and I'm trying to create a new connection to MySQL:
Inside VS en...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have the following 2 tables with a many 2 many relationship between them
Category TABLE and Member TABLE.
CREATE TABLE Category
(
CategoryId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Is there a way to show what type of a storeage engine a table is using from the mysql monitor?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Does anyone know of any tutorials or documents which would help someone like myself work out how to search a database and calculate relevancy.etc. I'm creating an auction site and so I want people...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
