10,938 Topics
 | |
| | 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 … |
| | I'm creating my class for mysql in which i have difficulty dealing with the parameters of which to use with prefix '@param' or '?param' or whatever it is. I need your help guys. I have here my stored procedure [code] DELIMITER $$ DROP PROCEDURE IF EXISTS `davidssalon`.`Customer_SearchName`$$ CREATE DEFINER=`root`@`%` PROCEDURE …  |
| | Hi i am a beginner in php and mysql.... I have a made a database for registration of a customer in shrare market.... Now what i want to show at the front end is the the person who is entering information has a choice to select from a company through … |
| | Hi , I want help in designing a Bonus System Database. I am planning to organize contests on my site where in users will have to answer some 10 questions , and at the end of each day users points will be calculated, based on there answers. Prizes can be … |
| | Azul(Hi) i created program on php where i can output data set of any table by submitting query. i need help to input i mean to load data into the table from the HTML file can any one give help please thank you. this is the program i created, so … |
| | Hi, How to export the data from the sql server 2000 to mysql ....Please help me.I had no idea Regards, santhanalakshmi |
| | I have eight tables with the same schema but containing different data: `node_a_data` ( `node_a_data_id` int(5) NOT NULL auto_increment, `timestamp` int(10) NOT NULL default '', `user_count` int(5) NOT NULL default '0', PRIMARY KEY (`node_a_data_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=795 ; The timestamp field just contains a Unix 10 digit timestamp … |
| | i am designing a site...under xampp with php...now,i have a table called link where i want to link some special links by fething it from database...but my problem is when i open it ....it happens something like below... suppose I give a url "www.intel.com" in the database by hyperlinking a … |
The End.