10,940 Topics
 | |
| | 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 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 .. |
 | 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 … |
| | Hello, My problem stems from reading an image from the local disk and displaying it. There's a middle step of storing it in a database, but I simplified the problem into this test script that replicates the error: The image "http://example.com/test.php" cannot be displayed, because it contains errors. test.php looks … |
| | |
| | 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?  |
| | 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 Guys, I am having few issues testing a software for which I have to develop a front end GUI. Basically, the previous person failed to document on how to run the system and left all the pleasure for me :D Anyhow, the system basically is a web crawler and … |
 | 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) { …  |
| | 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 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 … |
| | 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 … |
| | 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']; } … |
The End.