10,946 Topics
 | |
| | Here is part of the html <body> <table> <tr> <td id="ctl00_ContentPlaceHolder1_TD_Unlimited_Usage_PerDay" class="form_label" colspan="2"> <table width='100%' cellspacing='2' cellpadding='0' border='0'> <tbody> <tr> <td align='center' bgcolor='#E1E1E1'>Date</td> <td align='center' bgcolor='#E1E1E1'>Download Usage</td> <td align='center' bgcolor='#E1E1E1'>Upload Usage</td> <td align='center' bgcolor='#E1E1E1'>Total Usage</td> </tr> <tr> <td class='table_item' align='center' bgcolor='#EBEBEB'>2012-11-02</td> <td class='table_item' align='center' bgcolor='#EBEBEB'>1.269 GB</td> <td class='table_item' align='center' bgcolor='#EBEBEB'>0.286 … |
| | |
| | i Always getting : **mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\class\function.php on line 28** please give the suggestion friends config.php <?php define('DB_SERVER', 'localhost'); define('DB_USERNAME', 'root'); define('DB_PASSWORD', '12345'); define('DB_DATABASE', 'class'); class db_class { function db_constractor() { $connection = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die('Oops connection error -> … |
| | I'm getting this error in one of my scripts: **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 '-25,25' at line 1** Below is part of the code any help would be great <?php …  |
| | Hi... I am using following query to get data from a table *select * from emp where ename regexp 'rajkiran'* It will return only the rows with ename=rajkiran but I want to select all the rows with ename =raj kiran & ename=rajkiran using a single query |
| | Hello DaniWeb, First off, I am not looking for code, at least not yet. I also honestlly don't know where to post this, but since I'm using PHP, what the heck. If you're an admin and can help me find more relevant answers by changing the "forum type", so be … |
| | I'm doing a delete page, and this part is the part where all the data were supposed to be echoed. but, the problem is I don't really know how to print the checkbox within the php. The line 6 is wrong. Kind men, do show me how to write it … |
 | This is my php code, I was wondering if you could help me, <link rel="stylesheet" href="style.css" /> <script type="text/javascript" src="script.js"></script> <?php $cat = mysql_real_escape_string($_GET['category']); include '../includes/db-conns.php'; //The file is being accessed on the staging site $hostname = $hostname3; $username = $username2; $password = $password2; $databasename = $databasename3; $link = mysql_connect($hostname, … |
| | hi, i havent been able to retrieve a random row from my database hourly, daily and weekly. i need to display a row (doesnt matter if it repeats) but i need to make it change in one page hourly, another daily, and other weekly. For promotion. how could the code … |
| | final public function result($sql) { return $this->mysql['result']($this->mysql['query']($sql, $this->connection), 0); } Anyone got any idea how to best fix this error ? |
| | Hi guys, im developing an inventory system. things are doing good until ms access starts to slow down my vb6 project. my records are already exceeding 13k rows. retrieving and recording are laggy. like 3-15sec waiting. now. im planning to migrate to mysql. i already have mysql and SQLyog as … |
| | Im trying to convert a procedure from using sql plus to mysql but cannot get it to work. **SQL Plus:** CREATE OR REPLACE PROCEDURE PRC_CUS_BALANCE_UPDATE (W_IN IN NUMBER) AS W_CUS NUMBER := 0; W_TOT NUMBER := 0; BEGIN -- GET THE CUS_CODE SELECT CUS_CODE INTO W_CUS FROM INVOICE WHERE INVOICE.INV_NUMBER … |
| | |
| | So, I've been trying this multiple delete thing with a checkbox and I did look on the internet for some code snippets and up to now, I have this: <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Intrious Website</title> <link rel="stylesheet" href="tablestyle.css" type="text/css" /> </head> <body> <?php include('includes/header.php'); ?> <div id="main"> <h1>Hardware Delete<h1> … |
| | Hello. I am trying to connect my MYSQL Database to my JpGraph but it is not working. Any help is appriciated. Here is my conde. <?php include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph_bar.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph_line.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph_pie.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph_pie3d.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/db.inc"); $host = "localhost"; $username = "root"; $password = ""; $database = "test"; … |
| | Hi, I have a table and I need to write a SQL to limit the resulset set based on 2 conditions, by IP and out of that resultset, remove the rows which have nothing in 2 columns. So I have tried this but it's not producing the expected results: SELECT … |
| | Hello guys, I am trying to dynamically update a combobox using mysql database, however I get the Error Catch Message. Any help would appriciated. Private Sub cmbName_DropDown(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbName.DropDown Try dbCon = New MySqlConnection("SERVER=localhost;DATABASE=test;") strQuery = "Select name from customer_details" cmbName.Items.Clear() If DR.HasRows … |
| | So I just started learning MySQL. I am learning from [Tizag](http://www.tizag.com). They are using PHP files. Now I can see that the PHP files are slightly complex, I'm only 15. And they also recommended PHPMyAdmin. This GUI tool has many complicated options. So I quite don't know what to use. … |
| | Hi. My name's Frank. Many thanks in advance for any help you can offer me. It's much appreciated. about a yera ago I bought a gig on fiverr for a complete set up of an OS Class classified website. The original concept didn't pan out and it's been sitting there. … |
 | Hello, To Keep It Short! I'm Building Three Websites. And I Basically From What i Was Told Need To Put Images On In A Row Going Down The Page And The Images Need To Come From A Database Which Is Mysql And Im Guessing That PHP And Such. Also When … |
 | Hi Folks, I've recently started using High Charts to chart dynamic data from my database. I was on last week with an issue in relation to my column charts not rendering. I managed to figure that out with the assistance of other forum users. I now have a new problem, … |
| | My Insert statement is not working for some reason and I cannot figure out why. Any help would be highly appriciated. Imports MySql.Data Imports MySql.Data.MySqlClient Public Class frmCreateUser Dim connectionstring As String Dim dbCon As MySqlConnection Dim strQuery As String = "" Dim SQLCmd As MySqlCommand Dim DR As MySqlDataReader … |
| | Hi all, I cant get this at all. Ihave a form with a series of radio button, all which represent a category of animal. I have given each radio button a value which is the same as the mysql table it represents. For example: <input type="radio" name="delete" value="tortoises">Tortoises<br /> When … |
| | Is there anyone who can explain to me how can i store image in a folder to the server then the path to mysql. i dont know even how to get started,i will appreciate for your help. Or links where i can find the tutorials. |
| | Hello i am having problems creating an update query, I have two tables both have an Title column and one table has an ID column. I want to take the ID from the table that has it when the titles of both columns match one of the titles against any … |
 | I have created a table named student including column stu_id, stu_name & Blood_group.I created a delete button to delete rows and I used the following code when delete button is pressed.I take input using jtextfield.But this can only delete by taking input in stu_id.But now i also want to delete … |
| | I have created a table named student including column stu_id, stu_name & Blood_group.I created a delete button to delete rows and I used the following code when delete button is pressed.I take input using jtextfield.But this can only delete by taking input in stu_id.But now i also want to delete … |
| | Hi. i made a database table table and i showed it in a jframe through jtable.I want to change my column name displayed.So far i used the follwing code. private void Update_table(){ try{ String sql="select stu_id ,stu_name ,Blood_group from student"; pst=conn.prepareStatement(sql); rs=pst.executeQuery(); md = rs.getMetaData(); int columnCount = md.getColumnCount(); Vector … |
| | Hello, im a beginner at sql and i am struggling at comparing data from one table to another and then copying other data. *I have 2 tables both of which have 2 columns with the same name lets call them tableA and tableB. * tableA has a column id and … |
| | Hi guys! I'm currently making an integration of 2 different web apps. I would to ask if is it possible to restrict adding duplicate data in your table. for Example i have two different tables from two different databases. App1_Invoice (from Web App 1 database) e.g. transno name amount App2_Invoice … |
| | Can anyone assist me. I keep getting and error stating that the Column count doesnt match row 1. I have counted all of my fields and referenced all of them but still no dice. $con=mysql_connect($host, $username, $pass); if(!$con) { die("Could Not Connect: ".mysql_error()); } mysql_select_db($db); $CustLName=$_POST['CustLName']; $CustFName=$_POST['CustFName']; $CBR=$_POST['CBR']; $AcctNum=$_POST['AcctNum']; $CustCode=$_POST['CustCode']; …  |
| | Hello guys, im writing a calendar booking system and i want to populate a combobox where it will only show the time that has not been reserved based on the data inside database. The problem is, i'm using javascript to return the date when user clicked on the calendar and … |
| | Hi guys... I have this page I'm trying to get to work, but no matter what I do it doesn't want to insert a new post into the database. Help? Please? <?php //ansluter till databasen $opendb=mysql_connect("****", "*****", "****") or die(mysql_error()); mysql_select_db("*****") or die(mysql_error()); //skriver information till den angivna tabellen om … |
| | Hi I managed to get the tutorial from the below link to work. http://www.blueicestudios.com/chained-select-boxes-using-php-mysql-ajax/comment-page-11/#comment-34199 I would love to know how to edit this script so as to get the first dropdown to populate an already existing dropdown without the loader image and without the hiding of any dropdowns. I would …  |
| | it seems i can't output my username value from my database. All it gives was also a value of "username". So if i'm echoing my variable $users which is holding the rows of my username from my database, it strangely outputs "Welcome, username". I tried also with my password but … |
 | What am i doing wrong, It works when I hard code it, but when I try get the names from MySql it gives me the finger, cannot access docs OR it sends the mail wth no attachemnts is there a better way or something that I am missing, Look my … |
| | Greetings, I have two tables named 'copyright' and 'logs'. Table : copyright Field : Copyr_md5 Table : logs Field : md5checksum Problem 1 Say i have a value stored in `$md5check` in php , now i want to check if the value stored in `$md5check` is found in field `Copyr_md5`.If … |
| | I am trying to update a edit profile in mysql. the first bit of code is when the submit button on forum is hit the data in my table users willl change. the secound bit code get the user info from the database it work fine you can select what … |
 | I want to display table by default in ascendind order with dynamically changing header. Here is my code. It is displaying the rows unordered. It should be in ascending at first look and then can change by column. $order = (isset($_GET['sortCostCode']) && strcasecmp($_GET['sortCostCode'], 'desc') == 0) ? 'DESC' : 'ASC'; … |
| | Hi I have code I use to look up data from mysql, then dispaly in text boxes. For some reason ALL my data drops the words and spaces Example: if a supplier name is "DyFin (Pty) Ltd" the text box only displayes "DyFin" Example: If My phone numbers are "0860 … |
 | Below you will find my code, it's not it all in it's entirety, but shows what's important. I have some custom functions that are being used just to note out. What I have my code doing is searching a MySQL table and displaying all of the results based on the … |
| | Hi, how to pass values in mysql table from html form. give me simple examples. thanking you. |
| | Hi all, this is really geting to me now, I jsut keep going round in circles and getting nowhere. I have a form with multiple radio buttons, each button represents a category of reptile. When you choose one of the radio buttons you are taken to a page for that … |
 | i have two MySQL tables with the following structures CREATE TABLE tbldepartments ( departmentID TINYINT( 2 ) UNSIGNED NOT NULL AUTO_INCREMENT, department VARCHAR( 20 ) UNIQUE NOT NULL, PRIMARY KEY ( departmentID ) ) and CREATE TABLE tblemployees ( employeeID SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT, departmentID TINYINT( 2 … |
| | I need to make time difference of 24 hours from registed time. In my database, there is column datelog with type "timestamp" Default value: CURRENT_TIMESTAMP I need the result if user with data: 2012-10-02 14:51:41 Test1 Test 2 User must not be able to register for next 24 hours. Thanks … |
| | |
 | Hey everyone, I have just uploaded my php files onto a free hosting server and tried to access the website. I got this error " mysql_fetch_array() expects a resource in parameter 1" or something like that. By the way, the files did work on my local machine. What is the … |
| | I am having trouble trying to update my comment, well I also don't know why my table isn't displaying on my updatecomment.php page. How do you delete a comment too. If you see any other errors please feel free to fix it. Thanks in advance <!-- start dbconfig.inc.php page --> … |
| | i have a MySQL table with the following columns: employeeID, firstName, lastName, gender, salary. whenever i insert a new record for this table i want to be able to retrieve the employeeID of that record. how should i write the commands in VB.Net |
| | **Okay, first of all, I'm quite new to programming at this level. I have managed to create a dynamic administrationpanel for updating the current menues of a restaurants homepage.** ISSUE - The more posts in the table, the longer the space between the page top and the databasetable gets. I’ve … |
The End.