10,942 Topics
 | |
| | How do i write php code for getting field from mysql as dropdown in php, and, also to display the related records of selected option in dropdown from database |
| | Hello, I am trying to create a table in MySQL with the following data: $sql = "CREATE TABLE $uID ( Col0 int(10) NOT NULL auto_increment, Col1 varchar(255) NOT NULL, Col2 varchar(255) NOT NULL, Col3 varchar(255) NOT NULL, PRIMARY KEY(Col0) )"; However, I keep getting a syntax error. Can someone pls. …  |
| | I have 2 drop down. In 2nd drop down items are added dynamically based on 1st drop down selection. Now I want selected value of 5th subject to store in MySQL table. I am not able to get the value of option which is selected in 2nd drop down. How …  |
| | I have a php/mysql project and I am currently trying to display a table into an html table through PHP how ever Only the headers are getting returned not the actual table data, here is my query plus html table <?php $result = mysql_query("SELECT * FROM store"); echo"<table border = … |
 | I want to create an archive list like this: 2014 -March -Feb -Jan *Post 1 *Post 2 2013 -November *Post 1 My config file is: <?php ob_start(); session_start(); //database credentials define('DBHOST','127.0.0.1'); define('DBUSER','name'); define('DBPASS','pass'); define('DBNAME','sample'); $db = new PDO("mysql:host=".DBHOST.";dbname=".DBNAME, DBUSER, DBPASS); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //set timezone date_default_timezone_set('Europe/London'); ?>` the table I m …  |
 | how do i insert the textboxes with different data inside of them in one database table i have this code dunno what to do next Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click Dim sql As String Dim totcount As Integer = 0 Dim inc As … |
 | Hi all, I'm looking into the management of duplicate records in MySQL, but this case is a little bit more specific. A record is only duplicated if column A and column B have the same value. So a record is only a duplicate if two specific columns have the same … |
 | Hi, I am trying to get the records out of a mysql database where the time is less than todays date and time - I have set the column as DateTime in mysql and it is stored as 2014-05-31 15:00:00 $TodayDate = date('Y-m-d H:i:s', time()+28800); $sttTodayDate=strtotime($TodayDate); // We Will prepare … |
| | want to create an archive list like this: 2014 -March -Feb -Jan *Post 1 *Post 2 2013 -November *Post 1 My config file is: <?php ob_start(); session_start(); //database credentials define('DBHOST','127.0.0.1'); define('DBUSER','name'); define('DBPASS','pass'); define('DBNAME','sample'); $db = new PDO("mysql:host=".DBHOST.";dbname=".DBNAME, DBUSER, DBPASS); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //set timezone date_default_timezone_set('Europe/London'); ?>` the table I m using … |
 | Hi ! I need to have a single mysql query which should get COUNT of two different values in a single field, suppose i have a field in a table 'approved', and there are only two values ie. approved=0 or approved=1, and have suppose 100 rows for them,so how to … |
| | hey, I need help with this code, I have made database and code for inserting data, now I need code that will display data for group, in database I have groupnaziv, and id, here is code for inserting which works great, after that I will post code that I need … |
 | Hello PHP fanatics, The browser shows Warning: mysql_numrows() expects parameter 1 to be resource, array given in C:\xampp\htdocs\a\Student_Home.php on line 13 here is the line 13... the LINE 5 is the LINE 13. include 'Connect.php'; $student_id = htmlentities($_REQUEST['id'], ENT_QUOTES); $result = mysql_query("SELECT * FROM student_information where student_id='$_GET[id]'"); $data = mysql_fetch_array($result); … |
