7,368 Topics
 | |
| | Hey guys, I have been trying to create a registration page for a while now, and I just can't seem to get it right. Could any of you help me? I currently have 3 php pages. The first is the homepage, which also includes a sign up form: [code] <form … |
| | i am trying to create a simple guestbook to include in a web site. i cant get the form to add the data to the database nevermind post the entries. there are 3 files guestbook, addguestbook and view guestbook. im using server2go and dont know whether there is something in … |
 | Hi, I'm running my server on localhost. I'm trying to make a forum database program in php, but I can't get mysql to work! whenever I try to add a table, it says there isn't any database. How do I add a database to localhost? Thanks in advanced for your … |
| | How to use dreamweaver to create a database? |
| | Hi all, First of all I am new with server using. Below my virtual private server details: [LIST] [*]Processor : 2.8 GHz Dual Core [*]Processor Cores: 2 [*]RAM Memory : 4GB [*]Apache Version: Apache/2.2.3 (CentOS) [*]PHP Version 5.1.6 [*]MySQL Version: 5.0.77 [*]HDD: 100GB [*]Bandwidth: Unlimited [/LIST] Due to 3GB of … |
| | hello, I have a simple problem. I need to create a new table "smaller" using the data from an old table "larger" table. When I say smaller I mean it will have the exact structure as the older table but will have only a few records. Now, i know that …  |
| | I've been working on a project lately that is written in python and I want to incorporate mysql into it. The python code is basically a sales report writing system in which every sales report will have it's own number such as 10-0001, 10-0002 and will contain customer information like … |
| | Hi, I'm hoping someone out there has the answer to this question: How does one convert a table column's data type from INT to CHAR/VARCHAR? Background: I'm trialing some ID card software and it uses Access as its backend. It has ODBC capability and I'm able to connect to my … |
| | Hi, If I run the following mysql_query: [ICODE]SELECT * FROM products WHERE product_name LIKE '%SOM%'[/ICODE] I get the following results: [INDENT]SOM 1 - Coloured option SOM 2 - Magnetic Roof Sign SOM 4 - Magnetic Roof Sign - Centre L SOM 6 - Magnetic Roof Sign - Curved Top SOM … |
| | Can anyone see where im going wrong with this code I keep hitting a brick wall with it. Its doing my head in. I think its more the sql code, It keeps showing all data instead of just showing the data based on the user_id which should be limited to … |
| | Not sure if its the sql query or what, but I have a pagination class and a function I am trying to put together if some one would be able to point be in the wright direction it will be very appreciated. :) The following is the function which I … |
| | Hi, ( I have attached a screen grab of what it looks like ) I am trying to collect tags for tagged photos based on the photo id. I get duplicates when i do [B]GROUP BY tag_name[/B] or [B]DISTINCT tag_name[/B]. [LIST=1] [*]The first query is set up like that because … |
| | I'm trying to create a query for a report but I don't seem to come with the right query for it, I'm kinda new at doing queries and reports, anyway here's what I have. I have two tables that looks like this: t1 ------------- |id | date | | 1 … |
 | Hello All, I have two tables. One for messages and one for comments. For each entry in messages table there will be multiple records in comments table. Now I want to select the top 5 messages and top 10 comments for each message. My table structure is Messages ---------- MID … |
