10,946 Topics
 | |
| | Hi all, I'm somewhat of a PHP noobie so be kind:) I have a MySQL table that contains the latitude and longitude coordinates to several different service areas, as well as an 'AreaCode' field. I'm using a PHP point in polygon function to loop through each of the service areas … |
| | I'm populating a dropdown from a mysql table with php but some cells in the column are blank, so in the dropdown there are gaps where these blanks are. Can i choose not to show blank cells or something? Thanks  |
| | i have two different tables table1 - property ================= id,name, address, city state, zip table2 - floorvalue =================== id, rentmin, rentmax, bedrooms, bathrooms i need a query to fetch first min rent values from the two tables query i have : select p.id, p.name, p.address, p.city, p.state, p.zip, f.id, f.rmin, … |
| | Hi, I am looking for some help with my script, since only half of it is working. The image path will not be put in the database for some reason and when I process the form all I get is white space: [CODE] $reg_errors = array(); if ($_SERVER['REQUEST_METHOD'] == 'POST') …  |
| | I have mySQL v.5.3 I think... I cannot figure out what is going on. Ive searched high and low and cant find an answer as to why i keep getting a syntax error. Heres the error I keep getting. [code] You have an error in your SQL syntax; check the … |
| | I am filling a dropdown list and an HTML page with the contents of a MySQL database (the tablename is in the variable $tablename2). The file contains a single field, "BusinessCat", with 20 or so unique records. The code below is an attempt to display every category on an HTML … |
 | does anybody know a mysql query that i can use in my php document that will return the number of rows their are in a table? thanks, i cant find it in the MySQL mannual |
| | I am having a problem sending my form to MySQL on my application page (when you click GameTime! it should send the data to a MySQL table.)-http://www.facebook.com/apps/application.php?id=157666347603790&v=app_157666347603790 It sends the form data here: [url]http://bit.ly/91oi88[/url] however, it just won't seem to work in facebook. Obviously there is something wrong with my …  |
 | Hello all, I have a table dir_records < SHOW CREATE TABLE dir_records > CREATE TABLE `dir_records` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `TITLE` varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `URL_TITLE` varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `TXT` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `COMPANY_ID` … |
| | Hi, I have this image script and I want to upload the image and then save the file into a Database, but I keep on getting errors(a blank screen). Here's my code: [CODE] if(isset($_FILES['logo'])) { if(($_FILES['logo']['type'] == "image/jpg") || (($_FILES['logo']['type'] == 'jpeg') && (($_FILES['logo']['size'] < 524288)))) { $logoname = $_FILES['logo']['name']; … |
| | I am having a problem sending my form to MySQL on my application page (when you click GameTime! it should send the data to a MySQL table.)- [url]http://www.facebook.com/apps/applicatio[/url] … 6347603790 It sends the form data here: [url]http://bit.ly/91oi88[/url] however, it just won't seem to work in facebook. Obviously there is something … |
| | Im sure this has been posted a billion times, but ive followed steps on other threads and still no look. What im wanting to do is to be able to delete a record from a form that is echoed..get me? Heres the steps: - Post update news, insterts it into … |
| | There's a query where I want to get the: - Username of the user attached to the current opportunity record - Sales Stage associated with each opportunity record - Dollar amount associated with opportunity record I want to: - Take the current SELECT IF STATEMENT result, and collapse it based … |
| | I have a table in which i need to sort the column names. NOT sort by column names.....sort the COLUMN NAMES. since it is easy to sort the records.....is there any way by which you can convert column into rows and rows into columns. |
| | First time visit here and looking forward to picking up a few pointers with regard to database integration within a web environment. I have one particular issue at the moment and being new to MySQL is causing me problems so I'll just jump straight in there if I may. I … |
 | Hi there, I used code to fetch email address record from table abc on server but shows " Access denied for user 'mysqluser'@'serverip' (using password: YES) " [code] /********code ********/ <?php include "connection.php"; $tableName = 'abc'; $todayDate=date("m-d-Y H:i"); $backupFile = '../backup/abc_'.$todayDate.'.csv'; $query = "SELECT email_address INTO OUTFILE ".$backupFile." FIELDS TERMINATED … |
