10,932 Topics
 | |
| | MySQL Does not UPDATE second column. [CODE=vb] SQL = "UPDATE sampletable SET column1 = 'C1sample1'" & _ ",column2 ='C2sample1'" & _ "WHERE column2 = 'C2sample1'" [/CODE] |
| | Hello everyone. I have a question here, that to me seems there must be a way to do what I want in the way I want :) I have a thing that updates a Zen Cart DB and adds products to it. Ok everything works the way it is now, …  |
| | hi all could any 1 help me out. im trying to find the biggest id number in a db. the problem is that the "ID" column is saved as "TEXT"(its important to me). the language im using is PHP. 10x! tried to use this but it didnt work $resultt = … |
| | hai, i have a database file in mysql file extension, anyone help me how to upload the database to server. Thanks  |
| | Hai, I am developing a home appliances website. I had a detail database. Which stored the details of all the items in that shop. The columns are Id number, name, price, type, made, date. When user clicks on the TV menu in the website then the lists of TV in … |
| | I am trying something like this but the syntax is wrong. [code=sql]INSERT INTO bookingsA(task,date) VALUES ('test','2009-01-01') WHERE date != tableB.date;[/code] How do I do this? Do we use :: instead? Mike  |
| | e.g. i have 4 images... i'm trying to do onclick i swap id's(mysql) with the next onclick(image).. basically just swap id's but its activated by javascript onclick. the javascript part is what i'm having trouble with because you can't write mysql statements in a function.. any help  |
| | Hi there Completely stumped on the simplest of things... Here is my PHP code: [CODE]<?php //includes the connection parameters from external file require_once('connection.php'); // Receive the variables $fname = $_POST['fname']; $lname = $_POST['lname']; $email = $_POST['email']; $ip = gethostbyname($_SERVER['REMOTE_ADDR']); // Establish connection with database $connect = mysql_connect($hostname, $username, $password) or … |
| | Hi all, Pretty new to PHP and I am trying to get a handle on securing a form fields data. For example, I have a simple form where user enters information into a field called mydata. The field must be able to contain multiple words and basic punctuation. What I …  |
| | I received this error whenever I update an int(3) type field. [B]Error: 438 public member close on type integer not found[/B] This is my code [CODE=vb] conn.ConnectionString = "server=localhost;user id=root;password=;database=test" SQL = "UPDATE testTable SET int = 1 WHERE Name= 'Bob'" Try Dim myData With myCommand .Connection = conn .CommandText … |
| | Hello. I'm using AJAX for all the updates to the web site I'm building and it works very well. But now I face the need to: 1) Upload a file (an image or video) to a folder in the server. 2) Insert a row in MySQL with the name of …  |
 | i want to relate my tables, but i can't find out how to relate the tables. how? |
| | Hi All, I'm trying to find a way to display a table to the user using mySQL DB. [better then the DataGrid View] The table should have options to merge cells for related items and to embed buttons in the cells. Thanks for your help. |
| | Hello everyone - first time poster here, long time reader. I have a minor issue that appear to simple to fix - but I've just hit a road block. I would like to create a three way inner join to display all the information I need in one SQL statement. … |
| | how do you do this? i cant find it anywhere basically my server "starts" but i cant connect to it... i tried mysqld --debug but it makes a .pdb file and idk wat to do with it please help. ive got too much crap stressing me out.. |
| | Hi all, I have a two-part form intended to replicate the output from a toolbar, with the aim of sending data to a database. So the data is generated by the following code (sim1.php): [CODE]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> …  |
| | Hey Guys, I want to use mySQL with java and for this purpose i downloaded the mysql-j connector from the mysql website. But i dont know how to poceed forward. Please help..  |
| | Hai friends, I had a main web site and a number of 15 ( also increasing ) child websites. I had a master database in my main website. Now I need to connect main database from the child websites. I had a code to connect the database from main website … |
| | I am looking for ideas of projects I can do to further develop my PHP and MySQL skills. I did Business IT university and have a good knowledge of PHP and MySQL as I did my dissertation in it. I would like to develop these skills further but I have …  |
| | Hi, I am trying to design a website, where we have a table containing the days of the week and hours. The idea is to populate this table by its connection to the database. So two pages: Make appointment: 1. I insert into the database via php website selecting time … |
| | I know this contains actionscript, but the server side is Java. I am trying to get a red5 server to insert into mysql, but I can't get eclipse to compile this client side code. Could someone tell me if this tutorial is up to date with galileo, the new version … |
| | Okay, I'm a little confused - this code works perfectly fine in mysql; however, in php it keeps repeating the first person for about 15 rows. Can someone point me to what I'm missing here. [code] $queryUsers = "SELECT user_id, zipcode, gender, housing_status, active, username FROM users WHERE user_id != … |
 | I use MYSQL 5.0 I have a table with a field named ArticlePrice. The content of the ArticlePrice field looks like this [COLOR="red"]10.50[/COLOR] My question is: is there an environment variable or system variable MYSQL who can change the locale currency in to Europe setting . So that the content … |
| | Hi! We have a database that stores vehicle's gps position, date, time, vehicle identification, lat, long, speed, etc., every minute. The following select pulls each vehicle position and info, but the problem is that returns the first record, and I need the last record (current position), based on date (datagps.Fecha) … |
 | Hello everyone! I searched the site already to see if this question has been addressed already and found no results, but if it has then I appologize and if you can link me to that thread I'll refer to that to solve my problem. I am trying to save a … |
| | Hello all, I have the following SQL statement. [CODE]SELECT a.airport_code AS AIRPORTCODE, a.airport_name AS AIRPORT, u.usr_id AS USERID, u.usr_fname AS FIRSTNAME, u.usr_lname AS LASTNAME, u.usr_email AS EMAIL,u.usr_airline AS AIRLINE, u.usr_airline_iatacode AS IATA, t.title AS TITLE FROM users u LEFT JOIN userairportservices uas ON uas.usr_id_users = u.usr_id LEFT JOIN airport a … |
| | i am new in Jsp please tell me how to connect MySql to JSP ?  |
| | Sorry for posting this in this forum, but there is no forum for PostGreSQL. I am currently attempting to optimize a function that uses up to 3 seperate SELECT queries, by using a CASE conditional in my query. Right now my function does an initial query, then if no results … |
| | Hi, i am using vb.net2008 and mySql 5.1.36 to do an assignment. I need to count the number of seat available in a table in my database. When i run my code, the error [COLOR="Red"] MySQL :: invalid attempt to access a field before calling Read()[/COLOR] occurred in the code … |
| | [CODE] EXPLAIN SELECT post FROM `table` WHERE id = '123' LIMIT 1[/CODE] There are 411 records in table for id=123, even though limit of 1 is forced in the syntax, explain syntax shows that there are 411 rows in the table for the above query. Does that mean mysql will … |
The End.