[mysql] Forum Topics

well I'm not even a programmer, so please bare with me. let's say I own a myspace clone and my server is bogged down by heavy traffic. So what's next? I know I can place mysql on a separate server, but what if that's not enough? can i split mysql? …

Hii all I am new to this forum. could someone plz tell me how to validate a csv file before storing the values in mysql?:?: i have the code for uploading csv to mysql but not validation... plz reply ASAP. its urgent..

Hi every body.. i have some problem,, problem is that i want to make a prepaid customer pages.. like that a customer enter an activation code & access code, mysql verify it(if data exists in database).That the code are matched and then go to next page named as registration page …

python 2.4.1 mySQLdb 1.2.0 kernel 2.6.12 Hi, How can I make the following statement so I can search for any string? Right now I need to input at runtime %whatever I'm looking for% between % signs to get all records matching that query. I want to have this statement set …

The administrator quit- the site went down- when you login it points you to "mysql" has too many connections. we have done all the obvious mysql fixes and the problem is in the asp/net - the previous developer used visual studio? We need someone to take a look and tell …

Quick question. I have an updatestring to send into an SQL command. It actually needs to update three columns in one row. I know how to write the string to update one column but is there a way to write this string to update 3 colums in that one row? …

Hi This is my first post. I need a help on db designing for one requirement. 1.) For a domain name i will be collecting three statistics every day for one year. I thought of creating table for a domain name with each column (for each date). These column will …

Hi Iam new with php & making searching module for client.for searching i select two values from DROP DOWN list i.e: Category & City, Third value is the search string entered by the user like Hussain & co. Now wht i want is that , it giv me results by …

I have a page with many links on it but all the links are saved into my ,mysql database.These links are displayed on my site.I wanted to know if google robots sees those links there.if the admin of this forum will allow me to post my links page so that …

Hey, Does anyone know where the settings for MySQL's Query timeout is located? I think it should be in one of the ini files, but i don't know where i can find this. Thanks! AlPhA

