10,939 Topics

Member Avatar for
Member Avatar for RaptorMarketing

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 …

Member Avatar for RaptorMarketing
0
151
Member Avatar for cjay175

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 …

Member Avatar for metalix
0
5K
Member Avatar for epicrevolt

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 …

Member Avatar for epicrevolt
0
195
Member Avatar for alam14_mist
Member Avatar for jomgrg
0
172
Member Avatar for KenAs

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 …

0
120
Member Avatar for Wolfemann

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 …

Member Avatar for SundayForever
0
320
Member Avatar for mls880

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 = …

Member Avatar for AndyVI
0
196
Member Avatar for mosquo

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 …

Member Avatar for diafol
0
113
Member Avatar for pitic

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 …

Member Avatar for pitic
0
408
Member Avatar for jacob21

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 …

Member Avatar for swpou
0
134
Member Avatar for igor221189

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, …

Member Avatar for igor221189
0
109
Member Avatar for gunnarflax

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 …

0
157
Member Avatar for Transcendent
Member Avatar for mark4013
0
264
Member Avatar for jlego

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 …

Member Avatar for smantscheff
0
139
Member Avatar for gunnarflax

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 …

Member Avatar for gunnarflax
0
422
Member Avatar for andrewliu

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 …

Member Avatar for andrewliu
0
224
Member Avatar for icehiro

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 …

Member Avatar for icehiro
0
79
Member Avatar for jacob21

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

Member Avatar for mgranger96
0
114
Member Avatar for mrblippy

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 …

Member Avatar for smantscheff
0
107
Member Avatar for Tabone3

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 …

Member Avatar for reygcalantaol
0
301
Member Avatar for fabzster

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 …

Member Avatar for fabzster
0
206
Member Avatar for doctorphp

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 …

Member Avatar for chrishea
0
180
Member Avatar for aPPmaSTer

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.

Member Avatar for aPPmaSTer
0
76
Member Avatar for rajeesh_rsn

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

Member Avatar for Sorcher
0
85
Member Avatar for raghujosh

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 …

Member Avatar for smantscheff
0
1K
Member Avatar for jfunchio

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 …

Member Avatar for urtrivedi
0
248
Member Avatar for dot_co

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

Member Avatar for Jx_Man
0
26
Member Avatar for jfunchio

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 …

Member Avatar for smantscheff
0
64
Member Avatar for s1sofiane

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 …

0
47
Member Avatar for MDanz

for example.. in one column it has "test1, test2, test3, test4" .... when i search for test1... i only want rows the word 'test1' in them specifically. $search = test1 i've tried LIKE %$search% but it get's all rows with the word 'test' in it... i want only rows with …

Member Avatar for davidchilders
0
113

The End.