| | Okay, so I have 2 tables, mos_users & mos_tempban . mos_tempban contains 2 columns: ID & lastvisitdate (last one is not so relevant) mos_users contains 13 columns, only 2 importent: ID & block What I am trying to do is: I want to set Block = '1' in mos_users where … |
| | I seem to get this error message when I run this please can someone help? Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\unisite\products.php on line 11 I can't figure this out at all :( [CODE]<?php if(isset($_GET['action']) && $_GET['action'] == "add"){ $id = intval($_GET['id']); if(isset($_SESSION['cart'][$id])){ $_SESSION['cart'][$id]['quantity']++; } …  |
| | Need help in pivot table, Example code to create pivot table from single table data stored in Mysql DB? Can we able to use predefined classes ? please give example with mysql query... Regards, Ramsingh S |
| | I have two tables 'quiz' and 'topics'. The relevant columns in 'quiz' are 'passState' (which returns 1 or 0 representing true/false) and 'managerId' which is a record number referring to a particular administrator. The relevant columns in 'topics' are 'managerId' and six other columns named 'equip1' .... 'equip6' respectively, which … |
| | Hi I installed visual studio 2008 64bit.and i need MS sql server express 2005/2008 64 bit. plzz help me.i tried one.but installation is not completed.Is there a special way to install it. |
| | Hi All, I want Some ideas to retrieve the Date time from the MySql in the MM/DD/YY format i stored Date Time in DD/MM/YY ,I used date Time picker for Retrieve the Date Time Thanks In Advance  |
| | Hi mysql_connect is not working though mysqli_connect is working. Both are enabled in configuration file. Please help. Thanks |
| | Hey everyone, new guy here, having an issue with a section of code... decided one day to just stop working, nothing was changed. the code is [code] $query = mysql_query("SELECT * FROM products"); while ($row = mysql_fetch_array($query)){ $productname = $row['name']; $productinci = $row['inci']; $productdescription = $row['description']; $functions = $row['functions']; $pid … |
| | [CODE] $datef = (date("Y-m-d",mktime(0, 0, 0, $_GET['year'], $_GET['month'], $_GET['day']))); $datel = (date("Y-m-d",mktime(0, 0, 0, $_GET['year1'], $_GET['month1'], $_GET['day1']))); echo $datef.$datel; $result = mysql_query("SELECT f8_0, n7_91, t_stamp FROM westdrayton WHERE t_stamp BETWEEN '".$datef."' AND '".$datel."' limit 20"); [/CODE] I have this PHP code to try and grab records from between the two … |
| | Hi, I have the following table. How can I select the lowest `place` for each `query` for each `date` (some queries appear twice as they have a different `fullurl`). Thanks for your help. Matt [code] +-------+---------------+--------------------------------+------------+ | place | query | fullurl | date | +-------+---------------+--------------------------------+------------+ | 2 | query … |
| | I am getting the follwoing errors in my PHP and it seems like my post are not set. Any help? Notice: Undefined index: radio in /home/sajohnson/dynamic_php/editout.php on line 18 Notice: Undefined index: semester in /home/sajohnson/dynamic_php/editout.php on line 19 Notice: Undefined index: dept in /home/sajohnson/dynamic_php/editout.php on line 20 Notice: Undefined index: … |
| | I wrote this piece of code to pull out the count of users(rtnUser) subscribed to a class(CDID)... However, I get a count of '0'... I'm not sure if I have the variables reading correctly... I second set of eyes would be great... [code]<?php $cdid = $row_rtnUser['CDID']; $sql = "SELECT COUNT(CDID) … |
| | Hi all, I am using mySql query to insert a row into table. I have two tables as Table1 and ZTable1. Table1 has 3 fields TId,TName,TAge . ZTable1 has 4 fields ZTId,TId,TName,TAge. Table1 has 1 row. 1, Myl,24. Now i want to insert values to ZTAble1 as 1,(1,Myl,24) these values … |
| | hi all, i had a query and i need to substr that query. [CODE]@s ="select Emp_Id,First_Name,Last_Name,Gender,Mobile_No,Email_id,Blood_Group from Employee where Emp_ID like '%", empid ,"%' and [/CODE] my query is this now i used substr [CODE]set str1 = (SUBSTR(@s,-4));[/CODE] SO in str1 i am getting values as 'and'...Now i dont need … |
| | I created a php page. this is my code. [CODE]$con=mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql = mysql_query("SELECT * FROM $tbl_name WHERE (Order = '" . $_POST['order'] . "')") or die(mysql_error());[/CODE] But its showing error like this You have an error in your SQL syntax; check the … |
| | How do I set the last SECTION number of the CHAPTER of a BOOK as a LIMIT? i.e. When I search for a BOOKNAME in a search box, I want to output all the SECTION(s) of the FIRST CHAPTER of the BOOKNAME with a LINK to the NEXT CHAPTER. [B]MySQL … |
| | i need a small project on php and mysql i m beginner in this field can anyone help me out..... plz...... it can be anything like hotel management........ thankyou |
| | Hey guys i have a quick question. I need help with a statment i am trying to get the avg of students gpa but my grades are in letter form. How do i go about changing the letter grade to number (ie. A = 4) and getting the avg gpa? … |
 | Dear Friends! I want to build a API in php/mysql for obtaining the data for a verified request The First Step when i create the Url for API by cURL its done but after that i wont able to do The Server Setup and Response XML Return Is there anyone … |
| | I have to develop a database application in vb.net 2005 with the following rules 1. The application connects with an online mysql database (i.e database resides on a remote machine) 2. The application has no local database but it should have a local cache to stores new records and the … |
| | I have a table that a new line gets added to when the machine stops with reason for stopping, when the machine gets going again I want to add the time lost. So when the machine stops the table will look like this: [CODE]ID | reason | time_lost 1 | …  |
| | I have written the title as “Script to Group Values” for lack of a better title. I want to have a MySQL database that receives value from a form on a webpage. For example, I have people signing up for an event. I want to create something (probably in PHP … |
 | here is the database [url]http://img214.imageshack.us/img214/3852/23405199.jpg[/url] here is the form [url]http://img254.imageshack.us/img254/3518/60904005.jpg[/url] if the search click i want the selected month in the combobox search from the database table under departure field month and it will fetch on the table.. for example: <--departure--> 09/10/2010 10/10/2010 10/11/2010 [code]<select name=\"month\"> <option value=\"01\">January</option> <option value=\"02\">February</option> … |
| | i have one table.i.e Employee.my empoyee table having 22columns. i used below code.but i got error [CODE] DELIMITER $$ CREATE PROCEDURE sp_search ( ) begin declare str varchar(255); set str="select * from Employee"; EXEC(str); end $$ DELIMITER ; [/CODE] |
 | I'm in the middle of a project development, and I'm frustrated with this problem. Im running XAMPP under Ubuntu 10.04 (Lucid Lynx) mySQL version : Ver 14.14 Distribution 5.1.41 The problem is that, mySQL is accepting null values even if the field is declared with the NOT NULL constraint. Example: … |
| | I have a database hosted at a remote location. I want to access that database. But I keep getting the error [CODE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'username'@'%' to database 'db' [/CODE] This is the code that i have written [CODE] Connection con = null; Class.forName("com.mysql.jdbc.Driver"); String username = "username"; … |
| | Hey Friends! I have some tables by which i have to select the data to display in search result. Table Details user_type Table [CODE] int id string user_type [/CODE] ticket Table [CODE] int id 11 not_null primary_key auto_increment int user_id 11 not_null multiple_key int type_id 11 not_null multiple_key string ticket_type … |
| | So, not so much of a coding question but more of a development question. [B]Some background:[/B] I have finished writing a scheduling program (in part thanks to the folks at Daniweb) in PHP (using MySQL) for a small business that sells musical instruments, music lessons, and the like. The program … |
| | Hi, I used mysql_real_escape_string to insert a data with apostrophe, in the database, using php. This works. But when I want to select this data and display it in a form's field, it does not work. What happens is that the data before the apostrophe is displayed in the field, …  |
| | <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title>Edit</title> </head> <body> <?php $con = mysql_connect("************"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("**************", $con); $1 = ($_POST['1']); $2 = ($_POST['2']); $3 = ($_POST['3']); $4 = ($_POST['4']); $5 = ($_POST['5']); $6 = ($_POST['6']); … |
| | Can anyone see what is wrong here? This is my first serious attempt at this.[CODE]<?php $query1 = mysql_query(" SELECT topics.url_big, topics.url_small, topics.title, topics.".$egroup.", quiz.passState FROM topics INNER JOIN quiz ON (topics.managerId = quiz.".$managerId.") WHERE topics.".$egroup." = 1 ORDER BY title ASC"); ?>[/CODE] |
| | I have a complex query I've been wrestling with for 2 days and can'seem to get it to run. I've tried LEFT JOINs and sub-querys and GROUP_CONCATs and still can't seem to get this to work right! What am I doing doing wrong? Lets say I have 2 tables in … |
| | Hi, I can't manage to set a root password no matter what I try. I've tried to uninstall and reinstall. I've tried to get the new version and replace the old one with it. I've totally deleted all mysql files off my machine and reinstalled mysql but I STILL get … |
| | Hi there everybody, I'm working with a company and they are looking to set up 2 server a UK and a US server. This is good and I know how to check what country the viewers are coming from and redirect them accordingly, I also know how to share the … |
The End.