7,368 Topics

Member Avatar for
Member Avatar for begueradj

Hi people, I would love to list the table of my database: could you give me a hint to fix this problem using a PHP script ? Thank you very much begueradj

Member Avatar for pritaeas
0
33
Member Avatar for cmccully

Hi I have a PHP/MYSQL driven site. When a user creates a new account or updates their existing username or email address I do a quick check to make sure the requested entries are not already in use. I am concerned that in the few milliseconds between the SELECT and …

Member Avatar for cmccully
0
165
Member Avatar for extemer
Member Avatar for b1izzard
0
132
Member Avatar for Buppy

Hi, i have a fresh MySQL install, however, i cannon log in with root. All i get ir access denied for root@localhost. However, i can login without any username and password, but it does not have any useful privilegies. How can i get the root account working? Thanks

Member Avatar for b1izzard
0
121
Member Avatar for xero771

Hello, I'm trying to join two tables for [CODE]www.cs75.net[/CODE]project 2 (users, history), but i read that JOIN isn't a good practice and will eventually be bad if your tables get larger. so i created new tables as the following: [url]http://pastebin.com/MBzCM1Wv[/url] used a foreign key. the question now am i on …

Member Avatar for smantscheff
0
112
Member Avatar for abelLazm

Hey all... I have assigned a job to create back of the databases of our company, maintain it for 7 days and after 7 days delete the back... I have worked on this and make it up the following query but still confused on its authenticity. Please Check and tell …

Member Avatar for abelLazm
0
148
Member Avatar for Dani

Hey everyone, As many of you know, we've been having serious database issues here on DaniWeb lately, causing the site to go down just about every single day for a few minutes. We finally got the situation resolved thanks to our database sysadmins over at Percona. While James and Cameron …

Member Avatar for Ramin2000
0
303
Member Avatar for manaila

Hi, I have access to files in a remote web server that I use frequently ([B]each used file is removed from the server[/B]). The problem is that the server is accessed by many clients and accessing it is sometimes very slow due to this. So I want to make a …

0
89
Member Avatar for Antrim

Hi. I'm programming an e-commerce/online store using servlets and a MySQL database, and I'm having some problems with the db right now. Hope somebody here smarter than me can give me a hand. There are two kinds of users, both having their own table in the db: customers and admins. …

Member Avatar for Antrim
0
188
Member Avatar for techsavi

I downloaded the php. MySQL and the apache but, I am facing a problem in which the code is being displayed and not the web page. There must be a configuration problem. Any help would be much appreciated.

Member Avatar for sainigks
0
278
Member Avatar for dvidunis

hi i know there is a lib for mysql in c++, but i can't seem to install it properly! someone has a place i can find a tutorial for mysql for: Windows XP, Codeblocks. thx for helping. Checklist for Fast Responses: 1: Search before you post. Does what you're looking …

Member Avatar for Narue
0
271
Member Avatar for dyingatmidnight

I;m trying to move a database created with WAMP from one computer to another. I've exported it as a .sql file and imported it by creating a new database and then importing into it. The problem I'm facing with this approach is that none of the data in the tables …

Member Avatar for dyingatmidnight
0
131
Member Avatar for adamworld

