7,368 Topics
| |
Hello, I am just after some information if anyone knows how to create a system in php that auto assigns a user at random when a record is logged in a mysql database I have been tasked to build a logging system for which uses a database to store the … | |
Hi Friends! I want to create a dynamic website. So, to create it I need to know PHP and MySQL. I went to [amazon.com](http://www.amazon.com) and searched for books. I was showed by results of **learning php and mysql**, **learning php** and **learning mysql** book names. I couldn't figured whether should … | |
| Hi I'm trying to create a page for a stallion showing his offspring. I used the distinct query in the hope of showing each of his children only once, but I'm assuming that because the other data in the row differs (there is a unique reference number called runid) the … |
Hi I have this table name age John 14 Katy 14 Mark 15 and I want the number of rows where the age is equal to 14 , so in this example the result should be (2) but my problem is that I dont know how to start , so … | |
Hi, Need suggestion for a query. I am trying to get count(c3.id) for all days of feb. As in cs.created_at some dates are missing.How can i use below clause. **group by day(cs.created_at)** something like group by day(month(cs.created_at)) not working.. select count(case when cs.id IN(select max(id) from complaint3_status where complaint_id=c3.id and … | |
i already searched about displaying the data fields, my problem is how to retain the checked item and then set its value as 1. please help. i tried some code but didn't work: <html> <form action='' method='post'> <?php $database = 'sample'; $table = 'checklist_stud_columns'; $mysql = mysql_connect('localhost', 'root', '') or … | |
Hi all, I'd like to create an interactive voice response menu system on my own. I'd like to use my MySQL database. I have a found an interesting idea (https://ivrhttpozml.codeplex.com/), but it's based on using a webserver. In short, the previously copied guide presents a simple XML code (more exactly … | |
I am struggling with this, I have a database (mysql where i am trying to delete a single row. The idea is a list of items populated from the database. I am trying to add an additional column where there is a graphic and it reloads the page and runs … | |
Hello Guys. I am fetching some results from database and show into a page. This is a CodeIgniter Project. Here si the code for that: This is the view: <div class="product_view"> <form action="" method="POST" name="form" id="form"> <?php foreach ($get_product->result() as $key => $result) : ?> <h4>Product Name: <?php echo $result->product_name; … | |
I am trying to populate a select box from my database. The value chosen must be the id of the item, and the text shown the name of the item so that once selected it will insert the id into the table column and not the name so that the … | |
I use visual basic 2008 and MYSQL (Storage engine is innodb) Is use this code to retrieve informatie (see below) The SQL string ="select * from articles where articlenb=12345" I want to check of this record is used by een othor user in the network. Can use innodb for row-based … | |
What is the best Way to start working on projects if u already familiar with php and mysql? | |
| How do i transfer funds from one account to another in the same table? ![e88a3b19f85ebc5dd5a5d0e47b867200](/attachments/large/4/e88a3b19f85ebc5dd5a5d0e47b867200.jpg "e88a3b19f85ebc5dd5a5d0e47b867200") Say for example i want to transfer funds from UserID 1111101 to UserID 1111103. Anyone know the procedure for this. I use php/mysql and dreamweaver. |
Hello guys, I am on my revision of my thesis and I am actually stuck on this thing. My thesis is Online Requisition of Document and the panel told me that when the student submits his/her request, the expected date or tentative date release of document will automatically display or … | |
I have 10 field that I want to calculate the total. some of the fields take null value. I tried the codes below but the result was empty. select id, (c1+c2+c3+c4+c5+c6+c7+c8+c9+c10) as total from items order by id; the result show was null. In dreamweaver the result was blank. please … | |
| Hello, I have successfully created a login page(username+password) that links to an account page. But i would like to insert a middle page (post login) where the user need to type 2 or 3 random characters of a memorable name to finally log into his account. Any idea how to … |
Hello. I have a php script that will backup my databases and ftp them to another server. All works fine via a cron job - but the backups are piling up and I'd like to add some code to the script to delete all the old backups - and just … | |
Hi guys, I have a mysql database with many tables. Instead of creating a page each to enter info into the relevant tables, is it possible to have a form created dynamically depending on what table I want to insert information into? Database has 20 tables in it at present, … | |
Hey guys, first of im not sure if im posting my question in the right thread, if not do tell. anyway so i recently downloaded mysql installer 5.6.16 and now im try to set up a new connection in mysql workbench 6.0 but it keeps saying access denied for user … | |
| |
Hi, Need suggestion for sql query. I have 2 tables user user_status user: id,name user_status=id,user_id,status_type,status_value user_status stores multiple status_type and status_value.for 1 user there can be multiple rows I am trying to get all users having who are not blocked i.e user_status table dont have status_type(10) and status_value(11) | |
| Table 'user' fields: UserID* (Primary Key) Address FirstName LastName Email UserName Password UserLevel RegDate Table 'transaction' fields: transactionID* (Primary Key) MonthID UserID (Foreign Key) UserName transactionDate transactionType transactionAmount OpeningBalance Balance Desired output table (for the logged user): transactionDate transactionType transactionAmount OpeningBalance Balance Advance recordset details is like this : <?php … |
Here is online demo - http://cs-bg.info/news/archive/ I want to show my news like that. (like archive for each year) I want to work with epoch time. Thanks for any help. | |
Is there a program for mac that i can use to connect to my mysql Database instead of opening Fire fox and going in and logging in?? | |
Hello, i have the following column in mysql table. number | name 123 | ABC XYZ 456 | DEF QRS hre is my mysql query: $query = "SELECT name, extension FROM users ORDER BY name ASC"; $resultID = mysql_query($query, $linkID) or die("Data not found."); $xml_output = "<?xml version=\"1.0\"?>\n"; $xml_output .= … | |
| SELECT transactions.UserName, transactions.transactionDate, transactions.transactionType, transactions.transactionAmount, transactions.OpeningBalance, transactions.EndBalance, users.FirstName, transactions.transactionID FROM transactions, users WHERE users.UserName = transactions.UserName AND users.UserName = $_SESSION (['MM_Username' ]) ORDER BY transactions.UserName, transactions.transactionID DESC I am getting syntax error with this code. can anyone help please? |
hello friends. i have a function in where i move all table content to another table and delete from preview table, the `DELETE` DON'T work i can't understund why but here is my code i need your helps friends all your reply count for me. $query_suppr_panier = sprintf ("DELETE FROM … | |
Hi! I'm programming with VB.NET + Mysql database. I have one table of which, one of its column can have multiple entries to it. That's, say a table named TableA(item2,item2,item3,item4). Now, I have a scenario where I may have item1,item2 & item4 filled,but item3 is not. (Please have a look … | |
I've been trying to delete row in my database and all I get is this error ORA-04084: cannot change NEW values for this trigger type ORA-06512: at "myDB.STUDENT_ID_TRIGGER", line 4 ORA-04088: error during execution of trigger 'myDB.STUDENT_ID_TRIGGER' DELETE FROM STUDENT WHERE STUDENT_ADDRESS = 'NY Street' | |
Hello all, I'm trying to build a system to provide an easy access but very clever service select (sounds confusing, I will explain). Essentially I'm trying to create a system then will firstly store devices of different types, these types are: - Device type (iPhone, iPod, iPad) - Generation (4th … |
The End.