11,093 Topics
 | |
| | is there any premade customize-able online database softeware? Kinda like phpBB or phpnuke is for forum stuff? I just need something where I can display items from a database, and sort/search able and item desctiptions w/ pics? Any of that possible or that more of a make it your self? … |
| | Hiya my application is an online music video library where users can download music to their web browsers, mobile phones and pdas. right now my application downloads the track and plays the music track from the browser, I just want it to do the same on mobile phnes and pdas … |
| | I am developing a system where: - Users can go to a website, sign up for classes, and pay for classes - Or they can come to the store and sign up in person I was wondering if someone could walk me through the steps from the beginning of making … |
| | Hi, This is Abhishek. I am a newbie in PHP and we have to develop an Inventory management application. We have a MySQL database structure which looks like this (dissimilar) VORTEX Table 1: hardware ========================================== hwid | total | manufacturer | hardware type | model no | specs | remarks| … |
| | What i am trying to do is to extract data from mysql table into a .CSV file and then after editing upload it again to update my DB. I am planning on using php but i at the time dont know which command will convert mysql table into .CSV and … |
 | ** CAN A MYSQLD EXPERT PLEASE HELP ME OUT ON THIS ONE ** I am having a problem with my MySQLd on db2.daniweb.com going through periods of 1-2 minutes every couple of hours where it refuses connections from Apache on web.daniweb.com. The error being thrown back is: mysql_pconnect(): Can't connect …  |
