10,940 Topics
 | |
 | 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 … |
The End.