11,093 Topics
 | |
 | I'm a newb at web programming. Ugh, this is making me crazy! I've been programming it all day. I need expert's help. Please help me guys!! I've been trying to make a Sign Up filter and insert to database code. The code first checks if the username inputted in the … |
| | User clicks on a url, ie: example.com/AEQ438J When I perform this in the code below: [CODE] $referrer = $_GET['_url']; // echo $referrer displays the referrer ID contents correctly as "AEQ438J" if ( ! empty($referrer)) { $mysqli->query("UPDATE coming_soon_emails SET clicks = clicks + 1 WHERE code='" . $referrer ."'"); } // … |
 | Hi there all. This is my first time ever in Dani web. I just began teaching myself PhP by googling. My first question ( Not sure if i am even allowed to ask in here ) is that. * When you create a php registration form in PHP enabled page, … |
| | w whyhi i keep getting this warning and i dont know why [QUOTE]Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /users/2014/daf1/public_html/cs1109/lab18/adding.php on line 13[/QUOTE] [CODE]$add_topic_res = mysql_query($dbconnection, $add_topic_sql) or die(mysql_error($dbconnection));[/CODE] if anyone could help me it would be great cheers |
| | Hello, I have a MySQL database with 3 tables. Each table contains a list of persons, and each table represents the level of a person. For example, tbl_level1_p, tbl_level2_p and tbl_level3_p. Level 1 persons have level 2 persons under them, and level 2 persons have level 3 persons under them. … |
| | I am having some trouble. I have a Linux Server hosting 5.1 MySql. The Windows clients are running a POS Program written in C# using the .Net Connector. The Problem is that the initial connection takes around 12 Seconds which is not a big problem, but when you let it … |
| | I'm a beginner PHP programmer, so sorry if I'm asking some silly question. I've set up a MySQL database with a table carrying a list of boolean values. I want the PHP page count the number of 'true' on a column (from the table) and display it as a single … |
| | Hi I'm just learning how to use php and I'm testing out how to use a SQL trigger. What I need to do is print out the fields value before the trigger and then again after the trigger has been activated and changed the value. When I try to do … |
| | I've done some research on JOINs and UNIONs but haven't achieved what I want to do since something I do must be terribly wrong. I have the following SQL-statement: [CODE] SELECT posts.*, channels.channel FROM posts INNER JOIN channels ON posts.channel_id = channels.id ORDER BY posts.created DESC [/CODE] What I want …  |
| | pLZ GUIDE ME I AM NOW WORKING ON MY ONLINE EXAM PROJECT BUT SOME PROBLEM IS THERE. I HAVE A FORM WHICH HAVE A jump menu. text field and Submitt button. i want that when i select the desire thing from the jumpmenu and then click on submit button it …  |
| | |
| | [B]hi I set an authentication in php for [COLOR="Red"]admin[/COLOR] and it worked fine but now I need to use the same code for users who have limited access to the database that the admin use. [COLOR="Red"]user1[/COLOR] only update one table [COLOR="Red"]user2[/COLOR] only view tables [COLOR="Red"]user3[/COLOR] insert to one table only … |
| | I'm using an html form to submit data directly into a mysql database using a php script. For some reason the pictures will not be uploaded fully into the database. This is when I don't use a multipart/form-data tag. When that occurs the pictures partially upload but when I put … |
| | pLZ GUIDE ME I AM NOW WORKING ON MY ONLINE EXAM PROJECT BUT SOME PROBLEM IS THERE. I HAVE A FORM WHICH HAVE A jump menu. text field and Submitt button. i want that when i select the desire thing from the jumpmenu and then click on submit button it … |
| | <?php require_once('../../../../../Connections/Class5th.php'); ?> <?php function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? … |
 | Hi, I need to create a sql query that will return the sum of the total number of records in the t1 and t2 tables. Any ideas how to do it? Thnx in advance |
| | 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 … |
| | 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 … |
| | 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 … |
The End.