10,940 Topics
 | |
| | |
| | ` how do i change from msql to msqli the below statement, am learning this mysql but keep getting Deprecated error. And where can one get an easy tutorial on how to make the changes. thanx $displayImages = ""; if($_GET['cat'] == "juice") $sqlSelProd = mysql_query("select * from tblproduct where prod_cat …  |
| | I'm new to mysql and I need a ralationship tutorial.. like for example I made a table called MovieList with 1 column name TitleMovie and now I want to create another table called acc1_MyWatchlist and inside of it was also a TitleMovie..my question is I want insert a value in …  |
| | Hello. I am tasked with making a small survey for internal use. I have the HTML made up where it asks for a incident number (6 digit number) and has 15 checkbox items. Users here will goto the survey as needed, type in an incident number and check the box … |
| | Dear user I write a file upload code in php, the code work's fine but it will upload the file 50kb to 60kb, when i try to upload more then 50kb to 60 kb file then the page stuck on loading. The problem is why it is not uploading more … |
| | I was wondering if the following was possible with a query? If so, can someone give me an example query? I want to print a list of products, group them by color, and then have the totals at the end of each group. | Color | Product | ------------------- | … |
| | I'm making a kind of address book thingy and seem to have confused myself on the best way of organizing the tables. At the moment, I have two tables, Contact and Number. Here's a basic representation of my tables: ___________ | Contact | |-----------| | cid | | fname | … |
 | Firstly, Hi Guys, sorry I've been away so long, I've taken on quite a large project and just haven't had the time for anything. I am having difficulty completing my query. I initially have two tables UserWallet  and Captures  So far my query creates a new … |
| | Hi, I'm a 16 year old web designer and aspiring developer. I've learned the ins and outs of making a website look amazing, but I'm only now starting to try to figure out how the heck it's all possible. One of the things I run into with every site I …  |
 | Hi guys, i want to populate a drop down list with ajax, and so when i select the first option thesecond one select must be populated in table like if shoose <select><option>value one</option> <option>value two</option></select> was supoose be populated the second value in another select, but i want be populated … |
| | I have an issue in select query. I want to select total_comment From comment table and show it under each post. **What I Try** SELECT SUM(total_comment) AS comment FROM user_comment INNER JOIN post ON user_comment.image_id = post.id WHERE status = 0 **And** SELECT SUM(total_comment) AS comment FROM user_comment WHERE status …  |
 | Hello, I have a app where each page has an undefined number of tables (Meaning on one page we may have 3 tables and on another we may have 15). They are all dynamically populated with values from a MySQL Database, creating a template of sorts. The idea behind this … |
| | Hello everyone,i have two questions regarding vbnet and binding navigators.As you can see in the pic i have attached ,if we create a database in microsoft access,by going on the database tab and dragging the table in the form,automaically the binding navigator is placed on the top and we just … |
 | Hi Guys, Im currently working with application, where it will automatically inform the user that there is an overdue account today. i decided to compare the current date(today) to stored date in mysql database, heres my code: Public Sub getReminder() Dim _con1 As New MySqlConnection Dim _cmd1 As New MySqlCommand … |
 | Hello friends, I havea mysql database setup as the following database -------------- products | flexRange | color | pressingWidth | topSpacerorTopDie -------------------------------------------------------------- I have 400+ entries into these columns - the end result is to have 4 drop downs where the end user will select one item from each drop …  |
| | I am trying to do a check to see if a student meets the prerequisite before they can register for a course section. CourseSecID = 27 (ID of the course section the student wants to register for.) What I am doing is querying the student's acad cred records to see … |
| | Am creating an online examination website. I need to store the answers answered by the participants who are given a unique ID. So I will be storing ID, Answers for the question, score. So I think I have two ways to do it. 1. Create a table for every student … |
| | i'm making table reservations scheduling table with PHP and Mysql. i'm stuck on one thing, dont know how to check every cell i must print,which will indicate a reservation, with every column,which will indicate hours. Can anyone give me an idea ? i will get my reservation info from database …  |
| | I have a gps sending data to mysql db, but am having hard time ploting the values on google map. My javascript skills are not very good, pls help... javascript code <?php $server = "localhost"; $username = "root"; $database = ""; $password = ""; $conn = mysql_connect($server,$username,$password); mysql_select_db($database) or die("Unable … |
| | |
| | cannot update the db with below query. little help will be much aprreicated. Thanks in advacne $order_number=$_GET['order_number']; $invoice_id=$_GET['invoice_id']; $credit_card_processed=$_GET['credit_card_processed']; $total=$_GET['total']; $key=$_GET['key']; $email=$_GET['email']; $query = "UPDATE register_users SET order_number=$order_number, invoice_id=$invoice_id, credit_card_processed=$credit_card_processed, total=$total, key=$key WHERE email=$email"; |
| | Hi, I wonder if anyone can help me with a basic MySQL/PHP output problem please. I have a table called 'Recommendations' which has a small number of fields (id, recom_date, recom_name, recom_status and recom_size). I want to be able to show the 'recom_status' field as a heading with the other … |
| | Currently I have form with couple of fields and field for image. I have done with the part of field storing but don't know exactly how to store image path with PDO and can't find good tutorial. All I found was how to store image into DB instead of path. … |
| | Good day! I am now currently ugrading our database to mySQL. My problem is that, how to convert the any msaccess SHAPE command to a mySQL database syntax using 6 and get the same result? Below is the sample code: spath = App.Path & "\employeeaccnt.mdb" cn.Open "Provider=MSDATASHAPE; Data Provider=Microsoft.JET.OLEDB.4.0;Data Source=" … |
| | Hi. I'm new in PHP Mysql , please help me with this situation : i had this php code <form action="insert.php" method="post"> Check locked backdoor<br /> <input type="checkbox" name="Check[]" value="A" />Yes <input type="checkbox" name="Check[]" value="B" />No <br /> Laptops handover monitor<br /> <input type="checkbox" name="Check[]" value="A" />Yes <input type="checkbox" name="Check[]" … |
| | Hi all, I want to import a .csv file into mysql database with using php code. How i can do this . what php code i will have to use for this. Please help me to do this. Because i have thousand of records which is in .csv file format. … |
| | Hi Can anyone please help me on below issue I have created a website with PHP & MySQL. Its look like an Desktop Applications  |
| | I really would like to know the best way of going about this issue I need to union 2 select statements and then do a select statement from result of the union |
 | I want to find who is the heaviest borrower among the student and displaying Sname and heavy count. I have the following tables. tablename student having attributes SID,Sname,Spho. tablename sborrow having attributes SID,CDID,borrow_date,return_date. tablename Cd having attributes CDID,title. I have executed the following query in Mysql but it gives me … |
| | i was trying to login to this website I'm trying to create and i got this error: > Connection failed: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) please help me. TIA! |
The End.