11,093 Topics
 | |
| | I have a small problem. I wrote this script to update the status of my list using a checkbox for each line I want updated. But I (beeing new to this whole thing) can't seem to get my button to do what I want it to do. <?php //ansluter till … |
| | I have a table which shows our top sellers and Weeks of Stock left. Its generated by joining an order db with a stock db. I'm struggling with try to capture the really fast movers. Here is the script SELECT a.EAN, a.SKU, a.Name, Sum(a.OrderedQuantity) Round(Avg(a.Price),2) as AvgPrice b.Quantity, round((b.Quantity/Sum(a.OrderedQuantity)),0) as … |
| | I am trying to create a form that updates mySQL-database. I've created three php-pages. **updatepizza.php** <?php $host="localhost"; // Host name $username="root"; // Mysql username $password="billie"; // Mysql password $db_name="cygna_fyraarstider"; // Database name $tbl_name="pizza_menu"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot … |
| | Good Afternoon all, I'm working on a project for school, and we have a part where we want a combobox filled with data from a mysql database, tabel = sport. We can work out how to fill a normal combobox just with strings, but we can't find out how to …  |
| | how can i show the week number and corresponding dates using the tax year i tried Week(date, 0) but that shows 1-1-2012 as week 0 Eg; qc_data.date holds the date a qc inspection took place. if i want to show that the first full week in April this year (2 …  |
| | **I'm beginner of Php .. I Develop my first dynamic website -> http://wwww.afrogfx.com if you look at my sidebar you will see categories list my problem located here if i create sub sub categories like that** CAT A - SUB CAT A-1 - SUB CAT A-2 -- SUB CAT A-3 … |
| | Hallo there, does someone knows, where is the use of VARBINARY in MySQL database? Thanks, Danijel |
 | Hello I am making a simple page with one form. I want to update the password for a user in a table in MySQL - there is only one user in the table. The code DOES work. It really does update the table record, but once its updated, if succesfful …  |
| | I got a database with 2 tables. Table 1 is saving personal information Table 2 is saving dates, Time and a number In table 1 there is a date, time, number textbox. Which also is in Table 2. But Table 2 has some other fields which contain other data. Basically … |
 | I don't need the exact query , just the logic of how I should go about it: I need to compare for equality all records of a table for a given set of fields. If count of such similar records exceeds a particular value, I have to delete all those … |
| | Hi, I am trying to get a php variable into a header, I have managed it in another file but it not having it this time and I do not know why. Here is my php code [code=php] <?php header("Location: photo.php?albumid=".urlencode($albumid)); include_once 'title.php'; $result = mysql_query("SELECT id FROM user WHERE … |
| | Hallo! I would like to create a script to search a MySQL table (data). The table has two columns (ID & PRICE). Search must be done by ID and Price has to be displayed in the page, any ideas? Thanks in advance! PS: I've tried to modify [this script](http://www.phpjabbers.com/index.php?controller=FrontFrees&action=details&seo_url=mysql-table-search&page=4) but … |
| | Hello everyone! I am building a mfc dialog based application in visual c++ 6 and using mysql c api to connect to a database. What i need is a simple type of data grid to show mysql query results in a dialog. I do not need to edit, update, save … |
| | The MySQL database I want to use is using SSH tunneling and the MySQL connector provided from MySQL only allows normal connection. Can I somehow work around the SSH tunneling so I can connect Visual Studio with the database? Thank you :) |
| | Hi I have 2 Tables: CREATE TABLE IF NOT EXISTS `questions` ( `question_id` int(11) NOT NULL AUTO_INCREMENT, `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updateddate` timestamp NULL DEFAULT NULL, `active_flag` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`question_id`), UNIQUE KEY `id_UNIQUE` (`question_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE `alarts` … |
 | I have a similar mysql database both onine and in offline, with a few common tables in them. How can I synchronize both the databases to make sure the 'similar tables' in offline & online databases have the same data. How can I do this with phpmyadmin. |
 | Pls i need help on hw to store and display pictures from database. |
| | Please let me know the detailed procedure to install Apache, MySQL, PHP and PHPmyAdmin on my system which is windows 7. or post a link where the complete installation is given. I do not need to work on XAMPP or WAMP or such kind of other softwares. you can also … |
| | Hi, I am using below PHP script for insertion in mysql table from CSV file. Below code is working fine but i am trying to leave first row of CSV as it contains heading for data. need suggestions as it is reading from very first row. <?php //connect to the …  |
| | try { mysql_query("INSERT xyz"); mysql_query("INSERT xyz"); mysql_query("INSERT xyz"); commit() } catch (Exception $e) { rollback() } I would like so that if any of the queries within the try { } fails, to go to the exception and rollback the transaction, and commit otherwise. What kind of things will it … |
| | 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 '' at line 1 Its valid sql I checked I just don't understand what would cause that error. I also tried different statements and … |
 | Hi everyone, Here I have a php code, and i want to understand one part of it - like what is actually going on over there. (Based on Model View Controller(MVC) format) This is my 'model/category_db.php' - file It connects to the database and has some functions that have a … |
| | Okay, I am a total newbie stuck with the following task. I have one table, that looks like this: | id | name | rating | date | ------------------------------ What I am trying to do is gettin an output showing which 'name' has the best 'rating' based on months, showing … |
| | # whenevr i execute ne "select *"for any database the error belo is shown,is there any setting in phpadmin....coz this problem occured 1 fine day.....pls help. # <html> <head></head> <body><html> <head> </head> <body> <?php $con = mysql_connect("localhost"); if (!$con){ die("Can not connect: " . mysql_error()); } mysql_select_db("snippets",$con); if(isset($_POST['update'])){ $UpdateQuery = …  |
| | code: I am trying to debug the code, I can't understand why (or how) the same error is being thrown despite the if statements, dies, and different mysql_queries. I don't get it. <?php session_start(); $_SESSION['msg'] = ""; $con = mysql_connect('localhost','me','omglol'); if(!$con) { die("The connection to mysql server is not being … |
| | Hi, I'm developing an APP for android which requires a database, i'm using mySQL, but haven't had any luck with it's connection, this is my code: connection class: public class MySQLConnect extends Activity{ public void onCreate(Bundle savedInstanceState) { } public static void connection(String[] args ) throws Exception{ Class.forName("com.mysql.jdbc.Driver"); Connection con=(Connection) …  |
| | I forgot the way to write a query where you can psuedo name a table, for instance I have a table named user but I have to access it twice in one query and I want the results to be different. something like select user(a).f_name, user(a).l_name, user(b).f_name, user(b).l_name from user(a), … |
| | Hi, I have a question that can we use a mysql query in Concat clause. I want to make a query like this SELECT CONCAT(AVG(value),'-',(select Count(UserId) as counts from user_details )) as `Average` from surveyuseranswer Now I want to count number of users and concat it with the average value. … |
| | how to do this right Select DATE_FORMAT(EventDate, '%b %d, %Y') from details Order by STR_TO_DATE(EventDate, '%d-%m-%y') Oct 24, 2012 Oct 27, 2012 Oct 28, 2012 Oct 20, 2012 Dec 22, 2012 Jan 11, 2013 Jan 19, 2013 Nov 24, 2012 Dec 29, 2012 |
| | Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a1039476/public_html/getdetails.php on line 69 help <form action="getdetails.php" method="post"> Search Within: <select name="searchtype"> <option value="CustomerID">Customer ID</option> <option value="CustomerName">Customer Name</option> </select> Search Record: <input name="searchterm" type=”"text" size="20"/> <input type="submit" name="submit" value="Search"/> </form> <?PHP echo "<title> *********** </title>"; $searchtype=$_POST['searchtype']; $searchterm=trim($_POST['searchterm']); if … |
| | Below i made a MySQL Table in my phpmyadmin. [Click Here for a screenshot of my phpmyadmin table](http://i.stack.imgur.com/7gl77.jpg) I want to print on my php page the cat_name of a cat_id of my choosing. What code would i use exactly for that? I am looking at this guide here But … |
| | onload mysql 'query' will be executed then if the visitor will hit search the mysql 'querysearch' will be executed how to do that? <form action="default.php" method="post"> Search Within: <select name="searchtype"> <option value="CustomerID">Customer ID</option> <option value="CustomerName">Customer Name</option> </select> Search Record: <input name="searchterm" type=”"text" size="20"/> <input type="submit" name="submit" value="Search"/> </form> $searchtype=$_POST['searchtype']; $searchterm=trim($_POST['searchterm']); … |
| | Hello PHP geniuses! I am a beginner in php and would like to seek your expert advices and knowledge. When I display the result to a table, it always loop at the bottom, I want to display the another table at the right side of the first table. When I … |
 | I need to add an image (saved path in mysql - image from file on server returned from $image_id) to my page according to 4 rows returned. There will always be 4 rows returned from db. My problem is that it shows the same image (main with 3 thumbnails) in … |
| | I have a table attendance which contains id(int), attendance(char), and date(date datatype) columns. Values get stored in this table through a php file. In the below code I have given two textbox for the user to select date range. eg. from 2012-10-15 to 2012-10-17.. when the user selects date range … |
| | Hi! I have a contact form that won't...do anything!! I'm kinda new at this, although I've been succseful on MS SQL for YEARS...Can some one shed light on this? Thanx in advance!: The HTML: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> … |
| | I'm trying to make my first gallery with PHP and I'm having some problems i can't solve. My code looks like this: <?php include_once('config.php'); //Script der uploader og omdøber billeder if(isset($_FILES['billede'])){ $errors = array(); $allowed_ext = array('jpg','jpeg','gif','png', 'bmp'); $file_navn = $_FILES['billede']['name']; $file_ext = strtolower(end(explode('.', $file_navn))); $file_tmp = $_FILES['billede']['tmp_name']; $file_size = … |
| | I want to store my array into my database using jQuery. Here is my code i'm using serialize(); function. Its storing correctly but when i unserialize(); nothing happening. Please help here is my code. <script> $(document).ready(function(){ $("#save-skills").click(function(){ var skills = $('input[name="skills[]"]').serialize(); console.log(skills); $('#loading').css('display', 'block'); var queryString = "skills=" + skills … |
 | Ok so now I am stuck, I looked at the http://www.daniweb.com/web-development/php/threads/326436/php-read-text-file-and-save-into-databse page and understand some of it, Yet it is not what i require, substring does not count like I thought it would, like the left, right mid commands in excel. I want to count to the data I want … |
 | I have seen a couple solutions to this problem but none have worked so far. here is the error. [B]Fatal error[/B]: Call to undefined function mysql_connect() in [B]C:\wamp\www\login.php[/B] on line [B]12 [/B]and the code [PHP]<?php // connect to the mysql server $link = mysql_connect(localhost, root, admin) or die ("Could not … |
| | Hello, I am making a website to do with different tests so I need a script which can unlock test 2 after test 1 is completed. Then the same for 3, then 4 etc etc. I tried using MySQL to increase an INT so I could tell what the latest … |
| | How do I do that using SQL queries? I need a code to do that: For every "Name" on "names" column on DataBase, do this: { name: 'NameX', data: [Value from name X] } I need a code to display in categories, all names that theres in the "names" column … |
| | i have this main_login.php code <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"> <tr> <form name="form1" method="post" action="checklogin.php"> <td> <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF"> <tr> <td colspan="3"><strong>Member Login </strong></td> </tr> <tr> <td … |
| | I have a crontab job in which data from csv file get insert into mysql table at regular interval. Now i want the same table data to be inserted in ms sqlserver database. I know i can write code again to take data from csv to ms sqlserver database. But … |
 | Hello, I am trying to migrate sql file from one computer to another computer. And while trying to import the sql file these error appears why is it? I am trying to migrate sql from Joomla. Pencarian SQL: -- -------------------------------------------------------- -- -- Table structure for table `nafqc_usergroups` -- CREATE TABLE … |
| | Is this possible? Insert Into Customer(CustomerID, CustomerName) Values('6','test') on DUPLICATE key Update CustomerID='Select Max(customerID)+1 from Customer'  |
| | Hi, I am currently undertaking an assignment for university. I've having quite a bit of trouble with this seemingly simple task, which is to import the data from 2 .txt files into 2 tables within an sql database via python. Here is what I've done so far. This subject is … |
 | when new row inserting into mysql, then i want to dislplay some popup notification for few seconds in some page. so pls help me anyone ? thanx in advance :) |
 | I created a file in php and under this i wrote a code to lock a table with read mode. Below that file i wrote a insert operation into the same table, but as we know that read lock only supports read operation, meaning you can only view what is … |
 | hay how is everybody here, I have this form which should sign up users and send email to them to confirm they emails the users sign up OK but the Email don't go at all to the users email see my code and please need help on this. <?php if(isset($_POST['submited'])) … |
The End.