10,944 Topics

Member Avatar for
Member Avatar for naveedanjum

I am facing a query performance problem. While connecting to MySQL database through different Users methodology. Tell me does connecting by IP address user has over head. Like connecting using user@locahost or user@host-ip-address Is there any performance-wise difference by connecting using any of this user. I am getting a massive …

Member Avatar for mwasif
0
134
Member Avatar for ZPBSFG

Hello All- I'm in the process of getting started a complete website for guidance and discussion about a new type of banking/lending. I would like to offer my fellow investors or potential investors greater access to slice and dice the data of one of the key companies involved in this …

0
136
Member Avatar for MonkeyCode

Using the following: [CODE] protected void testDriver ( ) { String drivers = "nada"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch ( java.lang.ClassNotFoundException e ) { System.out.println("MySQL JDBC Driver not found ... "); } catch (IllegalAccessException ex) { System.out.println("Illegal Access"); } catch (InstantiationException ex) { System.out.println("Instantiation problem"); } System.out.println("Midway drivers are " …

Member Avatar for peter_budo
0
844
Member Avatar for Suzie999

[code] namespace sqlconnecttest { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { SqlConnection myConnection = new SqlConnection("user id=name" + "password=pass;server=http://www.mywebsite.co.uk;" + "Trusted_Connection=yes;" + "database=mydb; " + "connection timeout=30"); try { myConnection.Open(); } catch (Exception f) { MessageBox.Show(f.ToString()); } } …

Member Avatar for Suzie999
0
148
Member Avatar for som3on3

Hi, i need some help, since mysql benchmark don't work well on select i need help with a query what will be the fastest way? to use this query: [code]select * from news n, users u where n.users_id = u.users_id and u.users_id = '1' limit 0, 20[/code] using like this …

Member Avatar for 1stDAN
0
56
Member Avatar for tsteven

How do I format the links from a mysql query to show [U]click here[/U] on my webpage. $row['reviewlink'] (eg of reviewlink = [url]http://www.abc.com[/url]) I want this result to show in the html source code: <a href="http://www.abc.com" >click here</a> So the page shows [U]click here[/U] and links to [url]http://www.abc.com[/url] I want …

Member Avatar for tsteven
0
94
Member Avatar for lulemurfan

I've been trying for a few hours now, and to be honest I'm getting fed up of it not updating the table!!!:icon_sad: [CODE]$sql="UPDATE list SET title='$_POST[title]', console='$_POST[console]', system='$_POST[system]', tv='$_POST[tv]', sram='$_POST[sram]', chips='$_POST[chips]', size='$_POST[size]', md5='$_POST[md5]', sha1='$_POST[sha1]', work='$_POST[work]', error='$_POST[error]', retrode='$_POST[retrode]', comments='$_POST[comments]' WHERE ID='$_POST[id]'"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 …

Member Avatar for hielo
0
165
Member Avatar for lulemurfan

This is the part which searches and add the result to the 'pass' variable. At one stage I was getting a resource id number and found to get around that, but when I do this I get nothing on the pass variable [code] $result = mysql_query("SELECT `Pass` FROM `wiki` WHERE …

Member Avatar for lulemurfan
0
141
Member Avatar for thedrones

Hi all, I hope you are well. I have a very quick question for you please. I have a table with x rows and y columns. I need to select the top 100 rows ordered by col2 for eg. Further, I need to select only one row for a particular …

Member Avatar for 1stDAN
0
127
Member Avatar for teedoff

Ok back again. lol I just purchased a new hosting provider and was trying to transfer my database over to my new site. I exported the tables using Navicat and "tab" as the delimiter. I have three tables and they all saved as text files and look fine when I …

Member Avatar for mwasif
0
116
Member Avatar for keeda

Hi, Please let me know whats wrong with syntax of the following query, its written in MS Access format: Select count(*) from [Demographics/Job Data Table] D1 WHERE EXISTS (Select (*) from [Demographics/Job Data Table] D2 where [D2].[Supervisor ID] = [D1].[Employee #] and [D2].[Termination]=Yes) I am getting a syntax error message …

Member Avatar for mwasif
0
73
Member Avatar for arunpatyal1987
Member Avatar for arunpatyal1987
0
134
Member Avatar for Venom Rush

Hi all I have a table that has a datetime column. What I'm trying to do is select the time only like one does when selecting only the day or month from a date column (eg SELECT day(date)) Can anyone tell me how to get this right. Using the following …

Member Avatar for Ezzaral
0
177
Member Avatar for vibhaJ

HI All, my requirement is as below: lets product name is "aaa bbb ccc". Now in search coding i have use LIKE statement. [CODE]"... where product_name LIKE '%".$keyword."%'"[/CODE] Now when user insert 'aaa' or 'bbb' or 'ccc' or 'aaa bbb' or 'bbb ccc' search works. But if user insert 'aaa …

Member Avatar for mwasif
0
110
Member Avatar for wendeus

Hi everybody, I wanna make a simple leads form in php, this form has three fields. the first field is "code", the second one is Name and third is e-mail. the issue is that i have two tables in my database and i want in one hand store all this …

Member Avatar for CyberSpatium
0
145
Member Avatar for sami.asanga

Hi, Im having a problem with this image uploading thing..:( I was able to upload the image to a folder in the server,but the problem is I dont know how to set the path in the database.Every time after uploading I set the path manually.And I could be able to …

Member Avatar for teedoff
0
114
Member Avatar for mutawari

Dear all, I have some table on my database. i had input them via JSP and i view them on JSP too. i use simple MySql queri in it to view the values of the Table. But when i use another query like : [CODE] SELECT tabel_jawab.nis, CASE WHEN (tabel_jawab.jwb1=tabel_kunci.Kjwb1) …

Member Avatar for javaAddict
0
64
Member Avatar for arthurav

I use a couple of functions to which I have to pass the name of the mysqli connection in order to fetch some data. Is it safe to use a global variable for the mysqli connection to skip passing the connection name to the functions?

Member Avatar for FlashCreations
0
105
Member Avatar for ckant_kol2006

I want to upload and store images in MySQL database, but have no idea. Please help me out? Thank you

Member Avatar for FlashCreations
0
344
Member Avatar for ckant_kol2006

I have my website up and runnng succesfully with around 5000 member - [url removed] Now I want to start a Social Networking option for members using a CMS - like Wordpree-WU, Drupal, Joomla, SE ... How can I use my current users databese to these CMS database? Please help …

0
147
Member Avatar for ataomega

hello all i'm using cUrl and mysql in PHP but new to c++ for connecting to remote mysql database and run query what i need? should i install mysql connector? where are mysql libraries? may i download a large file for example 400 mb in c++ using cUrl ? i …

Member Avatar for ataomega
0
836
Member Avatar for gchurch

i want to use federated tables in my db and not sure how to set them up in phpmyadmin...? does anyone have a solution for me...?

Member Avatar for gchurch
0
630
Member Avatar for teedoff

How exactly do I transfer data from my local server to my remote server. I had been using Navicat, but want to do it using myPhpAdmin, if possible. Thanks for any help in advance.

Member Avatar for teedoff
0
116
Member Avatar for buzz-lightyear

Hey guys, I'm a total newbie with this PHP stuff but i'm stuck with my page that allows people to sign up to my mailing list. Every time you press the "Submit Query" button on the form it brings up the option to download the php file. Have been working …

Member Avatar for EverWebby
0
105
Member Avatar for rouse

I have a table with 3 columns, a record_num, a date field, and a description. In the date field there can be some rows that have a distinct date and others that have the same date. I wanted to take a look at all the rows that have dates that …

Member Avatar for mwasif
0
109
Member Avatar for usman6062

Hello guys, I am having a weird problem. I cant understand and i have spent almost 2 hours in finding the problem. Well,Actually I have a table of id,date,comment. id and date are composite primary key. so id always starts with 1 everyday. now i want to find the max …

Member Avatar for naveedanjum
0
138
Member Avatar for arctushar

Hi I m using xampp latest version. I have a table created by phpmyadmin. Now I want to delete all data form the table, But dont want to drop the table. Problem is that... When I click oncheck_all it select all checkbox. but some row r yello background. When I …

Member Avatar for mwasif
0
61
Member Avatar for sami.asanga

Hi, I need to print all the orders with the month in the Monthly Order Report.How should I do it.Can someone tel me how to do it... This is my query.Order date should equal to the relavent month... [code] $this->result = mysql_query("SELECT * FROM tbl_order,tbl_order_items WHERE tbl_order.order_id=tbl_order_items.order_id AND tbl_order.order_status='accepted' AND …

Member Avatar for mwasif
0
84
Member Avatar for sugikrish

Hi frnds, I need display mysql field as check box value. <?php mysql_connect("localhost","root",""); mysql_select_db("postal") or die(mysql_error()); $query = mysql_query("SELECT name FROM register"); while ($row = mysql_fetch_assoc($query)) { $tag = $row['name']; echo "<input type='checkbox' name='register[]' [U]value='$tag'[/U] />\n"; } ?> here i paste my code here. it displayed only checkboxes. not value.any …

Member Avatar for hielo
0
49
Member Avatar for 0xCMD

Greetings, I installed MySQL 5.1.48-2 on Fedora 13 64bit. Whenever I tried to connect using the terminal by typing : [B][user@work ~]$ mysql[/B] I get the following error: [B]ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)[/B] I also installed MySQL on Red Hat Enterprise 5 …

Member Avatar for 0xCMD
0
209

The End.