11,093 Topics
 | |
| | I want to find the percentage for each question’s answer and how many user response to that question The answer either yes , no, escaped (null) Table structure :[CODE] CREATE TABLE useranswers ( userAnswerID int(10) unsigned NOT NULL auto_increment, answer varchar(45) default NULL, userType varchar(45) default NULL, ques_tesxt varchar(300) default … |
| | hi, i need some help on inserting checkbox values into the mysql database. what sort of data type should i use for mysql to store these? for example i need to insert a few hobbies as checkbox 1.basketball 2.football 3.hockey i need to be able to perform a search and … |
| | Hello, I am currently designing a site that displays photography, and am exploring the different ways in which to do this. I am trying to develop, using PHP and MYSQL, a way of having image links held in a database and then the first image in sequence to be rendered … |
| | hey all i got a question where i am not sure that it will be possible. i already have my table in my data base which has values in it ex: first_property. and i made a little script which helps me grab all the names in the form that i … |
| | Hello everyone, I wrote this AJAX script to process a php file to remove data from a MySQL database, but for some odd reason it isn't working so I've come here for some help, hopefully someone on here will be able to guide me to solving this issue :) Here's … |
 | Hi All, I am trying to display the content of a single row from MySql with the following code but the echo is displaying nothing at all. Please can you advise as to where i can find the error? I have a feeling its something to do with the loop, … |
