10,946 Topics
 | |
| | 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 … |
| | Hi, I would like to know how to export my schema WITH the table rows/content into a .sql script in MySQL (If it's possible). I tried using Forward Engineering with MySQL Workbench but when I select "GENERATE INSERT statements for Tables" it doesn't do it... I tried googling and finding …  |
 | Hi, I just downloaded TinyMCE WYSIWYG, and I am doing an insert query into MySQL using PHP. Everytime I submit the form it returns false. and if I toke out the textarea everything goes ok. I am pretty sure it's TinyMCE. Have any of you came across this problem, am … |
| | Is it possible to use Kohana ORM with MySQL AND Oracle DB? More wider questions is is it possible to use two different databases (RDBMS) with Kohana? |
 | I have this code am when i try to execute it give an error where am i going wrong Set Rs = New ADODB.Recordset Rs.Open "Select stank from sidetank where job_id='" & Label18.Caption & "'", FrmMother.Db, adOpenKeyset, adOpenDynamic Rs(0) = Val(Rs(0)) + Val(Text7) Rs.Update Rs.Close Will be glad if i … |
| | Hi All, I was following a tutorial online that showed how to imput info into a MySQL database from an app, and I decided to edit it a little so that I could post what I wanted as opposed to the provided example. The problem im having is that the … |
 | Hey Guys, What i want it to do : 1. Combobox is displayed with a list of countys ie Limerick Dublin Cork 2. Choose County brings up second Combobox with countys towns and villages. 3. Hit search brings up relevant towns and vilages from the county chosen. What it does: … |
| | Hello, help me please. I have a db sample ( http://i.imgur.com/JRZ2ojP.png ) I have 1 combobox and 1 textbox If the combobox select "Notebook" then on the textbox it must be display the corresponding itemStock (3) Please :( By the this my simple code for my combobox Try Query = …  |
| | If got a problem in a mysql select string. I get some data from a mysql table and want use some data to pull data from another table. When I use static (i typed it in) it works good but when i use the data that i got from the …  |
 | I have multiple columns I wish to order by. I have columns: # # # # (1, 2, 3, 4) A 0 0 0 0 B 1 0 1 3 C 1 0 2 3 I want to ORDER BY 4, 3, 2, 1. Syntax I am using: [code] "SELECT … |
 | Hi, so I have been trying to create a Login and Register system, but the thing is every time I try to login using the system nothing really happens. You can check it out at http://edwinjoseph.co/logintest/ if you click login and use **user** for the username and **password** for the … |
| | hi in my registration page i got about 20 input fields everythings are working fine except this multiple checkboxes. i read the articles related to my isses but no joy yet becouse my code is very complecated for example the register.php datas will be validate and process by process.php and … |
| | I don't know what I'm doing wrong here, but I'm having hard time trying to insert data from a form into the database.The $_session['username'] is set and the database is included and working Here is my table CREATE TABLE IF NOT EXISTS `accounts` ( `accid` int(11) NOT NULL AUTO_INCREMENT, `acc_number` … |
| | //page2 edit button code.. page2 send the data back to page1 if user wants to edit <a href="purchase_form1.php?id=<?php echo $id; ?>" class="button4">Edit</a> //page1 php code. here the form is on this page //This GET[id] is sent from page2 which is user view page of the form on page1. //If user …  |
| | hello friends I have three tables with similer structure and same column name id,sname,ssno,grade. I want to copy rows from table1 to table2 and table3 based on column grade . I am getting an error No value given for one or more required parameters. can someone kindly tell me how … |
| | $query= "SELECT * FROM games where games.league='".$receivedleague."' AND games.gamedate >='".$todaydate."' AND '".$elnowla."' <= games.eldatetime AND (Not EXISTS(SELECT gameplayed.gameid,gameplayed.userid FROM gameplayed WHERE games.id=gameplayed.gameid AND gameplayed.userid='".$Userid."')) order by games.eldatetime asc limit 0,2" or die(mysql_error()) ; Hello gurus ! Can anyone help me to improve this query below ? I am no experty … |
 | hi, seems mysql_escape_string was deprecated ([http://php.net/manual/en/function.mysql-escape-string.php](http://php.net/manual/en/function.mysql-escape-string.php)) is there any alternative method? hope php developers can share with me. tq |
 | Hey boys and girls, I need help, I am working on a project that requires me to build a business tier (.dll) for a c# program, I've only ever used SQL server. The problem comes in as follows, at university I was tuaght how to import a datasource via the …  |
 | Hello, I have two tables one for the company staff and one for their projects(table name objecte). The table objekte has 4 colums that are connected with the id of the staff. The problem is that I want a query that shows all staff's names. I have also included the … |
 | Does'nt say could not connect. This is a new one for me. Don't know what to submit other than <?php $MySqlHostname = "mysql1.000webhost.com"; //the name of your host - if its local leave it as is. $MySqlUsername = "a8271678_unet7c3"; //the username to your database. $MySqlPassword = "pw"; //the password to … |
| | <?php include ( './includes/template_pageTop.php' ); if (isset($_POST['submit'])) { $username = $_POST['username']; $password = $_POST['password']; $check_username = mysql_query("SELECT username FROM users WHERE username='$username'"); $numrows = mysql_num_rows($check_username); if ($numrows != 1) { echo 'That User doesn't exist.'; } else { $check_password = mysql_query("SELECT password FROM users WHERE password='$password' && username='$username'"); while ($row … |
| | I'm curious about write locks with MySQL and how they are prioritized with eachother. Specifically, I'm wondering if "low priority write" locks have lower priority than "normal" write locks, or if they are equal. The only documentation I can find states that the low priority locks have lower priority than …  |
| | Hey everyone having some troubles here with an update statement. I want to update a value(scanISN) if it exists and show information updated and if it doesn't exist show an error right now it show information updated even if it doesn't exist. How would I do that? <?php if(!isset($_POST['addMe'])){ //show … |
 | Is there a setting in the MySQL Administrator to set the file upload size? |
The End.