[mysql] Forum Topics

hi guys , i am buliding the application using vb.net vs2010 ,mysql server workbench 5.2 . it works fine about the database connection and inserting and all sql operation with the mysql but now the problem is that unable to make the crystal report using that mysql it not supporting …

so i have followed this tutorial and i stuck into the activate section of this here's the tutorial. what went wrong? http://youhack.me/2010/04/01/building-a-registration-system-with-email-verification-in-php/comment-page-3/

Hi Master, I cant unlink or update my uploaded image. I can successfully upload image bt i cant use unlink function or Any body help me how can i remove / Update uploaded image. Here is my Controller: public function addProfileLogo() { $data = array(); $errors = ''; if ($_FILES['logo_image']['name'] …

Dear All, I have 2 tables one tblAssociate and tblData. The link between them is one to many. My search will be based on date time range where if I find even one data in tblData between the set range then I want to show the tblAssociate data. So I …

I have a MySQL database with a table that has a field/column labled "user8" (which is the field for users' state). I have this PHP call and its working fine if I call all states individually and I only want numbers of rows. <?PHP mysql_select_db("freeskat_promail") or die(mysql_error()); $result = mysql_query("SELECT …

Hi I have written a shell script to execute my data base query mysql -uroot -pshruti2 -B -e "use WebNmsDB;select HEADERINDEX from tekelec_meas_headers where CLLI=$clli and IVALSTART>="$ivalstart" and IVALSTART<"$ivalend" and RPTTYPE="$rpttype";" > win.txt But the output in win.txt is /mysql Ver 14.12 Distrib 5.0.44, for unknown-linux-gnu (x86_64) using EditLine wrapper …

Hi can somebody tell me how to delete a table space? Some days ago I deleted a table because I thought I didn't need it anymore. When I tried to recreate it I got this error: ERROR 1813(HY000): Tablespace for table 'test','employees' exists.PLEADE DISCARD the table space before import; I …

hi everyone, need to get some advice, when opening mysql connection what is the way using Imports MySql.Data.MySqlClient (use in my current vb.ney proj) or ado connection? (use in my current vb6) thx in advance.

In MySQL I have created database "[B][COLOR="Red"]mydata[/COLOR][/B]" with the table "[B][COLOR="red"]contacts[/COLOR][/B]". The fields are as follow: [B][COLOR="green"]ID[/COLOR][/B] (Primary Key) (INT(10) [B][COLOR="green"]Name[/COLOR][/B] VARCHAR(45) [B][COLOR="green"]Title[/COLOR][/B] VARCHAR(45) [B][COLOR="green"]Address[/COLOR][/B] VARCHAR(45) [B][COLOR="Green"]Comments[/COLOR][/B] TEXT Based on info at [url]http://www.webmasterforums.com/php-development/1683-php-form-entering-data-mysql-database.html[/url] I have created following two files: [B][COLOR="green"][COLOR="Red"]new_record.php[/COLOR][/COLOR][/B] [CODE]<? $usr = "myusername"; $pwd = "mypassword"; $db = "mydata"; …

Let's use the basic example.. I have a table for tree representation with just 3 columns: ID, PARENT_ID,NAME. If I delete a record X, how can I delete all recursive records that refer as PARENT_ID of deleted record?

I am trying to DELETE multiple checkbox values in my database but these values are being retrieved from the database and checkboxes are added here is the code [code] <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name …

I have a form that looks something like this: <input name="company" value="company1" /> <input name="company" value="company2" /> <input name="company" value="company3" /> I need to come up with a way to search a mysql table based off what checkboxes a user checks. Keep in mind there can be multiple companies selected. …

A simple insert query works as : INSERT INTO <table-name> VALUES(val1,val2,val3); and DONE. Suppose I wanted to insert only into last two columns I will do as : INSERT INTO <table-name>(col2,col3) VALUES(val2,val3); For less no of columns its not a big deal but what if i have 10 columns and …

Hi need some help.I am creating a small hotel booking system.I have a mysql Db whith tables rooms, clients, bookings,prices,supplements, supplements booked. I have a search form. Clicking on a calendar img will display a calendar.Clicking on the calendar will insert the date in the box.Also I can select n.persons, …

Hello, i want to search date greater than particular date but my date column datatype in text, How could i do,i used following query SELECT * from $table Where postedDate>='21-August-2013' and postedDate<='22-August-2013' ORDER BY modified_date DESC this not working properly

How do I change the query below so that MANU_ID which comes from the Manufacturers table is inserted into the Models table. $sql="INSERT INTO Models(MOD_Name) VALUES ('$_POST[model]')"; Any help would be greatly appreciated thanks

Hi, I have a table in which there are two columns. One column is id and the other is value. When I try to retrieve the data that is not empty it gives me unwanted error. I have to apply join to some tables as well. My query is something …

This query is not working. I need urgent help. Thanks a lot in adv. **ROWS affected: 0** I have cross checked the data in the table for the given condition. $sql = 'UPDATE LTE_noria_cellule cel_bk_up SET cel.NAP_'.$site->ur().' = '1' '. 'WHERE cel.nidt IN ( select gn from LTE_noria_candidat_bk_up can INNER …

Hello, I am doing some search in which my requirment is to search between specific dates. Like user can put start date and then end date. Once submit then it should find result between these two dates. [QUOTE]Select from table where date1>2001-01-05 And date2< 2001-02-05.[/QUOTE] Will this above statement will …

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'futurejunction'@'182.50.130.103' (using password: YES) in /home/content/90/11628090/html/phpmysqlcon.php on line 6 Unable to connect database. is showing in my website. whats the wrong happened.

I have a database that contains multiple comments. Each comment has their own ID. I want to select 5 comments from the database, store the last comments ID into a variable and then select 5 more comments at a later time. When I collect 5 more comments at a later …

Hello, Self taught guy here. Thanks for reading my post. I've made a app to track the sales of floating rubber ducks for a duck race. I have a database which contains data similar to this: id soldby package ------------------------ 1 John 6 2 John 25 3 John 1 4 …

Any idea why this is happening? garrett@bedroom ~ $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Hey everyone, I have an array of checkboxes that hold a value from 1-30, and when I first update the database it stores these values in a comma seperated list like 1,8,9,22 in the MYSQL database. Now my question is, can I when I go to the edit page to …

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\registration\r­egistration.php on line 66 i already tried mysqli_error() and does not fix this problem <html> <head> <title>Registration Form</title> </head> <body> <form method='post' action='registration.php'> <table width='400' border='5' align='center'> <tr> <td><h1>Registration Form</h1></td> </tr> <tr> <td>User Name:</td> <td><input type='text' name='name'/></td> </tr> <tr> …

(Linux System) Everytime I try to log into MySQL or create a database I get "Access denied for user@localhost". I just recently installed mysql using apt-get install and I don't recal creating a password or anything for it when I installed it. Any ideas?

Hello sir iam trying to upload the image in database..this is my code <html> <head> <body> <form action="" method="POST" enctype="multipart/form-data"> <input type="file" name="image" accept="image/jpeg"> <input type="Submit" name="submit"/> </form> <?php if(isset($_POST['submit'])) //connecting to database $db = mysql_connect("localhost:3306","root","") or die(mysql_error()); //selecting our database $db_select = mysql_select_db("tutorial",$db) or die(mysql_error()); $imageName = mysql_real_escape_string($_FILES["image"]["name"]); $imageData …

I am new to both html and php and I am trying to create a form that you have one text box with buttons that allow you to search for the item in the text box in the last 24, 48,72 hours. One the html side of things my form …

Hi, Can anyone help.. I iam creating a UDF Script in SQL 2005. But i have a mesaage saying "Select statements included within a function cannot return data to a client" Here is my whole code.. set @SubjectString = 'The quick brown fox JuMp over the lazy dog.' set @CategoryString= …

I will like to send sms to query numbers from a query