10,942 Topics
 | |
| | Please correct my syntax: im including a file with the following constants [CODE] define('IPADDRESS', $_SERVER['REMOTE_ADDR'] ); define('BROWSER', @$HTTP_USER_AGENT ); define('REFERER', @$HTTP_REFERER ); [/CODE] if i echo IPADDRESS; i get the ip address (127.0.2) so the include is fine. My mysql instruction is as follows: [CODE] $update = mysql_query("UPDATE login_errors SET … |
| | I am having problems loading images from my database. I think it's something with the variable...i am new to PHP and have a project i need to finish by Tuesday. Your help is appreciated. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> … |
 | hey there, I am trying to make my first connection to a mysql server with java. I took the following code from another thread: [CODE] import java.sql.Connection; import java.sql.DriverManager; public class Connect { public static Connection ConnectDB() { Connection conn = null; try { String userName = "root"; String password … |
| | here is my code want to get records between two dates [CODE] $sql=mysql_query("SELECT * FROM `expense` WHERE `date` BETWEEN '2011-04-26' AND '2011-04-28'") or die(mysql_error()); echo $r=mysql_fetch_assoc($sql); [/CODE] i getting "Array" in output instead of the data please sort it out for me i am not getting it right |
| | hey people, i have the following problem, i'm setting up a webshop with over 2k items and every 6months the prices are changing(wines) so i was wondering how to import an xml file into a mysql database without having to go in phpmyadmin. this because i don't want the people … |
| | Hi All I have to tried to connect MySQL with remote databases(GT.M)i can successfully communicate with remote database and after a specific period of time i face the following error message [B] "ERROR 1296 (HY000): Got error 1 'No response' from remote host". [/B] can anyone guide me what kind … |
| | Hi all, I'm stumped and can't seem to find an answer on Google. I am running a java application through Eclipse and it connects to mysql. It connects fine if I run it through Eclipse but if I make a standalone jar file and then run it through Window's Vista … |
| | Hello all, I have three table name with same data structure. So, I want to insert my data through store procedure by passing table name as variable with my data. Is it possible? Thanking You. Hakoo Desai. |
| | I'm using mysql 5.5.9 I used create database query to create a new database but this new database is not coming in mysql.db table can anyone tell me the reason y and even how to get the database in that table. |
| | Hi, I am new to MySQL scripting. I used tee command to append my logs. But I wanted the log file to be cleared every time i execute the script. Is there any command to do that? Thanks Shiny |
| | i am using netbeans and MySQL. i made an inventory application with a server host name "local host:3306". how do i distribute it to other computer? should i change the server host in mysql? |
| | hello guys , i have a table created in php and within this table there's a liked word that will lead to it's topic , and this topic would be stored in the database. then when it's clicked it will show a page and display what has being stored in … |
| | Hi Friends I have pasted the code below which i was used in my project. But i am getting mysql_fetch_array() error. For your more information i have attached the screen shot of the error Pls give me solution [CODE]<?php // Inialize session session_start(); include("../config.php"); // Check, if username session is … |
| | Good day guy., just want to ask what is the equivalent function of mysql_error in jsp.... i have a program created in netbeans and in successfully build but it doesnt seem to process right ..,  |
 | Hello, I have a query that needs to perform the following: where verified=1 AND where name is like '%$term%' AND/OR owner is like '%$term%' I have a basic knowledge of SQL and was wondering if the above is possible. I need the and/or because i would like it to return … |
| | hello friends i want to sum up my table field data...my table name is fee_info and i the field i want to sum is exam_Fee... i have come out with a query but at last i am not figuring it out yet. here is mine code [CODE] mysql_connect("localhost","root",""); mysql_select_db("new"); $get= … |
| | hello friends i want to add my table fields but i got a problem that when ever i add my field for example i enter two records one of ID 2313 having exam_Fee and transport_Fee and other having id of 2314 having same exam_fee and transport_fee.query for this which i … |
| | Hi friends, I got a table as follows Name | idNo | started | type | entrytype ----------------------------------------------------------------- Nick | 12 | 12-02-2011 | 0 | 1 Sam | 14 | 13-02-2011 | 1 | 1 Paul | 12 | 14-02-2011 | 1 | 1 Jwal | 12 | 13-02-2011 … |
| | At the moment i have dynamic list which displays the latest products added to the inventory list. I want to display birthday cards from the category. In my database i have the column 'category', and in a form you can select different options with values one being birthday. This is … |
| | I would like to develop a database system using ms sql server 2005 express or 2008 express edition where the data may store in other than english language into tables. so i did it using mysql database but not working in 2005 express edition. Is there any solution? |
| | Is there a way to create a program to rewrite a query in an optimal form. If so, how? What can I do to implement this. Rewrite SELECT EMPOYEE.EMPNO, POSITION FROM EMPLOYEE E, JOBHISTORY J WHERE E.EMPNO = J.EMPNO AND STARTDATE <= ENDDATE AND SALARY <= 3000 into SELECT EMPLOYEE.EMPNO, … |
| | I have details stored in a database of a web site firstweb.com I have created another web site secondweb.com I want to use data from database of firstweb.com Is this possible ... Assume : I have all user id and password for both these databases If YES, how to do … |
| | I'm new in using MySQL and I have to do a project where I should implement 6 queries within the database that I have created. The queries that should be implemented are union query, aggregation query, nested query, and three join query. Here is the script for the database. [CODE]create … |
| | hi all, i need to develop windows applications(c#,mysql)as i have started to develop applications recently i need some examples to refer(which includes almost all controls) may be like customer maintenance or order placement form etc..so can any one help me out.. thanks a lot,  |
| | My Alter Table Editor Window Not Coming Up in Mysql Workbench? PLEASE CAN SUM1 HELP ME! ^_^ My Alter Table Editor Window will Not open up.. Is there a way to make it open???? Im using Mysql Workbench Thanks! |
 | Hi, I'm making a custom user management class that inherits from DBManager class. The problem I have so far is executing queries using mysqli prepared statements. DB connects fine but then prepare statement fails. I have mysqli object as an attribute that is shared in the class. I'm new with … |
| | Hi Friends i am having one master table for category which contain 7 fields, i am having sitename as a table which contain 8 fields, if i create [B]newsite[/B] name then it has to copy all the fields from master table in addition to that it has to display the … |
| | I would like to know how to a use a text box in winform to name the table . can anybody help me please I am using the following statement to create table SQL = "CREATE TABLE tbCatalogue ([Id] COUNTER, [Stock Code] TEXT(10), [Account Number] TEXT(6))" |
| | I have these two queries which i want to run together and not one by one. How can i do that? Or can it be modified to be one query. [CODE] UPDATE runquery.table1, runquery.table2 SET runquery.table1.`Column1` = (runquery.table2.`Col1`/runquery.table2.`Col2`*100) Where runquery.table2.`itemid` = 3 and runquery.table1.`Userids` = runquery.table2.`userid`; UPDATE runquery.table1, runquery.table2 SET … |
| | I'm using mysql and phpmyadmin to create a video rental database and I've been having problems with the auto_increment feature and the numeric data type. I have auto_increment on multiple tables for their table id's. The problem is when i enter data into the tables the counter doesnt reset. So … |
The End.