10,942 Topics
 | |
| | Hi all, I have a table with multiple apps listed on it. The table is auto populated with the all available apps. The admin then has a options to assign user permissions e.g. user, admin or none. I have attached a pic of my table. I wanted to know how … |
| | HI there.. I've spend almost a day looking for a script for image upload but unfortunately, i see none. so, I consider writing a thread here at daniweb so the advance programmer there will help me with my problem. Please help me in creating a script that will enable the … |
 | |
| | hi guys, quick question. i have 2 tables. Client Table: ClientID INT PK AI, ClientName VarChar Folders table: FolderID INT PK AI, FolderName VarChar, client_ClientID INT The issue i have is that i have created this virtual folder appliaction in the site and have created it now where when they … |
| | I have used the delete query $sql="DELETE FROM table_name WHERE id='$ids'"; but the problem isthat it deletes the record but the record does not disappears from the page. It dissappears after refreshing the code. I have used the meta tag for page refresh but itis not working. Can any one … |
| | 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 |
The End.