Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

mysql

0
votes
3 answers
142 views

Displaying message when no results found in PHP MySQL search

I have a PHP search script which queries a MySQL database. Currently, when no results are displayed the script shows and error. How can I make it…
asked June 25, 2011 2:18 pm CDT
Callum Whyte
1
vote
4 answers
129 views

Returning 5 results in PHP MySQL search

I want to only display 5 results from my database with my PHP search script. How can I do this? My PHP code is: <?php…
asked June 25, 2011 1:59 pm CDT
Callum Whyte
1
vote
1 answer
244 views

MySQL on a dedicated server vs increasing RAM on server with MySQL + Rails app

I'm running into scaling issues with a Rails app running on top of MySQL. I'm using memcached and have lots of indexes. I'm also starting to…
asked June 25, 2011 1:43 pm CDT
dan
2
votes
1 answer
99 views

Suggestion for upgrading VB6 app w/ good printing support

I wrote an application on VB6/Access for a retail shop almost 8 yrs ago. They are still using it, and now they are asking for changes/upgrade and…
asked June 25, 2011 1:28 pm CDT
palaniraja
0
votes
1 answer
94 views

How to create Myisam database with Mysql ??

I want all my tables and infact the whole database to use Myisam engine. My Project uses myisam database exclusively.. So.. I want that by default…
asked June 25, 2011 1:14 pm CDT
Yugal Jindle
0
votes
1 answer
62 views

Mysql db doesnt save text if its too long

My problem is pretty much decribed with the title! I have this code that inserts data to the db: <?php require_once 'connection.php'; $pName =…
asked June 25, 2011 1:04 pm CDT
Fabian Hasan
0
votes
1 answer
65 views

Facebook live search using php jquery mysql, showing 5 results how to show the rest?

hello i'v built a search, using MySQL, PHP and jQuery, this is the search query using Prepared Statement.. $sql = "SELECT singer_name FROM singers…
asked June 25, 2011 12:48 pm CDT
Pinokyo
1
vote
2 answers
47 views

Is mysql_real_escape_string() sufficient for a MySQL REGEXP?

Could $user_input in the following code be chosen to make the MySQL query not behave as expected? <? $regexp = mysql_real_escape_string(…
asked June 25, 2011 12:45 pm CDT
Tim Nordenfur
0
votes
1 answer
60 views

MySql Python Adapter Installation Problem on Windows 7 Machine

C:\Users\Me>easy_install MySQL-python Searching for MySQL-python Reading [http://pypi.python.org/simple/MySQL-python/ Reading…
asked June 25, 2011 12:27 pm CDT
Milli Saboski
0
votes
3 answers
46 views

Is it preferred to create tables in mysql using a third party application (phpmyadmin, TOAD, etc...) versus php?

Is it preferred to create tables in mysql using a third party application (phpmyadmin, TOAD, etc...) instead of php? The end result is the same, I…
asked June 25, 2011 11:57 am CDT
LedZeppelin
1
vote
1 answer
49 views

Portable MySql-Driven App

My father has a small business and asked me to make him a quick program to help automate several of his daily tasks. Due to the nature of these…
asked June 25, 2011 11:47 am CDT
Kim
0
votes
1 answer
59 views

How to enable MySQL Query Log?

How do I enable the MySQL function that logs each SQL query statement received from clients and the time that query statement has submitted? Can I…
asked June 25, 2011 11:41 am CDT
Feng-Chun Ting
0
votes
3 answers
66 views

Different table for insert and select

In order to improve insert performance and load on server, I've decided to divide a large table into 2. A big table which will only be used for…
asked June 25, 2011 11:07 am CDT
Noam
0
votes
2 answers
53 views

Sql insert statement sometimes working other times not working

Im building an application and Im having a bizarre issue where sometimes an sql statement will work and the very next call the exact same sql…
asked June 25, 2011 11:05 am CDT
edmund
0
votes
0 answers
70 views

How to get Apache and MySql in XAMPP running?

I installed XAMPP in my pc and start run the XAMPP Control Panel Application. The FileZilla is automatically running but Apache and MySql is not…
asked June 25, 2011 10:44 am CDT
Jack
3
votes
3 answers
63 views

Best way to store similar music

I have millions of songs, each song has its unique Song ID. Corresponding to each Song ID I have some attributes like song name, artist name, album…
asked June 25, 2011 10:38 am CDT
Kevindra Singh
0
votes
1 answers
55 views

MySQL stopped asking for passwords

I'm currently experiencing a weird problem with one of my MySQL database servers: It stopped asking for passwords when I try to access the database…
asked June 25, 2011 10:15 am CDT
BlaM
-3
votes
0 answers
55 views

What sort of server specs do I need?

I'm going to create a php web application using mysql for a business in the future and I want to know what sort of server specs do I need? I will be…
asked June 25, 2011 10:14 am CDT
zentenk
0
votes
1 answer
61 views

Delete after 45 days

If an account kept inactive for 45 days that account should be deleted automatically. How to perform this? Do the following function old_date+45…
asked June 25, 2011 9:54 am CDT
Karthik Malla
-4
votes
0 answers
42 views

MYSQL Dont update connected to python

enter code here def pacman(self): while True: while True: try: x1=self.sockfd.recv(2048) print x1 print "\n hi" conn.begin() x.execute("UPDATE…
asked June 25, 2011 9:32 am CDT
Popo
Pages : 1 | 2 | 3 | 4 | 5 > [1061]
21205

mysql

Tagged: mysql
Related Tags
php × 7748
sql × 3105
database × 1613
query × 1045
java × 558
join × 466
ruby-on-rails × 415
c# × 395
phpmyadmin × 355
html × 353
select × 337
javascript × 304
python × 299
jquery × 284
php5 × 284
performance × 281
innodb × 249
table × 249
codeigniter × 241
ajax × 233
mysql-query × 227
insert × 222
linux × 210
hibernate × 209
update × 208
arrays × 203
asp.net × 198
pdo × 188