| | My ISP has set up only one DB in MySQL, for an electronics store. I want to have a bulletin board for books, but My ISP apparently does not know how to add a second db [i]and[/i]and arrange for separate permissions for each site. Can someone tell me where I … |
| | Hi there, I keep getting the following error message when i run this script: [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/httpd/vhosts/tellproperties.com/httpdocs/testing/register.php[/B] on line [B]42[/B] [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/httpd/vhosts/tellproperties.com/httpdocs/testing/register.php[/B] on line [B]43[/B] No Database Selected [CODE] … |
| | tell me how to generate a mysql database at the end system and how it is related to web server i want to ask that what is the extension of the mysyl file so that it can be uploaded and where do i create this |
| | Hello, I need help with this freaken' MySQL or whatever you call it thing. When ever I go to my site it says 'PHP-NUKE, and then the MySQL error' This is really starting to piss me off so can you guys plz help? I will be more than happy to … |
| | |
| | Hi all. Is there anyone out there who can explain to me on advanced level the cons of using a non persistent connection. I currently use a non persistent connection on my site because i run php as a wrapper. I like the piece of mind of having apache run … |
| | I am a newbie web designer and I have downloaded MySQL, php4 and uploaded phpBB2 to my server to setup my forum. and I have looked at countless tutorials and it's really getting stressful. Is there any way that you could guide me through the process using AIM or yahooIM? … |
 | I've recnetly finished building my CSS based website based on Alcohol, whereby I've links like Beer, Wine, Whisky and Spirit. I now wish to have "Cocktail" link in it, however, in this particular page, I wish to make a use of MySQL along with PHP. Although, I've basic knowledge of … |
| | [COLOR=#000000]Hi every one[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I have 3 tables[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]department department_id, name, description[/COLOR] [COLOR=#000000]category category_id, name, description[/COLOR] [COLOR=#000000]product product_id, name, description[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]category belong to more then one department[/COLOR] [COLOR=#000000]product belong to more then one category also more then one department[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I managed to show … |
| | help please........... i need u're recomendation of site to visit i need to learn (freely) the query (SQL SERVER 2000) thank's:confused: |
 | Hi, I have to connect sometimes to MSSQL and sometimes to MySql depending on the customer. I am experimenting with the php adodb library that claims to make database connection possible to either vendor using the same syntax. First the background at home I have: Rig1: windows XP professional PHP … |
| | i have two server A and B in server A i install forum and mySQL server !!! :D now i want server can connect to A mySQL server. But i want only server B's IP can connect to server A on my define port !!! how to config mySQL server … |
| | ok so I have two tables, and I believe I need an outer join lets say these are them: [code] CREATE TABLE t1 ( xid INT PRIMARY, data1 VARCHAR(50) ); CREATE TABLE t2 ( xid INT PRIMARY, data2 VARCHAR(50) ); [/code] so here is an explanation of the tables t1.xid … |
| | Good Evening, I currently have an issue regarding a query I wish to perform against a particular table in my database, any help would be much apprieciated Background: I am designing a website service which operates with the use of credits, if they pay a fee they are given a … |
| | can anyone help? thanks! <?php include_once "mysql_connect.php"; mysql_connection($dbc); $select = "SELECT DISTINCT D.Title, D.FirstName, D.MiddleI, D.LastName, D.Suffix, D.Address1, D.Address2, D.City, D.State, D.Zip FROM Donor D, Pre_award P, sch_donor S WHERE Approved = 'y' AND S.Did = D.Did AND S.Scholarship_id = P.Scholarship_id"; $export = mysql_query($select); $fields = mysql_num_fields($export); for ($i = … |
| | Hiya Im designing an online music video library. Ive already done my registration and login scripts to register a new user. I have decided that to store the mp3s im gonna have a file system instead of storing them directly in the database. Can someone please direct me on How … |
| | Hiya ive finally completed the login and registration forms for my online music video library site. I just want to know what would be the best way to store the mp3 files in the database and how i would go on about it so the user can view the tracks … |
| | IWhat exactly is the "unsigned" use for in sql and when should i consider using it? |
| | i am trying to connect java program to mysql databse. bascically i am aphp programmer. now i want to lear j2ee so i was trying to connect to mysql database.i am getting the error as not able to load the drive thi sis my code import java.sql.*; public class tc …  |
| | Hi I'm new here so be gentle! ;) I have a php form which poppulates an HTML <Select> tag with a list of approx 2500 items which consist of an id; a code and a name. The items come from a MySql database To make it easier to use I … |
| | I've constructed a photo gallery with a dynamic CMS backend that allows the content providers to upload, delete, etc images. All images are stored as reformated jpeg files (processed by the GDLib on upload) and the relevant metadata is stored in a table called `gallery`. References are made by an … |
| | I retrieved data from database, output to a form thru loop after that iwant to change something and then i will send it back to the data base for update here is the output datails so that you will the idea what iwantl. [URL=http://www.nwafh.med.sa/eng/php/progs/edit_book_test.php]http://www.nwafh.med.sa/eng/php/progs/edit_book_test.php[/URL] Thank you in advance Roland |
| | I have two tables: tb1: Name Email Location ----------------------------------- user1 email1 address1 user2 email2 address2 user3 email3 address3 ----------------------------------- tb2: Group Email ----------------------------------- group1 email1,email2 group2 email4 group3 email5,email6 ----------------------------------- Now I want to join these two tables, to display the usernames who are listed in table 2, with keyword …  |
| | [b]PREFACE:[/b] My name is Al and I'm a loving moron who locked himself out of MySql. Alright, Let's rock. I don't exactly remember changing my password, but since I was in the Terminal using commands like [b]-u password[/b], I think I might have done it on accident. So... I need …  |
| | Hi all i m currently having mysql5.0.18 installed on linux box and i want to downgrade it to some of 4.1.xx. at that same time i want to retrive data also so can any helpme with the same. plz provide some soltion as i dont know how to do that … |
| | Good day to all members! Anybody could help me or could give me a php code. What I need is I want to put link on each data that I had retrieved through array from mySQL database so that when I'm going to click each of them it will display … |
| | |
| | I am building an online music video library where u can strean the media to ur browser mobile phne and pda devices. I am using PHP for the middle HTML for the front end and MYsql for the backend. I want to have database with the music files residing on … |
| | I am creating a database and would like to create a unique primary key that is randomly generated. Does MySQL have any feature that will do this? I don't want to use an auto-increment, because when I have a page like "whatever.php?id=xxx", I don't want a user to be able … |
| | Hi all, Ok, first I'll let you know that I am very new to databases and scripting languages, so my questions are very elementary. I have read a book on the SQL language as well as a book on PHP basics, but I have no idea where to get started. … |
| | Hi, I am with a web host using mysql 4.0 and phpmyadmin 2.5.5 p\1 I am trying to get my html user form on my website to insert into mysql database. I keep getting: Error! Could not select the database: Access denied for user: 'match.match.com@10.80.0.%' to database 'mydb' Can you … |
| | [code] CREATE TABLE my_feature ( pk_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, member_id INT(8) UNSIGNED NOT NULL, time_added DATETIME NOT NULL, personal_questions BOOL NULL, hits INTEGER UNSIGNED NULL, PRIMARY KEY (pk_id)); [/code] When I put this into the MySQL Query Browser I get this error: You have an error in your … |
| | Hello. I have the following errors: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/winnie/public_html/pqQuiz/lib/templates.php on line 13 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/winnie/public_html/pqQuiz/lib/templates.php on line 13 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in … |
| | Hi, While I'm not entirely new with SQL, I am not by any means highly knowledgable. I'm attempting to write a SQL statement to do the following, and having no luck: Assumptions: There is only one table, with several fields of metadata including the following. 1 field (integer) that indicates … |
| | My MySQL query_cache_size is currently set to 50M and even at that setting I am getting a decent amount of qcache_lowmem_prunes. Queries are being removed from the cache to make room for new ones. My question is whether the queries being removed are based on time elapsed since they were … |
| | I am using MySQL 4 and trying to cache my queries per this tutorial: [url="http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html"]http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html[/url] Right now, my query_cache_size is set to 0. I would like to set both the query_cache_size and query_cache_limit parameters. However, I'm receiving the following error message: [code]mysql > ERROR 1227: Access denied. You need the … |
| | I am writing from the ground up a feature for this one company in Georgia while I am in school. It is running on mysql, but I have encountered a problem (actually a few problems, which led to this problem). I use auto increment for the unique identifiers for each … |
| | Hi I am so Desperate! I use a server internic.ca which host my website and offers me MySQL with phpMyAdmin 2.5.5-p\1 I seem to be able to make the table fine beyond that I cannot understand… How do I use this phpMyAdmin 2.5.5-p\1 I am trying to setup a Membership … |
| | Hello!! Please guide me. How do I install Apache, MySQL, PHP on Linux? Thanks Laxy [URL=http://www.funspot.com]www.funspot.com[/URL] |
| | I'm looking for a way to compare 2 lists of keywords and return the number of matches. I'm currently working with PHP and MySQL, but I'm not sure how to go about this task. Any suggestions are appreciated. Thanks, J_ |
| | Hello, I have this query: SELECT players.id AS id, players.name AS name, players.surname AS surname, players.email AS email, calendar.start AS beginning, calendar.end AS finnish, calendar.name AS title, calendar.event AS description, calendar.id AS eventid FROM `calendar` , `attendance` , `players` WHERE (attendance.present = "yes" AND calendar.start BETWEEN "1141060879" AND "1141665679" AND … |
| | I'm running a query through XML from the local database which uses PHPMyAdmin to a remote one which uses MSSQL. Unfortunately I have no way of checking syntax against MSSQL so all I know is that this works in PHPMyAdmin. So the query gets as far as running, but is … |
| | Hi everyone. I've only really just started using php and I've been trying to use it in conjunction with mysql. I keep getting an error though when trying to access the result set returned by performing a query on the database. I've performed queries on the database outwith php, and … |
| | so I have somewhere between 15-300 images in a folder and I want to know which would faster: loading all the image (file) names into an array and then randomly picking 3 distinct files using $file = opendir($folder_name) -- OR -- loading all the image file names into the mysql … |
The End.