[mysql] Forum Topics

I have a MySQL query that's using SUM() to take the sum of a column, BUT what I need it to do is basically this: If the string in another column is 'BUY', then I want to add the number in my column, but if this other column has 'SEL', …

I've having very much trouble with the last piece of my site. I retrieve my database including checkboxes. From here I want to check/ucheck the boxes and save it back into the database. The problem I run into is when I check some boxes it doesnt take any notice witch …

I have all the php coding Insert, view, delete. The problem now is user only can use once email address to register at my website. I would want them to register with same email at my website. is it possible? Thanks!

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 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

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 …

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 mysql_connect is not working though mysqli_connect is working. Both are enabled in configuration file. Please help. Thanks

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: …

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 …

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 …

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? …

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 …