Hi All, Need our expertise out there regarding the above mention error and below are the codes: [code] /* send SQL query */ bzero(query1, sizeof(query1)); sprintf(query1, "select a.CreateDate, a.MobileNumber, b.BillName, b.CorrName, b.ICNew, b.ICOld, b.Passport," "b.Addr, b.Addr2, b.Addr3, b.Addr4, b.Postcode, b.CountryCode from Register as a, Profile as b" " where a.MasterNumber …

please guide me how to acess database for mysql thr' php, i tried a lot but getting error like cannot open the page or c:/program files/ apache/htdocs/dbconnect.php Could not connect to database why these error, i am using mysql 5.2.0, php 5.2.0 and apache 2.2.3, are there any setting needed?? …

Hello, I am developing a simple calender in my site which will display the next upcoming birthday of my member. I have a table which has 2 column cname | dob ------------------- Joe | 9/12/1982 Mathew | 2/17/1997 Pat | 8/23/1880 ------------------- What SQL Query should I use to get …

G'day ladies and gents, I'm Kam. I'm from Birmingham. Pardon the username, but my excuse is that I've just been listening to some Jimi Hendrix for some inspiration. I've recently been introduced to database driven websites and I'm still finding my way around php and MySQL (among other things). I'm …

Below is the code I'm using to try and simply display the contents of a table...however, I'm getting the following errors: `Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in d:\Customers\user######\www\dbtest.php on line 18` `Warning: mysql_query(): A link to the server could not be established in d:\Customers\user######\www\dbtest.php on …

Hello all, I am designing a website using php and My SQL. It is an educational website which has an administrator... the adminstartor shall have the apility to add, delete or modify a course. I finished a part of the website but i dont know how to begin to implement …

Howdy everyone again, Just thought that i would post another snippet for those interested in working with databases and C# in the windows forms environment. I did some searching on this and found that there was not really any clear concrete answer on how to do this. After some searching …

i don't see anything wrong with it... what's the deal? this is the results page that displays the results of a search query. [b]Parse error: parse error in ../../../../merchandise/testreg/results.php on line 21[/b] [code=php] @ $db = mysql_connect("localhost", "apache", "R3GP@SS!"); if(!$db) { echo "Error: Could not connect to the database. Please …

When I try to add a new data source from MySQL I get this error: Connection verification failed for data source: entry java.sql.SQLException: Invalid authorization specification: Access denied for user 'root'@'localhost' (using password: NO) The root cause was that: java.sql.SQLException: Invalid authorization specification: Access denied for user 'root'@'localhost' (using password: …

Hello I have a search page where you select the letter of the alphabet and the person's information who's name beginning with that letter is displayed. This function is placed on the web page to search and display the information. Everything works except one thing. The problem is if there …

hi , how do i migrate data from mysql to mssql.....i need some free convertor tools....can any body help me

I have a password protection for my website. The LogIn name and passwords are stored in a mysql database. My question is: How can I define that a person who has a LogIn can only see some pages of the whole website? How can I connect the information about which …

I fond some tutorial that can search one field of the table in a database,. But I would like to search the whole table.. In my table I have people's name by first name, last name, phone number etc... how can I display the whole thing as a result? For …

Hi, i decided to make program, which will correct addresses in access file or some DB. Is not importent. But there is main question whic way to chose? Is this just complicated sql, or is this some nice tool written in VBA,VB,java,...? Requirments are big: Number of data is above …

for some reason or another, my AUTO_INCREMENT command won't work in my sql table for the column named 'ID'. i have no idea why. it SHOULD work, but it doesn't. anyway, that's not really much of an issue. however, i have decided to take this opportunity to learn something new …

Hi... Ok I have created a form which posts data into a mysql database. I can then read that data from the database with another page. I am trying to add russian text to the database... it says it has been added but it comes back as ????? I can …

hi, I decided to build a quick forum system for my site. nothing too advanced...heres the db setup i have. create table ForumsTopics ( id int auto_increment not null, topic_id varchar(7) not null, title char(100) not null, cat char(1) not null, views char(6) not null, date DATETIME not null, last_mod …

I have successfully got the data reader connected but i cannot figure out how to write the values to an array or variables on a windows form created in Visual C# Express edition all examples use the console. Can someone show me an example of how to write these values …

Surfed in looking for a solution for a WMP video problem and like the style of this forum so I joined..... Not as young as most of you guys and gals... getting on for 65 and retired lawyer, active radio amateur (that is why the nickname) and playing with electronics, …

This code is what I use to populate a dropdown menu to pick an NFL Team for the super bowl. Once they select a team I want a second menu that will draw from the same table but only grab from the opposite conference of the first team. The table …

Hi all, I try to compile my program and got this kind of error: test6.c: In function `main': test6.c:46: too many arguments to function `mysql_query' Here is my code: [CODE] int main(int argc, char *argv[]) { char string1[1600], string2[1600], query[1600], mobileno[50]; int i, j, len; FILE *fp2; mysql_init(&conn); /* Connect …

Hi I would like offer the user a choice of displaying search results. They should be able to select which column to ORDER BY and in ascending or descending order. $sort_order contain colums name $sort_type contain desc or asc How can I use these two arrays in the order by …

Trying to display images in html by calling a php script in the img tag. php script fetches the image binary from mysql. image is not displaying. here is img tag [code=html] <img src="getdata.php?id=1" /> [/code] my question is, it seems people are using the "...php?id=1" to pass an identifier …

i get this error: [B]Parse error[/B]: parse error, expecting `';'' in [B]/../../../../addCouple.php[/B] on line [B]156[/B] [code=php] @ $db = mysql_connect("yah", "blah", "blah"); mysql_select_db("registry_DB", $db); if(!$db) { echo "Error: Could not connect to the database. Please try again later."; exit; } $sql = "SELECT uID FROM my_search_table WHERE uID LIKE '%". …

[INDENT]I recently bought a piece of software and am having a hard time installing it. The instructions tell me to: 1.create a database on my [URL="http://www.computing.net/dbase/wwwboard/forum/126.html#"][COLOR=green][COLOR=green! important][COLOR=green! important]server[/COLOR][/COLOR][/COLOR][/URL](I have cpanel) 2.create a user 3.Enter this information in dbsetup.php file 4.Create a directory and ftp the files in the public_html folder …

Hi, I have one doubt in mysql command using limit. I want to delete a first record in a table using mysql query. I using the below query DELETE from view_me where member_id = '$sess' LIMIT 0,1 But if I used the above query mysql cannot deleted the record. It …

about VC+MySQL problem:) i install mysql odbc V5.0 driver i need to ADO Connect MYSQL DB; code: _ConnectionPtr m_CMConnect; ::CoInitialize(NULL); m_CMConnect.CreateInstance(__uuidof(Connection)); m_CMConnect->Open("Provider=MySQL;server=localhost;DataBase=test;port=3306;uid=root;pwd=","","",-1); but Program run error..... how to Ado Connect MYSQL DB; thank:)

i'm working on a simple search and results project. i don't have the database setup yet, but i'm working on that as we speak. i'd like for this to work the FIRST time i run it after the database is running. however, i'd like to add something to my search/results …

i have a mysql table with a few columns. some of the rows in this table might contain the same content in the same column. for instance. my column titles are 'uID' 'product' 'item' 'need' 'yah' 'blah' 'blah'... here's what i need i need some advice on how to design …

Hi, I am trying to insert a record in a mySQL 5.0 database through a JSP. I am getting an error that the format is invalid. I don't know how to manipulate the code using Java itself. Can anybody guide me? Thanks VDhara

Hello, Anyone know how I correct the following error message: My php website has category links, and I had to add a category which I did from my admin panel's "Category" than "Sub Category" than "Add". After I added the category, it shows up on my site but where the …

let's just say that this page i'm writing is called 'registry.php'. this page will be more-or-less a template, however contents of this page will vary depending on one variable. the variable is the ID number of a newlywed couple (in the database). the content of registry.php will contain tables. each …

i get a warning when i start phpmyadmin "The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results." any ideas? thx i have mysql server and …

Sir/Ma'am, I have a checkedlistbox and listbox in a window form, when i check the items that i want to search in a database in the checkedlistbox it will add to the listbox. My question is how can i pass the items in my query in order to search the …

[B]hi all,iI design database by sql by using visual studio 2005,i need to have pdf or any refrence guide to know how to write select,insert, delete statement ,could you help me[/B]

I get the result I want in a Datagrid by using Recordset Sql: Select * from MYQUERY Where (name Like 'WHATEVER*') I change the name by retyping the whole line, substituting the new name, typed into a long textBox named txt.Select, like this Private Sub cmdSelect_Click() Data1.RecordSource = txtSelect.Text Data1.Refresh …

HELP! I am trying to write a database app with three tables. I have figured out how to connect to my database with oledbconnect. From there I am confused as to how to get a select command to work. I have found plenty of info on selecting data from one …

Please let me know the code to populate the data from Table to Forms. What's the code for assigning values to Form buttons?

Hi, when I installed MYSQL Developer Edition, a new invisible user was created called SQLDebugger. I was just wondering, can I delete this user. I just find it inconvenient that when ever I leave my computer idle for a few minutes, windows goes back to the user selection screen. If …

Hello I have a web page which has a drop down menu. I want the user to select an option from the drop down menu, then click submit. This will then activate my php script and select data from my MYSQL database and populate the fields. How do i action …