18,960 Topics
Ok I am stumped. I am inserting the data fine into the table and database so i know its not the config.php nor opendb.php. I used a code like this before and it work, i've only altered the $sql, the td's, and the $rows[]. Table name is hotspots (all lower …
hey guys.. i have trying for 2 weeks now to connect 2 tables in the way that i need them to print out.. [B]to understand the table structure please see attachment 001[/B] Now... i have managed to join both table but the problem is that each time i insert a …
ey guys..i have been given a project that needs things which am still a beginner in.Am asked to develop a database whereby a user will enter the website and answer some questions about their intrest in using database to store their medical records...So far i just know that i have …
HI. I'm new to MySQL and downloaded easyphp a while ago and had been using the phpmyadmin GUI to create databases on MySQL. Because I am also doing web development I decided to download Wordpress. But as I was downloading Wordpress I got a message telling me that I did …
There must be a better way… Hello all, I am now designing a new data structure and I faced this problem that I am going to describe making me think that maybe I should redesign it. Maybe the solution is in front of my eyes, and please if you have …
I have a query which generates a soccer standings table and although it works fine there I am trying to implement a couple of variations on it but everything I have tried has failed. I have searched and asked many times and for both problems and it seems as though …
For my new code that I'm developing, I have a text box where a user will type in a date as follows: [B]MM/DD/YYYY (e.g. 05/19/2011)[/B] This date then needs to be converted and inserted into a date/time field on a mySQL database. I've been trying to play around with this …
Hi Friends i have some problem in update my dynamic text box value for particular id alone, i want to update only the 2 column fields into my database, i have used the below code. i am not able update the fields into my DB. Please help me to solve …
hi people.......i've already had my mysql table displayed in html......how can i update the table (a specific row or a the whole table maybe) ...by clicking the HTML table? .... btw i already a update feature im my document (1 text field and 1 button) but i want to update …
Hi All, This is the first time I'm using Java to connect to my online MySQL database that is hosted by a separate web host. Following is the code in use: (I've removed the server url, username and pass for obvious reasons. They all work when I use them in …
How to upload a photo in mysql database using Browse Button.that means i want to upload the photo in databse anywhere from hard disc using Brawse button.. please help me ..
When I do the initial install I get this: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in D:\Hosting\6585577\html\rhythmmovement\install\index.php on line 18 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in D:\Hosting\6585577\html\rhythmmovement\install\index.php on line 19 Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource …
Hi all, I want to perform cash transactions such as cash deposits and cash withdrawals in my project.Here i have created a page called [B]transaction.php[/B] to fulfill those requirements.But there were few error which i need your help to sought it out.. [B]account[/B] (account_number, account_type, fd_period, account_balance, account_interest ) [B]transacion …
Hey guys, I'm having some trouble setting up a form to delete a specific row in my database table. Here is the idea: I have one page that makes looping calls to MySQL for a query result, at the same time I print out the html as I need to …
Dear All, I have an application where I got few different sql queries that I would like to have an ACID properties. I have now setAutoCommit false. Where best to put commit and rollback statement? [CODE]try { [INDENT]dbconn = DriverManager.getConnection("jdbc:mysql://192.168.1.45:3306/***?"+"user=****&password=*****"); dbconn.setAutoCommit(false); stmt = dbconn.createStatement(); String selectQuery2 = "Select * from …
inside my database, there is a table name january such as: id | code | 1 | 2 | 3 | 4 2 | 0000 | X | X | O | O when i access the data using PHP and parse it into an array e.g. $array1, It became: …
Hi I have a problem with the mysql query that uses both order by and limit.Following is the sql query i'm using, select * from temp where venue <> '' and cat1 = 'sports' and id < 74528 order by id desc limit 10; in this temp table 'id' is …
I'm hosting on NetworkSolutions (which has PHP 5.2.17) and every time I make a prepared statement it returns the error "Incorrect arguments to mysql_stmt_execute" D: Can you help me spot the error in my code please? D: [code] <?php $mysqli=new mysqli(host, username, password, db); $query="INSERT INTO `Variables` VALUES (?, ?)"; …
hi, i have some variable defined in a php file. for example: DEFINE( '_clientass', 'Cliente' ); so when i do a echo of _clientass they return Cliente now i want call _clientass from a mysql row and return Cliente If i do this: $row['variable'] he return _clientass but i want …
Ive used date() before but I do not remember how to store it in mysql. VARCHAR, TEXT, TIMESTAMP?
hello... i want ot select multiple vakues from dropdown and insert into database. but it is not working. any one plz help. and one thing when ever i retrive values from database selected values come in top of the dropdown and remaing values are come in bottom of the dropdown. …
Hi All, I have a page with a PHP insert form that posts relevant info to the SQL database. At the same time the key value "reg_id" is auto incremented by the DB. How do I get new auto incremented value that has been posted so that I can use …
Hi, I need help with PHP/javascript/mysql I am fairly new to this so excuse me for my bad programming skills. I have PHP page which has to update mysql table and HTML table onclick. It updates HTML table ok but as soon as I refresh page it updates all data …
hi all, i am using temporary table to store ids,from this i am calculating the records count,it is working fine and i am getting the result.The problem is i am getting warning that temporary table does not exists
Hi. I'm not sure if this is possible or not, but I need to be able to SELECT * FROM all the tables in the database. Is this possible? Thanks!
Hi All... I'm wondering if an extra pair of eyes can find a problem with this trigger: [CODE] DELIMITER // CREATE TRIGGER `auto_approval` BEFORE UPDATE ON `my_table` FOR EACH ROW BEGIN SELECT security INTO user_sec FROM users WHERE userid=NEW.userid; IF user_sec >= 10 THEN set NEW.admin = 1; IF NEW.admin …
[CODE] <?php include("connect.php"); echo "<h1>Register</h1>"; $submit = $_POST['submit']; $name = strip_tags($_POST['name']); $email = strip_tags($_POST['email']); $password = strip_tags($_POST['password']); $confirmpassword = strip_tags($_POST['confirmpassword']); $level = 0; if ($submit) { $namecheck = mysql_query("SELECT email FROM users WHERE username='$username'"); $count = mysql_num_rows($namecheck); if ($count>0) { die("Email address is already taken!"); } else if ($email&&$password&&confirmpassword) { …
Hi all, I've pulled most of my hair out over the last few days and need some help. Description: I am creating a db application with dreamweaver and using php and mysql server behaviour. My database consists of losts of many to many tables that are necessary. I have created …
Nowadays i'm working very hardly on one prohect - mini social network with some advantages: You can generate tree style map ([url]http://goo.gl/ZP5yc[/url]) of all relationships of user. For example B, C, D are friends of A. On profile page of A when you click on "generate" button it shows A …
hello, few days back i attended one interview. he asked write a query for get the results from these tables. there are two tables. one is for 'USER' and another is 'Properties'. in the user table there is 3 feilds user_id,name and subscription_id. in properties page property_id and user_id. here …
So I'm trying to figure out the best way (if possible) to combine these two stored procedures. Basically these are the same, the only difference is one is looking at a 'Spot' table, the other is looking at the 'Retail' table. However, in both cases the column count is the …
Hi, folks. Need some help to develop a method/function. No problem if there is no code but I would like to start discussing the best way of doing this even in high level language. First of all would like to provide you with some information. The set that I use …
Hello guys! How to load content into the ckeditor? Pls look [url]http://ckeditor.com/demo[/url] for example. My code is below: [CODE] <textarea class="ckeditor" name="pagecontent" cols="100" rows="20" id="pagecontent"></textarea> <?php include_once "../Misc/ckeditor/ckeditor.php"; $CKEditor = new CKEditor(); $CKEditor->basePath = '../Misc/ckeditor/'; $CKEditor->replace("pagecontent"); ?> [/CODE] I want the content automatically loaded from MySQL database to the CKEditor …
i have 18000 records in my table i want to update a single field and i want that first 500 records update then after some sleep next records have to updated in mysql any idea appre thankx
hello guys can any one let me known where to find database design template.i am confused in making of my design for the database. Thanks in Adavance
So I have a table containing various software and a table containing various features. Each software entry need to have a list of features. Here's where it gets tricky: In my application, I need to be able to select a software entry if it has all the features in a …
I have 4 checkbox. 1)name 2)phone 3)address 4)dob 5)all What i am trying to do suppose name,address,& dob is checked by user,then query is: Select name,address,dob from table; Similarly if phone,address select phone,address from table; & for all Select * from table; I am getting value of checkboxes. Need suggestions
in visual studio when we make a project in c# with backhand as sql........we can see the sql file and we have to locate it in the corresponding place and specify that location........but in netbeans when we make a project in java and backhand as mysql.....we cannot see where that …
Hey guys, What are your opinions on rating systems in this case? I have users submitting ideas. Now other users can rate an idea UP or DOWN. I want to keep track of what user rates what idea, up or down, and want to be able to display this information …
Basically I have a database added to my project, and I need to know how to make a column map to another table. I have attached a couple of screenshots to show you what I mean, I want the "Absences" to be a new table, instead of a single DateTime.
Hey, I started learning PHP programming. I wrote this script to update a user's password from the mySQL database, but it's isn't doing so The script is :- [CODE]<?php include("header.html"); include("nav.html"); include("sidebars.html"); ?> <div id="content"> <?php $errors=array(); if(empty($_POST['uname'])) { $errors[]="You forgot to enter your username"; } else { $uname=$_POST['uname']; } …
I want to update my users last log in in the database : [CODE]<input name="login" type="submit" id="login" onclick="<?php mysql_select_db($database_web, $web) or die("Error : " . mysql_error()); mysql_query("UPDATE users SET timp='NOW()' WHERE username='$user'")or die("Error : " . mysql_error());?>" value="LogIn" />[/CODE] this is my code but it doesent update the table :| …
Hello all, I am building an online Logbook service and have come to a dead end with my script. I am trying to make it so that when members are logged in, they can add records to a database (which I have done), then it automatically assigns that members id …
Hello all, I have searched this forum to find the answer to my question however none of the answers seem relevant so here we go: I am building a member service however when coding the login.php script, I keep coming across this error: [QUOTE]Warning: mysql_num_rows() expects parameter 1 to be …
I use Visual Basic 2008 I use bound Datagridview I use mysql database If i run this code, everything on the screen ( in the datagridview) [COLOR="Green"]neatly Updated[/COLOR]. But when I look at records in the table [COLOR="Green"]"stock"[/COLOR] always the first row (0) of the DataGridView [COLOR="red"]not updated [/COLOR]in the …
Hi I am trying to implement a world cup 2010 database, but can't seem to find the best table structure. At the moment I have the following: Team TeadName PK group A with fixtures group B with fixtures group C with fixtures group D with fixtures group E with fixtures …
hi I have create a table with 11 fields with field1 is primary key and auto incremented. In java i use prepared statement.The code is working well without auto increment that is i add this value from my program. when i change field1 auto incremented and use prepared statement for …
see this is the code that is written in c# in visual studio 2005........In visual studio w can connect sql(not mysql) with c# and can even see the sql table visually......... can we do that similarly in java in netbeans7.0..... how can i connect sql with java.......do i need to …
this query was too hard for me write. so any help is greatly appreciated i have three table , a_device, b_devices and a_app under a_device i have the columns: hostname app_name under b_device i have the columns: hostname cpu_avg mem_avg under c_app i have the columns: app_name department_name I want …
The End.