11,093 Topics
 | |
 | hii..I have proplem of converting datatype from decimal to float to show it in view from table: [CODE] create table st_fees(s_no int(4) primary key,s_name varchar(50), reg_fs decimal(5,2),study_fs decimal(8,2),curr int(1)); [/CODE] and my view creation code is [CODE] create view sum_fs as select s_no ,s_name,reg_fs+study_fs as fees,curr from st_fees; [/CODE] the … |
| | Dear All, I would like to generate pdf document via my php page which are based on mysql data? Any recommendation so far I have seen fpdf and tcpdf. Which one will be better or is there any better tool for it? Thank you.  |
| | This is what I have for a main page and form and upload code for an image. The image information is stored in a Blob field in phpMyAdmin. [CODE] <?php error_reporting(0); mysql_connect("sql5c1d.megasqlservers.com","vincastweb356440","fakepassword") or die(mysql_error()); mysql_select_db("phpmy1_vincastweb_com") or die(mysql_error()); $picture = $_FILES['image']['tmp_name']; $brand = $_POST['brand']; $year = $_POST['year']; $story = $_POST['story']; $description … |
| | Im trying to write a delete function for a "path" class which has data points (lat/long). It also has notes and photos along it but each of these objects have comments that also need to be deleted. Essentially everything associated with the path. Here's my SQL attempt in the most … |
| | Hi, how can I import database file (.sql) to my database in phpmyadmin and ignore or replace duplicate fields. For example, if I have news with id 5 in .sql file and my local database, I want to replace that record in local database with record in file. I tried … |
| | [CODE]$sql="SELECT * FROM accounts,adminaccount WHERE accounts.emailaddress='$username' and accounts.password='$password' or adminaccount.emailaddress='$username' and adminaccount.password='$password'"; $result = mysql_query($sql); $count=mysql_num_rows($result); $row = mysql_fetch_assoc($result); $usertype = $row['usertype']; if($count==1) { $_SESSION['usertype']= $row['usertype']; $_SESSION['id'] = $row['id']; if($usertype == "admin") { header("location:indexadmin.php"); } else { header("location:indexmember.php"); } } else { header("location:index.php?page=loginfail.php"); } ?> [/CODE] I wanted it to … |
| | Hi am really new with php mysql, i need help pls. I have created a email software in my server, there is a field for inserting email data info. Right now i am inserting these data one by one, but this is annoying and taking hard time. Pls help me … |
 | Hello, i have some problem with this issue. i have to do display results randomly using mysql. but results don't repeat until one cycle completed. i mean there are 6 results is there.... example first displyed randomly like 2 and 6, next 3 , 4 next 1,5 (one cycle completed) …  |
| | Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Lcbo\flash_import.php on line 6 this is the error i get from this code: [CODE] require_once("Connections/LCconnect2.php"); $myquery = mysql_query("SELECT pro_brand FROM product_information ORDER BY pro_id DESC"); print "&winetitle="; while($row=mysql_fetch_array($myquery)){ //<----line 6 print $row['pro_brand']."|"; } [/CODE] is it something to do … |
| | Hi everyone! i am developing an application using java and mysql as a database server. the problem is i want to change the default date format in mysql. i created a table like this; create table registration (registrationNo integer primary key, customerName varchar[50] not null, regDate DATE not null); so …  |
| | hi guys, i'm having an SQL Error in my CMS, somebody please have a look i get this error: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files (x86)\VertrigoServ\www\portal\estrutura\publicidades\exibe.php on line 73" my code: <? $variables=(strtolower($_SERVER['REQUEST_METHOD'])== 'GET') ? $_GET : $_POST; foreach ($variables as $k=> … |
| | Hi everyone, First of all let me just tell you that I have never done database programming myself, and this is the first time I'm setting up a MySQL database via phpMyAdmin, so I could be missing something small but I'm sure someone will know the answer, anyways... I have … |
| | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 keep getting this error what do i do  |
| | Hi, I'm a bit of a noob with PHP. I am trying to retrieve information from multiple tables with the following code [CODE] <?php function check_input($id) { // Stripslashes if (get_magic_quotes_gpc()) { $id = stripslashes($id); } // Quote if not a number if (!is_numeric($id)) { $id = "'" . mysql_real_escape_string($id) … |
| | I am having a bit of difficulty in getting the right value. What I want to query is, the users who expire in 7 days, for example on 4th Oct 2011, the query should display the result of that particular day only. Right now I am querying as below: select … |
 | I have an html page that gets data from 'hs_hr_employee' table and lays the info in a table on a web page. Then I have another table 'rights' which gets info from 4 columns from the 'hs_hr_employee' table and stores them in columns. In addition to those 4, the 'rights' …  |
 | [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> <td> <a href="./event_manager.php?id=<?php echo $data['id']; ?>&mode=delete">Hapus</a> | <a href="./event_manager.php?id=<?php echo $data['id']; ?>&mode=edit">Edit</a> </td> </tr> <?php } ?> </table> [/CODE] Warning: mysql_fetch_array() expects … |
| | Hey all, I'm new-ish at MySQL and Navicat. I'm trying to import a file with about 1.16 million records and Navicat keeps "working" (I see the timer moving) but it actually stops processing records at 850,825 records. The log shows no errors whatsoever but I know there are many more … |
| | The following code is used to connect C# with mysql server connectionParam = "SERVER=" + DbServer + ";DATABASE=" + dbName + ";UID=" + uName+ ";PASSWORD=" + pass; MySqlConnection mConnection = new MySqlConnection(connectionParam ); But what will be the code, if MySql can only be accessed through HTTP Tunneling. Tunneling URL: … |
| | I'm looking to create a battles, Explanation: I want to create a place on my website where users can vote on two users on a certain category, such as (example: best eyes, smartest person, etc) then other users have the option to vote, but only once, and who ever has …  |
| | Hi all, I have 4 (four) tables using MySql database, ie: [CODE]tb_item ( id_item, (varchar) --> PK item_name, (varchar) price, (double) ) tb_order ( id_order, (varchar) --> PK id_item, (varchar) -->FK date_order, (date) lead_time, (float) order_quantity, (double) ) tb_use ( id_use, (varchar) --> PK id_item, (varchar) -->FK date_use, (date) use_quantity, … |
| | category_manager.php [CODE] <?php //LOAD USER $result = mysql_query("SELECT * FROM kategori_berita"); while ($data = mysql_fetch_array($result)){ ?> <tr> <td><?php echo $data['kategori'];?></td> <td> <a href="./category_manager.php?id=<?php echo $data['id']; ?>&mode=delete">Hapus</a> | <a href="./category_manager.php?id=<?php echo $data['id']; ?>&mode=edit">Edit</a> </td> </tr> <?php [/CODE] Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\php_template2\category_manager.php on line … |
| | Hello, I have been learning php stuff for the last few days. Recently, I have learned how to allow user registration, and I have made this simple voting code that allows people to "like" or "upvote" something on my site. The way the site is set up is there is … |
 | Hi, I installed MySQL from the MySQL site. The setup procedure required me to set an username and password, which I set as X and Y respectively (say). Then when I opened the mySQL command line client, it asked for password, and after providing Y, I was allowed in. Once …  |
| | Hi, i am just adding the last component to my registration page, but i am having a little trouble with it. Basically my website includes a referal based system, wherebye when the user signs up they can add a referal that benefits the referal later on. The code i am … |
| | Hi There, I would like to know if it's possible to use or what I could use to get the required results. The values [code] +2711 081 076 086 080 9011 6547082 9013 9039 9086 9041 +27084 substring(table,length(tbl_code),length(tbl_code))=trim(tbl_code) [/code] I have different values lengths in my MySQL table that's not … |
| | hello every1 actually m new to vb.net, i have installed oracle 9i on my system and i dont knw how to connect even a simple form to my sql table in which i have two fields named first_name and last_name, the name of the table in sql is user. can … |
| | Hi all. As a hobby I've been working on making a website with PHP and MySQL, both of which I am new to. I'm having some trouble with the comments system as I can't seem to be able to insert a date into the database. After the "insert", when I … |
 | Hi Guys, I have imported an excel document into MySQL to tidy up and make better use of the data but I am having problems running an update. All tables used as examples below; [U]Tables[/U] asset_register phone sim team The asset_register contains the following cols; [CODE] id INT, serialNo VARCHAR, … |
| | 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] |
The End.