10,946 Topics
 | |
| | Hi all i new to MySQL and currenlty now is trying to do a database and upload it up to PHPMyadmin so that the page im am creating can use it but im facing a big problem here Error SQL query: # # Database structure for database 'database name' # … |
| | hi can anybody help me i need to get the data from db through php script my code is : <?php $con=mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("poll",$con); echo "DB SELECTED<br>"; $result=mysql_query("select question from pollquestions",$con); echo "QUERY EXECUTED<br>"; echo $result ; echo "<br>DATA DISPLAYED<br>"; mysql_close($con); … |
| | I currently run your typical city guide web page and for this entire post i am going to use my artsandculture page with in this page i have sub pages of museums,wine,galleries when a user clicks on museums there is a list of all the museums in html format and … |
| | this is a program that i have, i dont know why it doesnt work. Could some one help me? thank you very much [code] #!c:\Python24\python.exe # Fig. 35.22: fig35_22.py # A program to illustrate Python's database connectivity. import MySQLdb print "Content-type: text/html" print print """ <html xmlns = "http://www.w3.org/1999/xhtml" xml:lang="en" …  |
| | I am looking for a set of buttons (CODE) for making a NAV set for php and mysql, I need next prev top bottom along with edit add delete reset, any one know of a good starting place to look at least? I would like for it to be working … |
| | I need some advice from the pro's :) I am building an application that has data from several places. The structure is all the same but the data is specific to a user. 1 such a feed can consist of 50,000 rows but on average it's more between 500-2000 rows. …  |
| | hi im new to the field of datawarehouse, but im familiar with the database concepts so, can you please give me the guidance or scope of ddatawarehouse for my career, how it is helpful to my career growth, please give me those information. |
| | Hi, I am new for PHP and MySQL, plz guide me for beginning, tnx Samad |
| | yes, i know mysqls query language, but what i need to know is how to connect mysql database with php. i am designing a dynamic website using macromedia dreamweaver 8, mysql and php. how can i go about configuration in order to connect successfully? |
 | I'm trying to create a libmysql.a file for my Dev-C++ project. Parameters for dlltool is as below : [IMG]http://img527.imageshack.us/img527/8911/beforeco4.jpg[/IMG] But the output libmysql.a file is not proper, it doesn't contain anything. [IMG]http://img72.imageshack.us/img72/1707/afterpj1.jpg[/IMG] What am I doing wrong? |
