[mysql] Forum Topics

This script works with require_once and produces warnings for line 6 when I try to use $mysqli = new... (which I've commented out). Please help me with this script: [codebox]<?php require_once "connect_to_mysql.php"; //$mysqli = new mysqli("localhost","user","pw","db"); $result = mysql_query("SELECT * FROM example") or die(mysql_error()); echo "<table border='1'>"; echo "<tr> <th>Name</th> …

My C# program is able to work with existing MySQL and Access databases. Additionally, it will also create a new Access database if none exists. I am not able to get it to create a new mySQL database though. When the program attempts to run the ExecuteNonQuery command for CREATE …

I want to create a data file(.txt) with the data in a mysql table. (of course i did that) [CODE] try { // Create the statement //Export the data String filename = "test.xls"; String tablename = "test"; c.getData("SELECT * INTO OUTFILE '"+ filename + "' FROM " + tablename); System.out.println(filename); …

I've spent a bit of time porting my database connection over to MySQL. It's taken a bit of time, but generally been fairly easy. However, one of my insert queries is currently failing due to an auto increment ID field. I have this insert query: [CODE]INSERT INTO entries(text, name, screen_name, …

Hey! I'm quite new to this whole thing, so please don't fire me with shait on this one =D I'm trying to learn PHP and MySQL, and atm I am trying to make a website which corresponds with a database - a database with customers. 1. I want the page …

A few days ago I decided to install MySql v1.2.17 and I downloaded a client class library: MySql.Data.dll v5.0.9.0 (by MySQL AB). I included the client classes inside my wrapper class and had it creating, dropping, inserting, and deleting tables..., or so I thought. I guess I never actually looked …

how do i add an image path to a mysql table of mine which has "product image" as a field. i have saved the necessary images to images folder in root folder as well... please help!

Hi, How to display values from database into datagridview using SQLAdapter and Dataset.

Is there a way I can display an image, pdf or word doc that is stored in a my sql database? I tried to pull up a word doc with this: [CODE]$sql = " SELECT * FROM user WHERE username = '$_SESSION[MM_Username]' "; $result = mysql_query($sql); while($row=mysql_fetch_array($result)) { $inv=$row['invoice'];} ?> …

Hello all.. Very new to php and am working on an online strategy game as a precursor to my business websites. I am having a problem coming up with something I thought would be simple. My intention was to have a list of units display on the screen using checkboxes …

Hello New member and pretty ignorant about SQL I should say. I have made regular backups of mySQL database and now that I need to restore it[B] I see all the characters (UTF-8) characters have changed to wierd characters [/B]that make no sense at all. I am using [B]phpMyAdmin's Export …

hi i have two tables, one is products, the other is for 'discounts' on those products... when adding a new 'discount' i want to avoid adding two discounts to a single product... so i was looking for some sort of Right Join which would exclude all products which have a …

Hello, I am a training developer in .NET and web 2.0 technologies and this one is an exercise from one of our first lessons in PHP: accessing a MySQL database from a PHP script. The problem I've encountered is that while database is thought to be in Unicode (i.e. the …

I want to knw whether I can access WAMP 's function (of course mysql) such as export & import programatically. (I am using java) or as mysql commands??? Thanks

Hi, Is it possible to upload a file that contains some data and directly save the data in specific fields as in database using php?. this is important as the data retrieved according to their field name. Thank you.

I have 2 datetimepickers on my form, and I use them to pass parameters to my sql queries for reporting purposes. You would use them to pick a date range and display clock in times for employees. Anyway, I need an option so users can see information from a single …

Hello all, i would like to know how it is possible to remove for example last 20 characters, or by specifing the string to remove. For example i have 2 rows (in reality there are more than 100, thats why im not working it out by hand) with the next …

Ok so what does mysql return when the select query doesnt exist. So say I query the database: SELECT username FROM user WHERE username='test' AND password='test' Ok so say test doesnt exist what will the database return because i code in java and have made a method that should return …

i have a table with 14 columns and 4 rows. i know how to echo a result with a table from a query but how do i input results into a table thats already there? results go into cell 1, cell 2, cell 3 etc been having trouble on this. …

Hi! After years I decided to sign up! Can you please tell me of a bot tutorial or getting a solution to my problem. What direction should I be going. I want to make a PHP script that searches a MySQL table's columns, rows and then returns all the spelling …

I have tried several different things with none providing the correct results. Any help is appreciated. I have the following: Table A Table B Pallet_No Pallet_No Qty Qty I need to return: - All of the Pallet_No's from Table A that are not in Table B - All of the …

I did this .. [CODE] String filename = "tempoutfile.txt"; String tablename = "table1"; try{ Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Test","root",""); Statement s=con.createStatement(); ResultSet r=s.executeQuery("SELECT * INTO OUTFILE '"+ filename + "' FROM " + tablename); }catch(SQLException se){System.out.println(se.getMessage());}[/CODE] But I can't find the file that is created!! When I run the query in …

How to import file in wamp server? I have a database file named as db.opt .I want to save this file in proper location so that I can access database from wamp server..Its showing unable to access database everytime. I saved those file in wamp\bin\mysql\mysql5.1.36\data. But I cant access database …

Ok so what i want to be able to do is connect to a mysql database. Here's my code so far: [CODE] Connection connection = null; try { // Load the JDBC driver String driverName = "postgresql-8.4-701.jdbc4.jar"; // MySQL MM JDBC driver Class.forName(driverName); // Create a connection to the database …

hello plz i need help with this urgently as it i supposed to be used tomorrow :S i get this error from the following script Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/aybasuco/public_html/MySQL-Formmaker/lib/db_index.inc.php on line 42 thanks in advance for your valiable time [CODE]<?php # …

Hi All, If anyone can help me take my sql database (a single table) that information and display it in a form on my web page. Sometimes the Sql request will be multiple lines of the table. I have my database created am completely lost in the form view or …

Hi. I have a web application whereby I perform a search through 4 fields, namely:book serial no.,tel no.,gender and publishing date.In my jsp page variables picking the values respectively are:serial,tel,gender and datez.These are submitted to the java class.Currently, I perform my searches as follows(in java class): /***********************************************/ [code=Java]//......after connecting to …

Hi! I have a form with two dateTimePickers (first with date of one month ago, and the secod with current date), a dataGridView and a button. When i click the button i want to populate the dataGridView, but only between date1 and date2 [CODE] mySqlCommand = con.CreateCommand(); mySqlCommand.CommandText = "SELECT …

Hi Guys, I'm new in PHP. I not familiar with it. Now i need to ask about the PHP Now i working we a program that have a login function and can allow admin to change or update the data. The users van view the info only without change it …

hey.. i have a table with one column defined as SET somethin like (a,b,c) does anybody know the sql query to be run inorder to get elements like a b c all seperately so as to save it in an array in php script..??

i m getting this bug.. and i still cant understand why this happening..?? here is my php code [code=php] $query1 = "call new_user('$cardDigits','$cardNo','$amount','$traiff','','','','','$creator',@_lastname,'$customer','$firstName','$email','0','0')"; $result1 = mysql_query($query1) or die('query_error'.''.mysql_error()); $lastname = mysql_fetch_row($result1); // Generate New User $query2 = "genrate_user('$lastname[0] ','$creator')"; echo $query2; $result2 = mysql_query($query2) or die('query_error1'.''.mysql_error()); [/code] Procedures are working …

I know this forum isn't for databases but I couldn't find a proper one so i post here. (my original post is at forums.mysql.com, but not much seems to be happening there) can MySQL server be started as a globally accessible server by using libmysqld? For example, can a application …

I have an HTML form with checkboxes. Based on the checkboxes that are selected I'm trying to contentate a query string so the select checkboxes are inserted in an IN clause in my SQL statement. I'm recieving an error that is telling me something is wrong with my sql statement. …

hi all how are u? i have a problem and i need your help ..i have a code in java that connect to a mysql DB and update the rows of the table ...but i have a problem ...the new updated column called (original_text) contains the updated columnss from the …

I have made stored procedures in Oracle...but need to export them to mysql. I have searched on google but cant figure out the syntax. Here is the oracle procedure: [code=sql]create or replace procedure delgroup (g_id in number) is begin DELETE FROM grouptable WHERE GROUP_ID=g_id; commit; end;[/code] I jus basically want …

JSP is a new world for me, since 3 days ago. I am having a problem (or I have no idea) how does the inserting datas into database works. I have looked at some examples, but still, im having a hard time. I know PHP and ASP, but JSP is …

hai,,,,,,,,,,, i completed my B.E cse and i completed my php and mysql course and am looking for an job, so anyone help me,,,,,,,,,,,,,,,,,

Hello, I have a two tables created to apply keywords to a given entry: Table: File FileID (int, pk, auto incr) Name (varchar) Table File_Keyword KeywordID (int, pk, auto incr) FileID (fk) Keyword (varchar) Given that I have a record in table File with 2 corresponding records in table File_Keyword …

Hi, I tried to restore my decompressed database [B]'cyberview_db_2809_2009-10-27_17h30m.Tuesday.sql'[/B] using the command : [QUOTE]mysql -h localhost -u root -proot123 info < /backups/daily/cyberview_db_2809/cyberview_db_2809_2009-10-27_17h30m.Tuesday.sql[/QUOTE] but there was no restoration. I checked the [B]/var/lib/mysql[/B] directory where all restored databases are located, and in the 'info' folder, the only script that was available was …

Hi, I was wondering if it is possible to connect a C++ program to a MySQL database on Linux Fedroa Core 5 os. It would be great if I could create a program in C++ that allows me to create a completely new database in MySQL, edit, modify, delete and …

wats roang in here .. [LIST=1] [*]<?php [*]ini_set('display_errors', 1); [*]//connecting to database [*]$error = "nu am putut sa ma conectez :("; [*]mysql_connect('localhost','root','')or die ($error); [*]mysql_select_db('dan') or die ($error); [*]//max display pet page [*]$per_page = 2; [*]//get start variabel [*]$start = $_GET['start'] ; [*]//cont record [*]$record_count = mysql_num_rows( mysql_query("SELECT *FROM news")); …

Hi, I am getting 3 warning messages below: Warning: mysql_free_result() expects parameter 1 to be resource, null given in J:\xampp\htdocs\propertypages\resultsForSale.php on line 660 Warning: mysql_free_result() expects parameter 1 to be resource, null given in J:\xampp\htdocs\propertypages\resultsForSale.php on line 662 Warning: mysql_free_result() expects parameter 1 to be resource, null given in J:\xampp\htdocs\propertypages\resultsForSale.php …

I have be struggling to turn the below while loop into a foreach loop with no result, so I am asking for help here on how to do this. [code] $query = "Select * from TIME_TABLE Where Extract(month from DATE_FIELD ) = DATE_FORMAT(NOW(), '%c') and Extract(day from DATE_FIELD ) = …

VC++ access MySQL query problem Hi guys, Could you help me out with ------------ string str1 res=stmt->executeQuery("select * from test2 where english='str1'"); ------------ anyone can tell me where is wrong with this query code?below is the error msg I got: 1>.\temp6.cpp(48) : error C2146: syntax error : missing ')' before …

Hi all, On compiling, i get no errors at all, the data is taken, but when checking the database, a record is made, but it is NULL. What have i missed? [code] /* * To change this template, choose Tools | Templates * and open the template in the editor. …

Ok l am coding a simple PHP & Mysq session based athentication. l have done numerous of these before with success. Sadly this one cant run,. Someone pliz send me the correct code.

could someone point out the error in the followin php/mysql code [code=php]$strSearchVal = $_GET['q']; //database connection.. //... $strSQL = "SELECT DISTINCT area FROM hospital where area like '%'+ $strSearchVal; "; $result = mysql_query($strSQL); while ($arrThisRow = mysql_fetch_array($result )) { echo '<li>' . $arrThisRow['area'] . '</li>';[/code]

This is my Stored Procedure DELIMITER $$ [code=mysql] DROP PROCEDURE IF EXISTS `call`.`sp_login`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_login`(userid varchar(50),pass varchar(50),out chk int(11),out user_alias varchar(50),out user_tariff varchar(50),out c_credit decimal(15,5),out r_reseller varchar(10),out r_level varchar(10),out c_tariff char(2)) BEGIN select id into chk from cc_reseller where useralias =userid and uipass=pass and level!=0 and activated!='0'; if(chk!="") …

Hi, I want to create script like in facebook. When we log into facebook, go into any friend's profile Their gift button , show gifts with pagination. when click on image and ok button it save into database. Any sample demo script ? How to create script like this? Please …

Hi everyone, I sat down to create a what I thought was simple SQL query but once I got thinking about it I realised I'm not sure where to start. The objective is to return two resorts from a Resorts table for each country code in that table. Countries table …