11,093 Topics
 | |
| | Hello, I want to ask you if you can give me an advice in how to make a secure login and register application in php and mysql. If you can give me a link or an idea I would be very thankful. Thank you! |
| | I seem to be having difficulties when using the following query: [CODE]$query = mysql_query("SELECT * FROM `products` WHERE `name` RLIKE '%$s1%' OR `name` RLIKE '%$s2%' OR `name` RLIKE '%$s3%' OR `name` RLIKE '%$s4%' OR `description` RLIKE '%$s1%' OR `description` RLIKE '%$s2%' OR `description` RLIKE '%$s3%' OR `description` RLIKE '%$s4%' OR …  |
| | Hello i am trying to pull the hosted domains from my sql database i am able to pull them and see them I just cant get the links to Phrase properly the link to the working script is here [URL="http://www.a1khosting.com/test/index2.php"]http://www.a1khosting.com/test/index2.php[/URL] as you can see the links are not correct when … |
| | Hi, I am new to web development. I am xampp package for development. First I was able to access MYSQL through CLI and PhpMyAdmin. But when I set the root password for the MYSQL, I am unable to access it. Any clue? Thanks |
| | I am in the process of designing a Database structure for a project. And i am stuck at a particular design decision. Ive searched quite a lot on google but not able to find a satisfactory answer. I am looking out for something like “TableSpaces” (like in Oracle) to use … |
| | Hi! Is it possible to retrieve XML data and input it to mysql database using JSP? If so, how will I do it? I'm new to java by the way. Thanks in advance to those who will reply!  |
| | I am using cake php I have a table called relates that holds the primary id values from the other tables. I used cakephp to generate the crud. it works fine. if you click on the number in the relates table it goes to the appropriate table and displays the … |
| | I have read many posts like this and can not get this to work right. The box always remains empty, yet there are rows in the table. Any help would be appreciated. Thanks. [CODE] <?php //Variables for mysql database connection $user='testuser'; $password='testpass'; // connect to MySQL $connection = mysql_connect(localhost, $user, … |
| | Hi all, I'm looking for some help with a PHP / MySQL scheduling component that our website users will use to schedule our services. I've drawn out 2 calendars that sit side by side using PHP. One for the current month, and one for the following month...to give users the … |
| | 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'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 |
 | After being requested to write a tutorial a few times, I've finally found the time to create a mod_rewrite tutorial for vBulletin 3. What this tutorial will allow you to do is make your vBulletin forum search engine spiderable - for Google and all the others. [i]<< update >>[/i] [i][b]This … |
| | 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 | …  |
The End.