10,940 Topics
 | |
 | 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 … |
| | hi, please help me, I'am using vb.net and MySQL as database. How do I save the image path to mysql database. So later when the customer list form when I select a customer and so appear on the customer edit form automatically direct the picture appears too Please help me  |
| | I'm trying to use the trigger below on my database but I keep getting the error "#1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'". Could someone tell me what is wrong. [CODE] DELIMITER $$ CREATE TRIGGER grade_change … |
| | Bonjour, Je viens vers vous car je ne sais pas du tout comment m'y prendre. Je cherche à faire 6 listes déroulantes liées php JavaScript mysql mai 1 listes déroulantes liées 2 listes déroulantes ca ce ok [COLOR="red"][B]3 listes déroulantes liées 1 listes déroulantes:'(:'(:'([/B][/COLOR] 3 listes déroulantes liées liées 4 … |
The End.