I have code where I am pulling data from my database and it needs to be separated by commas except the last value (that part works) so I can take those values and input into another SQL query. Here is the working code: [CODE]$biz_id = $row_businesses['id']; $query_related = sprintf("SELECT * …

Member Avatar for adamworld
0
107
Member Avatar for XAMPP user

i can't finde my.ini or my.cnf i installed XAMPP and it can't start mysql and the error is: because of port 80 and 3306 and i look up with netstat i don't find any program use these 2 ports and my firwall is off what can i do to start …

Member Avatar for smantscheff
0
69
Member Avatar for VengefulWrath

I'm having trouble with a MySQL INSERT query. I've used this exact code in many places, and even in different pages on the same web server. I feel like I've tried every variation of INSERT query with no luck. Here are a couple that I've tried so far: [CODE] $name …

Member Avatar for VengefulWrath
0
196
Member Avatar for ppetree

I'm not sure where to begin on this... I have a survey engine that supports 7 types of questions and really an unlimited number of entries per question (yes/no being one exception). So, I have 7 tables and each table correspondes to one answer type so I have: response_bool (true/false …

Member Avatar for ppetree
0
150
Member Avatar for mshauny

Hi I'm not an asp .net developer although I have done web development with php and mysql, I'm more of a software developer for desktop and mobile devices. So this is my first big project with ASP .NET. I have a question with the ASPNETDB database, understand that the database …

Member Avatar for crishlay
0
179
Member Avatar for McLaren

Hi, I wrote a qyery: [CODE] SELECT introtext FROM jos_content JOIN jos_sections ON jos_content.sectionid = jos_sections.id WHERE jos_sections.title = 'Redaktores zodis' ORDER BY publish_up, DESC; [/CODE] If I don't use ORDER BY then it works. But with it it throws error: Query : select introtext from jos_content join jos_sections on …

Member Avatar for McLaren
0
83
Member Avatar for Hakoo

Hello Friends, I am working in JME. Now, I have situation in which, I suppose to connect with Database which has been used with PHP. So, How can I access to Mysql? As usual same as to connect mysql with JDBC? Is Mysql and Mysql in WAMP Server different? Please …

Member Avatar for smantscheff
0
199
Member Avatar for ceyesuma

Hello all. The Java Date and time classes are difficult. I think I have to use java.sql.Date which is a sub class of Date but is not a date unless the time is normalized to zero. so I've heard. I would like to work with my studentDOB first by collecting …

0
72
Member Avatar for pitic

Hello, I have the following situation which I can seem to resolve. When I do an "ALTER TABLE" in mysql (v5.5) it hangs in with "waiting for metadata lock". Here is how I got there: - i have an xml which i want to import into a table; i use …

Member Avatar for Alekjenderbo
0
454
Member Avatar for eawade

Hello Guys, I'm having the biggest headache over this issue. I have a system that I designed which uses a standard php login script to a MySQL database. The system has account registration etc. For the past 5 months I've tested multiple accounts and logged in with one primary account …

Member Avatar for smantscheff
0
210
Member Avatar for catcit

Hello! I am interested how can I find the connection string in order to be able to connect to MySQL Server 5.1.50 using OleDbConnection(C#). I used this auto generated string (after adding new data source in Visual Studio): [QUOTE]erver=localhost;User Id=MyID;password=MyPassword;database=MyDatabase[/QUOTE] but I always get the same annoying error saying: [quote]An …

Member Avatar for lolafuertes
0
158
Member Avatar for Cuchara2

I have the function pt_replace: [CODE]function pt_register() { $num_args = func_num_args(); $vars = array(); if ($num_args >= 2) { $method = strtoupper(func_get_arg(0)); if (($method != 'SESSION') && ($method != 'GET') && ($method != 'POST') && ($method != 'SERVER') && ($method != 'COOKIE') && ($method != 'ENV')) { die('The first argument …

Member Avatar for smantscheff
0
142
Member Avatar for nats01282

i have a array which contains then numbers 1,2,3 etc... i want to connect to my mysql database and collect the information from the databse where the id column is = either 1 / 2 / 3 etc... how would i go about this?

Member Avatar for kurtopia
0
75
Member Avatar for Venom Rush

Hi all I'd just like to know what option would be better for my VPS. I'm going to have a number of domains on my VPS and they're all going to be connecting to the same database. Should I create one user that all my domains use to connect to …

Member Avatar for smantscheff
0
91
Member Avatar for Frankey

When i do a select on my db. example. a row with the column 'animal' has the value of 'Horse' select * from table where animal = 'horSe' doens't work?! How to make it work full all variations with capital or non capital?

Member Avatar for mwasif
0
107
Member Avatar for michaelzip

Hi. I have this table named tblProduct, which contains fldProductID, fldProductName, fldValue fldProductName contains its name, and fldValue contains how much is the product cost. Now I am having trouble with updating fldProductID. Here's what my fldProductID look like. [QUOTE][B]fldProductID[/B][INDENT]G01 G02 G03 GZ01 GZ02 TX01 TX02 TX03 TX04[/INDENT][/QUOTE] Its format …

Member Avatar for michaelzip
0
181
Member Avatar for Pro2000

[B]Hello everybody. I've been working on a PHP file that adds a value to a cell in one table in MySQL.[/B] First I thought that the following code might work properly: [CODE] <?php require("DB_Connector.php"); //The file that connects to the MySQL database required mysql_query("update tableName set cellName= cellName + '$The_New_Value' …

Member Avatar for Pro2000
0
261
Member Avatar for caierhui

Exception in thread "AWT-EventQueue-0" javax.persistence.PersistenceException: No Persistence provider for EntityManager named asset_monitoring_systemPU: Provider named oracle.toplink.essentials.PersistenceProvider threw unexpected exception at create EntityManagerFactory: oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException Local Exception Stack: Exception [TOPLINK-30005] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException Exception Description: An exception was thrown while searching for persistence archives with ClassLoader: sun.misc.Launcher$AppClassLoader@11b86e7 …

Member Avatar for caierhui
0
160

The End.