10,940 Topics
 | |
| | Hello guys! [CODE]"SELECT * FROM $tableName WHERE cata != 'abc' AND ORDER BY times desc LIMIT $start, $limit";[/CODE] Is there any reason as to why this block is not working? What is the rule for formating such queries? Thanks.  |
| | [CODE]import javax.swing.*; import java.awt.event.*; import java.awt.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.TimerTask; /** * @author Adrian BER (beradrian@yahoo.com) */ public class PopupAnkit extends JPanel implements ActionListener{ private JToggleButton invokePopupButton; private JFrame popupWindow; Statement stmt=null; ResultSet rs=null; // int tempCount=0; public static int count=0; /** * Constructor. …  |
| | Ok so my problem is I need to create a Page that a user can register on and also a log in page as well. The information i want to take in on the register page is: First Name Last Name email confirm email sex d of birth. and a …  |
| | Hi guys, i'm trying to test my asp.net app. it works fine when in visual studio 2010 ide, connecting to Mysql database and running. but, when testing in IIS the published app get the message exception "no database selected". it's everything running local, windows xp, mysql 5.x, IIS 5.1 my … |
| | I am compiling a VC++ source file in VS2008 licenced edition. Using the following header files: #include <regex> But I am getting the below error while compiling. fatal error C1083: Cannot open include file: 'regex': No such file or directory Please advise what Iam missing here.. :(  |
| | I am running a mysql query in mysql editor: select RegExCapture('sdfdj250043', '[a-zA-Z]{2}[0-9]{6}' ); Getting error: Function doesnot exist Trying to register the dll in mysql: CREATE FUNCTION RegExCapture1 RETURNS STRING SONAME 'RegExCapture.dll'; Getting error:SQL error(1126): Can't open shared library 'RegExCapture.dll'(errno:0) Can anybody help, where I am missing. Thanks in advance. |
| | Hi guys, I have a script that displays a list of tasks a user has to complete. To complete the task they must check the radio button and enter text into the textarea named eidtext. Here is the form: [CODE] <form id="form151" name="form151" method="post" action="update/update-sales-taks.php?&user_id2=<?php echo $user_id2; ?>&user_id=<?php echo $user_id; … |
| | hello I am making a login/register system for my website so far for the register php code i have: [CODE] <?php include ("config.php"); /* * To change this template, choose Tools | Templates * and open the template in the editor. */ $username = $_POST[username]; $password = $_POST[password]; $email = … |
| | [B]hi , i got an error.pls help me to correct. my code is[/B] [CODE] <form action="return.php" method="post"> <table width="200" border="0"> <tr> <td><h3 align="center">RETURN</h3></td> </tr> </table> <p align="center"> </p> <table width="41%" height="254" border="0"> <tbody> <tr> <td width="34%">Author:</td> <td width="66%"><p> <input type="text" name="author1" /> </p></td> </tr> <tr> <td>Title:</td> <td><p> <input type="text" name="title1" /> … |
| | I am sorry but I am just starting and I suck. I've been spending the last hour on the site trying to use others' threads and the FAQ to fix this but I simply have not been able to do so. This is real simple. All my code is.. [CODE] … |
| | I have a function C++ file, created in VS 2005. But I am not sure how to register that function in mysql, so that it get stored somewhere in mysql database and when the query runs, it should retrieve the func definition from the database itself.. Please guide me with … |
| | Hi I'm facing a problem. I want to join two table which are in the following format. Table 1 id - - name 1 - - xx 2 - - yy 3 - - zxz Table 2 id -- xx -- yy 1 -- 1 -- 1 2 -- 2 … |
| | hello there, i'm having a bit of trouble about this. im making a regiter page for our project and im using PHP, and im having a little problem, it says that: Could not execute the insert query.. but i got all my fields right?.. [ICODE]<?php include("config.php"); if(isset($_POST['submit'])) { $fname = … |
 | [CODE] <?php //LOAD USER $result = mysql_query("SELECT * FROM event"); while ($data = mysql_fetch_array($result)){ ?> <tr> <td><?php echo $data['event'];?></td> <td><?php echo $data['tempat'];?></td> <td><?php echo readDate($data['mulai']);?></td> <td><?php echo readDate($data['selesai']);?></td> [/CODE]> I have this error: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\php_template2\event_manager.php on line 206 Line 206 … |
| | Hello, Despite much searching, I've hit a wall with trying to get a varying number of records inserted into a database. Here's what I'm trying to do..... I'm building an online sign on site for races at a sailing club. For the sign on page, I want to make it … |
| | I have two date field in a table. Start and End I need to run a query to find out which records in a period. For example, in database have two date fields (event_start and event_end) I want to find out all activities include in 13/8 to 15/9. Not use …  |
 | I found an old thread that had never been answered here - [url]http://www.daniweb.com/software-development/vbnet/threads/330981[/url] Basically, the guy was asking how to retrieve database names and/or table names from a MySql database with vb.net. Here's my answer to that. Yes, I still use vb6 because vb.net is not much better and I … |
| | Hello Everyone I have a simple form posting to mysql database. I set one of the fields to be Text Area. I have and HTML Link Code that needs to be in that field. When I upload he data to the db, my " gets hashed out a \ gets … |
| | Alright, I have a members area, area.php, and I used mysql to find the userlevel and display content depending on the userlevel, 1 for user, 2 for admin. I made it, but it displays both the user and admin for 1, and 2. [CODE]<?php // Members Area // session_start(); $usernamee … |
| | Hello, I'm trying to display a table in PHP that uses multiple MySQL tables with some repeated field names. [U]Master table field names:[/U] Name, Student Major, Course Major, Course #, Credits, Course Name This is what I have so far...but the variables in the loop are not working and I'm … |
| | I have been trying to run a command from the SQL view I'm getting a syntax error [CODE] CREATE VIEW TopLevelCust AS SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit FROM Customer WHERE (((Customer.[CreditLimit])>=10000)); [/CODE] |
| | |
| | Table A(line_key,transaction_no,transaction_amt) Which is the o/p of the following query?? Select line_key,transaction_no,sum(Transaction_amt)From A; Ans 1. all the rows from the above table 2.no rows at all 3.error post your reply soon |
| | I'm looking to be able to have users register on my site or the forums (or vice versa) and be able to login to either with the same details. Is this possible? I sure as damn hope it is!! Hellppp! Also, how do I have users register? myBB comes with … |
| | I have a form with checkboxes [CODE]<input type="checkbox" name="yo[1]" value=1 <input type="checkbox" name="yo[2]" value=1 <input type="checkbox" name="yo[3]" value=1[/CODE] I want to to insert values into db exactly like this create table tablename yo1 tinyint default 0 , yo2 tinyint default 0, yo3 tinyint default 0 insert into table set yo1=value, … |
| | hi, how can i trigger an update query on a certain record if that record was not update within last say: 1 minute???/ can i doit without using any scripting? if can't then php.  |
| | Hi, i was just wondering how I get user details from a user table from a mysql database. Ive already worked out how to connect to the server, im just wondering how to import the data into a datagrid. Thanks Heres my current code [CODE]Imports MySql.Data.MySqlClient Module sql Dim Connection … |
 | Ok, working on a blog engine. Small and somewhat unimpressive, basically following along with a tutorial. The tutorial basically has me write a little MySQL to query some test fields that we filled in manually. And here is what I get. (see attachments) The first one shows the read out … |
| | Hi, I have a MySQL database and an array with ID's. For example: $q = array(4,7,9,34,12,3,...etc); The ID count in array can be over 100. What's the best way to select only those rows matching those ID's in array? The usual SELECT * FROM table WHERE ID = '$q[0]' OR … |
| | [CODE]update companystatistic set ReferencePrice = (select ClosedPrice from companystatistic WHERE CompanyID= 310 and ResultedDate = CURDATE() - 1) where ResultedDate = CURDATE() and CompanyID= 310 [/CODE] I have a same code. But it's not work.. help me..! thanks all |
The End.