10,946 Topics
 | |
| | hi,i am a web developer and i have recently designed a new website [fitnizz.com](http://fitnizz.com). Now i am facing some problem related to database ,i have recentky added a new application of diet plan ,you have to just enter your weight and height in the text box and click ok,then it …  |
| | I have a table with over a thousand records that I need to update a field I have called "id". I need each record's ID to be unique. I am using the uniqid() function which works just fine. When I use the code below (and several other variations of it), … |
| | attach is my code for search.php but i have error on line 9, can someone pleasee help me to fix it ? Thnk you XAMPP said Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\series\insert\Search.php on line 9 line 9 code: while($row = mysql_fetch_array($results)){ below is my …  |
| | Hello I got one problem. I have a site where people can add movies. Its possible to add up to 10 different hosts. Every host can have up to 2 parts. html <TABLE> <TR><TD width=120>Hoster*:</TD> <TD> <SELECT class="interfaceforms" name="addmovie[][hoster]"><OPTION value="">Please select</OPTION> <?PHP foreach($hoster_list AS $aKey => $aValue) { echo'<option value="'.$aKey.'">'.$aValue.'</option>'; … |
 | $cartOutput = ""; $cartTotal = ""; $ctr= 0; $collector = array(); $product_id_array = ''; if (!isset($_SESSION["cart_array"]) || count($_SESSION["cart_array"]) < 1) { $cartOutput = "<h2 align='center'>Your shopping cart is empty</h2>"; } else { $i = 0; foreach ($_SESSION["cart_array"] as $each_item) { $item_id = $each_item['item_id']; $sql = mysql_query("SELECT * FROM products WHERE … |
 | im on win 8. neither can i find the bin folder as i could on my xp machine , nor do i get any command line. googleing didnt help much either. either i got some really hard to understand mysql doc page , with no specific answer to my problem … |
| | my insert php cannot save data to phpmyadmin when it enter the details. localhost:locahost , username:root password: databasename:b_database tablename:my_library tablecolumn:2 contains : isbn(primary key) and title. index.php <html> <head> <meta name="description" content="Php Code for View, Search, Edit and Delete Record" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Search Library Record</title> </head> …  |
 | hi guys, am trying to make a simple PHP form submission and insert some data to MySQL, my tables are: category: -id -category_name table1: -category_id(FK) -title -description table2: -table1_id(FK) -filetype -filesize -filedate -filename Form: -Date -Title -description -category(drop down) -upload file (get the file info like type,ext,size,filename) Or is there … |
| | I get this message quite often and it has popped up again here, any ideas as to why? Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\.... on line 76 line 76 is this line in bold. [CODE] $productlist = ""; $sql = mysql_query("SELECT * FROM products …  |
| | hey guys... i know this is a very common problem and has been posted earlier also... but nobody seems to have figured out a solution... i am making a program using PHP/MySQL. I need to update 3 columns in a table. when i use a single UPDATE-SET command(using commas/AND etc …  |
 | Hi! Got errors on site... Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/header.php on line 30 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/config.php on line 4 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/index.php on line 16 … |
| | Hello. I created a little recover page. Users write the email and a random password is sent to them. The random password is successfully send in their emails but when they login with the new password it doesn't login. I think the new password does not updates in my database. …  |
| | How to do the code for design and develop an PHP/MySQL application involves insert, view, search, delete, update/modify a record from a database  |
| | Design PHP/MySQL application that involves insert, view, search, delete, update/modify a record from a database. "The application is mylibrary and we have to insert, view, search, delete, update/modify the isbn(length:13) and title of the book (length:128)" Can someone show me the code ? I already done mine but I want …  |
 | Hi guys, I've created a simple plugin for Wordpress that interacts with an API in the backend. The problem is that everything is inserted twice in the database, and I cannot figure out why. The form is submiting only once, not twice. What could it be ? Redirects from my … |
| | I have these templates: temp1(id,country_id,county_id,town_id,location_id,street_id) country(country_id, language,country_name) county(county_id, language,county_name) town(town_id, language,town_name) location(location_id, language,location_name) street(street_id, language,street_name) For now i am joining all these for the selected language to find the names of temp1 id's location. Is there a better way to retrieve the informations? Would be better to make a table …  |
| | A friend asked me to rewrite a program for him. Though the problem is it s using a rdb database, i am assuming this is a dec/oracle rdb database. Which i honestly never used and have no knowledge of. So i was wondering if there is any way to convert …  |
| | i am new to study web development..can anyone help me to how i can connect my website with the database..what are the requirements..very basic please.!! |
 | Hi there, I have a really irritating site problem that I just can't get my head around. I only have fairly basic coding skills and hope that someone here can help crack my issue. I own a small php/mySQL based job board which I have moved from hosting to hosting … |
| | Hi All, I am currently working on a MySQL database, and am using mySQL Workbench to create a local server. From this computer(the one that is hosting the server) i have no problem connecting to the mysql server through 127.0.0.1:3306, however when I try to connect from another computer, I … |
| | I've been trying to use mysqli instead of mysql. I have a file from another site which will fit nicely to this site im doing now, but i havent a clue what i need to do to convert it to mysqli. This is the file <?php include 'connect.php'; //populate form … |
| | Show me example design PHP/MySQL application involves insert, view, search, delete, update/modify a record from a database  |
| | PHP help , please asap , need your email to email you my problem  |
| | I have a mysql query that seperates an array of variables and uses each variables to compare inside the database. The query uses a OR clause and I want to make it so it can also use an AND clause. The trick is I want the left side of the … |
| | Hi, - Why use paging? It's not really cool to print out all 2000 rows you have in a table to the page, so it'd be nice to page them. Special cases? Yeah, if you have 1000 rows.. and you've set the maximum row per page to 20, well.. you're … |
| | Hello, I have a members area on my website. I'm trying to check if a user with a specific username and id has logged in, and then echo a string of text on page B (members area page) if its them. The user logs in on page A (login page). … |
| | hi guys, 1. i use this script from w3schools it works with real escape string. But my problem is it is slow displaying the table and i dont know how to check the problem. assuming password and table is correct. 2. can i change the "ajax_demo" value or delete? reference: … |
| | Hi I have a php header file that displays a random image from a mysql table each time the page is reloaded. I have done this just using rand() in the query. But doing it like this means that the same image could come up 3,4,5 times in a row! … |
| | I have a form that shows images whos paths are stored in mysql. The form has 'hide' and 'show' submit buttons for each image. Pressing the hide button should set the value of the 'status' field to 2 (hidden). But it does nothing, my queries don't seem to execute. Here … |
 | I need the steps to make an daily Back Up to my data base i am using SQL 2008 and when i do the backup job it gives me an error unsuccessfull complete , any one can tell me why ??  |
 | can you help me in 1 cell in a row can handle many data ? for example in the picture for costumer 1, he order a banana, it cost 50 apple, it cost 60 orange, it cost 70 and my program will retrieve the datas and it will get the … |
| | <?php $mysql_host = "***"; $mysql_database = "***"; $mysql_user = "***"; $mysql_password = "***"; mysql_connect($mysql_host,$mysql_user,$mysql_password); mysql_select_db($mysql_database); $query = "SELECT * FROM people coming"; $result = mysql_query($query); while($w=mysql_fetch_array($result)) { echo $w['Name']; } ?> this doesnt work--Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource y? |
| | Hi All, I have a table of about 120,000 records which are mostly chemical products all with 100 byte varchar for the 'name'. I've indexed the 'name' and looked at the list here http://www.ajaxline.com/32-tips-to-speed-up-your-mysql-queries for ideas. But can't really find a solution because it's taking about 20 seconds to retrieve …  |
| | i have database with tables like these: t_09_students t_10_students t_11_students where 09, 10, 11 show year and this table will increase over the year. how do i select all the data from the tables (using union) with flexible table name? ask me, if it is not clear yet |
| | it is possible for the database that a certain id number will handle or occupy 2 or more rows and then when it called it will take both rows like on the picture .[Click Here](https://fbcdn-sphotos-h-a.akamaihd.net/hphotos-ak-frc3/v/1056791_636382299706472_1144322928_n.jpg?oh=7160bd41f914616aa1a0c59be0821a9a&oe=51F21D0D&__gda__=1374895465_5046fd7250a283eac7faabc35a10c324) |
| | So here is what I want. if (tracks, the db) (user_id, the row) for '".$_SESSION['user']['id']."' = equal (tracks, row) in (users, the db) for '".$_SESSION['user']['id']."' exit else update (users, the db) (tracks, the row) to match. This isn't the script as I don't know where to start but I am … |
| | I am getting the following error on my home page. I am new to php code and this one is looking pathetic on my wordpress site. any help would be highly appreciated. The error is as below: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given on line 39 … |
 | i am building a message system for website.i have two table one store user_detail and other store message sent to each other users. you can see main.jpg file where inbox sent etc.. will be display and action takes accordingly. $query='select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, user_detail.user_id as userid, user_detail.username … |
| | I am working in a dataware house and few things are not clear to me that is why I wanna discus here. For example, I have 10 MS Access files, and each of they have more than 5000658 number of rows, and data is in such a format like **Plz … |
| | hello fellas i'm stuck in this function: function getDataForPagination() { $sql = "select * from t_book limit 1, 15; $result = mysql_query($sql); if (!$result) return false; $num_rows = mysql_num_rows($result); if ($num_rows == 0) return false; $result = dbResultToArray2($result); return $result; } i want to make the above function more flexible … |
| | Hopefully this will make sense and there is a solution in a single query... if not, I'm sure i can do it using multiple queries. I wrote a query that I thought would work, but didn't take into consideration that some of the records won't have data coming from one … |
| | Hi Folks, Recently I installed WAMP server for web development, during my first run I tried My Sql Console, but I was gettting error while creating a new table. I am surely missing something. I googled for it but cannot get what i was looking for . . . Am … |
| | Hi I have been trying for about a week to connect VB6 to MySQL and have so far been unsuccessful. What I am trying to do is have a login system in VB6 which, when the login button is pressed, searches the "userlogin" table in MySQL. If a matching result …  |
 |  |
| | I few weeks ago, I posted some code that I need help converting to MySQLi, now I need some help converting it to PDO. The code allows you to enter queries and commands and brings back the column headings and the information that I am looking for into a table. … |
| | this code runs at my other sample prog. but when I try to use it to my actual prog., it wont work. (variables changed, connection's ok) . . . cant show data at listview [CODE] Imports MySql.Data.MySqlClient Public Class Form1 Public sconnection As New MySqlConnection Private Sub Form1_Load() If sconnection.State … |
 | I am trying to learn MySQL to, '1 call all records from base '2 count number of records and store number as maxID, '3 display 1st record set by the ID number, '4 -A - add one to ID number- display record set in frame1 :(working_on_page_refresh -B - mins one … |
| | Hello , in a python application i wanted to insert datas to some columns of a table , the columns tha have as name "XS" , "S" , and "M" . i tried this query : `curso1.execute('INSERT INTO donnees (%s) VALUES (%s);',(liste1[i],qtetaillevar[i]))` , but when it compiles it , when …  |
| | I want to backup my database from vb.net 2010 and i am able to do this using mysqldump through vb.net 2010, but i want to backup my mysql database without useing mysqldump only by vb.net code. please help me ???  |
 | hi i am new to php and mysql, i am experimenting with a script for saving data to mysql database. and fetch the data on other page, i managed to get both of them without any trouble. But Here is the one problem. I added a additional input function to … |
The End.