11,093 Topics
 | |
 | Hi. I am having problems getting PHP to insert data into a MYSQL data base. I am using the following variations of syntax. [code=php] mysql_query("INSERT INTO table member VALUES ('$var1', '$var2', '$var3')") or die("couldn't add new user"); [/code] and also with session variables as well [code=php] mysql_query("INSERT INTO table member … |
| | Hi I need to store binary data in a MySQL database from a web page. Basically it the web page will ask user to upload an image, and on submit, it should store this image in a MySQL database on the server. Could someone please let me know how to … |
| | ok so this is what im trying to do. this is a products page and the products diplay but i want to create a filter so if they want to view only the in this case tvs that are sony they use the from that is in the coding to … |
| | Hi, I want to update a specific field in my database. My database has only one row with one field in it. How do I overwrite that field? This is what I have at this point, but its not working: [CODE]mysql_query(UPDATE Table SET column = "$item" WHERE column = "1") … |
| | Hi, This T-SQL works fine but i just want to make sure that it is also reliable. Do you think this is reliable? Thanks [code] CREATE DEFINER=`root`@`localhost` PROCEDURE `addNewUser`(IN username_in varchar(15), password_in varchar(40), name_in varchar(25), surname_in varchar(25), dob_in date, address_in varchar(50), postcode_in varchar(8), city_in varchar(20), phone_in varchar(14), email_in varchar(50)) BEGIN … |
| | hi everyone. please tell me difference between mysql_connect & mysql_pconnect? and which is better and how? |
| | Hello, I'm a bit new to VB (actually use VBA), but would like to get some knowlegde about class module. One thing I was thinking of would be to create a class module which take cares of the connection to the MYSQL database. Please let me know if you have … |
| | [CODE]<? include("db.php"); mysql_connect($host,$username,$password); @mysql_select_db($database) or die("Unable to connect to database"); $query="SELECT * FROM tcg"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<center>Viewing Records</center>"; $i=0; while ($i < $num) { $client = mysql_result($result,$i,'ClientsName'); [B]$prgno = mysql_result($result,$i,'PrgNo'); this is line31[/B] $prgname = mysql_result($reslt,$i,'PrgName'); $trainername = mysql_result($result,$i,'TrainerName'); $dates = mysql_result($result,$i,'Dates'); $days = mysql_result($result,$i,'Days'); $proffee = mysql_result($result,$i,'ProfFee'); …  |
| | Hello, I'm getting an error [B]"Column count doesn't match value count at row 1"[/B] [CODE] <? include("db.php"); $ClientsName=$_POST['client']; $PrgNo=$_POST['prgno']; $PrgName=$_POST['prgname']; $TrainerName=$_POST['trainer']; $Dates=$_POST['dates']; $Days=$_POST['days']; $ProfFee=$_POST['fee']; $TrainerFee=$_POST['trainerfee']; $ReimbExp=$_POST['rexp']; $HandoutChg=$_POST['handchg']; $InvoiceNo=$_POST['invno']; $TotalInvAmt=$_POST['invamt']; $FeeRecd=$_POST['feerec']; mysql_connect($host,$username,$password); @mysql_select_db($database) or die("Unable to connect to db"); $query = "INSERT INTO tcg VALUES('$ClientsName','$PrgNo','$PrgName','$TrainerName','$Dates','$Days','$ProfFee','$TrainerFee','$ReimbExp','$HandoutChg','$InvoiceNo','$TotalInvAmt','$FeeRecd')"; mysql_query($query) or die(mysql_error()); mysql_close(); echo "Data …  |
| | I had a mysql table with a field named "age". And I need to search it using php form. ie with two text fields called "age_from" and "age_to". In simple words i want to do a search like this... [code=sql]search * from profile where age>= age_from and age <= age_to …  |
| | hello all, i need help with php/mysql syntax that will search a mysql dbase using 3 user-provided (from web form) options. All options are contained in drop-down menus. the mysql database has an auto column which is the primary key allowing for duplicate entries which are neccesary the table has … |
| | hi, how to find and open the backup file .sql in mysql... |
| | Hi, I am thinking to create an e-commerce web site. I just want to find out about the logic behid processing the order that have more than one order. How do we place an order? Stock check and update before and after placing order. I am asking this question because, … |
| | Hello, My brother asked me to create an application where he can save all his data and retrieve at any time, which does all the calculation. A friend of mine suggested PHP and MySQL would be a better option. I know HTML and CSS but very little of PHP. As … |
| | when i install mysql, my computer keeps restarting I can't even uninstall it! i fixed it by logging into Safe Mode and do a System Restore. MSQL is now uninstalled, so it's fine now. I want to have MSQL working. - using XP SP2.  |
| | Hi, I am not sure what i am doing wrong. I got my code (below) basically it is to resend user activation email if they for some reason or other did not get it first time etc. It sends the email and everything etc... what i need to do it … |
| | Hello everyone. I'm now working on a banner software which allows admins to see full statistics of banner displays, clicks and other information in selected time interval by minutes, hours, days etc. I want to consult any experts who have experience using large tables with JOIN queries and optiomize my … |
 | the most important thing is that people cant access the members only page without loggin in first. the second most important thing is actually loggin the person in and being able to like store a session i guess thats what it is that makes it so they can visit thir … |
| | how to take back up the mysql data as an sql delimited file ie .sql file by using c# from a windows application  |
| | Hello guys, A Client walked upto me, and told me he wanna create a SMS portal where by user can by a Card from him and log in with a secret Pin on the card and they can login to the website and with th Issue Card and they will … |
| | Hi, How to connect visual basic program with mysql database?I need a sample program of retrieving the data and also inserting the data into the table using mysql database..........I dont have any idea..... please help me ....... Regards, Santhanalakshmi. |
| | hi guys, I have one table: exams(e_no integer primary key,e_name text); now i want to create another table called questions which should have primary key that is combination of exam.e_no (foreign key) and question.q_no questions(q_no,e_no,questions text); so i would like to make q_no and e_no both act as primary key … |
| | I summarised my problem by a simple example,anyone plzz ans this...then I will be able to understand my problem.......: Suppose in a database named "DATABASE"..there is a table called "XYZ"..it has 4 rows named "T1,T2,T3,T4"..one primary key named "T_id"..now what I want that to access this same table via different … |
| | Hi, Don't know why but i always seem to mess my, mysql querys up somewhere, usually silly things like quotes etc. The code below, i have a problem. Basically when user gets an email they click the link and they are taken to a page where they can change there … |
| | Hi, As you can probably tell by now my knoweldge of MySQL is not very good. I basically have two tables. One called [B]userinformation[/B] and another called [B]profiles[/B] My userinformation table is like this: [CODE]CREATE TABLE `userinformation` ( `id` int(11) NOT NULL auto_increment, `status` varchar(20) NOT NULL, `username` varchar(20) NOT … |
| | Hi Story goes - I have an online store... there is a sales table which records every product sold. Each product is within a style. So a Style might be 'Red Jacket'. I want to pull out (from the sales table), in order of how many sales have been made, …  |
| | how i use apache server, php, and MySql .Tell me the procedure for installation of Apache server, PHP, and MySql  |
| | I have two issues. I have simplified the tables involved. Issue1. advertisers is a table with two columns unique id and name views is a table with two columns id and advtid msgs is a table with two columns id and advtid How do I fetch only those advertisers who … |
| | Hello everybody, I have this text file, and when I import them into mysql through phpMyAdmin, everything is ok, but the persian (Farsi) not shown correctly, also I use ' utf8_persian_ci ' collation, can anyone kindly plz convert this file into MySQL that farsi data shows correctly too? NOTE: farsi … |
| | Hi all! So I've been reading about the "FOR XML AUTO" function which sounds great, but it hasn't been working when I try it in phpmyadmin. I get an error in the area of "FOR XML AUTO", I know SimpleXML is disabled on my package but would that be why … |
| | Hi to all ! Im new to java n i m working on Project of Web base Image Annotation Tool using jsp and java i have to save n retrieve image in to database which im using is mysql How i can store image in to database not the refference … |
| | hi all Database Masters Here i have suffer one critical issue,i have two column a and b, Table name : Student "A" "B" "1" "SAntOsh" "2" "SAuraV" "3" "SAriya" "4" "SAnju" "5" "SAthiYa" These are the sample records from my Table field. The "B" column always start with 'SA', the … |
| | Hi, I am trying to display the users email address when they login to there account on there profile page.. I have successfully done this for there username as i use $_COOKIE to display the users name with the DB. Problem is i am not sure how to do it … |
| | Hi, I have installed the **mysql connector ODBC 3.51** on the remote machine as well as on the local machine. Mysql Connection with VB.Mysql Connection on the local machine its working fine. cn1.ConnectionString = "driver={MySQL ODBC 3.51 Driver};server=localhost;database=dummy;data source=dum;Option=3" When i trying to connect the mysql from the remote machine … |
| | Hey, I've just started using mysql and I have som problem with JOIN. I have table1 and table2 and I would like to join these two on table1.col1 and table2.col1 to eliminate all identical rows. In addition I need to have a WHERE statement on table1. This is my attempt: … |
| | Hi guys, I've been using asp.net 2.0 over the past 2 years making simple web applications but have never used it with MySQL. I've been asked to create a website for a relative. The site will be a vehicle leasing company. After speaking to owner and understanding his requirements i … |
| | Hi, I have been trying to find a way to get my databases on two external hard drives plus one internal hard drive but I just can't find a way to place each database on a separate drive. The only thing I have come across is windows junctions but can't … |
| | Hey all this is a pretty simple question, basically I connect to a mysql database, and iterate a list of names like this: [CODE]$result = mysql_query("SELECT * FROM Students"); echo "<table border=\"1\">"; while($row = mysql_fetch_array($result)) { print " <tr> <td> " . $row['Student'] . " </td> <td> <form name=\"FRMdelete" . …  |
| | Hi guys, I know what I need, but not sure how to do it.. a) Store values in a database field like: 12|3|43 b) How to retrieve these values as seperate variables. Appreciate any help! :'( Thanks |
| | Hi!, I am trying to update record but an error is coming. Can any one help. [B]error is - mysql_numrows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\xampp\Test\Report\Despatch\update.php on line 10[/B] [B]here is the script[/B] <? $id=$_GET['id']; $username="root"; $password="mysql"; $database="service"; mysql_connect(localhost,$username,$password); $query = "SELECT * FROM contacts … |
| | |
| | I am trying to do a simple MySQL query using my db class, but for some reason I am having issues with getting the query through using my db class. If I hard code the db call bypassing the class, it works fine. Here is the class: [CODE=php]<?php //////////////////////////////////////////////////////////////////////////////////////// // … |
| | [B]I am trying to insert a new record into a mysql database and get the following error:[/B] 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 '30, 60, 90, DayCreated) VALUES ( 'Rush Shirt', … |
| | |
| | <?php include 'dbconnect.php'; $query="select * from pnmsg;"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $msgs=$row[0]; } echo $msg; include 'dbclose.php'; ?> THis is my code and am working in my local machine it give the same error Anybody help . I could not find any mistake in my code |
| | Dear members, I am after some help with a script I am trying to write/use! I am currently re-designing a website for an animal charity for which they would like to add a section in the members area where people can upload their own photos of their animals/pets. I have … |
 | i have 4 input box of credit card number and 2 boxes of credit card expire date month and year and one for the card holder name i have some code but is it ok or i have to do some thing else [CODE=LANGUAGE]<?php $connection = mysql_connect("localhost","root","password") or die("error connect"); … |
| | I am using mysql as backend in my windows project, some times one of table gets stucked and application also gets stocked after restartin mysql server it will be alright , any alternative solution for this problem... Thanks in advance |
| | Hi, I wonder if someone could help me please. I basically made a registration form and need to insert the data into the database. I am not sure how i use the MySQL functions to do this, I created a db connection file and included it on registration page but … |
| | Hi everyone, I have PHPAuction XL V3.1, please may someone help me. I have managed to create the auctions but i cannot bid on them, the following error comes up: update PHPAUCTIONXL_auctions set current_bid=20, starts=2009-05-01 18:21:29,ends=2009-05-02 18:21:29 where id="1336eca400908b7a04133d27be69e27e" You have an error in your SQL syntax; check the manual … |
The End.