Hi folks,
Ubuntu-6.06-LAMP-server-amd64
I followed section "10 MySQL" on;
http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p4
and found "libmysqlclient12-dev" ...
[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 my jsp form named frmAdminSelectid.jsp.
In this,i am coding to get data from database from one table called artist.
i have three different conditions where i need to display artistid'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
Hi people
I am trying to lock a table which was created in the MyISAM engine.
I use the following query:
Code:
LOCK TABLES A WRITE;
That works fine
At the end of my executing 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
I have an art website. I have the pieces of art grouped under each artist. I need to be able to change the ordering of the art from time to time. Currently, they are ordered by most recently ad...
[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 search by zipcode query. It used to work on MySQL 4 and now gets the error " Unknown column 'location_zip' in 'on clause' ". We have a huge list of zipcodes with their latitude/l...
[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 there
I was hoping for some urgent help. One of my websites is having big problems with MySQL. Its a popular website and MySQL hasn't been able to cope. The site recently froze, here is...
[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 community website i'm doing "friends" in a similar way to myspace.
What's the best way to do it ?
Have a two rows in the friends table. One with the the user reqesting the friendsh...
[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
Currently I have an algorithm to do this, but I'm interested to know whether it could be done using a SQL query, here's my table:
Value1 Value2 Code
-----------------...
[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
Well, I own a website for rating pictures of girls.
The thing is, I need to implement a anti-cheat voting script so that people can't vote more than once on the pictures.
I am thinking of ...
[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'd like to be able to move up/down output data (rows).
So i need some help how i could swap two rows in a table.
This is what i tried:
Code:
$q_pos = mysql_query("SELECT * FRO...
[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 Guys,
I have inherited a query that works perfectly on MySQL 3/4 but not 5. I didn't write it and very little experience with joins.
So my first question is... what's it trying to do and...
[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
hello friends,
i have 3 tables namely--- artist, journalist and songs.
i try to update the flags in artist and journalist and try to update few fields from songs by firing foloowing qurries.
...
[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
Anyone know what the select speed difference is between MySQL 4 and 5, if any? I'm not looking for a specific number since of course it will depend on a whole host of factors, but I'm just wonder...
[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
Hello all.
So I'm looking for a way to pull the results from the database showing all the records EXCEPT for the latest one i.e. if there are 30 recordsets I only want to show numbers 1-29.
...
[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 set up a mysql database with several tables on a shared server. I have raw data (sql) I want to populate the tables with and am using the command line in telnet. Can someone give me an exam...
[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
Arrrghh,
Just learning from a php/mysql book, really getting through it ( the larry ullman visual quickstart one) and i left it on the train on the way back from london! IM gutted
Could 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
Is there any way of looping through a list of dates obtained from a table, e.g. "select mydate from mytable" and then for each of the dates call a stored procedure, e.g. CALL MySP( theCu...
[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'm creating a solution where I want to be able to control which users can use each page.
This is how database is designed (in short).
PHP Code:
pages
id | page_title
...
[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
hello friend
i have two website . both hosted on diff. server
now what i need is to connect second website database from first website
***
detail
***
when user register...
[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,
Ive set mamp up on my mac and although i know i can use phpamin to manipulate mysql i want to use the terminal to do it.
so i cant even get myself dumped on the mysql command line. 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
I'am working in kevin yanks book. It seems to be a good one
but,for some reason I can't seem to get passed this part.
I've worked on it for couple of days now and still can't
figure out why...
[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
Dawned string ->$q=mysql_query("select * from usrlogs where match('ID') against ('1') ") or die(mysql_error());
Having some idea why it is not working .
...
[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 there,
I'm trying to add a FULLTEXT index to one of my tables but it isn't MyISAM. How do I change it (command line)?
Thanks.
...
[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,
Recently I have got a new computer and I have installed PHP, Apache and MySQL on it. I installed version 5 of MySQL. On my previous computer I had 4.1 and made a mysql dump like the follow...
[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,
can any one suggest good online mysql tutorial.
Bye..
Azhagiri
India
...
[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 
