7,368 Topics
 | |
| | I am new, any one can tell me how can add image link in mysql after adding image link how can we display image. |
| | Hi, I am practicing MySQL JOINs and was hoping I could get some insight on how to do a particular problem. I am using the World database, it has a table called City with name, population, country code. It also has a table called Country, with Code and Name. What … |
| | Hello everyone. I have tried to fully install MySQL on Windows Server 2003 for a few days now, with no success. There are two things stopping me from completing the install: 1) I forgot the initial password that was used for the root user 2) Every time I get to … |
| | Example of GRAND TOTAL, TOTAL1 TOTAL2 TOTAL 3 SUBTOTAL 1, SUBTOTAL 2 SUBTOTAL 3 How many chairs we have in our village? Grand total chairs in houses =total chair in house A + total chair in house B Total chair in house A = TOTAL CHAIR IN ROOM 1 + … |
| | Hey guys. You guys were awesome in helping me solve my last issue. I was wondering if I couldn't pick your brains again? I've been able to troubleshoot and solve most of my issues myself, but am a bit confused on this one. I found a similar thread to my … |
| | I have created a website in Dreamweaver CS3 that includes mySQL databases. I have been using xampp, and have a test server running on my local machine. Everything seems to be working fine, and now would like to put the website online. I'm not sure how exactly to do that. … |
| | I have a table with information about the type of scrap generated on a bag making machine. Every time scrap in generated on either side of the machine (left or right, there are 2 packing machines on the one bag maker) a line is added to the table with the … |
| | If I want to search record by age like (30 to 35) just like dating script but I will not use in dating site, I have my school website and I just want to display record by age but If I want to display age between 14 to 17 kindly … |
| | Can someone look at this and tell my why it's not working like it should? It gets the data from the database fine, just wont post to search.php [CODE]<?php //connect to your database ** EDIT REQUIRED HERE ** mysql_connect("localhost","root",""); //(host, username, password) //specify database ** EDIT REQUIRED HERE ** mysql_select_db("test1") … |
| | I am trying to Add rows to my table through DOM. I have two drop downs and one text field in one row. One drop down is populated from database and when the second drop down is populated through Ajax. As far as one row is concerned it is doing … |
| | Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\registration\login.php on line 19 is the error i get when i run the below code i cant figure out what is wrong with it. :( [CODE]<?php $username = $_POST ['username']; $password = $_POST ['password']; if ($username&&$password){ $connect = mysql_connect("localhost","root","") … |
| | I have tbl 1 id_column(1 2 3 ) tbl 2 id_column(1 1 1 2 2 3 3 3) I need result tbl2 join with tbl 1 values (3 3 3) Thank you in advance i'm strugling from two days for this. |
| | I need to create a row and its content to be unchangeable and undeleteable, as a secure way to ensure that the administrator will always have access to the website. Does anyone have any idea how to do this? A Google Search gave no results, but perhaps someone knows how …  |
| | Hello friends, Well i have two table one is used for user information while registeration and another table is only used for users profile image. In member list page i want to show users name , location and profile image. I m able to show a name and location but … |
| | Hello all, I have spent a good few days looking over daniweb trying to get the right answer, But I am yet to find what I am looking for. I have successfully upload my image to a folder store and named my uploaded image. The path and file name is … |
| | I understand after running now() function in an SQL statement, I will get current date/time like following in mysql browser: '2010-08-04 17:01:06' If I want the returned value to be '2010-08-04 00:00:00'. How can I do? Thanks. |
| | To view this tutorial with notes at [URL="http://www.effectivewebdesign.co.nz/tutorial.php"]http://www.effectivewebdesign.co.nz/tutorial.php[/URL] yes I am aware this is more php than mysql. howerver I get asked how to do it so often I thought I'd post it here aswell :) |
| | I have a dedicated server that I wanted to look at moving to cloud based computing, so I hopped on over to rackspace and setup a cloud with 2gb of ram. I then setup mysql and had it replicate my dedicated server so I could keep the data updated and … |
| | Hi I have created two tables in MySQL using Navicat. When running an update query, I noticed that first, when I am entering a price for a product, the price is rounded to whole numbers it seems. Secondly, one field that I enter data in to be added to the … |
| | i got this error in my code in my hosting account plz help ti solve it [COLOR="Red"][CODE] "Error connecting the database"[/CODE][/COLOR] this is my connection codes [CODE]$MYSQL_SERVER='jsnf.db.6477609.hostedresource.com'; //sessions not need for this one $MYSQL_USER='jsnf'; $MYSQL_DB='jsnf'; $password='[removed]'; mysql_connect($MYSQL_SERVER,$MYSQL_USER,$password) die("Error connecting the database"); mysql_select_db($MYSQL_DB) die("Error Selecting the database");[/CODE] this information give me … |
| | I'm developing a system to help monitor payments recieved and inventory items. I was asked to add a payment entity to my erd .. i'm kind of confused which entities it will have relationship with and when i am creating my tables, which foreign keys would be in its colum.. … |
| | Hi everyone, I need help in my school project which requires me to send data from a mobile application to a database table. The inputs for the table data is through textfield and when i press the submit button, it will send the input fields into the database table. Will … |
| | dear, everyone... i need solutions. i have several tables in a database. this is tabel_jawab [CODE]kd_jwb nis kd_mk jwb1 jwb2 jwb3 jwb4 jwb5 321 654 2 A B A C B [/CODE] i input them via jsp to mysql table. i have these table too named tabel_kunci [CODE]kd_jwb kd_mk Kjwb1 … |
| | Hi! i have problems one query. $day_result has a value of 1 and 4 $sql3 = "Select * from Venue where idVenue != $day_result"; echo $sql3; if i use for loop for the above it will give the result below Select * from Venue where idVenue != 1 Select * … |
| | I'm not all that certain how to go about this, but here's what I am trying to do: Firstly, coding in PHP and using MySql DB. I have a table (called overall) that holds each individual Softball teams stats. fields are: 1. team (team name) 2. gp (games played) 3. … |
| | hello, i am building a website using mysql and php on an apache web server. The site has over 100 index pages for differnt parts and content of the site. one of the problems i am having is i have to write the navigation bars in for each page, and … |
| | Erm, well I'm having heaps of trouble telling the difference between what the bracket value bracket thingies do... [like tinyint(1), tinyint(2), tinyint(3)] I've read this, but I can't seem to understand it >.< [QUOTE]Another extension is supported by MySQL for optionally specifying the display width of integer data types in … |
| | ok I had an insert query that worked fine when using Access as my datasource, but I wanted to start using MySQL, so now when I run the insert statement, I get an error that says Filed "bulbID" doesn't have a default value. This error didnt occur with Access, so …  |
| | Hi newbie here I’m currently making a hotel booking system in mysql/php, but I’m having problems with overlapping dates/double bookings. For example if a user attempted to book room1 from the 1st august to the 5th august, but the room is already booked on the 3rd and unavailable on the … |
| | Hi everybody! I'm having some problems and hope to get help in this forum. My website name is SNIP. At this time it is setup as coins website. I'm trying to reinstall original categories to make it a full auction site. When I ran SQL dump file that was given … |
The End.