10,940 Topics
 | |
| | 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 … |
The End.