10,940 Topics
 | |
| | can someone help me or give me codes on how to save images into database i'm a new user of java. |
 | Hello Friends, I am new with asp.net.How to use mysql backend in asp.net please answer with code example.  |
| | 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'm having problem with my website, and I just cannot figure it out what's the problem with my code. Any ideas? Thanks. [CODE=PHP] // get related files from database if ($settings['related_files'] == 1) { $related_query = mysql_query('SELECT f.fileid, f.title, f.description, f.icon, f.iconlocation, f.timesplayed from '. $tbl_prefix .'related AS r … |
| | 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 everybody! Please,help! My problem is as following: in a file XXX1.php we have a form with checkboxes: { echo '<form action ="XXX2.php" method= "post"> What you are looking for: <br /> <p><input type="checkbox" name = "wordprop[]" value ="Option1" >Option1<br/> <p><input type="checkbox" name = "wordprop[]" value ="Option2" >Option2<br/> <p><input type="checkbox" … |
| | I have a PHP page opened directly from a URL with params in it: http://subdomain.domain.com/phppage.php?id=123456 The PHP page is [I]supposed to [/I]execute a very simple SQL statement to retrieve a single data row based on the id variable. The SQL execution is done this way: [CODE] $id = $_REQUEST['id']; $sql … |
| | Good day forum: I need some assitance retrieving and displaying an image. I have stored image in a directory on my server and saved its name in mysql. I'm able to retrieve and display all images on a page in the following way. [CODE]<?php // Connects to your Database include … |
| | 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: ' . … |
| | give me complete code to see content of table and after tat edit data everytime diff an update it in same table of database |
| | 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 … |
| | I am just trying to make a php edit script using a combo box or any other method. But I am not sure how to write a script when selecting a sportsid and fetch the related data at the same time. [CODE] $sql = "SELECT * FROM sports WHERE sport_id=2"; … |
| | 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 … |
| | I am attempting to update the value of one field within a table, by doing a select of the value of another field within the same table in a single UPDATE statement. Is it possible? And if so, could you tell me what is wrong with the syntax of my … |
| | [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'm currently trying to refresh a DIV on my page that is linked to MYSQL (changes if database has 1 or more rows) without refreshing the entire page, I've tried using javascript although it didn't seem to work and so Im back to the drawing board, Im not … |
| | 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 … |
| | Hello everyone! I need to be able to check if a "username" exists in one table in the database, and if not then create a row with that "username" and various other bits and bobs. I have it so I can input a username into a database but when I … |
| | 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 … |
The End.