11,093 Topics
 | |
 | I won't beat around the bush. A simple form is posting the field "notes" and "request_id" to this script. "billingrequest" is my tablename, "notes" is the field on the table I wish to update with the field "notes", and requestid is the field on the table that identifies which row … |
| | [COLOR=#000000]Dear all[/COLOR] [COLOR=#000000]I need to build a search with 2 select boxes like; [/COLOR] [COLOR=#000000]Search [/COLOR] [COLOR=#000000]I need the second box to be populated according to the first. (The first one will be populated by me and not from the database with 5 or 6 values). [/COLOR] [COLOR=#000000]After the second …  |
| | Hey, I've got a form that passes the date onto a php script, which posts all the form entries into a database. One of those fields happens to be a date field. I have it going into a column in a mysql database that has the DATETIME datatype, but no … |
| | I am trying to write my own php mysql banner advertising system. i have written imported images to the mysql table and i have got the php code to return normal images files e.g .gif, .jpeg etc. for flash banners i know that the headers are different can anyone give … |
| | Hi How can I create vb6 application that can be able to access to mySQL data base on web site ( the app is on computer connected with the internet ) . Thanks . |
| | Problem: I have two tables and those two table have one field in common which is "S_ID" first table have 2 fields: "S_ID", "T_ID" second table have these fields: "S_ID", "First", "Last" ---------------------------------- What i want to do is that i need to extract the the field "S_ID" from the … |
| | Hello, I am looking for a good php programmer that really wants to work and get jobs done and go onto the next job. I have many jobs open websites range from models site to free counters site.. I DO NOT need any getafreelancer.com wannabee programmers I have had enough … |
| | Hi all, I install mysql 5.0. I create one stored procedure on my local machine. Simply I need to create same stored in Live server. Is there any GUI to access mysql 5.0. like sql server or phpmyadmin. I can access Mysql 5.0 from command prompt only. On mysql prompt, …  |
| | Hi All, I've write a code for client and server. It works well so far but the server just acknowledge the client of what it received. How to recode this program to make sure that once server acknowledged the client that the data sent by the client have been append … |
| | Using a php generator "appgini" having a problem I believe with the script. 1 table with 4 fields, fields 2 & 3 are text and field 4 is an image field. Everything works but field 4, when you upload a image along with text in fields 2 & 3 it … |
| | Hi How can I to access to mySQL data base on my web site from visual basic 6 application. thanks. |
| | i have a data file in text format , i want to convert this text file into mysql database. For this i want coding in vb.net 2003 such that to calculte from this byte to that byte should be update in particular field etc. pls help me? the text file … |
| | howdy all, im just looking for some good websites that list all of the controls in C# that list the various ways of interacting with a MySQL database through C# through a website. While i normally use PHP for this type of thing i would like to expand my horizons. … |
| | I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query("CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)") or die(mysql_error()); mysql_query("CREATE TABLE spam_free( … |
| | |
| | [COLOR="Navy"]Hi everyone, I just finished my summer internship last week and part of what my boss told me at the end of the program was to work on DBMS skills. I am thinking of working on MySQL and from experience I know the best way to master any programming skill(or … |
| | having an issue--*cough*newbie*cough*--the html and php code here supposedly creates a new record into my database. problem is, the successfully connects to sql and creates the record, but the contents of the $_POST variables do not make it into their respective fields. I have an id field (AUTO_INCREMENT) that is … |
| | Having built a work around for the counting feature not working, in any of the normal ways Ihave the following problem. [b]This works perfectly:[/b] [b][size=1][color=#ff0000][i] <%[/i][/b][/color][/size][size=1] [i][b]RSPage[/b] [/i][/size][i][size=1][color=#008000]=[/color][/size][size=1] [b]TRIM[/b][/size][size=1][color=#008000]([/color][/size][b][size=1]Request[/b][/i][/size][i][size=1][color=#008000].[/color][/size][b][size=1]QueryString[/b][/i][/size][i][size=1][color=#008000]([/color][/size][size=1]"page"[/size][size=1][color=#008000]))[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]Len[/b][/size][size=1][color=#008000]([/color][/size][b][size=1]RSPage[/b][/i][/size][i][size=1][color=#008000])[/color][/size][size=1] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]0[/color][/size][size=1] [/size][b][size=1][color=#008000]Then[/b][/i][/color][/size][i][size=1] [b]RSPage[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]1[/color][/size][/i][size=1] [i][b]Max[/b] [/i][/size][i][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]10[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]RSPage[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]1[/color][/size][size=1] [/size][b][size=1][color=#008000]Then[/b][/i][/color][/size][i][size=1] [b]Offset[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]0[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]RSPage[/b] …  |
| | Hi all I am pretty new to website design and am trying to incorporate my website into a database. At the moment I am simply trying to put some basic code together and will finalise details later. I have however come accross a problem, I have managed to get working … |
| | Hi, I have a row where it has multiple columns distinguishing the number of votes a user has. so it'll look like this: [inlinecode] [ user ] [ option_1 ] [ option_2 ] [ option_3 ] [ option_4 ] bobby........ 1 ......... 3 ............ 7 ......... 3 [/inlinecode] Is there …  |
| | [COLOR="Navy"]Hello all, I installed MySQL 5.O but due to some errors I need to uninstall the file , but while trying to delete the file, I keep getting a message that some files (under a specified directory) are shared by other processes or used by other users so I can't … |
| | Hi, I have a calendar table that has event comments and a date tagged to it. I would like to view "Upcoming Events" only. I was wondering what type of syntax I'll need to be using? heres how the table would look: comment | d1 | d2 | d3 ---------------------------- … |
| | Hello there, I know (i think) this can be done (i saw it somewhere, but can't remember where), so maybe you guys can help me. I need my primary key to have left values on the auto_increment. For example P20060001 P20060002 P20060003 ... I need to have P2006 values on … |
| | Has anyone used the tools for this before? How does it handle the code differences, e.g. no SYSDATE in MySQL. Does it automatically change the differences. Thanks |
| | Has anyone done this before? How does it handle the small code differences, eg... no SYSDATE. Does the migration tool actually edit your code? Thanks |
| | [B][U][COLOR="Navy"]What is a database?[/COLOR][/U][/B] A database is a collection of data stored in some organized fashion. The simplest way is to think of it is to imagine a database as a filling cabinet. [B][I]What are tables in the database?[/I][/B] When you want to store some file with information you just … |
| | I am learning to set up a cookie and assign a user_Id to whoever visits my website. I want to keep a record of all user IDs in mySQL database. I tried something like this: [PHP]if(!isset($HTTP_COOKIE_VARS['user_id'])) { $cart_id = md5(uniqid(rand())); $COOKIE=setcookie("cart_id", $user_id, time() + 14400); if (!$COOKIE) { echo "To … |
| | i am using c# with a MySQL database, using OleDbConnection and OleDbReader. When running a query using the count(*) function and try reading the returned value using: OleDbReader.getInt32(0), it gives an exception "Index was outside the bounds of the array". thanks, |
| | This is the first time I try to use MySQL for very large tables. Experienced users warned me against possible problems with *index* definition for large tables: they claim MySQL indices are stored completely in memory, which is problematic to me : I have a huge table and limited memory … |
| | What does connection.conv() means? I know that connection.conv() - set type conversion options between MySQL and Python but How to implement this in python Vinay  |
| | I need to know if anyone using vb6 has hooked up with mySQL database system without any clumsy third party drivers or so. |
| | List Of Free PHP,MYSQL Webhosting Provider at [URL="http://softwaretutorial.myitcareer.org/freephpmysqlwebhosting"]http://softwaretutorial.myitcareer.org/freephpmysqlwebhosting[/URL] |
| | Mysql info [IMG]http://kennyleitz.googlepages.com/mysql.jpg[/IMG] [PHP] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <?php /* call this script "advs.php" */ if(!$c) { ?> <form action="advs.php?c=1" method=POST> <b>Find Results with: </b><br> Any of these words: <input type="text" length=40 name="any"> <br> … |
| | Hi, I have two fields...both are not unique, but both can't be the same. So two fields: user | fruit | joe11 apple angel bananna bobby apple jeff orange julie orange angel apple angel orange ---------- So lets say the above was my table, notice how both fields are not …  |
| | Hi, Need in brief: [COLOR="Blue"]Have 3 tables. I need to extract data from two tables and fill the third table.[/COLOR] Table structure: COM PROFILER: CREATE TABLE comprofiler ( [COLOR="Green"] id int(11) NOT NULL default '0', user_id int(11) NOT NULL default '0', firstname varchar(100) collate latin1_general_ci default NULL, middlename varchar(100) collate … |
| | :mad: I'm currently creating a quiz program that radomly generates questions from a table in mysql........right now I have to php forms. takeTest.php..... <html> <head> <title>Test Week 13 CIS32</title> </head> <body bgcolor = "yellow"> <center> <? $link = mysql_connect("localhost", "web26", "web9660!", "sere1") or die("Error ".mysql_errno().": ".mysql_error()."<br>\nThe SQL sent was: $sql"); … |
| | Incase you are looking for tutorial for configuring apache with PHP and Mysql, I found [url=http://www.expertsrt.com/tutorials/Matt/install-apache.html]one[/url] Hope, it will be useful to you too. ;)  |
| | How do I communicate with my mysql database using VB.Net. I am trying to create an application for my employees to use. They will enter calls made, support requests, replies to those requests, and client data for our clients. |
| | I am not able to connect to remote MySQL server, using MySQLdb package. I have enough permission on remote machine with all rights set to 'Y' and Host field of USER table in mysql database has a value '%', which allows remote login. I tried using Navicat which requires me … |
| | [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/content/r/a/e/raeyshe/html/fanlisting/admin.php[/B] on line [B]21[/B] [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/content/r/a/e/raeyshe/html/fanlisting/admin.php[/B] on line [B]26[/B] [code]<? if ((!$_POST['action'] && !$_GET['action']) || $_GET['action'] == "login") { // get total member count $querycount="SELECT id FROM … |
| | [COLOR=#0033cc]Dear all[/COLOR] [COLOR=#0033cc][/COLOR] [COLOR=#0033cc]I have the following problem. I am trying to communicate with mysql through php but unsuccesfully. In the following script when i misspell the password it gives me the error message. but while it does not create the database it does not return any message. It seems … |
| | i m trying to connect jsp page to mysql. i have insatlled jsp-mysql connector. but still not able to connect to mysql. pla anybody help me. thanks |
| | |
| | Dear all I have a few questions. I would be grateful if you could take the time to answer. I have installed on windows xp home apache2, php 5 and mysqlserver 5. The [URL="http://localhost"]http://localhost[/URL] page of apache works fine. The <?php echo phpinfo(); ?> page works fine. However when i … |
 | I can't find it anywhere! :rolleyes: I want to install it onto a test Red Hat box so that I can replicate our live environment before doing an upgrade. I've scoured and scoured. If the internet had been a saucepan, it'd have very little of its copper bottom left. :lol: … |
| | Hi everyone!! I need some help with setting up a php page that calls an sql database.. here is what I want it to do? -firstly: a user must be able to log in(because under this login you must be able to get stats from this user) Then the user … |
| | I create 2 connectionsand then try to select the current active database: [code] $aaa_link = mysql_connect("host1","user1","pass1") or die(mysql_error()); $bbb_link = mysql_connect("host2","user2","pass2")or die(mysql_error()); mysql_select_db("dbname1", $aaa_link) or die(mysql_error()); [/code] However, mysql_select_db fails with error: [code]Access denied for user: "user2" to database "dbname1"[/code] What is wrong here? |
| | Hi I'm real new to php etc, and just wanted to know if there were any implications to using an IIS on windows as my server rather than apache? thanks alot...oh apart from the obvious being apache is free open source....:) |
| | [code]mysql> insert into fund_history select * from temp_fund_history where data_date='2006-06-30' and index_num between 1 and 10; Query OK, 0 rows affected (0.03 sec) Records: 10 Duplicates: 10 Warnings: 0[/code] I am really wondering why this INSERT statement is not inserting 10 records. Its saying 10 Duplicates: 10, and there is … |
| | I've been having this php/mysql problem that I can't seem to be able to fix. I'm displaying information from a mysql database on my site, but for some of the variables only half of the cases can have information in tehre that needs to be displayed on the site (e.g. … |
The End.