10,946 Topics
 | |
| | Hey folks, I need your help. I stuck with my Database project. I have five tables on the database: These are Room, Guest, Booking, Employee and Admin Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address,…) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, user_name, password) Employee …  |
| | I've been impressed by MySQL's ability to run as a database on a server with clients connecting using a client-server or web based architecture. I'm now wondering if a version of MySQL can be cost effectively licenced to run with application software (which might traditionally have used a Jet database) … |
| | hi, please anyone help me with this.I have a database 'hbm' which contain a table called hitted having 2 columns(id,hit). I inserted a record with id=1. Now i need to query this database. define("hit_TBL","hitted"); "select hit from" . hit_TBL. " where id=1 and LIMIT=1"; throws error. request members to help … |
| | I'm having trouble figuring out how to query multiple tables. (Note: I've greatly simplified the tables for clarity purposes) I have 2 tables: Invites and Purchases The invites table has the following fields: email & invitee The purchases table has the following fields: useremail & product Invites tables +------------------+----------------------+ | …  |
| | I am working on a site for a school project and all I have access to is php and html. I would like to be able to run some MySQL - but I am unable to find a place that will remotly host it for me. Does any one know … |
| | Hi all, I am learning to write with PHP and am stuck and need some wise souls help. In a nutshell I need to be able to take grab a DB coulmn status and then count how many times it gets updated and output that number to a file and … |
| | Hi all, I am learning to write with PHP and am stuck and need some wise souls help. In a nutshell I need to be able to take grab a DB coulmn status and then count how many times it gets updated and output that number to a file and … |
 | |
