10,940 Topics

Member Avatar for
Member Avatar for Mekano

Hi, I put websites together using Xoops and OsCommerce. I need to know how to edit mysql databases using Cpanel. Please could you point me in the direction of some tutorials? There are some which show how to se up a database but not how to edit one. For example, …

Member Avatar for Mekano
0
192
Member Avatar for CzechRock3

I am trying to replace mysql fields with this code... But unfortunatly it is not working... I do not know why... Here is the code please help me. Thank you. [CODE] <?php session_start(); if ($_POST['txtName'] != ''){ $host="****"; $username="****"; $password="****"; $db_name="****"; $tbl_name="****"; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select …

Member Avatar for amigura
0
108
Member Avatar for samnav

Does anyone know of a free tool or utility that I could use with pgAdmin III that would accomplish the same type of import functionality found in Navicat?

Member Avatar for samnav
0
73
Member Avatar for jk_bscomp

Hello Everyboby!!! I just want to ask basic information but confusing in my part about the differences of ADO, ODBC and OLEDB ... I get confused in differentiating this three.... I hope you could help me with this problem... Your help is highly appreciated.... Thank You.

Member Avatar for Ancient Dragon
0
67
Member Avatar for justinmyoung

I'm trying to set permissions in mysql for an ecommerce open source application (freeway) for a path: Set the permissions on Freeway/images directory to 777 in my terminal I have typed: chmod 777 /Sites/Freeway/images but it is telling me that "no such file or directory exists", and yet when I …

Member Avatar for justinmyoung
0
137
Member Avatar for Doctoremote

This maybe an old chessnut to you old sweats but I am a newbie to this.. I getting this error:- [B]mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\dsg\Mytest.php on line 9[/B] the database is called Camsdb the table is called DBF the fields of which there …

Member Avatar for Doctoremote
0
139
Member Avatar for justinmyoung

Can someone help me figure this out. What do I need to do to set permissions in MySQL? Thanks in advance.

Member Avatar for phper
0
70
Member Avatar for richardzhangss

Hi, Here is my mysql sentence: [CODE]select last_insert_id() from pp;[/CODE] and the table pp is created by: [CODE]create table pp(id int not null auto_increment primary key,name varchar(255) not null);[/CODE] Now I'd like to change the above into sentences that are right in Oracle. First I create table: [CODE]create table pp(id …

Member Avatar for jwenting
0
252
Member Avatar for smartness

Hi. I Installed Apache 2, PHP 5, and Mysql 5 (All Latest Version) and now i when open e script on my localhost that needs a mysql connection (i tried with phpmyadmin) i get a error: Could not load module mysql.dll (ore something like this) but the service is running …

Member Avatar for smartness
0
94
Member Avatar for nevets_steven

I am using MySql 5.0.51a and am trying to acheive the following I have 2 tables, one of categories and one of company details, each company can select up to 6 different categories for their business. In my category table, I have sub categories, and sub sub categories, eg, Main …

Member Avatar for tesuji
0
106
Member Avatar for swapna7999

hi is it possible to run a java application on a linux server if so, is it possible to run the exe of the application in the linux server or an applet should be called initially i was doing my project in vb and since it is not possible to …

Member Avatar for jwenting
0
42
Member Avatar for still_learning

Hey guys, I am trying to figure out a way to update a row in a table for my database by filling out information in an html form. What I am doing is filling out a form with a username and other information. I want to be able to either …

Member Avatar for still_learning
0
142
Member Avatar for swapna7999

hi there when im trying to connect to a remote mysql server im getting an error i searched for it and i came to know that MySQL database server remote access disabled for security reasons by default and they provided with lot of steps to enable it the problem is …

Member Avatar for amigura
0
101
Member Avatar for gatsu

Hello, why wont this code give my "Rubrik" a link with its ID? I only get "www.yada.com/open.php?id=" [code=sql]<a href="skapaannons.php">L&auml;gg till annons! </a> <?php $con = mysql_connect(" "," "," "); if (!$con) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("annons", $con); $result = mysql_query("SELECT annons.id, annons.datum, annons.rubrik, annons.pris, …

Member Avatar for gatsu
0
102
Member Avatar for Designer_101

Hey Im having this problem, im sure theres a simple solution, but i cant seem to see it :D The code bellow is part of a regestration form validation. Basicly when i ask the database if anyone else exists with the same username, password or email address - it works …

Member Avatar for Designer_101
0
113
Member Avatar for En1ro

Hello, First of all thanks for time reading this post and the problem is that: I'm Using Borland c++ builder 6 and i want to connect to my database through BDE components, i added Database, Table and Query components, filled query , added params to Database and tried to connect …

0
62
Member Avatar for Pakse

Hi there, I'm new to web development and I have a question about MMS. I couldn't find a fitting forum to post in, but I hope it's alright in here :) How do you create a MMS-inbox on a server, what techniques do you use? We're running a Resin web …

Member Avatar for peter_budo
0
57
Member Avatar for forzadraco

hyy... i hv aproblem.. iwant to make aplication thabt need some field database from other database(pg-sql) and want to copy it to other database(mysql). can that skrip make this happen auto copying...?

Member Avatar for AaronASterling
0
101
Member Avatar for forzadraco

Hello all, i get a problem: 1 have 1 database and want to move some field in tabel to other database automaticly, how to make this happen to auto copyning data everyday or every hour..? anyone can help me.. Thanks for read my thread, Ardy Satria.

Member Avatar for mwasif
0
51
Member Avatar for thirusvga

Hi.. I am new in php +ajax.....Now i am doing project in php+ajax+linux environment...i create a login page using php,ajax,mysql,, i have mysql tables are. register,slideshow,,,,,In register table having following field... 1.uid (autoincrement)2.first (firstname)3.last(surname)4.user(username),5.pass(password) In slide show table having following field,,, 1.uid 2.pid(presentation id,autoincrment) 3.slideno 4.description 5.location(this is what image …

Member Avatar for thirusvga
0
160
Member Avatar for hacker9801

Hey. Right now in my game (online) I'm using std::vectors to store player info. Should I continue to use them (I hate having to loop thru them each time to find a player) or should I use MySQL to hold player information (like map their on, nickname, id, position, etc.)?

Member Avatar for Rajith Cherian
0
116
Member Avatar for n00b3

Hello, I am a PHP programmer, trying to transition to C++. I need C++ to communicate with MySQL, so I realize i need to have mysql++ libraries. I am using winXP. I have MinGW. I am just trying to install MySQL++, and I am having problems. I have been following …

0
62
Member Avatar for webguru07

I need to get information from 2 tables in the same mysql database [code=php]$sql = mysql_query("SELECT * FROM notes, customers WHERE `to`='next' LIMIT 5"); while($a = mysql_fetch_array($sql)){ $row_color = ($row_count % 2) ? "#EFEFEF" : "#FFFFFF"; echo("<tr bgcolor=\"$row_color\"> <td height=\"25\">" . $a['custid'] . "</td> <td height=\"25\">" . $a['name'] . "</td> …

Member Avatar for prethum
0
267
Member Avatar for dabamb

Good day!! Hi...I having hard times in doing an online voting system using PHP and mySQL as database. It's like...student council election; once I login..i can then view my personal profile then view all the candidates in each position...I can then vote my desired candidate.Only one vote is allowed in …

Member Avatar for dabamb
0
139
Member Avatar for kevin wood

i am trying to send out an email which contains images from a database of images that have been uploaded. when i send the email out only the text and any images that have been hard codeing in using the img tag. i have done some research on this and …

Member Avatar for kevin wood
0
162
Member Avatar for cmax

hello to every body, i have a problem in mysql database i dont know where i made mistake, i wrote a database this one dow, please show me where is my mistake or how i can use in simple way [code=php]<? trim($searchterm); if (!$searchtype || !$searchterm) { echo "You have …

Member Avatar for mwasif
0
83
Member Avatar for veledrom

Hi, I have a project which requires me to use PL/SQL blocks, PL/SQL cursors, PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers. I think(not sure) i can create PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers in MySQL. Can i create PL/SQL blocks and PL/SQL cursors within MySQL …

Member Avatar for tesuji
0
111
Member Avatar for queenc

hi i have two tables,i want to display the details in startpost and based on the userid i want to display the username ie i want to print posttitle,date,name using single query please help [CODE] CREATE TABLE `creuser` ( `uid` int(11) NOT NULL auto_increment, `username` varchar(100) NOT NULL, UNIQUE KEY …

Member Avatar for queenc
0
110
Member Avatar for krishnasaradhi
Member Avatar for BearofNH
0
192
Member Avatar for jimesten

I've been away from sql for quite a well and need a little push to get restarted. Need to report out of a single table, with values coming out of only two columns. Need to group items from column 1 as the left column in the ouput table with totals …

Member Avatar for jimesten
0
98

The End.