| | hi i am trying to design a dynamic website using php and mysql, how can i make configuration so as to connect successfully? |
| | Hi, I wish I could solve this on my own but I tried searching and googling but nothing doing. Althought worse comes to worse, I can use Perl to do what I want, but I would prefer having a SQL syntax that can handle it. Problem: 3 columns: username, daily … |
| | Please help me on how to join 4 or more tables. I have an idea of joining tables but it is good only for two. I have joined 3 tables before but i worked that in access. For now, im using MySQL and Php. Hoping for your response. Thanks.... |
| | Any recommendations for Barcode software that can be embedded into certain field in MySQL database to generate barcode? Thanks! |
| | I've about given up on my previous problem. I [I]was[/I] beginning to think it'll be easier to do simply by dropping the user, then recreating it with the appropriate privileges next time around. Only, when I tried (as the superuser, no less) to drop the problem user, I got the …  |
| | I am trying to maintain a MySQL db which is required for business usage. I recently ran into a problem where one of our programs would blow up with an SQL error; taking a look at the error message, the program description, and the database in question reveals that the … |
| | Hey all, So here's the deal. I have a list of comments, and each comment gets an automatically generated commentid when it gets added to my mysql table. I just added the functionality to allow users to reply to other ppl's comments ... So I added another field to my … |
| | |
| | Hi I am tring to populate a drop down by selecting another drop down. The first drop dwon populates from eventdata table and i want the second drop down to populate from a race table. I have tried to find the row which contains the same event id as the …  |
| | hey there, i recently installed php5.0.2, apache2.0 and mysql4.1 independently but got them to work together. however i can only access a database when i type: [code]$db = new mysqli('localhost','username','password','database');[/code] and yet when i try: [code]$db = mysql_connect('localhost','username','password');[/code] it does not work, i have uncommented the extension in my php.ini …  |
| | [B]Description:[/B] The problem is with the SQL. In tbl_comment.comment_mreference, I have made this column varchar(60). It can either contain an integer value, or an alphanumeric value. If it's an integer value, an admin would be logged in and it would have inserted there auto_increment member number into tbl_comment.comment_mreference. If it's … |
| | Hi, I have been trying to see how it is possible to get the name of the primary key column from the database by checking the constraint name. I have, up until now been unsuccessful. I have tried the below and I get nothing returned and no errors as well. … |
| | Hi all......another question for ya all :S Does anyone know of a way to monitor a change to a database, Basically I need to write some code for my app that can detect a change i.e. table x has been modified in someway or table y has been created etc? … |
| | can any body helpme on this point! i have the merge module MSDE n i have to deploy website to another PC i dont want that i install mysql there i want to attach just a fileor dll of database to the project set up . so i will not … |
| | Hi , I have got a dump sql file from the remote db server and the concern is that i am new to the design which involves the triggers and all. When i tried to set up a environment for a application to play around locally , the import shows … |
| | hello i have my data stored in different Ms Excell sheets. now I am planning to make a database of the data i have. but i m confused whether to use Postgresql or mySQL for the same. i had plans to import data directly to Ms Access but there is … |
| | Hey guys, im in deep need of help for mysql. Ive been given a few questions most of them answered although theres 3 which are really bringing me down. I was wondering if u could get some help :D Given this schema borrow([U]transactionID[/U], personID*, borrowdate, duedate, returndate) author([U]authorID[/U], firstname, middlename, … |
| | I'm building a large scale application and was wondering the difference between static counts vs dynamic counts. Right now, I'm using dynamic counts. For an example: [code] SELECT *, (SELECT COUNT(1) FROM CarImages WHERE CarImages.carid = Cars.id) as ImageCount, (SELECT COUNT(1) FROM CarBuyers WHERE CarBuyers.carid = Cars.id) as BuyerCount, (SELECT … |
| | Hi, I am currently trying to write some sql that includes a where clause to limit responses but will leave blanks where there is no match. I will include the code so its easier to understand: SELECT DISTINCT teacher.teachername, student.studentname, results.grade FROM teacher INNER JOIN student ON teacher.teachername = student.teachername … |
| | Hey guys. I know this is more of an sql problem but I didnt know where else to put it :S I have an application which stores a UNC path in a mysql database table. However it doest store it correctly for example: I want to store the UNC Path: … |
| | i would like to know how i can save data from the list view to mysql. i have two coluns on the list view and i would like to save all the items that are in the list view. |
| | I have been looking at this code for some time and just can not figure anything wron with it. My Error Message is: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/gwthorn/htpsinc-web.com/York_County/login.php on line 13 I commeted 13 [CODE=php] <?php session_start(); //The fields are censored but …  |
| | hi guys.. i really tried many things to solve this problem.. but i really cant figure this out.. i have 2 tables actually its 3 tables but the other is just for the user's account so here it is: [B] employee table [/B] ins_ID -> pk emp_ID* -> unique key … |
| | This is my current database structure [php] create table tournament ( tid int(5) not null auto_increment, period varchar(20) not null, Primary key (tid)); create table game ( gid int(6) not null auto_increment, tid int(5) not null references tournament(tid), Primary key(gid)); create table results ( gid int(6) not null references game(gid), … |
| | How would you execute MySql commands found in a text file? It's really beginning to bug me!  |
| | I am new to PHP. I am trying to connect mysql with PHP with mysql_connect but i m getting "A link to the server could not be established" I have used ODBC 3.51 driver for odbc and made connections with odbc with odbc_connect but i don't know how to connect … |
 | Hi there, I'm trying to screen some programmers I'm looking to potentially hire & I have a list of questions a previous programming consultant drew up, but I don't know what to do with them b/c he did the screening b4. Can someone please help me determine if I place … |
| | Any one doing sever programming with MySQL please let me know , all problems that can occur with connectivity of MySQL with SJSAS 9. There is a connectivty setup in the Admin Console. It is a bit confusing with duplicate Capital and small letter entries. Can we use the XADataSource … |
| | Hi , I've been working on comparison query with PHP and MySql 5.0 yet not getting anywhere with it. I'm trying to perform a search ( query ) I have several tables within the same database that contain same fields yet hold different data eg Table 1 id |Product | … |
| | Hello, I have two databases on my website lebphoto.com with the same tables. One with a 1665 members and the other with 33 members, I want to merge them together. is there a way other than typing each records by myself or ask the members to register again? Thank you |
| | I hope someone can helkp me. This is driving me nuts. I have the following code that produces this error " [B]Exception Details: [/B]System.Data.SqlClient.SqlException: Login failed for user 'selfmadeBrowser'." The entire code is as follows (please note, this script came DIRECTLY off of [URL]http://www.expertrating.com/courseware/DotNetCourse/DotNet-ASP.Net-4-3.asp[/URL], I also am able to cnnect …  |
| | I know this is pretty dumb question but I just wanted to ask because I am not sure if I can figure it out by myself. :( So here is the deal. I have a mysql database called "appinfo" there there is a table called "appdis" Now in that table …  |
| | Hello all, I have been using mysql_fetch_array to read data from a query to a php array so i can then use it on my webpage. Everything was going fine until now... I cant see the problem with my code, but it keeps calling the or die() error handler when … |
| | Hello all, Is there any algorithm to convert a python tuple to [URL="http://www.daniweb.com/techtalkforums/thread74502.html#"]MySql query[/URL]. Ex: [B] ('*','name','sliver')[/B] should convert to [B] select [Pri_Key] from [All Tables] where 'name' = 'sliver';[/B] I have been able to do so ... but my [URL="http://www.daniweb.com/techtalkforums/thread74502.html#"]algorithm[/URL] looks very ugly and have to process everything bit … |
| | Hi, How safe is to allow users to submit the entries with single or doube quotations to the database? and wondering is there any free site or service to check vunerabilities of the site? Hope to see it in daniweb. Thanks!  |
| | Hey, first poster here: I'm not actually running on MySQL (I'm using MS), but my question is more of a design issue. The model I've been using is perfect for maintaining relationships between data logging devices I have in the field, and so-so in keeping an aggregate of that data … |
| | Please help - Why can I get this sql to work? SELECT Count(dsd.price) Total , dsd.reporting_date , dsd.reporting_state_type , dsd.requisition_id Order_id , round((sum(decode(dsd.reporting_state_type,'SHIPMENT',dsd.price, 0)) - sum(decode(dsd.reporting_state_type,'RETURN_RECEIPT',dsd.price, 0))) Net_Orders from dw_sales_data dsd, dw_programs dp where dsd.program_id = dp.program_id and dsd.program_id = '4387300' group by dsd.reporting_date, Order_id, dsd.reporting_state_type, Net_Orders_Com, Net_Orders_Ret, Net_Orders; |
| | :sad: I am trying to connect to a mysql database. ideally, i'd like it dumped into a grid view so i can edit it... no matter how i try it, i get this error- [B]Compiler Error Message: [/B]BC30002: Type 'ODBCConnection' is not defined. here is the code for this page: …  |
| | How can I maximise the command line window of this progamme as click and drag does not work? |
| | [COLOR=#000000]Hi ! I have a problem in connecting JSP pages with My SQL database using JDBC connector. I m using:[/COLOR] [COLOR=#000000] [/COLOR] [LIST] [*][COLOR=#000000]For TOMCAT -- apache-tomcat-5.5.23[/COLOR] [*][COLOR=#000000]For JRE -- Java EE 5 SDK[/COLOR] [*][COLOR=#000000]For database -- MySQL 5.0.37[/COLOR] [*][COLOR=#000000]For JDBC -- mysql-connector-java-3.0.17[/COLOR][/LIST][COLOR=#000000] [/COLOR] [COLOR=#000000]JSP pages other than database working … |
The End.