10,942 Topics
 | |
| | I know that this has been discussed several times before and that "PDO (PHP Database Object) works with multiple databases", "PDO supports dynamically generated prepared statements" (meaning that it can bind parameters from an unknown amount of parameters, which MySQLi can do with a bit of trixing). But I've never … |
| | With over 15,000 wood names in the wood knowledge base I am building (at [url]www.prowebcanada.com/taxa[/url]) it has become practically essential to add a versatile search engine to extract queries from the MySQL files. I started with an online template and have brought it quite a way along but some things … |
| | Hello folks, i need help for a query.. I have 2 tables .. user table: useridid city and another table, the reward table : userid reward points , I want to sum up the points according to the city and list them.. Any ideas ? I am loooooost .. Thank … |
 | Hi, I have one simple problem. PHP (CodeIgniter) code: [CODE=php] $query = $this->db->where('filename',$filename)->select('valid_until')->get('jos_reklama_banners'); $row = $query->row(); $valid_until = $row->valid_until; if($valid_until > time()) { $sql = "UPDATE `jos_reklama_banners` SET valid_until = valid_until + ? WHERE `id` = ?"; $query = $this->db->query($sql, array($days*86400 ,$filename)); //viena diena 86400 sekundziu //echo 'daugiau'; } else … |
| | Hello I am looking to dump data from a MySQL database to an excel spreadsheet. I know I can dump it to a CSV file and import that way, no problem. But I want to dump the data to a specific spreadsheet in an excel and specific cells. I have … |
| | Hi all, I am trying to select multiple rows from the database and then separate the rows into array values so I can use them throughout my code. This is what I have right now... [CODE] $result = mysql_query("SELECT url, image, placement FROM advert WHERE user='1'") or die(mysql_error()); //This grabs … |
 | Alright, I'm back for another educated post (got the newsletter btw :(). So I am trying to [COLOR="Red"][B]use AJAX to remove a joke from a list of jokes[/B][/COLOR] inside the administration panel. I know basically nothing about AJX, but I am a quick learner. I know that if I press … |
| | 1.if there is no relation between two table. 2.if relation exist. please help. Thanks all |
| | Any ideas on detecting the current version of the MySQL ODBC driver? Currently I am reading the registry to obtain the version: [code=delphi] Function MySQLVersion:String; Var TR : TRegistry; SL : TStringList; I : Integer; Begin Result := 'ODBC 3.51'; // Default version SL := TStringList.Create; TR := TRegistry.Create; TR.RootKey … |
| | Greetings all, I've just started learning Ruby (and Geo Ruby), and am trying to create overlays for Google Maps. I found a [seemingly] great tutorial for doing this [B][URL="http://blog.newsplore.com/2009/02/22/spincloud-lab"]HERE[/URL][/B] ...and it uses Ruby to generate the final javascript - cool, eh? Have everything installed properly (as far as I can … |
| | Hi Guys I have an e-commerce website. Two of the columns are for the pricing of products. What I would like to do is update the price ('prodprice') directly from the cost price ('prodcostprice'). It would be nice to set a certain markup according to price range. eg. $0-$1000 = … |
| | Hi everyone, this is my first time using daniweb, so helo! I have a major issue with building a menu from a query. I have the following, a query built from a join from 4 tables my query returns the following Id cat name sub 2sub con 3 1 axle … |
| | Hy. I'm trying to do a select from multiple databases and tables for an occurence. let's say i have databases db1, db2 and db3. Each have the following tables t1, t2, t3. And in each table there is a field named id which i want to select and a field … |
| | Hello, How to use date function in my sql for current date. Table description: jid desc cname category date(posting date) 1 kpo job ab kpo 7/3/2011 2 lpo job bc lpo 8/3/2011 3 bpo job df bpo 9/3/2011 What i want to do, when i fetch data from the table … |
| | Hello, Would it be possible to add text to textboxes with the click of button? The page contains three dropdowns (category, sub category, items). First, user selects a category in the dropdown. In the second dropdown, all items that are held in that category are displayed. In the third dropdown, … |
| | Since no one answered to my previous thread about a similar issue I rephrase the problem and try my luck again :) I have rather recently started working with prepared MySQLi-statements in php. From what I've learned is it supposed to be much more effective and secure so I've tried … |
 | Is it better to learn html, javascript, php, then mysql if you want to start ur site? Is it better to learn it in that order? |
 | the language is vb.net, but it is more of a mysql database question. I have a table that holds customer repair information (where it is, whats going on, if it was completed, etc). the table starts with a basic auto increment ID, the id is used to view the repair … |
| | Hi! I have a problem with binding parameters dynamically in my mysqli_stmt objects. As I don't know how many parameters which will be put into this function I must bind the parameters dynamically. Though I cannot understand what's wrong with this method: [CODE] public function execute($unprp_stmt, $data){ //Prepare the stmt … |
| | Hello, I'm trying to create a search engine for my databse. I be able to select multiple tables [CODE]$sql = mysql_query("SELECT * FROM table1, table2, table3 WHERE ...");[/CODE] I was wondering if this even works? If it does, how do I get rows from different tables? [CODE]while($row = mysql_fetch_array($sql)){ $fromtable1 … |
| | I want to fetch some data from my database which something weird came out. [CODE]<?php include("conmysql.php"); $selectdb = @mysql_select_db("vote"); if (!$selectdb) die("Connect database fail!"); //find number of people supporting $sql = 'SELECT COUNT(support) FROM address WHERE support=1'; $result = mysql_query($sql); if (!result) { die('Invalid query: ' . mysql_error()); } echo … |
| | Hi, How to change date format in my sql.By default it is taken as 2011-03-05 but I want to change as 05-march-2010. need your help Thanks |
| | Hi everyone, I am having an issue with a query i am doing for an assignment, i have made an attempt but i know i have not done it right. below is the table structures: Customer: CustomerCode,[pk] CustomerName Movie: MovieCode,[pk] Name, Rating Video: VideoCode,[pk] Name, CustomerSoldTo,[fk1] MovieCode,[fk2] What i have … |
| | Hi, I recently begin to work with MYSQL, php and html and I have this problem. On the homepage of my site on the sidebar I have a section where it tells you the latest blogs that have been posted. Now here comes the problem. I wish that whenever I …  |
| | Hi I have a join query which I use for a report ok I have a query to give me results for a report that will give me all the stores that sold policies from a group during a period. It works however I cannot get it to give me … |
| | Hi everyone. I am trying to build a script where a user of my website can download files. I have a problem. My site has two different user types, Free and Premium at the moment the only protection I have on the script is to check whether the user is …  |
| | Hi everyone, I am pretty new to SQL and I would like to know how can I add a prefix or postfix to all records in one field. Example: I want to add "PK-" before all barcodes in my database. |
| | Hi I had a mysql data base and had a date column in it. Date is like : date("Y-m-d"), I need to search in the data base between two days, select users who registered between 2009-12-13 and 2009-12-25. Please help me thanks in advance |
| | Are dynamic insert statements possible in MySQL. I am creating an application that generates a database driven web application with minimal human intervention. Briefly, a user is allowed to build an HTML form(by adding HTML form elements) on a web portal and then he/she submits the form. Once the form … |
| | Im just learning how to do triggers in mysql with php I have two versions of the trigger i would like to use but i keep getting errors saying the syntax is wrong. the first one is: [CODE=mysql] CREATE TRIGGER credits_earned AFTER UPDATE ON takes on (grade) REFERENCING NEW ROW … |
The End.