mysql

Shall I put contact information in a separate table?

I'm planning a database who has a couple of tables who contain plenty of address information, city, zip code, email address, phone #, fax #, and so on (about 11 columns worth of it), a table is an organizations table containing (up to) 2 addresses (legal contacts and contacts they should actually be used), plus every user has the same in...

Mysql query for getting unique rows

I have table named 'testing' of 3 columns i.e. user,score,time in that 'time' is unique and user,score is repeated with different score. like below user | score | time ---------------------------- 535 | 17 | 1279170280 535 | 1 | 1279170693 100 | 55 | 1279171361 100 | 30 | 1279171412 535 | 2 | 12...

how to upload,play and store videos in a better way on my website

hello i am trying to making(just for knowledge purpose) a website similar to "you tube" and i am using LAMP(linux+apache+php+mysql). so please guide me on these topics(please keep in mind that the website is a high traffic web site like you tube): 1.i am taking video uploads from user using a simple form like: <form enctype="mult...

Update MySQL row automatic at change.

Hi! I got a kind of admin-panel where I want to be able to change customers order status live without refreshing or changing page. I have figured out that I need to use Javascript, AJAX or jQuery for this but since I have no experience for that and have no time to learn all that I'm asking you for help to achive this. My code: <form> ...

Background update via PHP??

I don't know if it is possible only with PHP but thought will ask here... I do have a PHP code which updates data every 15 days. my problem is when it updates the entire process taking more than 5 seconds so user must wait until the updates done. what I am looking is I want to do an background update while user is viewing the content. ...

Need SQL to get a record with two corresponding entries

Hi guys, I have a table which holds contact details against corresponding account numbers: Contacts_Accounts Table contact id | account ID ======================= 1 | 12 1 | 13 1 | 14 2 | 12 2 | 13 3 | 12 how can I make a sql query that returns all entries that have BOTH account ...

PHP/MySQL Pagination with one query

The way I am doing my pagination now is as follow: =============== First I do the normal query, and get all the result back. After that I count the results, lets say 300. I do this with num_results Now I check what page the user wants, and the limit, lets say 30,10. Last I do the new query, with the limit selected. =============== ...

how to implement "contains" function in Mysql4.x ?

i have a keywords table,and i want to check a String contains keyword or not. String str="aaabbbccc"; TableName:keywordTable field:id keyword ------------------- 1 ee 2 bbb 3 xx .. ------------------ i run this sql (in mysql 4.1): select * from `keywordTable` where contains(`keyword`,"aaabbbccc"); return a syntax error how to imp...

use mysql inbuilt functions with cakePHP find()

can any one help me to use the mysql inbuilt function in cakePHP????? ...

Need Output like mentioned below in MySQL + PHP

Hi please watch the image link below for table structure. http://i31.tinypic.com/2v0zw4o.jpg we have to print it in a layout format like below.....like for d same date diff regions with total count.... Date CentroOeste Nordeste Norte RJ_ES_MG SaoPaulo Sul 7/6/2010 233 204 154 130 128 99 7/7/2010 0 ...

SQL query to get the bookmakers with the highest odds.

Hello, I try to solve an sql problem but without success and I thought that you could give me a good answer. My table looks like this: league_id|style|bookmaker|hometeam|awayteam|odd1|oddX|odd2| ----------------------------------------------------------- premier |1X2 |bet365 |arsenal |chelsea |2.50|3.20|2.30| -------------------...

MySQL permission denied from local but can connect remotely

I am trying to connect to my mysql database on a remote server (via ssh) through the command: mysql -u me -h mydomain.com -p But it fails with a ERROR 1045 (28000): Access denied for user.. error While mysql -u me -h localhost -p Works Now this isn't just because I have not setup permissions, because the permissions to this data...

Apache, PHP, MYSQL on Windows 7

What is the best (and easiest) way to set these up on Windows 7? I have tried Xampp and WAMP but all I get after installing them is a blank local host. So I create a php info file using the following code: <?php phpinfo(); ?> Put it in the httpdocs folder, call it using http://localhost/info.php and I get a 404 file not found erro...

MySQL OR question.

Is there a way I can use the OR or something similar inside a join, inside the mysql code below. INNER JOIN users_friends ON users.user_id = users_friends.friend_id OR users_friends.user_id ...

i need to question my database about a word received from another aplication, my tables are related on a many to many relashionship

i have 2 tables one market, another brand , so when a client search for a brand i need to return all the markets where he can find that brand. ...

MySQL - How to check if user_id or friend_id are equal to the logged in users ID ?

How can I query my database to check if user_id or friend_id are equal to the logged in users ID and that their friendship_status has been accepted. Here is the MySQL code I got so far. SELECT COUNT(id) as num FROM users_friends WHERE users_friends.user_id = '$user_id' AND friendship_status = '1' Here is my MySQL table. CREATE TA...

all combination output in mysql

I have three tables: table1, table2, table3. Table1 contains: Title1 desc LHR LONDON HEATHROW LGW LONDON GATWICK Table2 contains: Title2 desc2 W1 TESTW1 W2 TESTW2 Table3 contains: vehicle desc3 SALOON SALOON DESC VIP VIP DESC EXECUTIVE EXECUTIVE DESC I want to output all combinations like t...

Calling a stored procedure in mysql from .NET throws error - all parameters must have their type explicitly set.

I have a page which submits a form in my local system but in my production system when i click my submit button it just freezes with the error in my web developer toolbar saying Error: Sys.WebForms.PageRequestManagerServerErrorException: When calling stored procedures and 'Use Procedure Bodies' is false, all parameters must have their ...

What's the MAXIMUM number of records and tables MYSQL supports?

What's the MAXIMUM number of records and tables MYSQL supports? I've just seen a figure of 60,000 tables and 5 billion records but i'm sure it much more than that now? Does anyone know? Also love to see a comparison with other RDBMS's out there? Thank you in advance ;-) ...

Table join is so slow!!

Hi friends, I have joining two tables,There are hundreds of records in table a and there are hundred thousands records in table b.I joined them both inner and left join but it is two slow.My query is: SELECT ch.id, ch.client_client_id, ch.duration, ch.start, ch.isread, ch.prefix, ucr.ucr_add_factor, ucr....