10,940 Topics
 | |
| | I have a databse in mysql and am looking to select the last 5 values in the database and there contence. How would i do this. Will be using php to do this. Thanks There is an incramenting variable called Id and could use that if possible. |
 | i need to run a backup script for a mysql database how do i run "mysqldump" from asp? ive tried aspexec and mcs but no luck. am i missing something? basicaly i need to be able to backup a database at a click of a button in an asp application. … |
| | Is there a SQL query to check to see if an index (by name) exists on a table? I have this for SQL Server and for Oracle, and need to be able to query to see if an index exists before I try to create it. In some cases, I … |
| | hi, i need to create a database of images. does anybody know where i can get a database of sample images? any help will be greatly appreciated, tristan |
| | This is what I need [url]http://www.vital-ic.com/index.php?page=part&PHPSESSID=6b1baaeb7d9e4d26bdda4faa5265b7f6[/url] in the field enter xc2v and click on the arrow image for search once result comes back you will see part# links If you click any of the links it will enter the part# in to a form field How can I make mysq … |
| | i have made a script that adds to a tabel in mysql, one problem is, even though it echos that it worked. it doesnt add them :( [php] <?php $dbhost = 'localhost'; $dbuser = 'tezzana_cams'; $dbpass = '**********'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); echo … |
| | Hi there ,I am working on my web site and I need some help with my search result query's If you look here [url]http://www.sensitivetechnology.com/search.php[/url] and in the top search field enter 74AC86SC the resilt will show Product ID and Description ,but it won't show quantity and price And also I … |
| | I'm trying to complete an assignment for a Certificate IV WebDesign. I'm finding it all really hard and have heaps of questions. I have installed IIS, PHP 4.3.8 and MySQL 4.0.20 on my home computer. The reason for putting myself through all this agony is i need to learn how … |
| | Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I … |
 | Hi, I have a Windows 2003 server running Plesk 7.5.5 Recently MySQL is shutting itself down and I really dont know why it would be doing this. I restart the server and it runs again but I get one of those Microsoft reports asking if I want to send it … |
| | I was wondering if any of you knew of any optimization techniques? Or any other sly tricks to help lay off constantly using the database.... A friend wants me to help design a high-traffic forum site (for her organization) and the only thing I can come up with is precaching …  |
| | is there an site for asp mysql tutorials.using mysql database with php is very eazy but i am having problem with asp.which database comnly used with asp.i hope sombody help me in learning asp  |
| | Hey people, hoping to find some answers here to a problem I'm stuck with. :sad: I have recently installed Windows server 2003 onto a machine and are trying to get a phpbb forum set up. I installed apache and the webserver is all working perfectly without any issues. THIS IS …  |
| | i m getting the error as Error Type: Microsoft VBScript compilation (0x800A0401) Expected end of statement /myweb/updat.asp, line 18, column 181 my code is <% if session("bvuser")="true" then struser=request("usercode") stremail=request("email") strfname=request("fname") strlname=request("lname") straddress=request("address") straddress1=request("address2") straddress2=request("address3") strcity=request("city") strcountry=request("country") strpassword=request("password") struser=session("usercode") dim rsupdat,Conn,sql Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Driver={MySql ODBC 3.51 Driver}; … |
| | hi really this issue is troubling: I exported the database structure using the phpmyadmin as harry.sql from my local system.now I went to company server/cpanel /mysql database.created a user with username and password. I would like to import this file and I tried the same way that I used to … |
 | Hi All, I'm messing around with different PHP scripts on my server. I can't seem to setup MySQL. I have installed and configured it. But I have now idea what to do with it. Is it like PHP where all you have to do is install it and its done? …  |
| | MySQL 5.0 vs. PostgreSQL 8.1 what is main diference? advantage? disadvantages? |
| | hi, I have started programming (learning) to free myself from depencies.I do not know how to do the below. [COLOR=Navy]i made a form that has a input box for emai and two passord inputboxexs.on submit i have to pass the same email inputbox value as the hidden value for username.In … |
| | I have three tables, table1 store records which may have next level ID(child), table2 lists corresponding child ID, and table3 stores the possible message for that particular ID. table1: [CODE]------------------------------------------ ID | group | tochild ------------------------------------------ 1 A y 2 A n 3 B y 4 A y 5 A … |
| | I know it's possible, but I'm not sure how. I need several services to use one database. For instance, I need blogs,chat, and a forum to share a database so that when you sign up at one place, you are automatically signed up at all of them. |
| | Hello, I created this page. it contains textareas and checkboxes. when user enters information or check any of the checkboxes. this translates to a conditioned query.i achieve this using javascript. u can find the url @ [url]www.laterallinks.com\search.htm[/url] try entering gibberish and any of the fields and click on the fetch …  |
| | Hi, got another problem. I have an interface that uses javascript to generate the Mysql WHERE condition of a query it posts to the a PHP page that retrieves values from the database. it works fine as usual on my local pc. but i when i uploaded it to my … |
| | Hi, got another problem. I have an interface that uses javascript to generate the Mysql WHERE condition of a query it posts to the a PHP page that retrieves values from the database. it works fine as usual on my local pc. but i when i uploaded it to my … |
| | I have two tables: [CODE] table1: ---------------------- id name member ---------------------- 1 user1 2 user2 3 user3 table2: ------------ id group 1 A 1 B 2 A [/CODE] Now I want to update table1 and set member field to "Y" if this userID belongs to table2, how should I write … |
| | |
| | heres the complete error that i am getting. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'A (A) )' at line 1 does anyone else get these errors at all? [php]<?php $host = … |
| | Team of Web developers is looking for customers/partners for development of Web programs, regardless of task complexity. A wide experience in development enables us to develop different projects: we can fulfill simple tasks such as Web site development and up to the difficult one such as the development of complex … |
| | In database I have three tables: t1,t2,t3 all three tables contain the same field (username) t1(username) ------- user1 user2 user3 user4 user5 t2(username) ------- user3 user4 t3(username) ------- user2 Now how can I write SELECT statment to retrieve all username from table1(t1) which is NOT included in table2(t2) and table3(t3)? … |
| | Hi there, i have question on arranging columns whereby the datatype is date and time how should i arrange them so that the latest date & time entry will be in the first row? i have a table displaying records and these records' columns are retrieved from 3 different tables … |
| | hello everybody, i'm new to this forum. i've a small problem after migration process of my sql server sample database to mysql server. if anybody are aware of this problem please let me know the appropriate solution. i have downloaded the MySQL migration tool kit from the mirror site and …  |
The End.