10,940 Topics
 | |
| | 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 |
| | I have this form to send an email and the visitor can send an attachment with his email as will everything gos well the email sent but the attachment comes to the email like this if he uploaded any C.V the C.V will be attached to this Email --_1_c4fe3315ccb7d6076c71d64ec5265ecc Content-Type: … |
 | I'm using VisualBasic.Net 2010 Pro, Windows Form Application, Win. 7, Wamp Server & MySQL Database This CODE is from the Declarations Section of the main form. Imports MySql.Data.MySqlClient Public Class Login Private mysql_host As String = "Localhost" Private mysql_player_log As String = "root" Private mysql_pass As String = "" Private … |
 | i have a registration form which code are below <html> <head> </head> <body> <table width="350" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><form name="form1" method="post" action="user_reg_get.php"> <table width="100%" border="0" cellspacing="4" cellpadding="0"> <tr> <td colspan="3"><strong>Sign up</strong></td> </tr> <tr> <td width="76">Name</td> <td width="3">:</td> <td width="305"><input name="name" type="text" id="name" size="30"></td> </tr> <tr> <td>E-mail</td> <td>:</td> <td><input … |
The End.