11,093 Topics
 | |
| | I'm new to SQL and was wondering how exactly do i use the join in a query. i have 3 tables, with the primary keys from the first two tables acting as keys for the third table. I have to get information from the first and third tables but need … |
| | Howdy All I know next to nothing about PHP, just very basic stuff. I have a PHP Mysql driven web site that I would like to change the look of. I am looking for a program that I can point at the PHP file and will show me the HTML … |
| | Hello, I am very new to the world of Linux. Could someone tell me if I were to setup one machine with Linux, Apache, MySQL and PHP and dual boot it with Windows 2000 Professional, what would the ideal hardware requirements be. Also, what is the ideal size of a …  |
| | Well first some background, this hasn't happened before but last night I had some trouble installing a shoutbox mod so I undid all the steps I had performed I have also installed a search engine friendly mod successfuly which makes php links html links even though I know ipb supposedly … |
| | hey I've been getting this error: [COLOR=Red]Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource [/COLOR] This is what it said that is causing the problem: [B]$stafflist=mysql_query("SELECT id,name,sn,email,title FROM staff WHERE man='Yes' ORDER BY id");[/B] Can you please tell me what is worng ASAP. Thank you |
| | Alright, PHP Beginner here. I was just wondering, does anybody know of any good PHP books out there and if so, can you recommend one to me that has both help with PHP and MySQL? I know some parts of PHP, such as the opening and closing tags (<?php and … |
| | Hi all, I own a vbulletin forum, from what i hear the archive that comes withvbulletin isn't great when it comes to SEO. What i have done is created a second archive for my forum that follows SEO procedures. I could have created the whole thing dynamically but i decided …  |
| | Hi, I have come up with a project to design a web-based Complaints and Suggestion System for a local estate agents in my area and I am going to use PHP with a MySQL database and at the moment I am doing all my Process and Data Analysis before moving … |
| | HI all (Battled with the WORD – (probably wrong in these terms)) I have a field in an access database (DateInserted) and want to get a (DateID) field out of it. To get the DateID field I use – [B]Day(DateInserted)&Month(DateInserted)&Year(DateInserted)[/B] - (Unique key for date outputs as 21102004) my problem … |
 | I am working on a project which involves a server/client model running over a network. The server is written in Java, and the client is a C++ addition to an existing product (which is written in VB and C/C++). I chose to write my section in Java simply because I … |
| | Hi, I've run into absolute brickwall and am really desprate for your help please. I have a MYSQL Database with two Tables called user_comment and the second user_table. When a user register with the site, their details are kept in the user_table. the second table user_comment is so that users … |
| | [B]How many clients can access a PHP script at a time from a MySQL server?[/B] thanks in detail. |
| | Hi All I' am a new pie in php I have finished with installing php5 and mysql and the apache server when ever I have tried to run php nuke portal I got this sample of errors Notice: Undefined variable: querystring in h:\apache group\Apache\htdocs\html\mainfile.php on line 28 Notice: Undefined variable: … |
| | Hi, im new to the forums and i hope you wont mind me launching in with a big question! Ii am currently prototyping a multimedia information system which holds wakeboarding images and videos, along with a comprehensive set of meta-data about the multimedia data. Users can query the metadata in … |
| | I have a portal site [url]www.localmiamiguide.com[/url] that needs to be transfered to mysql. Anyone have any idea how much that would run me? :cry: Please advise. Jcolome [QUOTE=fsn812]I have worked on large scale projects using Oracle, medium sized projects using MySQL, and some small projects using Access. All have worked …  |
| | Hi all, I have a question. [B]How many clients can access a PHP script at a time?[/B] Suppose, I have a database site written in PHP. I have used MySQL. Then How many clients can access that database through PHP as a midlware?? Can anybody answer this or help or … |
| | Hi all, This is my first post and first attempt at PHP so sorry if this sounds daft. I'm about a fifth of the way through the php bible and a quarter through php/mysql for dummies, so it can only get better. Anyway I'm getting this error when I try … |
| | Hi, I'm trying to connect to a database using MySQL. Very new at this. I already have an existing table consisting of 2 rows created using phpMyAdmin. The problem (not exactly) I'm facing is when i insert a new row, it seems to insert after the 2nd row, not at … |
| | I have created a small application in PHP and MySQL. Could someone tell me what I need to do to add the appln. on an Apache Web server? Is there anything I need to take care of in the application to be a web app? |
 | :cry: I downloaded MySQL 4.0 then clicked on Setup file but ... (oops!)The followin' message appear [IMG]http://img94.exs.cx/img94/8826/error2.jpg[/IMG] Just tell me how could i solve this pro??? Thank u a lot!!! |
| | hi, i am thinking of designing a customised GUI frontend for mysql. i would like to know which of the programming languages Perl or Python can be used. my preference would ease of use and cross platform compatibility. i have already used off the shelf GUI's for mysql and i … |
| | CODE HERE A FOLOWS: namespace ODBC { #include <stdio.h> #include <stdlib.h> #include <tchar.h> #include <windows.h> #include <sql.h> #include <sqlext.h> #include <odbcinst.h> //-- #pragma comment(lib,"odbc32.lib") #pragma comment(lib,"odbcbcp.lib") #pragma comment(lib,"OdbcCP32.Lib") //-- #define IS_SQL_ERR !IS_SQL_OK #define IS_SQL_OK(res) (res==SQL_SUCCESS_WITH_INFO || res==SQL_SUCCESS) #define SAFE_STR(str) ((str==NULL) ? _T("") : str) //-- enum sqlDataTypes { sqlDataTypeUnknown = … |
| | I'm ujsing php 4.0.3 with apache web server. generally i use mysql. but i have to use mssql for another reason. so i am using ODBC for this purpose. but the "odbc_fetch_array()" is not work. says, undefined function. but as far i know, this function should work with this version … |
| | I am a second year IT student who is working on a project using PHP(frontend) and MySQL(backend). I am brand new to these softwares which are not being touch in class. I have 2 questions: 1. How do I populate fields (textboxes) in a html form from a selected item … |
| | |
 | Hey all im trying to start my own webserver with Mail server Ftp sever mySQL PHP CGI webmin (i think thats what its called that or usermin :rolleyes: ) Counter-Strike Dedicated server (with AMX MOD) BUT! im a newbie to linux if any one PLZ :cheesy: help me or direct …  |
| | Hi .. i was trying to install MySQL apache server and php4. i did instal MySQL and Apache and they did work fine on.. but php didnt get install properly, i installed MySQL and Apache on D. and Php in C drive its a same hard disk though, do u … |
| | [FONT=Arial]arial[/FONT][SIZE=4]4[/SIZE] :rolleyes: I receive the following message: Error No.1064. " You have an error in your SQL Syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and chrStatus'= 1' at line 1. Can somebody please help me ? |
| | A project that I've been working on (and getting help on [URL=http://www.daniweb.com/techtalkforums/thread10421.html]here[/URL]) is just about complete, but I've had to develop it locally on MySQL 4.1 for it's support of nested queries - I'm [B]rubbish[/B] with joined queries. However, the project is going to be running on my host, who … |
| | I only started last week with php mysql(be nice) I have a MySQL db where a user can enter contact info, usually stuff: FirstName LastName Address City State Zip I return this info to a php page which shows all info in db. $result = mysql_query("SELECT * FROM contacts"); I … |
| | I've at least *seen* PHP code before, and have modified my own phpBB forum moderately. However, I've been set a project to build a web interface for recording skittles scores (like 10-pin bowling, but with 9 pins!!), and producing a nice ordered table with player names, number of games played, … |
| | I need a little help connecting to a database in Java. The example in the book I have uses the following: [code] static final String JDBC_DRIVER = "com.ibm.db2j.jdbc.DB2jDriver"; static final String DATABASE_URL = "jdbc:db2j:books"; [/code] It goes on to use it: [code] System.setProperty("db2j.system.home", "C:/mysql"); Class.forName(JDBC_DRIVER); connect = DriverManager.getConnection(DATABASE_URL); [/code] First … |
| | I am new to php and i want to know if i can use microsoft access as the db??? instead of mysql??? please help?? :-|  |
| | |
| | hey ya , i get some problems and hope u can help me to solve it first, i'm using Window XP , Laptop - service pack1 , uhm .... i tried to install mySQL on my computer but it didnt work ... some1 can help me to install MySQL , …  |
| | Thank You for taking your time to read this. Well, the subject kind of tells it all. I have built an webshop, but would like the order to be place in an text file insted of mysql. This text file has to be in an csv format in order to …  |
| | I am trying to connecto to mysql database using RedHat 9 but always get a wonderful error message when I try to compile this code: Context ctx = new InitialContext( ); //Error is thrown here if(ctx == null ) throw new Exception("Boom - No Context"); DataSource ds = (DataSource)ctx.lookup( "java:comp/env/jdbc/xsmsDB" …  |
| | Hi, I have apache, php, phpmyadmin, and mysql in my computer. I could connect to mysql and manipulate database well before. But for an unknown reason, I can't do it now. Each time when I tried to do this, it gave an error message as "Can't create TCP/IP socket (10091)". … |
| | I'm trying to get started in ASP.NET, but I just don't understand the errors being returned to me. I'm trying to connect to my MySQL database. I have followed several examples from books and the internet with no success. Could someone look at my code and see if I'm screwing … |
 | I am trying to create an INNODB table with a foreign key, and it doesnt seem to be working. Can someone give me an example on how to use a foreign key. Here is an example of what i have: FOREIGN KEY (client_id) REFERENCES CLIENT (client_id) This line is preventing … |
| | Hello I have just bought a book on php, MySQL and Apache server which came with an installation disk. I have installed all three on my laptop computer running MS XP Professional. All three seem to work ok independantly but when I try to run any code examples through IT … |
| | I have used the following code on one of my pages to place the variables in the URL for the next page: [php] <?php $db = mysql_connect("HOST","USERNAME","PASSWORD"); mysql_select_db("DBNAME",$db); $result = mysql_query("SELECT * FROM TABLE_NAME WHERE FIELD_NAME=??",$db); while ($myrow = mysql_fetch_row($result)) ( printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[7], $mysql[8], … |
| | Hello, I was wondering, Do I really need to download MySQL and Apache to run PHP-Nuke? |
| | Hi there, just like everyone else i have this annoying torjan downloader.purity problem that replaces itself everytime i go on the internet the first time after re-booting... an explorer screen pops up and then avg kicks in, with the warning of the virus and a browse install popup screen.... and …  |
| | |
| | Can anybody help me with *any* information on MMOG (Massive Multiplayer Online Gaming) engine development ? I'm trying to develop simple (as a start point) MMOG engine using PHP + MySQL (or PostgreeSQL). Main questions are: 0. Is it necessary to put game logic on DB triggers and stored procedures … |
| | I am extremely new to MySQL and web databse programming. I am runnning an Invision Board forum and have had numerous problems when installing mods (I know, install at my own risk, blah blah blah). My question is this: I am restoring the SQL database (I did make a backup; … |
| | I am having difficulty uploading text files to mysql database through phpmyadmin. Here is the feedback from the hosting company: The problem is in the inappropriate input file format (the txt file) - there are spaces before and after the comas. To solve the problem - strip the spaces arround … |
| | does anyone know where i can find a complete list of mysql commands. Im in the proccess of writing a live mysql database interaction for web use. and right now i need to store all mysql commands to an array and have the php script read the array and modify … |
| | Having problems with a site that is built in php and mysql. The goal it for a page to list the name, city and phone of a service from a state, with no hyperlinks and this is currently setup and working correctly. Then I wanted to add a bonus if … |
The End.