10,940 Topics
 | |
| | 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 of invoices just fine. But now I want a way to click the "view" link to call a php script to open up a jquery … |
| | Hi, SELECT * FROM admin INNER join category on category.cat_id=admin.cat_id where cat_id=5; showing an error. #1052 - Column 'cat_id' in where clause is ambiguous need suggestions..  |
| | 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 |
| | 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" … |
| | 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 … |
| | 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 … |
 | 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 |
| | 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 … |
| | 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 … |
| | 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"] > … |
| | 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.: …  |
| | 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 … |
 | 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), … |
| | 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 … |
| | 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 … |
| | 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 …  |
 | 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 … |
| | 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 …  |
| | 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  |
| | 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 … |
| | 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 - … |
| | 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!! |
| | 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 …  |
| | <?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 …  |
| | 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 |
 | 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 …  |
 | 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 … |
| | 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 … |
| | 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 … |
| | 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??? |
The End.