[mysql] Forum Topics

Hi all, I'm trying to insert an array (which I've decoded from a JSON object) into a mysql database (for the first time!) and keep coming back with a "Could not connect - Column count doesn't match value count at row 1" error message. My server and database connections are …

Hi! I'm start learn php and i have few problems what i can't fix it. Before i say what is my problem, YES i have search for my problem in google and other. So my question is how to make 1)table with few data column and after few column i …

How to insert jsp testbox values in sql database in button click plz help

I have php code running fine from the server. but if i use any mysql functions e.g. [CODE]mysql_connect()[/CODE], the server does not render the page. it keeps on "waiting for localhost...". what could be the problem.

[CODE]if(isset($_POST['addreservation']) and $_POST['addreservation'] == 'Add'){ include $_SERVER['DOCUMENT_ROOT'] . '/TattooSite/include/db.inc.php'; $username=$_SESSION['username']; //Geting the id of loggedin client $result=mysqli_query($link, "SELECT id FROM client_tbl WHERE user_name='$username' "); if(!$result){ $error='Error identifying user ' . mysqli_error($link); include $_SERVER['DOCUMENT_ROOT'] . '/TattooSite/include/error.html.php'; exit(); } $row=mysqli_fetch_array($result); $clientid=$row['id']; //Geting the values generated in reservation form $id=mysqli_real_escape_string($link, $_POST['id']); $tattoo=mysqli_real_escape_string($link, $_POST['tattoo']); …

Hi, I have a table storing score and level information of a user. Both are integers. Level value depends on score and mapping is not expressable as a mathematical function. There are min, max values of points for every level. Please help me to design the dabase table. My problem …

[CODE]<?php //This checks to see if there is a page number. If not, it will set it to page 1 if(isset($_GET['pagenum'])) { $pagenum = $_GET['pagenum']; } else { $pagenum = 1; } $var1 = 'gene_name'; // When user click the submit button if(isset($_POST['submit'])) { //if(isset($_GET['page'])) //{ if(preg_match("/^[a-zA-Z0-9]+$/", $_POST['keyword'])) { $keyword=$_REQUEST['keyword']; …

Hello all! So in my app, I have 5 columns, firstname,lastname,membership,accountid, and date. Once a members card has been scanned, the app figures out if that member is in my sql table or not. If he/she is, it will update their 'date' column in my dgv. If he/she is not, …

So heres my problem: I have a datagrid w/ 5 columns(ID, firstname, lastname, Membership, Date). My app takes a 5 digit number from the user and with that number populates my datagrid with the members information. My BIGGEST problem is trying to check to see if the member is already …

Hi everyone, Having a little difficulty getting anything from this. The code appears to me to be correct, then again I have been looking at it for hours, so it is possible there could be a mistake...... :/ Anyway, the code seems sound, should let me login and instead gets …

Hi, I am following the chapter on Replication from the book High Performance MySQL. There it is written that I need to enable binary logging and specify a server ID for my MySQL server. It instructs me to write (or verify the presence of) the following lines in the master’s …

I'm trying to pass a word that has the char ' or " in the middle of it. it's one of the fields in a form, so when I submit, the next page gets only the part of the word before the " or ' char. I tried using mysql_real_escape_string() …

Hi There, MySQL is not my strong point so any guidance or advice will be greatly appreciated. I want to know what's the best way of linking multiple MySQL tables together. I have +-10 tables that will interact with each other. Example Tables : users, logins, communication, sightings etc. When …

The below coding is the javascript coding in which i have used [B]AJAX coding also[/B].its only pagenavigation coding. [CODE]function change(which) { if(which=="page1") { document.getElementById(which).style.borderBottomColor="white"; document.getElementById("page2").style.borderBottomColor="#778"; document.getElementById("page3").style.borderBottomColor="#778"; document.getElementById("page4").style.borderBottomColor="#778"; } else if(which=="page2") { document.getElementById(which).style.borderBottomColor="white"; document.getElementById("page3").style.borderBottomColor="#778"; document.getElementById("page4").style.borderBottomColor="#778"; document.getElementById("page1").style.borderBottomColor="#778"; } else if(which=="page3") { document.getElementById(which).style.borderBottomColor="white"; document.getElementById("page4").style.borderBottomColor="#778"; document.getElementById("page1").style.borderBottomColor="#778"; document.getElementById("page2").style.borderBottomColor="#778"; } else if(which=="page4") { document.getElementById(which).style.borderBottomColor="white"; document.getElementById("page1").style.borderBottomColor="#778"; document.getElementById("page2").style.borderBottomColor="#778"; …

Dear All, I have a table tblEventAlert as below. So what happens when the data gets insert into this table the problem is that the eventAlertID is autoincrement. Then below it I have another table. My problem is that I want the eventAlertID to be stored into the tblSCvData. I …

what's wrong with my code? i'm new to java, can someone help me? the data is not showing. [CODE] public class GUI { private static JTextField fname = null; private static JTextField lname = null; private static JTextField search = null; private JPanel panel = null; private JPanel tablePanel = …

Hi all, So I have 2 files where one is an ajax script that calls another file that does some mysql database query. What is the best way to echo out multiple recordset rows to ajax?. Please see the source code below: ajax code: [CODE] <form name="form1" method="post"> Please enter …

Dear team, Please explain, which one will be faster in Mysql for the following query? SELECT * FROM `userstatus` where BINARY Name = 'Raja' [OR] SELECT * FROM `userstatus` where Name = 'raja' Db entry for Name field is 'Raja' there is no key for the field. I have 1000000 …

I want a ready made database of the countries all over the world, the major cities of those countries and their time difference (in hours) from GMT. Please tell me where to get it. I need it soon.

What im doing is i have a form with 4 inputs like below. and im using the post method to store the fields values so i can send them to the database. what i neeed is each input to be put into a separate row in a databases table. also …

Dearest VB GuRus, thanks for all your contributions. this time, I have a problem and I need your magnanimous assistance and contributions. I have developed a a VB Cash-expense application and I am designing a Database using MS-Access to be used as back-end. I am confused on which fields should …

Hi folks. I'm looking for a bit of help and guidance on what you think would be the most suitable DB for a project I'm working on. This isn't a web-based project but as I couldn't find a more suitable sub-forum to post this query, I thought I would ask …

$user['username'] = name of the table producttotal 500 6105 131 [CODE]$ordertotal = mysql_query("SELECT SUM(producttotal) FROM ".$user['username'].""); echo "Order total: ".$ordertotal;[/CODE] why is the result "Order total: Resource id #7". I wanted to sum all the values below producttotal column. Thanks in advance.

hi to all.. just a new member here & also a beginner in VB.NET.. we were assigned to make a payroll system and we've done most of its part.. but still there are big problems: computation of tax and print employee information.. well, the employee information is really long so …

banner_manager.php [CODE] //Cek apakah ada file yang diupload if((!empty($_FILES["uploaded_file"])) && ($_FILES["uploaded_file"]['error'] == 0)){ $gambar = uploadPicture("uploaded_file"); } if (empty($id)) $sqlstr = "INSERT INTO banner(link, gambar) VALUES('".$link."','".$gambar."')"; else $sqlstr = "UPDATE banner SET link = '".$link."',gambar = '".$gambar."' WHERE id =".$id; $result = mysql_query($sqlstr) or die(mysql_error()); $confirmation = ($result)? "Data telah …

php and mysql form Hi all, how I can add values ​​in a table to a combo box in html .. eg: the user's table has the id 1,2,3,4 and that using a query, being able to move to a combo box, to make a selection of id?. Greetings and …

[CODE]<form action= '1stform.php' method = "POST"> <fieldset border = "5"> <table> <tr> <td>Check Availability</td> </tr> <tr><td> <p>Garden Room: </label> <select name="room_GR"> <option value="0">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option …

Hi, i have written a section of code for my website and i have been trying to get it to work but whatever i try it will not work Here is the code [CODE]$upgrade_user = mysql_query("SELECT * FROM user_info WHERE id='$id'"); while($row = mysql_fetch_array($upgrade_user)){ $real_balance = $row["$balance"]; $real_rank = $row["$rank"]; …

Hi Friends, I created one database like credit card statement. Purchases all in one table. Debited all in another one table. I am trying to link two tables using with inner join. But its repeating the data depending on purchases record count. Table1 = Purchases Table2 = Received [COLOR="Green"]SELECT * …

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 …

input_berita.php [CODE] $id = isset($_POST['id']) ? $_POST['id'] : ''; $confirmation = isset($_POST['confirmation']) ? $_POST['confirmation'] : ''; $kategori = isset($_POST['kategori']) ? $_POST['kategori'] : ''; $isiBerita = isset($_POST['isiBerita']) ? $_POST['isiBerita'] : ''; $judul = isset($_POST['judul']) ? $_POST['judul'] : ''; //Load berita if (!empty($_REQUEST['id'])){ $result = mysql_query("SELECT * FROM berita WHERE id =".$_REQUEST['id']) …

...hello there....i really need help.. ..i'am now working on a web-based student information system through the use of PHP and MySQL... ...but i know that before i can go through the coding part...i have to study first about its business process...... ...the SIS that i've been working was divided into …

I need to update the SQL table every minute, as if typing on an online notepad, that save frequently. So of course, I have: [CODE]<textarea rows="20" cols="80" id="notepad"> <?php $con=mysql_connect("localhost","username","password"); if(!$con) { die('Could not connect: '.mysql_error()); } mysql_select_db("database", $con); $result = mysql_query("SELECT * FROM Notepad"); while($row = mysql_fetch_array($result)) { echo …

Basically, I make a query based on the first query that I made. It returns the right number of rows but it only displays the first record based on the number of rows. For example, if my second query returns Result1 and Result2, the table will look like Result1 Result1 …

Hi i just want to know that how to connect php with sql server..because i have database in my sql server.... regards.. Farhad

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 …

I am building a plant reference guide that pulls from two tables within a mysql db . One table "findplantsdb" has the plant name, desc, image and the other table "plantdb" has the availability of plants listed in the yard and field. I need both databases to come together (JOIN) …

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) …

Hi, can i ask some help on how to delete records in database.im using wampserver... I retrieve all rows and display it on the table which is php code and i want to delete rows if i will click the delete in the table...is this possible?please help me... [CODE] <?php …

news_manager.php [CODE] //LOAD KATEGORI $result = mysql_query("SELECT * FROM kategori_berita ORDER BY kategori ASC") or die(mysql_error()); ?> Pilih Kategori Terlebih dahulu <select name="kategori" onchange="submit();"> <?php if (empty($_REQUEST['kategori'])) echo '<option value="" selected="selected">--Kategori--</option>'; while ($data=mysql_fetch_array($result)){ ?><option <?php if ($_REQUEST['kategori'] == $data['id']) echo 'selected="selected"' ?> value="<?php echo $data['id']; ?>"><?php echo $data['kategori']; ?></option> <?php …

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 all i have a new problem that needs some solvin I'm trying to add data sets to Google's Javascript Motionchart from my SQL database via PHP Here is what i have so far: [CODE] <?php include "conn.php"; // Select all the rows in the markers table $query = "SELECT …

Dear all, I have created a webpage and a SQL database runs in the background. When user enters options in the query page of my webpage, they get some tables with results. I want to provide an option to the user to download the results in tab-separated, tabular (excel) and …