[mysql] Forum Topics

I have created a page which is supposed to pull some information from a mysql database and display them. Another page is supposed to save the data to the database. The problem is, that I am not even able to get the data in Persian or Arabic displayed correctly, instead …

hey everyone, actually i am creating a website in which data is queried from mysql. in mysql table one of the attributes is in form of hyperlink. When i am displaying the result it is in normal text but i want a hyperlink as the result is displayed so please …

hey please help me actually i have used the command as part of program <?php echo "<a href= echo '$Geneprocess'>$Geneprocess</a>";?> getting a hyperlink bt when i am clicking over it it gives an error for all the hyperlink.... the error is Object not found! The requested URL was not found …

Hi need some help suggestion I am trying to search data form two date range but it seems not working properly when i search for $from_date = "2013-04-01"; $to_date = "2013-04-04"; $query = mysql_query("SELECT * FROM date WHERE Date between '" . $from_date . "' AND '" . $to_date . …

I am designing my very own first web page. It's a real estate page where some users will add open house information while others can pull the info out. The code for the database and the web is very good (after two months...) and inserting and getting data is sweet. …

hi i wan to add my `.xml` files into `database` and into the directory `uploads` . i have following done into the `php` if(isset( $_FILES["f_name"]) { $path = ""; if(file_exists("uploads/" . $_FILES["f_name"]["name"])) { echo $_FILES["f_name"]["name"] . " already exists. "; } else if($_FILES["f_name"]["type"]!= "text/xml") { echo "invalid type is tried …

hi everuone i have website but i cant connect to database for login & register how can i connect? here my code <?php $connect=mysql_connect("184.154.164.202","ahmedhay_royal","xxxxxxx") or die("couldnt connect to data base:".mysql_error()); mysql_select_db("ahmedhay_login",$connect) or die ("couldnt find data base"); ?>

Hello, I'm tring to develop a mysql news scroller for my website. The problem that i'm facing is that i need to have multiple mysql querys joing together beceuase i have multple categories like: select * from news where category LIKE '$cat1' order by id desc limit 1 select * …

am doing project in c++ using mysql api i have update query like that q2<<"UPDATE `dorder` set `ddown_status`= 1 WHERE `Machine ID`= "<<"'"<<xbx4.mid<<"'"; > but when i execute it , its says Unknown column 'ddown_status' in 'field list' but ddown_status coloumn already exisits in dorder table , so any idea …

I have a form which is like a question paper. It has multiple text fields for entering a question and related information like marks allotted for that question, complexity level, tags in that question etc. I enter all this info into my db. **Tags are the keywords in that question**. …

Basically my table Itinerary table where a record can have a parent record. so table cound have ID Parent ID which can be any ID from The same table. Other details Parent ID can be null if the record doesn't have child. and if i delete the parent record of …

Guys can I connect my vb.net program to my php website's database even if I already uploaded it in a web server, is the database that will be use by my PHP is the database that I made in my PC? please help me because this is the first time …

Hi everyone I have windows form application connected to mysql database. To menage this base I use mysql.net connector. After I make some changes in datatable in my app, I use rowChanged handler to store changes in mysql. Here is code I use in handler: cmdBuilder = New MySqlCommandBuilder(dataAdapter) dataAdapter.Update(datatable) …

mysql update query not working.

Hi there, I have a classified website, built with custom PHP code. The problem is that the title of the entire site is the same. Attach files **index.php** and **pOffers.php**. Please give ideas on how to call from database the title of the listing. Tell me if you need more …

there is no file zf.bat in zend frame work2 like in the previous version ............ please any one can tell how to install it easy way and in windows

Hello All! I have a MySQL database with 4 items, id (numerical), group_name, employees, and surveys. I need to in my select calulate the percentage of 'employees' who my the number in 'surveys' have taken the survey. This is the statement I have now: SELECT group_name, employees, surveys, COUNT( surveys …

I'm working on a design for a calibration management system but, i'm stuck with designing a table or tables to accomodate this data as desscriped in the picture below.  all the numeric data in the picture should be entred by the user but, the correction is calsulated automatically …

I'm trying to get to grips with this create view thingy, but can't see it. This creats my view mysql_query("CREATE VIEW list AS SELECT AlbumId,Title FROM album, LEFT JOIN artist ON album.artistId = artist.ArtistId ORDER BY album.Title")or die ("no dice pal ".mysql_error()); that works, and creats it fine. But when …

Hope this is the correct place to put this question. i am new to linux and am runnning ubuntu 12.04. I just installed Netbeans 7.0.1 and xampp 1.8.1, both running on ubuntu. i would like to make a c++ program that uses the MySql database that comes with xampp. I …

Hi Experts, I need your valuable suggestions for research topic in mysql. Topic should have practical implemenatation part. Thanks

Hi, I'm having trouble getting the information I need from my mysql db. I need to write a query that gets me: 1. A list of all combinations of answers from 8 columns and the frequency of them. Every row contains answers from 1 person from a survey and I …

Hi all gud morning > I try in to implement table with pagination. Am using Jquery data table. In data table i have problem loading all data from database so time dealy more. so i want to implement in Ajax, jquery, Mysql. kindly gudience to me.

what I am trying to do is use this php script to load the data being submitted in the html form into my database and then populate the database into an excel (csv) file and then e-mail it to my address. Everything works great it populates into the database and …

i am still learning,pls i need help,i want each and everytime i submit to database all the html tables with value should relect in database,i mean all the table should show in the database this my posting only display one table ............help thanks $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction …

Hi, Can you set auto increment in phpmyadmin to be 2? So that it goes 1, 3, 5, 7etc? Thanks...............

I have written a code which used to send data that was saved in my mysql database, through ethernet using UDP protocol, everything worked fine until i sent fewer data(25 rows), when i started sending data in huge amount(100 rows) it used to display Java Result: -1073740791 and would stop …

hello, ive recently created a login in and register page for a website im working on and when using the register.php page to sign up, then entering the details into the login.php page all the login page seems to be doing is refreshing and removing the entered information and not …

Hello to everyone, im having trouble getting the value of a combobox in HTML to php! Frist I import data from a mysql collum into the combobox, being this the value of the combobox! I want to be able to get the selected value when I submit my form. I …

Hi I am running phpMyAdmin 5.6. I have created a table as described in a tutorial. This table is supposed to have a null value in a text field, I cannot do it, I tried everything.The examples on the web refer to older versions and I keep getting error.I even …