MySQL | Forum profile

Nope you have merely ducked the issue PHP Code: if( $status == "IN" ) { header ( "location: phpinfo.php" ); exit(); }else { header ( "location: login-failed.php" ); exit(); }  PHP: if - Manual

Hello, When trying to use mysqldump, I got this error message: Quote: mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect According to the MySQL Documentation Library, error 2003 means that my network connection has been refused and that I should check that there is a MySQL server running, that it has network connections enabled, and that the network port specified is the one...

Solved my issue. Used the mysql_result($status, 0); command and it gives me the data I want. Thanks!

obviously the "set-it-and-forget-it" strategy (apologies to ron popeil) is simply to put all your identifiers into lower case

Hello, We are using MySQL 5.0.44. When I run a stored procedure first time, it might take over a second. If I immediately rerun it, it takes milliseconds. Each subsequent rerun is also super fast. Why is this happening? Is there some caching? I thought there is no stored procedure caching in mysql 5.0. The reason I'm asking is because I am trying to optimize a stored procedure 'A'. So I created a modified version 'B'....

Yes, username is indexed. select count(*) was actually slower according to response time

I just now tried to upload my portal in the linux server and after I uploaded everything including my data base and tried to see the home page I get the following error - Can you help me how to solve it. Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'bestjobs_user'@'localhost' (using password: YES) in /home/bestjobs/public_html/system_function_initialize.php on line 0 Warning: mysql_select_db():...

I Developed 2 Table 1)FriendTable Code: CREATE TABLE `friendtable` ( `username` varchar(50) default NULL, `fusername` varchar(50) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 2)Msg Table Code: CREATE TABLE `msg` ( `msg` varchar(50) default NULL, `username` varchar(50) default NULL, `dt` date default NULL, `id` int(50) unsigned NOT NULL auto_increment, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 i need to...

Hi All, I need help in optimization of my following query, which takes too much time to pull out all the data... I have build indexes on all columns which involve in 'joins'... any suggestion or idea to improve it...? select x.question_id as question_id, (select text from vw_questions where vw_questions.id = x.question_id) as question_text, sum(case when vans.nature = x.answer_nature then x.no_of_clicks else 0 end) as no_of_clicks ,...

Hi I am creating a searching api for an e-shop with a mysql db. I use these tables from the db 1)Products 1)Manufacturers_xref_prods 2)Prices_xref_prods 3)Attributes_xref_prods each of these has a "product_id" column. I need to retreive the common product_id's from the selected by the user Manufacturer,Price....etc I have 2 options to do that 1) Run small queries that refers on 1 table for each of the above tables...