11,093 Topics

Member Avatar for
Member Avatar for boykin

Linux newbie any way ... MySql 5 installed eaisly on my Mandrake 10.1 box but the Gui admin tool MrSql-Administrator 1.1 will not. Is it my ineptness? Thans in advance :(

0
88
Member Avatar for screwrup

[COLOR=SeaGreen]Hi guys, i hope u can help me solve this prob of mine. Im currently werking on this project and somehow im unable to insert this data into my database eventhough the data was being retrieved. Can anione help :sad: [/COLOR] <% option explicit %> <% response.buffer = true %> …

Member Avatar for DMR
0
211
Member Avatar for dx20021213
Member Avatar for techkar
0
235
Member Avatar for dsureesh

How can MySQL can be connected with Java I need sample coding

0
79
Member Avatar for katharnakh

how do i move to next record after i click a button called 'Next' and how do i move to previous record after i click 'Previous' in MySQLdb. does method exists to do this? please help me........... [I]import MySQLdb from Tkinter import * db=MySQLdb.connect(host='127.0.01',user='',passwd='',db='Trimtabs') print 'mysql got connected.....' cursor=db.cursor() root=Tkinter.Tk() …

0
73
Member Avatar for rcasinillo_s
Member Avatar for rcasinillo_s
0
139
Member Avatar for delite

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /data/9/0/24/113/676928/user/690291/htdocs/inc/_up_index1.php on line 40 This is the error i get every time when any of my php scripts try to read/write in my mysql data base. This is _up_index1.php [PHP] <? $test_act['new_tranzaction']="OK"; $test_act['tranzaction_details_started']="OK"; $test_act['tranzaction_details_pointing']="OK"; $test_act['accept_tranzaction']="OK"; $test_act['reject_tranzaction']="OK"; $test_act['tranzaction_details']="OK"; $test_act['payment']="OK"; …

Member Avatar for rcasinillo_s
0
181
Member Avatar for rev4eva

I have tried to connect my JSP codes to my database server but i seem to get an error saying that it cannot locate the driver. My normal java codes to retrieve data frm database works fine but not my JSP codes. I m a bit lost in the configuration …

Member Avatar for sangamesh
0
201
Member Avatar for roychong

Hi everyone, I'm keen to use Access as a client application to access data from a MySQL database. The reasons are Access for its strength in reports creation and MySQL for its stability and scalability. I also intend to site the MySQL database with a web hosting service provider. This …

0
113
Member Avatar for realestninja

Hi I've been told by my bf that php and mysql are very very powerful tools in the computing world and that it can make all kinds of neat things like databases to small nifty programs. I'm a model, and I began to get addicting to computers after i was …

Member Avatar for BlazingWolf
0
212
Member Avatar for rcasinillo_s

Good day members! Could somebody help me here, could modify it for me. There is an error in the syntax: $query = "UPDATE jobs SET position = '$position1', description = '$description1' WHERE id = '$checkbox1'"; $query = $query . " 'UPDATE jobs SET position = '$position2', description = '$description2' WHERE …

Member Avatar for sarahk
0
116
Member Avatar for Walyer

hey, i'm trying to insert data into my database with PHP5 i've created this code, <? //open the connection $conn = mysql_connect("localhost", "user", "pass"); //pick the database to use mysql_select_db("musiclist", $conn) //create SQL statement $sql = "INSERT INTO musiclist (artist, title)"; $sql.= "VALUES ("; $sql.= "'John Denver', 'Thank God I'm …

Member Avatar for calcop
0
106
Member Avatar for snowweb

I'm creating my first web application in PHP/MySQL, however, when I go to view the database contents, the data has been stored in the wrong columns. I've gone through my insertion code with a fine toothcomb and can see no errors which might cause this. I will post the code …

Member Avatar for snowweb
0
85
Member Avatar for mark1048

[b]Configuring PHP with MySQL[/b] [B]Intro[/B] To use PHP with MySQL, of course you need to install MySQL server on you system first. On my local system, I have MySQL server installed in \mysql directory. If you need help on installing MySQL on your system, please read "Herong's Notes on SQL". …

0
73
Member Avatar for jaikar

hi i am extremly a newbie and i have a doubt. i have wamp server installed, if i create the mysql database on my system using phpmyadmin how can i upload that database to the remote server ?, what type (wht type of file extention) of database files that i …

0
71
Member Avatar for hbmarar

Hi to all, I would like to build a registration module and this registrastion module has the following requirements. It is mainly divided in to four parts. [B] 1.General Info 2.Personal Details 3.Searchable details 4.Owned products[/B] The first two are compulsory and the later two are opted from a group …

0
82
Member Avatar for snowweb

I've created a web page in .php which receives it's content from a MySQL database, it is all working nicely and looking good except that a field which I have called Ed_Main is now about 65kb and now does not display all the text stored in it. I'm using PHPMyadmin …

0
68
Member Avatar for invincible_king

hey guys, i need to setup a database server, and as of now , i do not have any knowledge about MySQL, PHP, and things realted ...although i have a fair knowledge of how things work, i have used Access for my earlier databases, i want to have adress book(forms) …

Member Avatar for william_stam
0
138
Member Avatar for Brims

Hiya all ive decided to do my final year project designing an online music video library that will allow multiple access by many users to the same files that will be highly available, with facilities to access the video library by pc, pda and mobile phones. how would i integrate …

Member Avatar for william_stam
0
141
Member Avatar for michael123

I would like to know how I can backup Mysql tables from hosting server to my local pc? I don't want to use phpMyAdmin, is there some simple commands to do that(I use PHP)? and how to restore it back to hosting server? I assume it will use csv file. …

Member Avatar for william_stam
0
237
Member Avatar for albert85

i'm a newbie in MySQL. i want to know if i want to update MYSQL, can i check that is it have any user at that time, provide me the solution. if i get there is the user how i block the traffic and wait for the user finish their …

Member Avatar for william_stam
0
92
Member Avatar for mehrzadsoft

whats wrong with this code? i'm really confused! when i use INSERT code insted of UPDATE in my file, every thing is ok. but when i use UPDATE,it doesn't work!! UPDATE: [CODE]$query = "UPDATE $tblname SET title='$title', desc='$desc', body='$body', time='$time', faday='$faday', famonth='$famonth', fayear='$fayear', fu_show='$fu_show', fu_day='$fu_day', fu_month='$fu_month', fu_year='$fu_year', wshow='$wshow', dshow='$dshow' WHERE …

Member Avatar for william_stam
0
169
Member Avatar for PH03N1X

Hey there, im not very great at php and im wondering how i could fix this error [CODE]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/blindst/public_html/forumbeta/vtopic.php on line 328 No replys to this topic.[/CODE] This is line 328 [CODE]$sql2=("SELECT * FROM `reply` WHERE tid = '$id' …

Member Avatar for PH03N1X
0
148
Member Avatar for jpl80

I cannot get MySQL working. Can someone please help? I have changed permissions on the /var/lib/msql directory and I still can't get it started. Running Suse Linux Enterprise Server 9 # mysql -V mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686) # mysql start ERROR 2002: Can't connect to local …

0
104
Member Avatar for namit

Hey all What is with this query $query = mysql_query("UPDATE `namitposts` SET `title` = '$topic' , `date` = '$date' ', `postee` = '$postee', `post` = '$post_text' , `ip` = '$ip' WHERE `id` = '$del'") . mysql_error(); Its not passing the variables am getting this error message Notice: Query error You …

Member Avatar for Ooble
0
222
Member Avatar for Amunra

I am trying to install phpbb to use as a forum on my home server but I don't know where to start in the line of mysql. I have downloaded the latest version of mysql and installed it, but I can't figure out how to create a database for phpbb. …

Member Avatar for Amunra
0
207
Member Avatar for ronb722

Hi all, Does anyone have an example of how to synchronize two databases on different servers? Thanks, Ron

0
99
Member Avatar for namit

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.

Member Avatar for paradox814
0
106
Member Avatar for william_stam

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

0
76
Member Avatar for HockeyFan

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 …

0
124
Member Avatar for tristan17

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

Member Avatar for techniner
0
87
Member Avatar for bennieblanco

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 …

Member Avatar for Phaelax
0
121
Member Avatar for terence sharp

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 …

Member Avatar for chrisbliss18
0
83
Member Avatar for bennieblanco

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 …

Member Avatar for bennieblanco
0
128
Member Avatar for Janet Field

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 …

Member Avatar for Phaelax
0
150
Member Avatar for iketunde

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 …

Member Avatar for Phaelax
0
126
Member Avatar for baker011

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 …

0
96
Member Avatar for paradox814

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 …

Member Avatar for sarahk
0
83
Member Avatar for aarya

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

Member Avatar for Lafinboy
0
156
Member Avatar for ShadowBC

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 …

Member Avatar for Lightninghawk
0
64
Member Avatar for aarya

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

Member Avatar for aarya
0
310
Member Avatar for hbmarar

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 …

Member Avatar for hbmarar
0
235
Member Avatar for viperman224

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

Member Avatar for chizy2
0
210
Member Avatar for Sword

MySQL 5.0 vs. PostgreSQL 8.1 what is main diference? advantage? disadvantages?

0
116
Member Avatar for hbmarar

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 …

0
73
Member Avatar for michael123

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 …

Member Avatar for chrisbliss18
0
138
Member Avatar for server_crash

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.

Member Avatar for zippee
0
113
Member Avatar for iketunde

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 …

Member Avatar for bwest
0
109
Member Avatar for iketunde

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 …

Member Avatar for zippee
0
176
Member Avatar for iketunde

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 …

Member Avatar for wally_lawless
0
156

The End.