| | Hi friends I have some names and address in macro excel.how can i import the values which are present in the macro excel to the mysql through php thank you |
| | I've a example text file below. I need to pass this data to mysql. and can anyone help with this. I figure out the way of connecting database, and the thing I am suffering with is transferring below data to mysql actually factors are arbitrary so do choices, so I … |
| | Hi All, I am trying to echo the held text in the "Title" field where the id has a fixed value of 1, but i am getting the following error: supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 46 your help would be greatly appreciated. … |
| | When I fetch the records from the LIKE the query returns no results but when I fetch records from the equal to (=) then the query returns results. Following user name are stored in the database: (1) `~@#$%'\|/?.><^&%@()-_+-: (2) (){}[]|\/?"*&^%$#@sujeet` I am searching the records from the LIKE operator as … |
| | [code] <?php include('./Connections/hostgator.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; …  |
| | hello can any 1 give me the idea if we use single web page for both admin and user then how to hide admin priviliges from user?? |
| | so i have this code on 3 different pages... and i'm kinda a newb... can u please help. the script is suppose to let someone select a $manufacturer... then from there select a $model... and then finally see the $notes for that model. The script works until it gets to …  |
| | Hi, I have 3 sentences in table. These are the sentences. [code] Spatio-temporal tracking and phylodynamics prm. These are prM based values. All MR values are greater intensity than PRM vales. Values specified are equal to PRm values and PRM-lacZ. [/code] If user specifies the query like this: prm* i … |
| | Ok help please , cant get my head around this .... i need to build a database that will hold the following : width x drop = price what i actually want to do is a quotation form for my website where the costumer will input the width and the … |
| | I have a form which allows for the user to pick ZERO or MANY items. I was hoping when I SUBMIT the form, all the values would update in the field. Here is the form code: [code=html]<tr> <td><div align="right">Instruments:</div></td> <td width="116" align="center" valign="middle"> <div align="left"> <select name="Instrument" size="5" multiple="multiple" id="Instrument"> … |
| | Hi all, I have a table in which i have 2 columns.i.e. name and ID number as Table1 -------------------------- Name || ID number -------------------------- Mark || 204 Roger || 207 Ronny || 209 Robert || 309 mac || 390 black || Mark || Roger || Mac || Mark || Ronny …  |
| | Hello. I am trying to understand how to solve a problem I have run across involving self-referential tables. The table stores the name and various relevant details about musical artists. One detail I want to be able to list is the artist's influences. The artist's influences are themselves artists. And, … |
| | Hello. Im getting this error on a product page on my website Quote [QUOTE] 'Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/supremew/public_html/catalog/osc/products_new.php on line 89'[/QUOTE] [code] ?> <tr> <td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?>" valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_id']) … |
 | Why is installing MySQL on Windows Vista such a bear? For someone who is not a professional database administrator, it seems like I am jumping through hoops. This page [url]http://forums.mysql.com/read.php?11,200958,204223#REPLY[/url] pointed to this page [url]http://www.sqlservercentral.com/blogs/brian_kelley/archive/2008/04/04/installing-5-0-51a-mysql-community-edition-on-windows-vista.aspx[/url] which suggests this page [url]http://port25.technet.com/archive/2007/03/16/mysql-on-windows-configuration-install.aspx[/url] which points to this beautiful pdf file [url]http://port25.technet.com/videos/research/MySQL_Windows.pdf[/url] Ah, now … |
| | I am trying to search for something in the database. However, this error keeps popping up. I was wondering if anyone could help me. Thanks [code=php]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <? $host = '127.0.0.1'; $database = 'lab11'; … |
| | I am using a function in php for all select queries so that i can dynamically retrieve data from my database ..... I just wanted to know that is my code secure and efficient or if their is a better way to do this, if so please point me to … |
| | Hi All, it's me again :) How can I attach MySQL to my ASP.Net application? I want to create user table in MySQL and then use the login controls in my application to give the user access and different roles? Thanks in advance! Donish |
| | hi all - can anyone help with the following - I am unable to upload any data to my database - I can connect successfully as i have changed the password, database name and got the error's i was expecting. but for some reason, the data just doesn't seem to …  |
 | First off, let me state that I have read the FAQ about this error, and have tried all the fixes, with no success. If anyone can give me a hand with this I'd be grateful. I've got some PHP web pages that connect to a MySQL database. I've got a … |
| | hi forum i was working with odbc and used odbc_exec(). but when i used this in mysql this is not working i also used mysql_query() but this is not working too here is the code [code=php]$id; $sr; $cs='fa'; $q2="SELECT MAX(ser) AS mxid FROM (SELECT * FROM Table1 AS T2 where … |
| | HI, I am using Roshan's Ajax dropdown code for my two ajax dropdown menus. All is working fine, but when I want to use $_POST in the submitted form with FireFox, its not working...??? Its working fine in IE. Can anybody please help me with this problem? The Form where …  |
| | Hello I would like to know how to display orders placed on a certain day. For e.g. I would like to display orders placed today. My MySQL database contains the following tables: 1). orders 2). orders_statuses Under [B]orders[/B], I have the following fields: 1). orders_id 2). orders_placed_date Under [B]orders_statuses[/B], I … |
| | Hi there, I'am developing a system for banner selection (affiliates) and I have tested the system throughly on my local machine and everything works just fine, but when I have uploaded it to my GoDaddy account and tried to use my system I got the following error: Warning: mysql_fetch_array(): supplied … |
| | HI, I am using Roshan's Ajax dropdown code for my two ajax dropdown menus. All is working fine, but when I want to use $_POST in the submitted form in FireFox, its not working...??? Its working fine in IE. Can anybody please help me with this problem? The Form where … |
| | i heard there is a data type call blob in mysql to store image,can any one help me in which data type the image should be stored to db, or if any one send a link of a sample project with storing image to mysql using c# , that would … |
| | Hi there, i have a problem with this updater script which means that when i click update, change the record, and press submit-it says record changed or something like that, but does not actually do anything! Here is the code, it is supposed to be three files- list_file.php, update.php, update_ac.php, … |
| | Is it possible that select records for example 20 records from the table randomly, but in addition 1 certain record for example 3rd record. Let me explain: SELECT * from table limit 1, 20 rand(); In this way I will get 20 randomly records but I want that one certain … |
 | Hi all I've been trying to find a way of doing this and have come up dry. Is this possible? If so could someone tell me how to go about this? Much appreciated Venom Rush |