| | Ok, heres an odd situation. I've been using a code for a few years to basically add edit, and delte content from my site. I have taken this bit of code and once again am using it to add some content. ARGH! I can't figure this out for the life … |
| | I am very new to php & mysql. i have made a webste with a database in mysql. i have developed a search engine to search my database. I just discovered a weakness in my current search engine. It won't show results if I don't have an exact match or … |
| | how is access used versus mySQL? i know access isnt much of a web database but what are its advantages/disadvantages over mysql?  |
| | could someone provide me with the sql for the following code: Dim i As Integer Dim countvar As Integer If Number_of_Panels.Text > 1 And Number_of_Panels.Text < 27 Then For i = 1 To Number_of_Panels.Text countvar = (countvar + 1) Project_Number.SetFocus MsgBox Project_Number.Text & countvar Number_of_Panels.SetFocus Next i Else End If …  |
| | Okay, not new to MySQL, or PHP, but I'm really lost on this one. I have a query (simple one really) that is supposed to return the requested values from a database. I've tested the query with MySQL direct and it works fine, but when used via the web interface, … |
| | I am using mysql 4.0 server. But in the database I can not use special characters (i.e. latin characters, root sign etc.) or can not use superscript or subscript. In the front end I am using VB. When I am copying the text from Ms word and pasting it the … |
| | hi folks, i am creating a database in access 97. I have designed 5 different forms which are all linked to the same table. the forms share some of the same fields but not all, except for the admin form which sees them all. my forms are made up of … |
| | how would you check if a value exists in a database? i want to use this for ip blocking so it will check if your ip is on the list and if so, it will not let you access a specfic page. |
| | There is only so much one can do with a database. The basic requirment is to add delete search display and go somewhere with the information. The better DB have images. I can write all the wants that a web master has but there is no way (at present) I … |
| | i'm having a problem with my SQL query. i'm trying to create another column with values based on the values of the other columns and call it sTitle. Every time i try to execute my SQL statement it brings back this error: Illegal mix of collations for operation 'concat' Error … |
| | I have the following code: [php]$rebate_query = tep_db_query("select * from " . TABLE_REBATES . " where product_id = " . (int)$HTTP_GET_VARS['products_id']); $rebate_information = tep_db_fetch_array($rebate_query);[/php] This should return only 1 row of data I have this code - " [php]$rebate = $rebate_information['rebate_amount'];[/php] " for extracting the rebate amount. For the life … |
| | Dear friends! We are asking your opinion on alpha-version of our MySQL Client Some people ask what is the point of yet another My SQL client (there are dozens of them). We see our niche as low cost solution-a set of several tools with everything a web-master might need. It … |
| | Dani has given me permission to post this here I co-developed a flash poll sytem that uses php/mysql for the anyone to download IF you go to my site: [url]http://www.sportsrant.com[/url] ou can see it in action on the right side or [url]http://www.uoptoday.com[/url], you can see it in action on the … |
| | Helo everyone, I have installed a php directory script similar to this at: [[url]http://www.dentalarticles.com/directory/add_url.php?c=303][/url] and I wonder if someone could possible tell me how to add 3 additional fields to the submission form. Is this something that could be done by someone with almost zero programming knowledge? !!! Thanks all. |
| | I have a web portal from a buddy's website using PHPNuke that I administer. The site has user accounts for the site itself and for the forums. I recently purchaced my own domain and am currently designing it the same way using PHPNuke. Is there any way I can transfer … |
| | I'm trying to figure out if this is possible, and cannot find any information about it. Specifically what I want to do, for example, is allow a web-based user to search for a particular value in one field the first time around. If that returns an overwhelming number of results, … |
| | hi im new to php/mysql i have developed a code in asp and converted it to php with asp2php programme. the original solution asp/sqlserver iis works fine..the new solution will be a iis php mysql. mysql server works fine iis works fine however the php wont let me connect to … |
| | This may sound stupid but I am very new to MySQL. I am thinking of using this for a database driven site on a Linux server with a new, (hopefully more reliable) host. My current host can supply a MySQL database for £25.00 per year, (seems too cheap) my proposed … |
 | I want to install my own php script into my server (shared) but the moment I test my page, the following errors occurs. [CODE]Warning: main(): Unable to access ../includes/global.php in /home/linkme2u/public_html/paidmail/site/index.php on line 3 Warning: main(../includes/global.php): failed to open stream: Permission denied in /home/linkme2u/public_html/paidmail/site/index.php on line 3 Warning: main(): Unable … |
| | I'm getting ready to make a database of my baseball cards and wanted to know how would I go about making a searchable database of my cards? |
| | I know how to do MySQL connections, queries etc. with PHP but I want to do some MySQL stuff with an offline language - I know C++, VB and Java - but I'm not sure which one to do it with. Is it even possible? Can someone please recommend one … |
 | Hi, I have a small problem I have a flash game SWF file not the fla and it sends and recieves values from a PHP file send - update and recieve is INIT Great except the person who gave me the SWF and PHP file did not tell me how … |
| | Hi. I use Win2k PHP 4.3.1 MySql 4.1.9 [B]Trying to install phpBB 2.0.11[/B] My phpBB files are in C:\BB There I added the directory ..\BB\forum PROBLEM: I can't get past the html "start install" page. On that page - In Admin Configuration section: [B]a)[/B] Where it asks for ADMIN info; … |
| | i can't connect to mysql. the error is [code] Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Documents and Settings\... [/code] im using the script here in the php tutorial: [code] $Host = "mysqllocation"; //location of mySQL on server $User = "username"; … |
| | hi, in order to install my php gallery, i have to "Run the photos.sql script in your MySQL database" what does this mean? i know i have mysql, as i have a phpBB2 forum running. but how do i do this? thanks |
| | hi can anybody please help me with this, i had install a php script but i got some problem with mysql_connect the below is the error message: Warning: mysql_connect(): Access denied for user: 'maximus_dbwebnews@localhost' (Using password: YES) in /home/maximus/public_html/webnews/WebNews/admin/func/db.inc.php on line 25 Database error: Link-ID == false, pconnect failed MySQL … |
| | What I'm attempting is to have database driven links on my page. It is all ok except one thing and that is this error when my page comes up in the browser. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/admin/public_html/index.php on line 114 Here is … |
| | ok i am getting the error that my fields i want to full text search are not in my index but in phpmyadmin it lists them in my index! i do not understand y it is doing this:( also does it automatically order results by relevance and how i change … |
| | I'm new in script installation and I am trying to install several free scripts in my testing server. I always have problem running install.php. The moment I enter my mySQL information, it always returned blank.. Please try to visit this page and enter the following MySQL server information if you … |
| | Hello again =) Now i have a question about vbulletin and its usergroup manager and some mysql questions that goes with it. We have a clan site and vbulletin forum. I have created a specific usergroup for our clan members. Now i want to display those users on a none … |
 | I have recently installed php nuke into my web host by extracting all contents of "html" folder into my main directory. I went to "http://www.myhost.com/admin.php" to find this error message: [code] Warning: main(language/lang-.php): failed to open stream: No such file or directory in /home/killtpfn/public_html/mainfile.php on line 183 Warning: main(): Failed … |
| | Hi, i am using mysql and php. i was wondering if anyone can help me. when customers login a form with thier details which are stored in the mysql database are displayed. when they change a detail such as their address and click on the update button their details are … |
| | I am tring to complete a project for university using msql, php, apache and phpmyadmin(local) The main basis for this project is being able to transfer data to and from a mysql database. Having never used the languages required I am having trouble figuring out what I am doing wrong. … |
| | [SIZE=3]PHP Saving[/SIZE] I just bought a book to learn PHP/My SQL. It does not thoroughly explain how to install PHP an SQL on my server( However I did use the accompanying cd to start download of files). My problem is , after I write source code in notepad and save … |
| | Hi Peeps, I am new to this forum, I am trying to create a weblog to allow users who are registered in a database I create in Access to create a blog entry which will be displayed on the screen to every one. I have created the database i Access … |
| | Hi, I am creating a database driven website - and I have the content stored in a mysql database at the moment. At the moment each page starts with the script: $connect = mysql_connect('$host', '$username', '$password'); $select = mysql_select_db('$database', $connect); This works fine, but if Iv been playing around with … |
| | Okay, i'm setting up this new vbulletin software on my server, Mysql 4.1 Is installed and the databases are created as instructed in the instillation documentation... But after step one i gets this Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in c:\inetpub\wwwroot\vb\upload\includes\db_mysql.php on line 140 The database … |
| | is there a way to auto increment a value in a MySQL with PHP without having to lookup the value for instance: UPDATE SomeTable SET cell=cell++ WHERE row='some_row' |
| | I'm looking for a mentor to walk me through writing a program that will teach me begining web services in Java. I have set up snort and I have MySQL logging the snort events. I would like to write a webservice that accesses the MySQL SNORT database. I will give … |
| | Hi all! I need to export some data from a table (let's say table X) but I do only want to export some of its field (for example if I have f1,f2,f3,f4..I only want f1,f3 to be exported) so how can this be done using phpMyadmin? Thanks in advance. |
 | Certain graphical elements in this forum (such as user's avatars and file attachments) are actually stored in the database instead of in the file system. Is there a way to back these up along with the database? For example, when I make an sql dump file, it obviously doesn't export … |
| | 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 … |
The End.