10,938 Topics
 | |
| | hi, i opened two mysql sessions(A,B) and set the autocommit variable to 0 for both the sessions. by giving "set autocommit=0" then in session A i added a row to my table by calling a stored procedure and i tried doing the same in session B also.. but in session … |
| | Anyone want to help me with this SQL-code? [url]http://pastebin.com/VWnJmM34[/url] I want to add a column that shows the number of cupcakes the customer bought for that specific order_date. Is this possible? How do I do it?  |
| | I'm a beginner on MySQL. I tried to run this statement [CODE]SELECT* FROM address WHERE email=a@abc.com[/CODE] but it shown an error message. What's wrong? |
| | can someone help me to write a query that will sum the information across the row and down the column (sum) in ms access table a b sum 1 10 11 2 20 22 total_all I tried the following select a,b, sum as (a+b) from table1 the error i get … |
 | Good day! This is the code I've done in saving and retrieving an image to and from a database...I have encountered an error in retrieving the image.....how can i solve this? can u help me..thanks...hope you reply soon... Imports System.Data Imports System.IO Imports MySql.Data.MySqlClient Public Class frmMain Dim cnString As … |
| | Hello all, I'm I am very new to using MySQL databases and came across an error that I need help with. I'm trying to make a simple Connection file in php to connect to one of my databases and it keeps giving me this error:"Warning: mysql_connect() [function.mysql-connect]: Access denied for … |
| | Hi all... I need your help, there must be something I am not seeing here when trying to update a table of information in a database. Here is the code I am currently using. In my program I have this call... [CODE] if (($_POST['changeAddress'] != "") || ($_POST['changeAddress'] != null)) …  |
| | I have recieved this, Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\...register.php on line 16 I dont understand to be honest what this mean as i am new to php and mysql. What do i need to do to fix this problem? Below is my php. … |
| | Hi, I have a problem duplicate entry in same time. I am getting some parameters in other gateway (some websites) and stored in Database. I trim all parameters. Before i store in db, i check db whether that record already exist or not. Other Gateway website which they send three …  |
 | 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 … |
The End.