User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
White Papers
All
•
•
•
•
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 332,572 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,151 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
•
•
•
•
FAQ | Community Rules | Welcome Guide
Please support our advertiser:
•
•
•
•
Showing results 1 to 40 of 78
Search took 0.01 seconds. Posts Made By: mwasif
Save these search results for 24 hours
Page 1 of 2 1 2 >
Forum: MySQL 9 Hours Ago
Replies: 3
Views: 66
Posted By mwasif
Re: Stupid Error!!!

Did you echo the query? You might be missing values for $c/$d.
Forum: MySQL 9 Days Ago
Replies: 10
Views: 267
Posted By mwasif
Re: MySQL Error 1064 when DELETEing

You were trying to run multiple sql statements with a single mysql_query() call which is not supported. If you need to run multiple queries in a single call, then consider the use of...
Forum: MySQL 9 Days Ago
Replies: 10
Views: 267
Posted By mwasif
Re: MySQL Error 1064 when DELETEing

Write statements without aliase e.g.
DELETE FROM images WHERE image_id = 803 AND plant_num = 2277 LIMIT 1;
Forum: MySQL 12 Days Ago
Replies: 2
Views: 261
Posted By mwasif
Re: Image Database

trudge is right, there is no point to save images in database. Displaying images from databse is relatively slow than filesystem. But if you still want to save images in database, take a look this...
Forum: MySQL 12 Days Ago
Replies: 2
Views: 226
Posted By mwasif
Re: SMS Message and Email Message

You can create database with either of them. Sending an SMS will cost you but email does not. To send SMS, you need a SMS gatewy like clickatell.com.
Forum: MySQL 15 Days Ago
Replies: 2
Views: 199
Posted By mwasif
Re: "no such file or directory" error in mysql

Are you sure the path is /Sites/Freeway/images. The path might be Sites/Freeway/images.
Tyep the following command in terminal and let us know what it says.

ls /Sites/Freeway/images
Forum: MySQL 17 Days Ago
Replies: 2
Views: 215
Posted By mwasif
Re: Setting Permissions in MySQL

