10,942 Topics
 | |
| | I have two columns with stirngs ( "String1" and "String2) . How to make string inputed in text field ($search) to be comparative with sum of the both strings ("String1String2") Something like as: [CODE]" SELECT id, string1, string2, FROM table WHERE string1+string2 LIKE '%$search%' "[/CODE]  |
| | Hi, I have this question, having two numeric values field1 and field2, i need field3 by default to be the difference between field1 and field , any idea??  |
| | how do i select a row in a table columns i dont know the name of(and find the name of it)? but i know the cell/field of the column has a value of "55" i also have to EXCLUDE ONE COLUMN that i know the name of. does anyone know … |
| | Good Evening everyone. I work for a marquee firm and i am creating a php mysql components list for the assistance for loading equipment. SO far, the user can input a marquee size (eg: 6mx3m) in a form and we search the database and output the items required for said … |
| | Hello All, Don't know if this is the right place to put this doubt. Help if possible. I have a python file that extracts data from a file and adds the required part to the database. Now MySQL has certain reserved characters, whenever my update query comes across a reserved … |
 | Hi all, When you add integer ID primary key auto increment, it automatically makes ID for you. But I was pondering on what happens after deleting a record. Does the server automatically adjust all IDs for you or it remains un assigned? For example, I have inserted as follows +------------+-------------+ … |
| | I have created a very long code on my app for checking if a record exist then insert. Is it possible for a single SQLString to check if records exist then update or insert? Sorta like [CODE] IF NOT EXISTS (SELECT column1 FROM table WHERE column1 = [COLOR="Red"]'sample1'[/COLOR]) THEN (INSERT … |
| | All, Does anyone know if there is a package available to allow PHP programmers to store their PHP Objects / Instances into mySQL, and still allow them to be searchable? ie .. not serialized? Looking forward to your responses, E,  |
| | can someone help me identify the syntax error with this code [code] CREATE TABLE IF NOT EXISTS Persons ( id_number VARCHAR(13) NOT NULL , name VARCHAR(45) NOT NULL , name_2 VARCHAR(45) NULL , name_3 VARCHAR(45) NULL , surname VARCHAR(45) NOT NULL , date_created DATE , date_modified DATE , PRIMARY KEY … |
| | Hi Guys Firstly: Is it possible to import two columns from an excel sheet into two new columns in a mysql database? I would like to import new product codes([COLOR="Green"]prodcode2[/COLOR]) and pricing([COLOR="Green"]prodsupplyprice2[/COLOR]) into these two columns and then set up a query to do the folowing... I need to compare … |
| | 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 … |
The End.