10,946 Topics
 | |
| | I am trying to update a mysql entry. Getting this error; [CODE]Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('loginid='15',title='Test',author='Sorcher',body=' Yeah just testing this aga' at line 1[/CODE] [CODE]if ($_GET['edit']){ $getedit … |
| | Good day all: Is there a mechanism through which I can have a button on my html form which on click calls a script that converts the form (or the html page) into a pdf file and inserts the file into mysql table with a specified name originating from the …  |
| | It wont work, the script might be messed up, please help / give a hint, i'll rep any help. [CODE]<?php session_start(); error_reporting(E_ALL); //////POST STATEMENTS/////////// $loginid = $_POST['loginid']; $title = $_POST['title']; $author = $_POST['author']; $body = $_POST['body']; $category = $_POST['category']; $dbLink = new mysqli('xxxxx.xxxxxx.com', 'xxxxxxx', 'xxxxxxx', 'xxxxxxx'); if(mysqli_connect_errno()) { die("MySQL connection … |
| | getting the problem ~ mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /studhome/1/0803087/public_html/RSS.php on line 14 trying to create a RSS feed no idea what is wrong, so can anyone help [CODE] <? // Connect to database DEFINE ('DB_USER', '******'); DEFINE ('DB_PASSWORD', '********'); DEFINE ('DB_HOST', '*****'); DEFINE … |
| | I get this error message: Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'testing this thing again' at line 2 NOTE: the 'testing this thing again' is $body This is my … |
| | I get the error #1005 - Can't create table 'db1.#sql-9e8_2c1' (errno: 150) (<a href="server_engines.php?engine=InnoDB&page=Status&token=3947cba14f7c39305d6f460b76698c5e">Details...</a>) I have 2 tables that I want to connect as a 1-1 relationship. table1:[U] a ,b[/U] ,c ,d table2: [U]a ,b[/U] the plan is that table2 will hold the keys of some of the records that … |
| | Hi, I am fetching date from the database which is submitted by user while form filling. The date came from database 2011-11-15. What i want to do,show date in below format. 2011-dec-15 or dec 15 2011 need help?? |
| | Please I need help, I don't know what I'm doing wrong here, [CODE] $query=( "UPDATE $tblname SET totwrong =".$wrongAnswers."', SET Test_score ='".$percentage."' WHERE UserName = '".$UserName."'"); [/CODE] It does not update the table, please please  |
| | Does anyone know how I would go about storing something from my database into a variable to use elsewhere on my PHP code? |
| | Hi, I am fetching current date from mysql database by using curdate() function. 16-06-2011 what i want to do.. 16-june-2011 how it is possible in mysql Need help?????? |
| | Hi, I'm building out a social network system, and when trying to pull user info for a user's friends, I'm stumbling into a problem with the query. The issue is I'm trying to keep the lookup table from listing redundant entries. For instance, [CODE]FRIENDS TABLE ------------- uid | fid ------------- … |
| | Hi, I have 3 feilds in my invoice processing Table. [LIST=1] [*]Submet [*]Return [*]Resubmitted [/LIST] Now I am using this query [CODE=mysql]SELECT `SRNo` , `VenName` , `Submet` , TO_DAYS( NOW( ) ) - TO_DAYS( `Submet` ) AS Days FROM `invmain` WHERE `Status` = 'SENT TO PAYABLE' AND `Submet` != '0000-00-00' … |
| | Hello, I am building a stock market website and i want to show all commodities prices rise fall even charts later .first of i want to know whether it is possible or not.If yes please guide me through.Please help any kind of help appreciated |
| | Hey, the data in my DB isn't going to be in english, and I'm wondering if I should name the tables and the fields not in english as well, or there might be problems later when using the names in PHP or SQL code? any one had experience with that? |
| | table: hometeam awayteam homepoints awaypoints leeds man u 3 0 leeds man u 3 0 man u leeds 0 3 i want to calculate how many points each team has. with the above data leeds should have 9 and man u 0. i have come up wth the following sql … |
| | Ok so let me start off by saying I am not a NOOB. There... So i need help trying to figure out an export of just my 2 colums from a table. Got it done. Now i need to make sure that I only export from a date range and … |
| | Hello, I have a form from which I post some data into 3 tables: when I click on the submit button I don't get any error message from mysql_error(); but when I look to my 3 tables I see no one of them has received the data I just posted … |
| | I have an issue with an insert statement not producing what I think it should produce... Here are the relevant parts of the code: [CODE] $free_pos[0][0] = $free_pos[1][0] = $left_top = $row[0];// value is 10000002 $free_pos[0][1] = $free_pos[1][1] = $left_step = $row[1];// value is 1 $free_pos[2][0] = $free_pos[3][0] = $right_top … |
 | Hi there. Thinking about creating a membership registration-enabled website, that will store people names and some info about them, after they register, but what i can't begin to make is a PHP code that whenever, a user searchs ( In a search box ) a name of another user, that … |
| | I have two tables: CDDemographics and CBTechProviderData. Both have 200,000+ rows. A common column between these tables is CensusBlockID, of which the first 5 integers are the fips code - in this case I am defining that code as 55001. I am trying to sum the population of CensusBlockIDs where … |
| | Morning,afternoon,evening and av a great night to all, solution needed plaese. secnario. players eneter log on screen and enter name ,password, (id is index on base) then go to check_logon.php if happy end up at logon_success.php this run ok :) am now trying to display players id number on logon_success.php. … |
| | Hi, mysql_query() expects parameter 1 to be string, object given in C:\xampp\htdocs\livesearch\livesearch\ajax-search.php on line 18 need help [CODE]<?php include_once ('database_connection.php'); if(isset($_GET['keyword'])){ $keyword = trim($_GET['keyword']) ; $keyword = mysqli_real_escape_string($dbc, $keyword); $query = "SELECT * FROM register WHERE subject LIKE '%$keyword%'"; echo "SELECT * FROM register WHERE subject LIKE '%$keyword%' "; //echo … |
| | Hello to everyone. I have an old flat database with a couple of hundred entries that I want to convert to a relational design. It was a user database for simple login and some preferences. I would like to know if there is a simple way to convert from one … |
| | hey there, I am doing testing to my site and i need to make over 60 rows to check paging. Is there any possible way to just copy rows over and over again? Thank you, |
| | 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 … |
The End.