10,938 Topics

Member Avatar for
Member Avatar for vijaygupta

hello, I have build an code for opening a map in thick box but i have problem closing it ,i have to click outside a thickbox please help

Member Avatar for tinymark
0
226
Member Avatar for mikecronauer

Hi, I am trying to use AJAX to pull back mysql table information. I tried to alter an example I found (w3 schools) where they showed how use a selection table to pull a specific line out of a mysql table, using the "q" (not really sure if the "q" …

Member Avatar for mikecronauer
0
155
Member Avatar for ashvamedh

hey friends... i am using fedora 13... when i am trying to access a database i am getting this error-- mysql> use bgm_scr; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'bgm_scr' --------------------------------------- i also tried accessing by switching to superuser.. but i get this error -- [CODE][user@localhost …

Member Avatar for davidchilders
0
206
Member Avatar for TeddyBear2155

Well this is what I have done so far I ran these 2 lines first, they worked: VARIABLE g_total NUMBER VARIABLE g_prod NUMBER Next I ran these 4 lines and they worked: BEGIN :g_total := 100; :g_prod := 4; END; Then I ran these and that is when the problems …

Member Avatar for davidchilders
0
142
Member Avatar for Acute

Hello there, I'm selecting only one column, so if I have 20 rows in result, how to merge all these rows into [U]one row[/U] where all the rows will be [U]comma separated[/U]? Thnx in advance

Member Avatar for smantscheff
0
91
Member Avatar for klemme

Hey All! I am trying to update some records using forms - But something gets mixed up when I send my info to the database: [B]My form with the info I wish to update, look like this:[/B] [CODE] //Getting the info from a dropdown list, where the user has picked …

Member Avatar for klemme
0
84
Member Avatar for dschuett

I know this is kind of a jquery/ajax question, but I figure it wouldn't hurt to ask here since someone may have done something similar. I have a database of invoices that have multiple attachments(which are stored in a different table) per each invoice. I have it returning the row …

0
83
Member Avatar for xxreenaxx1

I can read from files that are uploaded but now I would like to INSERT the data entered on the file to be inserted to mysql database. But not sure how this work. Tried to search few term and I have tested few methods. Nothing works. [CODE]<?php if ($_FILES["file"]["error"] > …

0
62
Member Avatar for patrickm129

Hi all, I'm working on a login system for my site. But when I use mysql_num_rows I get an error [CODE]"Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/patrickm129/patthepcwizard.com/login02.php on line 25"[/CODE]. I'd really appreciate it if you would be able to solve this with me. P.S.: …

Member Avatar for happytogether
0
110
Member Avatar for woolm110

Hey Everyone, I'm currently creating a simple shopping cart with interaction to PayPal. I've set up a database with a table named orders. I'm using the PayPal sandbox and what I'm looking to do is to post the order details into my database on payment completion. I have a script …

0
156
Member Avatar for rom.

I'm making a simple IP logger. I've tested the script, but the database doesn't seem to filling up. It could be a problem with the database format etc, details below. Otherwise, I must have made an newbie oversight in the PHP. Some fresh eyes would be greatly appreciated! id: INT(10), …

Member Avatar for diafol
0
169
Member Avatar for klemme

Hi All! I have a table with different kinds of customers information. With the code I have posted below, I want to pull out all the records from the database. When I progress to make the "create_record" page, my intention is that it should automatically be added as an extra …

Member Avatar for joban.ali
0
119
Member Avatar for adamworld

I am working on a site and I want to be able to query the appropriate table based on their location. For example, if they input they live in NY, it should query the NY table. If they input they live in CA, it should query the CA table and …

Member Avatar for adamworld
0
93
Member Avatar for devinodaniel

I have a site the generated a row of data from MySQL db. The parent element DIV is called "enclosure". This shows up as hidden when page loads. I have a link "show/hide" that I'm using to show the data when click using jQuery. My problem: Since all the rows …

Member Avatar for macneato
0
203
Member Avatar for jrotunda85

I keep getting the following error whenever I try to run this query on my "spot" table: [CODE]#1054 - Unknown column 'a.Longitude' in 'field list'[/CODE] The weird thing is though that the column DOES in fact exist, is spelled the same way, and has thousands of rows of data. Even …

Member Avatar for jrotunda85
0
113
Member Avatar for ohgee

On a project I am currently working on, we are supposed to differentiate between different classes of users based off their IDs (which are 10 digits). For example, one group's IDs should all start with a 9 (marking them as belonging to that group) and the other groups should start …

Member Avatar for javaAddict
0
139
Member Avatar for vijaygupta

hello , I am writing a validation code in which i have validate two feilds and check if the feild username and email already exist in the database. please help

Member Avatar for jkon
0
143
Member Avatar for GreaseJunkie

Hi, I've looked around and cannot find an answer to this. I want every email that comes in to a certain email address to get stripped of everything but the subject and email address and get stored into a MySQL database. First, is this possible? If so, how? If someone …

Member Avatar for GreaseJunkie
0
250
Member Avatar for JerieLsky

Hi, I'm having a problem on how to query from the following tables. Here are the tables. PATIENT: PK - PatientNo - FirstName - LastName - MiddleName - Address - Age FK - PageNo PAGE PK - PageNo BOOK PK - BookNo BOOKPAGE 'Junction Table PK - BookNo PK - …

Member Avatar for pratik_garg
0
144
Member Avatar for arsheena.alam

Hi, I have a variable @FranchiseId declared in my stored procedure If I try the following select command, will it work???? SELECT @FranciseId=(select FranchiseName FROM franchise WHERE username=@username),username FROM MyTable I hope you Understood My problem!!

Member Avatar for arsheena.alam
0
125
Member Avatar for josephbeluan

HI, I'm new to VB6 programming and i need some help of anyone to please help with my problem. I want to know what do I need to do or know before to create a code that connect VB6 to my SQL. and if you desire please give a sample …

Member Avatar for Jx_Man
0
116
Member Avatar for quincy.89

<?php ob_start(); include("sys.php"); session_start();//when nid use session nid put tis ?> <html> <title></title><head></head> <script type="text/javascript"> function addRowToTable() { var tbl = document.getElementById('tblSample'); var lastRow = tbl.rows.length; // if there's no header row in the table, then iteration = lastRow + 1 var iteration = lastRow; var row = tbl.insertRow(lastRow); var …

Member Avatar for debasisdas
-1
1K
Member Avatar for manutd4life

Hello, i hav no idea abt MySQL, but i have a program with access database. Is it possible to convert it to MySQL database?? Any HELP please.. and i wanted to know also that all the code also will need to be change?? any way how should i start..?? thanks

Member Avatar for debasisdas
0
88
Member Avatar for amie900218

hello, i'm very dull at js, so i hope you guys can help me. ok, i have create a prompt box that will ask user to enter a password, and this prompt box will take user to secured page. [CODE] <script type="text/javascript"> function show_prompt() { var name=prompt("Please enter your password","Fill …

Member Avatar for McLaren
0
100
Member Avatar for Venom Rush

Hi there I'd like to know if it's possible to combine an update and insert query into one query. What I'd like to do is insert new data into one table and update a colum in another table at the same time. For example, there are 3 different baskets (puppy …

Member Avatar for nuraini
0
10K
Member Avatar for VipinDugaya

Hi , i am vipin facing a problem in mysql table i hava two table, primary key of one table is used as a foreign key of another table. but when i inserting some values in first table it gives [B][COLOR="Red"]error:Cannot add or update a child row: a foreign key …

Member Avatar for debasisdas
0
363
Member Avatar for adamworld

I am trying to store millions of records with address, city, state, zip, etc. I originally had one table with 17 different fields with the primary key being id. However, I soon realized after inserting almost a million, the website began to lag and was slow. What is the best …

Member Avatar for debasisdas
0
260
Member Avatar for anip1610

hello!!!...i want to start program a to store video record to database using vb2008 and mysql..but i dont know how to start since i still new to this whole thing about programming..can someone help me???

Member Avatar for debasisdas
0
103
Member Avatar for amie900218

hello, need help from you guys. ok, i have create a prompt box that will ask user to enter a password, and this prompt box will take user to secured page. [CODE] <script type="text/javascript"> function show_prompt() { var name=prompt("Please enter your password","Fill Here"); if (name!=null && name!="") { location.href="index.php"; } …

Member Avatar for amie900218
0
126
Member Avatar for branding4you

I have code like this, it shows data when tehre is data but if there is no data i want to say "no records" where am i going wrong? [CODE]<?php require_once('db_conf.php'); $sql = "SELECT * FROM tbl_holidayspecials WHERE fld_country = '$countryname' AND fld_state = '$statename' AND fld_city = '$cityname'"; $result …

Member Avatar for branding4you
0
144

The End.