| | I'm testing out wdcalendar, a jquery based calendar for a wesbite. Some info on it: [url]http://www.webappers.com/2010/06/08/wdcalendar-jquery-based-google-calendar-clone/[/url] The installation instructions are simple, but not detailed so maybe im screwing up somewhere. They go as follows: Copy the unzipped directory into the apache www directory/sub-directory. For a database: Create a database, execute … |
| | I am trying to connect a Crystal report to my database.mdf i.e SQL Server database. When using the wizard At the [I]Database Expert[/I] window after choosing the [I]OLE DB (ADO) [/I]i can not find any server and a database in the drop down menu. how to get that? i have … |
| | hello can i search a field for different words simultaneously??? we have a |or opertor in mysql regex but not and operator...please help  |
| | hello all; <!DOCTYPE html> <!-- To change this license header, choose License Headers in Project Properties. To change this template file, choose Tools | Templates and open the template in the editor. --> <html> <head> <meta charset="UTF-8"> <title>Our Local site</title> </head> <body> <form action="welcome.php" method="post"> <input id="t1" name="t1"type="text" placeholder="table name"><br> … |
 | Hello, I am trying to fix that error, yet I cannot find mysqld in the registry. I am afraid that I accidently delete it. [mysql error](http://en.kioskea.net/faq/1718-mysqld-exe-encountered-an-error-and-needs-to-close) What should I do now to fix that error? Do I need to reinstall windows? Thanks in advance.  |
 | i'm new learn php and mysql and i got stuck can't get better logic for my brain i want to get message from page if i type url like **index.php?user=user1** and page will show with data table and if username doesn't exist and page show no username found so this … |
| | This is the scenario: I have one table (main_tbl) with columns RECID(primary key),JOBNAME(text),STATUS(text). Now, I created an application that will query to the database and get one jobname and update the status. How can I make sure that multiple users wont get the same jobname when they executed the query …  |
| | Hi guys hope your all well, I want to put a quiz into my website that I'm doing. I've found some code for a Multiple Choice-True False Quiz Here is the code, (yes I know its long and there are some reputation in it) You have to add questions by …  |
 | In the process of converting an old web application I did from MYSQL to MYSQLi and am a bit lost with echoing a result, This code works in the old app with Mysql: <textarea name="dump" style="width:300px; height:400px;"> <?php include ("../connect.php"); $content = mysql_query("SELECT $field FROM customer WHERE cusid = '$cusid'") … |
 | How do I connect to MySql database using C# please,someone explain to me,thanks |
 | I need a connector to connect from a application running on Windows CE machine to a MySQL Server. Is there anything like this for both ARM and x86? Thank you |
 | I'm trying to make a quick filter like this site with PHP and MySQL, but do not know how start? http://www.mysmartprice.com/mobile/pricelist/mobile-price-list-in-india.html#subcategory=mobile&property=|200088-200485&startinr=799&endinr=1999 Who can teach me how to do this are not? |
| | if i insert more than one its taken only one value.database field city_id type is int $city=intval($_GET['city']); $query="SELECT `city_id`, `city` FROM `cities` WHERE `state_id`='$city'"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { ?> <li> <input type="checkbox" name="place[]" value="<?=$row['city_id']?>" /><span><?=$row['city']?></span> </li> <? } ?> $ids = array(); foreach($_POST['place'] as $val) { $ids[] = (int) $val; } … |
 | I have my php page, in which i have 3 fields old pass, new pass, confirm new pass. I'm trying to chnge the password of my id from which i am logged in. The program first check in the database and change the password of the logged in user. I … |
| | Hi, I am a beginner at programing and I have to do this project where it is asking me to valid ISBN 10 and 13 using MySQL database to store the information. I checked my php code to validate ISBN 10 and 13 and it works, but when I try …  |
| | I have a lookup table that contains 2 columns k_id, keywords as follow k_id | keywords 1 | hi 2 | play and so on I want to create another table using the previous lookup table where I want to put the k_id values as the columns of the other … |
| | hi guys so this page where part of the form elements are made arrays by adding square brackets to the input names. the reason i did that is because that part of the form is handled in jquery [this post(my post about jquery)](http://www.daniweb.com/web-development/javascript-dhtml-ajax/threads/478800/show-form-elements-based-on-dropdown-value) if you take a glimpse will understand … |
 | how to edit in the post in php? i m using update query but no working? can anyone suggest me any idea and please give me suitable example |
The End.