10,940 Topics
 | |
| | I am trying to update a edit profile in mysql. the first bit of code is when the submit button on forum is hit the data in my table users willl change. the secound bit code get the user info from the database it work fine you can select what … |
 | I want to display table by default in ascendind order with dynamically changing header. Here is my code. It is displaying the rows unordered. It should be in ascending at first look and then can change by column. $order = (isset($_GET['sortCostCode']) && strcasecmp($_GET['sortCostCode'], 'desc') == 0) ? 'DESC' : 'ASC'; … |
 | Hi I have code I use to look up data from mysql, then dispaly in text boxes. For some reason ALL my data drops the words and spaces Example: if a supplier name is "DyFin (Pty) Ltd" the text box only displayes "DyFin" Example: If My phone numbers are "0860 … |
 | Below you will find my code, it's not it all in it's entirety, but shows what's important. I have some custom functions that are being used just to note out. What I have my code doing is searching a MySQL table and displaying all of the results based on the … |
| | 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 # … |
The End.