10,940 Topics
 | |
 | 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 … |
The End.