10,932 Topics
 | |
| | Hello, I'm trying to set up a website where user can upload files to which should be readable by everybody. Logged users should be able to comment on the files and rate the files. I'm new to MySql and quite new to PHP so it has taken me already lots … |
 | Ok, so the scenario is a database which stores customer contracts (to keep it simple) so that every time a contract is expired and renewed a new version is created in the database to reflect any changes (terms, price etc). My page needs to display a list of the latest … |
 | Hey I want to search for a text string but I dont know what table or column it is in. I just know the database that it is in. I know also that the type is a text type. Any query I can do or in MySQL Workbench? Thanks! |
| | OK, this is probably a variation on a previous question but the original question was never resolved, so I will present it on it's own to avoid confusion. I have a member data table called 'members' Primary key is 'mem_id' I have 7 different 'position' tables called position_1, position_2, position_3, … |
| | hi guys... i really need reference ASAP what i'm trying to do now is: -creating API from my website so that -other website can read certain content for my website database and put it in their website. i don't know if i explain it correctly, i tried to googling for …  |
| | I've had nighmares about this since 3 days ago and couldn't find anything by googling so here I am. As the title says so i need to find a way to store and then retrieve images from a mysql database I have tired the code below to do so (the … |
| | Hi, I am trying to query a MySql database based on which search fields are filled in and ignoring those that aren't. I have only got as far as the first part and it isn't working, could anyone tell me why? It doesn't seem to be finding anything in the … |
 | I need to transfer the sql server databse tables to mysql . How can i do that?.  |
| | Hi there, I would like to make an email form that would select all the emails from a MySQL db and then send that message to all addresses. I got this script but was unable to get it working. Any help would be great. [code] <?php //Connect to database mysql_connect("localhost","user","password") … |
| | Hey guys, I'm just wondering if it's possibe to get the results from a query and then assign the results to a variable. So I will run a query which will return the names of the tables stored in the database, then I want them to be stored in a … |
| | I am having problems getting getJSON call to work. At the moment it doesn't retrieve any data, however when I change the '$.getJSON' to ' $.get' it retrieves the data in it's encoded format: [{"Page":"User Journey","Description":"Interactive User Journey Diagram","Bounce_Rate":"0","Avg_Time_On_Page":"0","Page_Views":"0","Click_Rate":"0"} What am I missing from the $.getJSON call? getstatistics.php: $query="SELECT Page, … |
| | Hey all, Some rows of a single table in a database that I administer manage to have gone missing. Not that big of a problem: I have a backup. The issue is that there has been more information added since the old data was lost, so I can't do a … |
| | I have a query in which I need to display some group function figures SUM COUNT etc from a joined table. I also need to select the latest version (by datetime) of a matching record from a separate table, which I can do using an ordered subquery in the join. … |
| | i have a form and checkloginstudents.php,,but my problem,i can't display the details of a user after login,, this is my form: <form id="form1" name="form1" method="post" action="check_login_students.php"> <label>Name <input name="username" type="text" id="textfield" /> </label> <label>Password <input type="password" name="password" id="textfield2" style="margin-top:5px;" /> </label> <label> <input type="submit" name="button" id="button" value="Submit" /> </label> </form> … |
| | I had my wordpress site up and running just fine but when I visited it recently I got the following error: > *Your PHP installation appears to be missing the MySQL extension which is required by WordPress.* I contacted the person who set up my database and was told > … |
| | am total newbie to programming, apart from knowing SQL, the thing is i have been given a MYSQL database containing various information about kids diseases and a web interface written in php to create reports from the database that can be accessed via the interface. there are almost 25 different … |
| | Hi, wondering can I get some help here please as this is incredibly frustrating. I have a database that contains files and I want to be able to search those files by putting in a ID number. In my databse my doc_id is the primary key, and I want the … |
| | Hi All, I'm having a problem with a query - which is based on conditional user inputs. In all circumstances, the outputted query ALWAYS works in phpmyadmin returning rows where applicable, but not always in php. No errors are displayed, with error reporting set at E_ALL, and mysql_error hasn't been … |
| | Hey guys, So, I have a connections php file which contains info such as the host, username, password and database to be accessed. I'm wondering if there is anyway to make the database value to be changed later on in the website. When first logging into the website they choose … |
| | Good Morning, I have an ever growing member database that is currently at around 6000 (developed over the past 2 weeks), and expect it to be in the hundreds of thousands within a few more weeks... My problem is that alot of members are using a single email address for … |
| | I have an application written in VB.Net with a MySQL database that is working fine in my development environment. I would like to create an installation package to test on other computers. The install package should include: 1. Check for .Net 4 - if it doesn't exist then install it …  |
| | Hi, When a user registers on my site there status is 0 (not active) ... meaning they not activated there account via email. When they register i also store the DATETIME they registered, i store it in MySQL using MySQL DATETIME and using `NOW()` in my INSERT query on registration. … |
| | Hello peeps! I've got an issue which I am trying to sort out. I am trying to build a website where ppl can search for car's sell and buy. I got stack where I had to make the search option on the website, so I started looking on google where … |
 | Hello, i am saving a listbox into a mysql database. it saves correctly expect if there is space in between the data, it saves only the first part. any reason why so? |
| | I keep on getting this warning message Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\test\checkPosts.php on line 12 <html> <p><a href = "postArt.php"> Post Article </a></p> <p><a href = "editArticle.php"> Edit Article </a></p> <p><a href = "viewAllPosts.php"> View All Article </a></p> <p><a href = "Logout.php"> Logout … |
| | So guys, I really need a script that I can select from drop down menu, depends on choose, and updates mySQL row every click gives +1 point. Thanks you! |
| | What I need to do is search brand names, find all the brands that start with the letters A-E and put those under a header on my webpage. Then search F-O and then P-Z and do the same thing. How would I go about querying the database to get the … |
| | Hi, I have been trying to solve this for ages and just can’t seem to get it right. I want to do 2 things here, i am getting an array out of a mysql database (i am getting the user’s id) and then converting that array into a string and … |
| | Hello all, I am having problems setting up a connection with a mysql database that i'm going to need to use for one of my projects. My code to establish the connection is as follows: import java.sql.*; import java.sql.Connection; import java.sql.SQLException; import java.sql.ResultSet; import javax.sql.ConnectionEvent; import java.sql.DriverManager; public class SQL … |
| | Hello, Can someoneone tell me when you `prepare()` a statement (in my case an update statement) and then `execute()` it, i then check using `rowCount()` after the update query (see code below) if `rowCount() > 0` if it is then a match was found and update took place, but i … |
The End.