10,939 Topics

Member Avatar for
Member Avatar for lkrvk

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', …

Member Avatar for smantscheff
0
160
Member Avatar for haithomy

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 …

Member Avatar for dipakatcvrca
0
83
Member Avatar for nice_candy

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 …

0
84
Member Avatar for nice_candy

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 …

Member Avatar for nice_candy
0
211
Member Avatar for kardklub

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 / …

Member Avatar for kardklub
0
54
Member Avatar for bartjuh10

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 …

Member Avatar for jkon
0
80
Member Avatar for FBG

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 …

Member Avatar for FBG
0
143
Member Avatar for shakeit13aby

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 = +) …

Member Avatar for smantscheff
0
87
Member Avatar for roachae

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 …

Member Avatar for smantscheff
0
232
Member Avatar for ptara1

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 …

Member Avatar for ptara1
0
264
Member Avatar for deolalkar_pooja

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.

Member Avatar for d5e5
0
121
Member Avatar for litchi

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 …

Member Avatar for pkulkarni89
0
745
Member Avatar for kadriirdak

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 …

Member Avatar for kadriirdak
0
172
Member Avatar for simplyit

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. …

Member Avatar for smantscheff
0
165
Member Avatar for deolalkar_pooja

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 …

Member Avatar for smantscheff
0
140
Member Avatar for lkrvk

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 …

Member Avatar for smantscheff
0
186
Member Avatar for ganeshrnet

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 …

Member Avatar for pritaeas
0
248
Member Avatar for lloydsbackyard

how do i join fields from 3 or more tables....please give me a sample code...thanks

Member Avatar for smantscheff
0
43
Member Avatar for ptara1

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); …

Member Avatar for pritaeas
0
116
Member Avatar for Sorcher

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 …

Member Avatar for diafol
0
1K
Member Avatar for featherwebdiva

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 …

Member Avatar for diafol
0
18K
Member Avatar for Fudgey

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 …

Member Avatar for Simon180
0
493
Member Avatar for snowweb

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 …

Member Avatar for janajay
0
2K
Member Avatar for mrhankey

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 …

Member Avatar for mrhankey
0
157
Member Avatar for dkaptain

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 …

Member Avatar for dkaptain
0
2K
Member Avatar for GreaseJunkie

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 …

Member Avatar for GreaseJunkie
0
223
Member Avatar for justiceigwe

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 …

0
57
Member Avatar for oldezwe

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 …

Member Avatar for prem2
0
82
Member Avatar for drewpark88

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 …

Member Avatar for drewpark88
0
1K
Member Avatar for fuston05

Having trouble storing dollar amounts in the thousands due to the "," that gets inserted once the number becomes 1, 000.00. Any advise?

Member Avatar for fuston05
0
185

The End.