10,940 Topics
 | |
| | Hi to all, i created following table ------------------------------------- create table employee(name varchar(20), dob datetime) ------------------------------------- I want to extract names of all months from 'dob'. for that i wrote following query ------------------------------------- select datepart(month, dob) -------------------------------------- it works and shows all months but in number format, i want to display … |
| | hi guys, i wanted a table to get created with the table name submitted from the form. how shall i go about this, i have tried it with my basic knowledge its here bellow but it dint work well, please help me anyone. [CODE] <?php if (isset($_POST['update'])) { mysql_connect('localhost', 'root', … |
| | hi all i have search engine like that: sql = "SELECT * FROM ads WHERE ad_country='7' and approve='1' and ad_name LIKE '%iphone%' or ad_country='7' and approve='1' and ad_content LIKE '%iphone%' ORDER BY ad_date DESC LIMIT 0,30"; and it's work great but it is too long. are there any sample way …  |
| | hi, i have created a web form that input data from user and insert it into the mysql database by calling stored procedures butt i am facing the following error " Exception during execution of 'p_AddUser': Invalid attempt to access a field before calling Read() ". plz help me how … |
| | hi, plz help me how can i get the return value of mysql stored function from ASP.net with c#. Currently i m using the following code for this purpose [code] string strConnect = "Data Source=" + host + ";Database=" + database + ";User ID=" + user + ";Password=" + password … |
| | The code below displays a signature on the screen previously signed on the form before. It has now displayed the image as a png. How do i go about saving the image into a mysql database field so i can recover the picture as and when i need to / … |
| | Hello, I'm new to Daniweb. I have a question. I tried too google it, without result, so I hope you guys are able to help me ;) Anyway, I created hiscores for my RuneScape Private Server. Everything works well, except the part to load a rank. [url]http://epicscape562.no-ip.org/highscore/attack.php?page=0[/url] That is the …  |
| | Hi, On my website I have a group of tables (about 40). I want visitors to be able to search all these (identical) tables at the same time. Right now I'm using MATCH and UNION to do a FULL INDEX search on all tables. The problem is that this method … |
| | I facing a problem where i cant update my mysql data with calculation and if statement i want to update my column answer column and make calculation between column one and two depending on column sign.whether to sum minus multiply or divide:S UPDATE calculation SET answer IF (sign = +) … |
| | I need to add two different fields in two separate tables, but the second sum is double what it should be. Here's what I'm using: Select A.dc,A.rc,B.acctno, ((Sum(If(B.ttc In ('X','Y','Z'), 0, B.ua))) - (Sum(If(B.ttc In ('X','Y','Z'), B.ua, 0)))) As Total_UA, (Sum(C.cub)) As Total_CUB From Table_B As B Left Join Table_C … |
| | I have a php script that echoes results from a search. Generally I have no problem getting the results in a table but for some reason I can't get these scripts to do that. I figure its a small error. I'm going to put in the code but if you … |
| | Hi to all, i created following table in SQL. =================================== create table employee(name varchar(20), dob date) =================================== But, when i ran the query, i got the massage that 'SQL can not find data type 'date''. How should i include 'date' in to table definition.  |
| | Hi :) I am writing an admin application for a website I've written. It's a basic database update/insert/delete app. I started by using the website's server, but the time it took to connect to the server (since the main JTable is populated from the db, you have to wait for … |
| | Hi Guys, Can anybody spot the error on this code? it gives me error: SQL Server Database Error: Incorrect syntax near the keyword 'inner'. 5 0 [CODE]Select e.event_number,e.start_date ,event_desc, venue_desc,s.location from events e inner join venues v on v.venue=e.venue inner join sessions s on s.event_number=e.event_number and session_type='0' (inner join contact_categories … |
| | iam doing computer engineering and currently in 3rd year and i am making a web based agricultural forecasting system using some web services for getting information about weather forecasting,location of the region etc. i have also collected the available data about my region which may be helpful for my application. … |
| | Hi to all, I created following table =================================================== create table man(id integer, name varchar(20), city varchar(20), age integer, dept integer) =================================================== I want name and maximum age of person residing in 'mumbai'. I wrote following query, but got the error like 'can not include name with max() fuction since it … |
| | hi, guys i have a problem here. i have a form which creates a new table for each new user and that user will have a monthly update of his salary now im confused how to go about this. do i need to create a new table or how to … |
| | Below is a piece of code i,ve configured with, It's giving me an Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/****/public_html/****/g.php on line 265. The information stored in the database can accessed be accessed by other pages, using the same code. but its not possible …  |
 | |
| | I currently have a linked table from two tables in one database. I would like to add information from a third table contained in another database. The code for the current table is: [CODE] <?php $con = mysql_connect("","",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("", $con); … |
| | Hello guys, i need a text box editor for users to post their own article, the article is stored to a database. I've been searching and i have not found what i need. I dont require a mega-advanced one, just so people can write an article. I hope someone can … |
| | Hi I've been all over these discussions and still cannot find the syntax that works! When I echo $co and $bus, they both print on screen as they should. But when I try to update the mysql records using the following php, the business_name field data gets erased instead of … |
| | Hi Everyone, I am having some trouble with the libmysql.dll file in Delphi 7. When I try to connect to a database with the dbexpress MySQL driver, i get the error "Unable to load libmysql.dll". I have tried the following to resolve my problem: [LIST] [*]installing different versions of MySQL …  |
| | I am trying to implement a CSS hierarchical unfolding menu on a site. The thing is, it needs to be dynamically populated from the results of a database query. I previously had the menu working but then it was ‘hard coded’ and not built on the fly. Menu description: 2 … |
| | hi, i have a client request which i am unsure how to achieve. i need to be able to search the mysql database for the closest post code to a person who enters in their post code. so for example a user types in post code nn1 1ne and the … |
| | I need to record insert statements, who did them, and when. I am adding triggers to tables and putting the freshly inserted data into a sql_log table. Everything is working well except one thing. I want dates, times, and timestamps to be surrounded by quotes. Just like they would be … |
| | Hi everyone, I have a project I'm working on where I am collecting data for a client on a form I host. They use "MailApe" (you know who I'm talking about), who aren't a very helpful group of monkeys. I need to collect the data to my db from my … |
| | PLEASE can someone help me, am trying to upload files into mysql database. fine uploadiing the file is working, but trying to download thesame file, it's working, but the download is giving me a 0byte empty data. pls if any one has a full code on how to download and … |
| | I've been creating a login system in Java. The functionality of all the programming in java has been a breeze. Though, I can't find any good comprehensive tutorials on creating a login database, which is something I have never done before. [B]Could someone please give me or link me to … |
 | Hey guys, I understand how to setup the cron job to run once a day. Now I am having trouble putting together a function to do the following: I need to delete all content (rows) automatically where the "expire_date" field is equal to or greater than todays date. Keep in … |
The End.