10,940 Topics
 | |
| | 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 |
| | Hello All: I need help constructing a mysql statement to post data from the following form to db <form id="updateHrs" name="updateHrs" method="post" action="process_updateHrs.php"> <table align=center class="ebc-table" cellpadding="0" cellspacing="0"> <thead> <tr> <th colspan="7"><?php echo $SBS_LANG['time_title']; ?></th> </tr> <tr> <th class="sub">Days</th> <th class="sub">Opens</th> <th class="sub">Closes</th> <th class="sub">Day Off</th> </tr> </thead> <tbody> <?php … |
| | Which Is simple To learn Php with mysql or python with mysql ?? php or python with some other database...??  |
| | 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 … |
 | /* also, read the edit */ So... after painful MySQLi intro to working with MySQL Stored procedures... I have come to the conclusion that the only good way to pass variable length binds is to use eval() Is this a poor choice? The way I am using it is: $Conn … |
 | 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 screip to resize an image, save it to a dir and store the path in mysql. This works ok. The images are gotten from a suppliers website where the filename of each is the product code. The variable $remote_file in my code looks like this ../images/products/wsx339.jpg. How … |
| | 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 … |
| | Public Class Adminpage Dim result As MsgBoxResult Public Sub shw() End Sub Private Sub Adminpage_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load clr() End Sub Public Sub clr() patientno.Text = "" lasttxt.Text = "" Firsttxt.Text = "" Middletxt.Text = "" ComboBox1.Text = "" gencbad.Text = "Select..." MaskedTextBox1.Text = …  |
 | 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 … |
 | Using Linux. I'm trying to learn PHP so I'm also going to need to learn some MySQL to work with my PHP code. Do I need mysql client or mysql server? I thought it was on my system but after issuing the command 'mysql' I got the following error. garrett@bedroom … |
| | 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) |
| | Hi I have a mysql table in which 3 columns are of main interest. I want to final output like, if two columns matches(of different rows) then third columns should be sum of two columns. Example column1 column2 column3 abc hiren 5 bcd host 10 cde ketan 13 abc hiren … |
 | 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 ! can you please help me with my independent study. im making library management system with visual studio C# and mysql. what mysql connector needed for C# and how to connect them?? thank you in advance :)  |
 | Hello guys, I have my problem in saving date to mysql. Dim conn As MySqlConnection Dim myCommand As New MySqlCommand Dim commandB As MySqlCommandBuilder Dim data As MySqlDataAdapter Dim query As String = "SELECT * FROM events e;" Dim myconnstring As String Dim comm As String Dim vers As String … |
| | 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 |
 | Hello there, I have problem as: have two tables **Candidate** and **candidate_interview** for perticular vacancy_ID , Candidate's status becomes "In Proces" and when his interview is schedule , entry is added in candidate_interview table againt that vacancy with status In Process. now what i want is , such candidates whose … |
| | Forgive me if this is something obvious or a simple question. I am having issues with my date field when loading data into my database. I am having it load using a python script using the below command and once complete the date is 0000-00-00. the file I am loading … |
 | its my Data base structure , I want to create login for admin , franchisor , distributor , seller , its gives me a problem that when i take a user name 'David' for franchisor then can i also registor 'David' as a seller . i want a user name … |
 | im trying to do this : alter table project_info change column number proj_id int not null auto_increment, add primary key (proj_id); but mysql tells iv got an error. any help with whats wrong here ? i followed this from head first sql book (page 210 if anyone's interested ) . |
| | HI, I have a table with three columns id,history_nr,value. Now I want to make a query that should concat value with different nr. I have tried this syntax but it is not working. SELECT CONCAT((SELECT value FROM table WHERE history_nr=63 and id=1),'',(SELECT value FROM table WHERE history_nr=803 and id=1)) FROM … |
The End.