| | Hello, I am making some progress on this database I am building for practice...I am new to programming...and was wondering if there is any way to add navigation functionality using buttons or links under the fields being displayed to go to the next or previous record. I Also am trying … |
| | Hi, I'm not entirely sure which forum to post this question because I cannot determine whether it's a MySQL, Joomla, or PHP issue. But I will post it here, as some of you may know about this. I am using a custom built "user" table in my MySQL database, and … |
| | Hi everyone, i would like to know whether the result of a mysql query executed from one php page will be available to another php page on the same site. thanks! |
 | I have recently taken over the running of an e-commerce website. Once in a while i will need to increase the prices of certain products by any given percenatge. The products all have a code starting with 3 letters and then digits. for instance: ffc1234, ffc1245, dcc4544, dcc5799, vff300, and … |
| | hi there, help anyone..i have problem in my query..i need to query with multiple values. for example..in where patientid could be one or more values like this where element = 'element a' or 'element b' or 'element c'...the values are dependent on what the user inputs in his search list.. … |
| | Hi, Is it possible to have a subquery within a case statement and perform greater than / less than comparisons on the value returned in the subquery? i.e. [code] select case (select price from product) when < 100 then 'cheap' when < 150 AND > 101 then 'fairly expensive' else …  |
| | I have installed Mysql 5.1 and it did install. But when i configured mysql, It gives me an error while staring the Service saying "Could not start the MySQL service". I have Reinstalled the Complete Mysql by deleting all the registry keys but still the same error is being displayed. …  |
| | Hello, i'm building a server application in C#.net which connects to a MySQL server via ODBC/Connector 5.1 .Net If a execute a query it works but when i try to exectute a query after waiting a while (ex. 5 minutes) i get an error which says: "The connection has been … |
| | Is it possible to design a search box which suggest the values from the database. Its very cool. can show the data from the page but its difficult to show from the MYSQL Database Table. If you have any example please share with me. [CODE=html]<html> <head> <script type="text/javascript" src="clienthint.js"></script> </head> … |
| | Hi frnds.... I need code for PHP AND MYSQL POLL... It should contain admin part for inserting poll quetion, and saving all data into database.. In the user part also having graphical bar representation... ex:This is the way i want.. [B] [url]http://www.ndtv.com/news/polls/poll_details.php?pollID=505003&poll_saved=1#postcommentarea[/url][/B] Plz give some URLs regarding POLL.. or Plz … |
| | Its urgent please help!!!!! animaldetails(Table 1 ) Animal_Id int (primary key) IsMilking boolean Milking_Capacity varchar milking (Table 2) Animal_Id int (primary key) Month_Year varcahr (eg. '6 2009' -- Means June 2009) Day1 varchar Day2 varchar and so on (till 31) milkingevent(Table 3) milking int (primary key) Requirements: 1. I need … |
| | I have used sql for a while but never to any advanced degree I would very much appreciate some help. I have 3 tables: [code] member, member_details and reg_options [/code] member holds all of a member's details like email, password, username and it has a primary key called id. member_details … |
| | Hi frnds... I saw previous threads regarding photo gallery in this forum.. All threads start from errors in code.... But i want Image gallery total code with db...I was also doing gallery, but it looks not good..code is working fine..but look and feel is not good...also it takes more time … |
| | [ICODE]<?php $con = mysql_connect("localhost","teachms_fooduse","science0"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("teachms_foods", $con); $result = mysql_query("SELECT * FROM Foods"); echo "<table border='1'> <tr> <th>Name</th> <th>Shop</th> <th>Price</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['Name'] . "</td>"; echo "<td>" . $row['Shop'] . "</td>"; echo "<td>" … |
 | Hi every one I am new to php and trying to connect PHP and MySQL my code is as below [code=php] <html> <body> <?php $My_con= mysql_connect('localhost'); echo $My_con ?> </body> </html> [/code] but this error occurd [B]Warning: mysql_connect() [[COLOR="Red"]function.mysql-connect[/COLOR]]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Program Files\EasyPHP … |
| | Hi All, I am new to PHP and MYSQL. I installed Apache2.2, MySQL Server 7.0 and PHP 5.2.10. I created database and table in MYSQL - its working fine. PHPINFO() - its working fine. When i tried to connect to my MYSQL using PHP with the following code, i am … |
The End.