[mysql] Forum Topics

I want to pass my all database from windows to ubuntu on my computer. I think passing all releated data files will be enough so I need to find the files in my windows. Do you know what isthe directory path for these files? Also is it enough to carry …

Hi I would like to have a system where I offer a free service, and then two other tiers where people pay different amounts for a different service, so say £5 and £10. I want this to be put into a MySql database, so I'll have a column and for …

How do i insert this into my sql database? I have tried a few things like putting the array bracks on the upload file. when i do this it saves the image location but doesnt upload the image. This is my upload snippet for ($i=0;$i<4;$i++) { if($_FILES['userfile']['name'][$i]) { $uploadfile = …

hi all, this my question again.. i need to load data from database and it will show in combo box. if i want to load id_user from database i will get all id user fill the combo box item, so i can choose the user. how can i do this? …

Really really need help with this one! I need to convert from php to mysql so that it reads language information from mysql, i made mysql table already but I just don't know how to change from php to mysql <?php session_start(); header('Cache-control: private'); if(isSet($_GET['lang'])) { $lang = $_GET['lang']; $_SESSION['lang'] …

Hi. I'm a newbie in php, and I recently bought a book called PHP and MySQL Web Development by Luke Wlling and Laura Thomson. I was able to make an order form in Chapter 1, but in Chapter 2, I have to process orders so that every time I fill …

Hi I am trying to allow users to update records in a MySql database through php forms. One problem I am having is with a drop down field for dates. I want to echo the date already in the database so that the drop down menus is set to that …

I don't have any proper experience with MySQL but need to make a query from python to a database that would return a list of vacant apartments. So, I know the number_of_beds, start_date and end_date and need to get a list of available apartments. The two MySQl tables that I …

Hi I am trying to run a query where the user enters a number, and it searches the table for it and displays any results within 50 of that search. e.g. user searches for 500, anything from 450-550 would be shown. I have the code for showing an exact result …

hi all.. i have a problem. Actually i want to view respond select by MAX(tran_id)...don't know why when i run this code, i do not get the max/ last respond.. it return to me the first respond..for the tran_id it view the max id but not for respond..here the script..hope …

hi everyone, I am looking into a small problem I have with a mysql database. At the moment users can upload upto 4 images per item. I am using php to display the images from the database, but if a user has only uploaded 2 images I am getting empty …

I want to allow registered members to upload files to the file system I have two mysql tables members for registered users and a table files to have a trace which member uploaded which file. now, I only would like to allow the upload of PDF's to the file system. …

Hi folks! I got a little problem with my assignment. The idea is to create online bookstore. As far didn't have much troubles with the project, until now. Problem occures when I'm trying to update/delete an entry to mySql. if you take a look at line 93 - there is …

Hey I have the following code private void buttonInicio_Click(object sender, EventArgs e) { MySql.Data.MySqlClient.MySqlConnection conn; String constring = "server=localhost;database=bd;uid=user;password=pass;"; try { conn = new MySql.Data.MySqlClient.MySqlConnection(constring); string query = "COUNT (*) FROM table WHERE usuario=" + Globales.usuario + " AND pass=" + Globales.contra; MySqlCommand cmd = new MySqlCommand(query,conn); cmd.CommandType = CommandType.Text; …

Hi All, Don't know if this is the right forum for this query, but couldn't find anything more suitable. I have written a new app in VB.net as a front end to a mySQL database held on a PC on the LAN running Windows XP. This worked fine for a …

I want to ask something. I don't understand how to get same data from table at only one time. Here are the example Like table name product_data and there are atleast six field. in data field the date look like this product Date 23-04-2012 23-04-2012 23-04-2012 23-04-2012 23-04-2012 23-04-2012 18-04-2012 …

hi, I’ve got a big problem. Could anyone give me a hand? My aim is:Remove the duplicate data, that is, the various entries of EndTime and Qos for a same ServiceID due to the repeated feedback. The rule is to only keep the records with the lowest Qos for a …

During some recent project issues I found myself asking this very question: **Does MySQL short circuit WHERE clause statements?** After doing some research and finding that several other people and technical forums have posed this question, with several answers pertaining to be intelligent but that amount to *"i don't know"*, …

I have created a simple database designed to accept domains and their associated TLD values: **CREATE TABLE domains(name VARCHAR(50) NOT NULL, PRIMARY KEY(name), tld ENUM('.com', '.net', '.info', '.org', '.co.uk', '.co', '.biz', '.info', '.de', '.me', '.nl', '.it', '.ch', '.li', '.us', '.name', '.ws'));** ...and I now need to display a form with …

Hi guys Im developing this java application and i have the following hurdles: a) I would like to develop an installer for all platforms(including windows,linux and Mac). b)Can someone please illustrate clearly how to connect to a mysql database in java after having downloaded the driver(connector/j) and having imported all …

Hi! I have started learn about Query and PHP, and i don't know what to do next. I have made table with query help i can show in table records from my Database, so far i have well, but next what i want to do is every record in table …

I want to know how to add headers and comments in MySql files?

Hey guys, I have a problem with searching for a string within a string. Here's the code I have at the moment: $query = mysql_query("SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = '".$db."'") or die(mysql_error()); while($table = mysql_fetch_array($query)){ $checktbl = $table['TABLE_NAME']; foreach($_POST['fields'] as $f){ $f = substr($f,strpos($f, '.')); if($checktbl == $f){ …

Hello, I'm new with Python and running into an error trying to print data I have retrieved from a database. The code works but there are characters being printed with it that are not displayed in the database...here is my current code: con = mysql.connect(host="silo.soic.indiana.edu", port=3306, user="XXXXXXX", passwd="XXXXXX", db="XXXXXXXXX") cursor …

Hey guys, I have a form that is used to navigate through records in a table one at a time. The form generates the number of textboxes required automatically. Navigating through the records is easy enough, but when I click the update button it comes up with the error: Object …

i have little problem with one algo . first i have two tables there are above one lac records in each table . table 1X structure id domain 1 google.com 2 daniweb.com 3 yahoo.com table 2X structure id domain 1 google.com 2 facebook.com 3 youtube.com now my task is to …

Hello, I'm trying to set up a website where user can upload files to which should be readable by everybody. Logged users should be able to comment on the files and rate the files. I'm new to MySql and quite new to PHP so it has taken me already lots …

Ok, so the scenario is a database which stores customer contracts (to keep it simple) so that every time a contract is expired and renewed a new version is created in the database to reflect any changes (terms, price etc). My page needs to display a list of the latest …

Hey I want to search for a text string but I dont know what table or column it is in. I just know the database that it is in. I know also that the type is a text type. Any query I can do or in MySQL Workbench? Thanks!

Hi, I make a page to display all applications from table and few of these applications have an interview dates, location etc in another table. I use this code pasted in this article below. The problem is showing the applications with interviews only and the interviews without interviews are not …

Good Day Experts,,can anyone help me,,i have a codes for inserting,selecting and deleting row data from original table into archieve table: this is the original table `Username password fullname year course breakzzz breakzzzz romel first year prog.` and this is my archieve table: `username password fullnae year course` my plan …

how to deduct qty from data base i have used this sentex to deduct...... cm1.CommandText = "update inventory set qty=qty- " & cust_gv.Rows(i).Cells(3).Value() & " where item_name='" & cust_gv.Rows(i).Cells(1).Value() & "'" this sentex is giveing error

I have two tables containing different fields bar one. I want to merge the two subject to comparing one field using sql - is it possible? Table1 has fields: conkey reg when where 1 ABCDE 251011 EGLL 2 BCDEF 261011 EGLL 3 DEFGH 271110 EGKK Table2 has fields: conkey type …

hey everyone.i have a project that requires the use of a barcode scanner then apply it to a vb6 application i dont know how to do this. the barcode scanner will read the barcode from the id of an employee. then after reading it, all the details of that employee …

Hey guys, I have some code which returns the column names, but not the actual data. Here is the code I have: $success = mysql_query($final) or die(mysql_error()); echo "<table><tr>"; foreach($_POST['fields'] as $f){ echo "<th>".$f."</th>"; } echo "</tr>"; $i=0; while($row = mysql_fetch_assoc($success)){ echo "<tr>"; foreach($row as $r){ echo "<td>".$r."</td>"; $i++; } …

Hello, my problem is related to uploading images (i keep info data in database and images in filesystem). I plan to generate image path from image ID, that's why i need to get the ID of the last inserted image. For example: image with ID 123456789 has this path /images/123/456/789 …

I have a code where I am inserting a new record into a database. I need a way of redirecting the user if they have already entered their information into the database. Here is my php code...how would I modify this to check for an existing record based on their …

Hi all, I have a table with quite a bit of columns in it. Nothing stored there yet, but will be soon. What I need to do is populate a drop down list with the first name and last name of the people in the table and also the unique …

I need to turn the attached ER diagram into a relational model. This is what I have came up with, is it going the right direction or away off? relation AB1relationship a1 : A1 b1 : B1 primary key a1 foreign key a1 references A foreign key b1 references B …

So, I have this following snippet of code: if (isset($_POST['type1'])) { mysql_query("UPDATE table SET status = 1 WHERE id = '". $_GET['repid']."'", $c2) or die(mysql_error()); } if (isset($_POST['type2'])) { mysql_query("UPDATE table SET status = 1 WHERE id = '". $_GET['repid']."'", $c2) or die(mysql_error()); } if (isset($_POST['type3'])) { mysql_query("UPDATE table SET …

OK, this is probably a variation on a previous question but the original question was never resolved, so I will present it on it's own to avoid confusion. I have a member data table called 'members' Primary key is 'mem_id' I have 7 different 'position' tables called position_1, position_2, position_3, …

Hi, I wonder what is the best way to prevent injection against user input. There are a lot of examples but one say "magic_quotes_gpc" is good but removed from PHP soon. Therefore, no point of using it. Another says "mysql_real_escape_string and addslashes" just used to clean iptuts. Etc etc. I …

I want to retrieve records in my database in order to manage details. The below error message displayed when i trying to do that. Can anyone help me out? ( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\Student registration\manage student details\manageStudentDetailsForm.php on line 250 …

hi, i want to design a website where only students from a certain university can access by logging in how do i make this using dreamweaver and MY SQL as the database. for example if daniweb was only meant for people from USA and someone from africa tries to sign …

hi guys... i really need reference ASAP what i'm trying to do now is: -creating API from my website so that -other website can read certain content for my website database and put it in their website. i don't know if i explain it correctly, i tried to googling for …

Hey guys, I have this code which gets some reults from a table and displays them: echo "<table><tr>"; while($col = mysql_fetch_array($columns)){ echo "<th>".$col['COLUMN_NAME']."</th>"; } echo "</tr>"; $i=0; while($row = mysql_fetch_array($data)){ echo "<tr>"; foreach($row as $r){ echo "<td>".$r."</td>"; } echo "</tr>"; } echo "</table>"; Getting the column names is fine, but …

I've had nighmares about this since 3 days ago and couldn't find anything by googling so here I am. As the title says so i need to find a way to store and then retrieve images from a mysql database I have tired the code below to do so (the …

Hi, I am trying to query a MySql database based on which search fields are filled in and ignoring those that aren't. I have only got as far as the first part and it isn't working, could anyone tell me why? It doesn't seem to be finding anything in the …

I need to transfer the sql server databse tables to mysql . How can i do that?.

Hi there, I would like to make an email form that would select all the emails from a MySQL db and then send that message to all addresses. I got this script but was unable to get it working. Any help would be great. [code] <?php //Connect to database mysql_connect("localhost","user","password") …