You need to use GRANT (http://dev.mysql.com/doc/en/grant.html) statement.
Forum: MySQL 21 Days Ago
Replies: 1
Views: 255
Posted By mwasif
Re: Automate Query

You can create a script (PHP/shell) to move data and set the cronjob to run it every hour/day.
Forum: MySQL 21 Days Ago
Replies: 6
Views: 321
Posted By mwasif
Re: how to make a remote mysql server to be accessed

What was the error you got? Did you enable the remote access for mysql user?
Forum: MySQL 25 Days Ago
Replies: 1
Views: 227
Posted By mwasif
Re: mysql

What do you expect from the code and how it is behaving?

trim($searchterm);
should be
$searchterm = trim($searchterm);
Forum: MySQL 27 Days Ago
Replies: 3
Views: 335
Posted By mwasif
Re: MySQL SUM Statemene

Try
SELECT SUM(i.amount) - SUM(p.amount) FROM income i, payments p
Forum: MySQL 33 Days Ago
Replies: 1
Views: 329
Posted By mwasif
Re: select syntax for variable tablename??

SET @a = 'table';
SET @x := CONCAT('SELECT * FROM ', CONCAT(@a, '_', 'name'));
Prepare stmt FROM @x;
Execute stmt;
is same as
SELECT * FROM table_name;
Forum: MySQL 33 Days Ago
Replies: 7
Views: 248
Posted By mwasif
Re: Can i retrive different fields of a record as one result.

You can use CONCAT()/CONCAT_WS() (http://dev.mysql.com/doc/mysql/en/string-functions.html) functions to get as many fields as you want as a single column.

SELECT id, CONCAT(', ', location1,...
Forum: MySQL 33 Days Ago
Replies: 7
Views: 248
Posted By mwasif
Re: Can i retrive different fields of a record as one result.

Double post.
Forum: MySQL 33 Days Ago
Replies: 1
Views: 155
Posted By mwasif
Re: help for log files

These are data files. To recover data try these links
http://code.google.com/p/innodb-tools/
http://www.percona.com/services/data-recovery-services-mysql.html

As per my knowledge, you can get INSERT...
Forum: PHP 33 Days Ago
Replies: 2
Views: 363
Posted By mwasif
Re: how to save and retrieve an image using mysql and php

It is always better to store the images on disk instead of database. File operations are always faster than database. Saving the images on disk will reduce your database size which will give you...
Forum: MySQL Mar 30th, 2008
Replies: 3
Views: 182
Posted By mwasif
Re: small error with dates

You can use LIKE but can not use BETWEEN.
Forum: MySQL Mar 30th, 2008
Replies: 3
Views: 182
Posted By mwasif
Re: small error with dates

In MySQL dates are saved in YYYY-MM-DD.
Forum: MySQL Mar 29th, 2008
Replies: 2
Views: 207
Posted By mwasif
Re: Database Problem.........

In PhpMyAdmin on selecting a table from left frame you will see the related options in right side of the page. Select the option Import and provide the CSV file path. Then select CSV and the related...
Forum: MySQL Mar 28th, 2008
Replies: 3
Views: 324
Posted By mwasif
Re: how to use same database for two domains?

In order to work, you need to allow the mysql username (and your host also must allow this) to connect from remote machine. In host, you need to provide the IP or the domain name e.g. domain1.com and...
Forum: MySQL Mar 28th, 2008
Replies: 7
Views: 340
Posted By mwasif
Re: table does not exist

Are you using the same mysql username with PHP and with GUI to confirm the table existance? May be they have rights issue.
Forum: MySQL Mar 28th, 2008
Replies: 7
Views: 340
Posted By mwasif
Re: table does not exist

Check your database if the table is there by using some GUI or command line.
Forum: MySQL Mar 28th, 2008
Replies: 5
Views: 212
Posted By mwasif
Re: Recommended books?

I always consulted MySQL Manual and Google and never read MySQL book. Did you look at MySQL Press books?

If you can get one from 'Unleashed ...' series from SAMS Publishing, i think it would be...
Forum: MySQL Mar 27th, 2008
Replies: 4
Views: 321
Posted By mwasif
Re: mysql

Dani, is he asking about DaniWeb.com's root access?:)
Forum: MySQL Mar 24th, 2008
Replies: 1
Views: 562
Posted By mwasif
Re: How do I SELECT FROM a subquery?

This should give you the required output

SELECT m_id, COUNT(*)
FROM taglink
WHERE m_id <> '25'
AND t_id
IN (
SELECT t_id
FROM taglink
WHERE m_id = '25'
Forum: MySQL Mar 22nd, 2008
Replies: 15
Views: 345
Posted By mwasif
Re: ISP issues with INNODB

I personally like www.liquidweb.com as I have referral link on my site as well :). We have dedicated servers with them. They are bit expensive but are really good. You can check hosting forums to get...
Forum: MySQL Mar 22nd, 2008
Replies: 15
Views: 345
Posted By mwasif
Re: ISP issues with INNODB

Did you get your money back?
Forum: MySQL Mar 21st, 2008
Replies: 15
Views: 345
Posted By mwasif
Re: ISP issues with INNODB

This is realy strange. Now you can find a host which supports MySQL InnoDB :)
Forum: MySQL Mar 21st, 2008
Replies: 2
Views: 218
Posted By mwasif
Re: Error if I use comma or any other symbol

Hi Adi,

Use mysql_real_escap_string() to insert such data if you are using PHP.
Forum: MySQL Mar 21st, 2008
Replies: 15
Views: 345
Posted By mwasif
Re: ISP issues with INNODB

I never worked with POSTGRESQL so I can't say anything about it. It also has community support like MySQL but after SUN acquiring MySQL things may go much faster in the favor of MySQL.
Forum: MySQL Mar 21st, 2008
Replies: 15
Views: 345
Posted By mwasif
Re: ISP issues with INNODB

I hope following 2 links will clear the...
Forum: MySQL Mar 21st, 2008
Replies: 15
Views: 345
Posted By mwasif
Re: ISP issues with INNODB

Do you have any other concerns?

To get best performance from InnoDB the MySQL server should be tuned for that :)
Forum: MySQL Mar 20th, 2008
Replies: 15
Views: 345
Posted By mwasif
Re: ISP issues with INNODB

Easy and quick fix is to change the host. There is a lot of good hosts around which provide hosting services.


I do not recommend doing this. You need more time, resources, good understanding of the...
Forum: MySQL Mar 19th, 2008
Replies: 5
Views: 469
Posted By mwasif
Re: Incorrect string value

Take a look at this http://forums.mysql.com/read.php?103,154519,154613#msg-154613
Forum: MySQL Mar 19th, 2008
Replies: 5
Views: 469
Posted By mwasif
Re: Incorrect string value

There might be some issue with file encoding. Because these queries can be executed without any problem if run on command prompt/GUI.

So the only thing that can create problem is file.
Forum: MySQL Mar 19th, 2008
Replies: 5
Views: 469
Posted By mwasif
Re: Incorrect string value

There is no issue with your SQL. Copy the data to a new file and run the new file.
Forum: MySQL Mar 18th, 2008
Replies: 3
Views: 323
Posted By mwasif
Re: retrieve data frm 2 tables

To clarify, you need to use JOIN (http://dev.mysql.com/doc/mysql/en/join.html) to get data from all 3 tables.
Forum: MySQL Mar 17th, 2008
Replies: 5
Views: 241
Posted By mwasif
Re: is my code correct?

And
$result = mysql_query("SELECT * FROM images WHERE 'Broad1'='$thumb_name'");
Should be
$result = mysql_query("SELECT * FROM images WHERE Broad1='$thumb_name'");
No quotes around Broad1.
Forum: MySQL Mar 16th, 2008
Replies: 1
Views: 346
Posted By mwasif
Re: MySql Remote Connection - Hacking?

If this is not your application then it should be some person whether it is you, your co-worker or some hacker. As a first step, install a firewall on your dedicated server (apf is very good if you...
Forum: MySQL Mar 16th, 2008
Replies: 1
Views: 147
Posted By mwasif
Re: help I keep getting this

You have a problem with your MySQL query. To indentify the problem, use mysql_error() (http://php.net/mysql_error) e.g.

mysql_query("some select statement here") or die("QUERY ERROR:...
Showing results 1 to 40 of 78
Page 1 of 2 1 2 >

 
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 12:27 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC