11,093 Topics
 | |
| | Hi, how to pass values in mysql table from html form. give me simple examples. thanking you. |
| | Hi all, this is really geting to me now, I jsut keep going round in circles and getting nowhere. I have a form with multiple radio buttons, each button represents a category of reptile. When you choose one of the radio buttons you are taken to a page for that … |
 | i have two MySQL tables with the following structures CREATE TABLE tbldepartments ( departmentID TINYINT( 2 ) UNSIGNED NOT NULL AUTO_INCREMENT, department VARCHAR( 20 ) UNIQUE NOT NULL, PRIMARY KEY ( departmentID ) ) and CREATE TABLE tblemployees ( employeeID SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT, departmentID TINYINT( 2 … |
 | I need to make time difference of 24 hours from registed time. In my database, there is column datelog with type "timestamp" Default value: CURRENT_TIMESTAMP I need the result if user with data: 2012-10-02 14:51:41 Test1 Test 2 User must not be able to register for next 24 hours. Thanks … |
| | |
 | Hey everyone, I have just uploaded my php files onto a free hosting server and tried to access the website. I got this error " mysql_fetch_array() expects a resource in parameter 1" or something like that. By the way, the files did work on my local machine. What is the … |
| | I am having trouble trying to update my comment, well I also don't know why my table isn't displaying on my updatecomment.php page. How do you delete a comment too. If you see any other errors please feel free to fix it. Thanks in advance <!-- start dbconfig.inc.php page --> … |
| | i have a MySQL table with the following columns: employeeID, firstName, lastName, gender, salary. whenever i insert a new record for this table i want to be able to retrieve the employeeID of that record. how should i write the commands in VB.Net |
| | **Okay, first of all, I'm quite new to programming at this level. I have managed to create a dynamic administrationpanel for updating the current menues of a restaurants homepage.** ISSUE - The more posts in the table, the longer the space between the page top and the databasetable gets. I’ve … |
| | I want to the answer of article titel. |
| | Field defined as DECIMAL(5,2), trying to INSERT (250.00). When query is performed remotely to DB server, it fails with 'Out of range value for column...', when query is performed locally on the DB server, the query works. The query works remotely when the value being inserted is 226.24 (yes, that … |
| | Hi Prows,am creating a farm produce monitoring system using mysql and php.The database contains several tables of different produces that have the similar fields.The admin is supposed to update each table with different values.How will these datas relate. For example,maize field has Product-id,produce-name,location,date,time and mobile number of the buyer.Each table … |
| | I have recently been working on a job with a client who gets their data from county data. The county data is contained in .dbf files. Every year the data is updated and my client will get a CD/DVD from someone containing the county data in .dbf format. Now the … |
| | I am making a basic craigslist type website with a search function. There is a field where you can enter what you think the name of the product might be and my search function is supposed to find names of products that match. so for example a user can enter: … |
| | Please Help!! i have been trying to get some help on displaying data from mysql in a sequence (like a course). basically i want my student to view and learn the couurse that has been saved in mysql database in learningmaterial table, the table contains images, audio files, online documents … |
 | Hello! I've recently installed Windows 8 and since that moment my XAMPP installation has been acting a bit weird it takes over a second to establish a mysql connection (mysql_connect) where it used to take less than 0.01 seconds.Timed: Timer 1 (mysql_connect): 1.02864 Timer 2 (select_db): 0.00023 I have found … |
| | I'm attempting to wrap an auto-generated link around a thumbnail displayed from a Mysql database. Can someone help me with the syntax? `echo "<a href= 'http://www.website/link.php?field=".urlencode(img src='".$showimage"' height='10px' width='50px' />) . "'>$showimage</a>";` Thanks! |
| | I need help and thank you in advance for any advice. I'm new to Php and Mysql. I've put three drop down menus in one cell of a table and I want to display results of a simple query (4 fields per record) in another cell of the table. Only …  |
| | I have two tables (points, pointsmatch) Table 'points' have following fields id (int) seriesid (int) team (varchar) points (int) id seriesid team points 1 9 Chennai 4 2 9 Delhi 0 3 9 Kolkata 0 4 9 Mumbai 0 5 9 Bangalore 0 6 9 Mohali 0 7 9 Rajasthan … |
| | hope i worded this well enough... :D trouble working out a query Table: weeklyrevenue Week Number||value 25||20 26||40 28||60 Table daily_totals Week Number||quantity 26||10 27||10 28||10 Need week 27 totals to be multiplyed by week 26 revenue not week 28 revenue as the revenue would have been generated by the …  |
| | 1.I have a MySql DB called 'scheduled' and table called 'messagelist'. The first field msgID is int(10). Rest all are varchar(20). 2.broadcasttext.php <form name="frmText" method="post" action="addScheduled.php"> 3.addScheduled.php <?php $host="localhost"; // Host name $username="scheduledUudk8"; // Mysql username $password="KeszRXqXo.)-"; // Mysql password $db_name="scheduled"; // Database name $tbl_name="messagelist"; // Table name $i = …  |
| | l need to generate a dynamic PDO update query. l am not sure of the behaviour where we have the same placeholder name in th update and WHERE clause for example UPDATE users SET name = 'Master User' WHERE name = 'Dev User' As you can see placeholder name will … |
| | I am trying to figure out why I am getting this error notice, Does anyone have an idea as to why this is happening. Notice: Undefined offset: 5 on line: `if ($tree[$i]['level'] < $tree[$i+1]['level']) {` on line: `} elseif ($tree[$i]['level'] == $tree[$i+1]['level']) {` on line: `$diff = $tree[$i]['level'] - $tree[$i+1]['level'];` … |
| | i have this problem for checking for duplicate username in database. this error appear whether the username is duplicate and does not duplicate. Please help. Warning: mysql_num_rows() expects parameter 1 to be resource, boolean in <?php include_once 'db/db.php'; include_once 'admin-class.php'; $admin = new itg_admin(); if(isset($_POST['Submit'])) { $con = mysql_connect("localhost","username","password","tablename"); if … |
| | hi everyone..hope every1 is going great..well i'm a beginner in mysql and php and i cant fix the query as i desire..iam joining 3 tables here and displaying thre data.. 1st i have displayed course names from the courses table 2nd i have displayed the subject names from wich the … |
| | I am trying to insert my form's data radio buttons into my mysql database. it works very well but when i skip any one value of my radio button,as this is more than 20, its giving error that Notice: Undefined index: qr1 in C:\wamp\www\exam\contents\omr.php on line 134 Call Stack # … |
 | Hey there, I have these three tables: A, B, and C. A has a one-to-many relation with both B and C. Right now, what I am doing is: I run a select query on A. I put the results on an array, lets say aArray. For each row in the …  |
| | |
| | I have two tables, author and quote: author: AID, Name, YOB, YOD. quote: ID, AuthID, Content. I currently get all the authors with one query and as I loop through them, I run a second query to get the count of quotes that have the current AID: $sql = "SELECT … |
| | I have two tables that I need to get the following information but I can't seem to figure out how to structure the query: Table 1 type show max min Table 2 model height width depth In Table 1 I have the following for the first row (as an example): … |
| | Hi I am attempting to build my own cms (although very basic) using php and mysql. Instead of having a static homepage, I want the content displayed to be dynamic. In other words, I want the homepage to be flexible/changeable based on whatever the latest 'content' entry into the database … |
| | Hi, i am inserting data from CSV file in mysql. I am trying to skip ist row of CSV file as it contains headings. need suggestions??  |
| | SELECT t.* FROM (SELECT * FROM jobs WHERE `status` IN (0,1,2,3) ORDER BY `status` DESC, job_datetime LIMIT 11, 20) AS t That's a cut down sample of my sql. It was more complicated, but I've pared it down to this just to see why I was getting some strange numbers … |
| | i need a querry to add -- in the end of a table. for example if i have a table like tb name ze ad|ID| aa | -------------- 01|02|aa01 | 02|03|aa02 | how do i add -- to the end of all fields of aa column to be like aa01--\aa02--? |
| | Stuck again... :) I am returning close to 60 records from a search in mysql. I want to add these records to a select box. When I am looping through the records, it adds a select box for each record. Not sure where I am going wrong. It does load … |
| | Hey guys, I don't see anything wrong in the function but mysql_result is complaining about the parameter value passed to it. function question_exists($question_id){ $question_id = (int)$question_id; return ( mysql_result(mysql_query("SELECT COUNT('id') from `posts` WHERE `id`=$question_id"),0) == 0) ? false : true; // if the question doesn't exist (equal to ZERO) then … |
| | I am trying to configure a menu for my CMS I want to be able to use Nested Sortables just like you have in WordPress. The problem Im having is getting my head around how I am going to start I already have a column in my database table called … |
| | I am totally stuck here and found tens of samples on posting to get and set values. What I am trying to do is - 1) Let a user enter a vehicles year model into a textbox in my form (set to post) 2) I then need to get this … |
| | I'm trying to use a drop down form box & select statements to gather certain pieces of information from my database however i'm recieving the error **Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /study/comp/c3329871/webpages/mysql/queryContinent.php on line 26** This is the code from my php file … |
| | Hello, I am getting the following error message: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mochas/domains/zoink.sx33.net/public_html/includes/blogpost.php on line 54 My code (Line 54): while($row = mysql_fetch_assoc($query)) |
| | Hello guys, i need a help slightly with this project of my university. my equipment are working with some components, 1. Radius Server - MySQL - OS Linux Ubunto 12.04 or OS Microsoft WindowsServer2008 - SQLServer. 2. Router Linksys Wrt-54g 3. Other Server with certification unit, which we need manage, …  |
| | Hi I am having some issues with getting data to update for a logged in users account, I have got it to display the data in the database which i want to edit but for some reason it just wont go through it says it has updated but when I … |
| | Does anyone know a better way of getting this code to execute the mysql queries. I am trying to Insert table records to a new table then update it. so I need to call the table cms_homecontent first then insert those values to the new table cms_homecontent_versions and also ignore … |
 | I am baffled, I have the following query which should return 4 records but for some reason it is counting 8 records and returning each row twice. I know I could use distinct, but as I also know that there are no duplicate records in this table I don't want … |
| | hi frnds..can you give some idea about php training.how to start in online or any institute |
 | Hi, I am trying to create a script which searches through a MySQL column which contains URLs and check the URLs to see if they are up OR down. At the moment I am getting no results added into the database e.g. 1 = UP, 0 = DOWN. Can someone … |
| | Hi, I wanted to know that can we use a php function on a column in mysql query. I want to make something like this SELECT html_entity_decode('field') from table. Thanks in advance. |
| | Hi, I'm wondering what type of mysqlfield would be advantageous for outputting the containing text as a bullit list in php and if the text should be formatted a certain way. I would be supergrateful for an example! :p Take care Adam |
| | Hello, I have problem with entering default values in MYSQL database. When i insert new record using phpmyadmin it works fine (empty fields get default value), but when i use the same query in my application (written in PHP), empty fields in html form don't get default value in MYSQL … |
| | Hello DaniWeb, I've finally gotten around to swapping from MySQL to MySQL(i), mainly due to it's security advantages with Prepared Statements. In the past I've been adding `include ('/Some/Directory/File.php);` to the top of each page, so that I can store my functions in a secure directory and so that I … |
The End.