10,940 Topics
 | |
 | 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 … |
The End.