| | Hi Im pulling a list of users out of a user table and want to include photos, from the photo table, for each user. But not all users have a photo in the photo table... If I left join 'photos' onto 'users' i only get users who have photos... is … |
| | I am looking to build a fairly straight forward internal recruitment site which will include a job search. I need to be able to search on keywords in one field and postcode/location in another similar to guardian jobs ([URL="http://jobs.guardian.co.uk/"]http://jobs.guardian.co.uk[/URL]) Ideally there would also be an option to define radius of …  |
| | Hi, I am trying to get my date field in a table to display as a long date (%W, %D %M %Y) format, but when I change the query variable using the FORMAT_DATE function it doesn't work at all, I just get a warning error. [CODE]die('Could not connect: ' . … |
| | Hi, Im trying to print out section titles and instructions from a database, however the first section title gets printed twice, I've no idea what I'm doing wrong. Here's a code snippet: $query = $this->db->query('SELECT DISTINCT SectionTitle FROM SECTION WHERE SurveyID= '.$number ); $j=1; foreach ($query->result() as $row) { $secTitle= … |
| | Hi, I want the db to return records which have either "bmw" or "audi". Below is my code but the db only shows records which have bmw. [CODE]SELECT * FROM `details` WHERE BRAND = 'bmw' OR 'audi'[/CODE] Thank you in advance. Cheers, Vishal |
| | So, I need to let a Visual Basic application connect to my XAMPP MySQL server. I set up the .Net/SQL Connectors, XAMPP, and all that other good stuff. When I try to connect to the server using 192.168.1.2 (my static IP) it will work. When I try to connect to … |
| | Hi, I want the db to return records which have either "bmw" or "audi". Below is my code but the db only shows records which have bmw. [CODE]SELECT * FROM `details` WHERE BRAND = 'bmw' OR 'audi'[/CODE] Thank you in advance. Cheers, Vishal |
| | Hi, Myself and a couple of other programmers have decided to make an online email client (similar to Horde or RoundCube...). And we're going to need all the help we can get. The whole thing is an open source project. So, if you know your way around MySQL and/or PHP, … |
| | Hi everyone. I'm trying to export my C program that used MySQL from Linux to WindowsXP and to make the exportation simpler, I'm thinking of downloading Cygwin. May I ask if I still need to download anything to help me use MySQL in Cygwin? Links to download sites and/or tutorials … |
| | [B][COLOR="Green"]Hello Guys I have learned c++ and some of java and I wish if anyone can help in starting the database design and how can connect it to a program , I mean by giving me some useful books and programs in which I will program in(MYSQL and ORACLE ) … |
| | Hi, I require some help in making the following possible with mySQL. My [simplified] database layout is as follows UserID Timestamp League Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Fields 1-6 values are either "yes" or "no" Basically a user submits a form selecting the … |
| | hi guys... i can connect now to the mysql database and is able to display the database names (because i have 3 databases) in a combo box.. i was stuck up in displaying tables from mysql in a listview.. please help me solve this.. here are my codes: [code] Public … |
 | Hi, I have started a new app in my current Django project and I want to make the new app use its own database. I have found this solution on the web: [URL="http://www.eflorenzano.com/blog/post/easy-multi-database-support-django/"]Django Multi-Database support[/URL] but it seems more like a hack than a supported solution. Do you think this … |
| | Hi, I have 2 tables i am querying. The first table has 2 columns, one for folder ID and the other for Category ID. I want to query that table to get a loop of all the folder ID's based on the category ID chosen. Then i query the second … |
| | Hi ALL, When i run this query it's take too much time to execute. SELECT ptnt.*,ptntF.familyName FROM -> (SELECT ptntPatientDetails.*,ptntPatientDetailsLang.occupation,ptntPatientDetailsLang.notes,pracStatusMasterLang.statusDesc, -> IFNULL((select countryName from genCountry where ice_global.genCountry.countryID = ptntPatientDetails.country),'') as countryName, -> IFNULL((select stateName from genState where ice_global.genState.stateID = ptntPatientDetails.state),'') as stateName -> FROM ptntPatientDetails,ptntPatientDetailsLang,pracStatusMasterLang -> WHERE ptntPatientDetails.patientID = ptntPatientDetailsLang.ptntPatientID … |
| | I'm having some problems with the UPDATE statement in VB.NET. Not the UPDATE statement directly, but when it comes to incrementing a field's value by 1. Below is the code that I'm using for writing to the database, as well as the two UPDATE SQL statements that I've tried. Any … |
The End.