10,940 Topics
 | |
 | i am building a message system for website.i have two table one store user_detail and other store message sent to each other users. you can see main.jpg file where inbox sent etc.. will be display and action takes accordingly. $query='select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, user_detail.user_id as userid, user_detail.username … |
| | I am working in a dataware house and few things are not clear to me that is why I wanna discus here. For example, I have 10 MS Access files, and each of they have more than 5000658 number of rows, and data is in such a format like **Plz … |
| | hello fellas i'm stuck in this function: function getDataForPagination() { $sql = "select * from t_book limit 1, 15; $result = mysql_query($sql); if (!$result) return false; $num_rows = mysql_num_rows($result); if ($num_rows == 0) return false; $result = dbResultToArray2($result); return $result; } i want to make the above function more flexible … |
| | Hopefully this will make sense and there is a solution in a single query... if not, I'm sure i can do it using multiple queries. I wrote a query that I thought would work, but didn't take into consideration that some of the records won't have data coming from one … |
| | Hi Folks, Recently I installed WAMP server for web development, during my first run I tried My Sql Console, but I was gettting error while creating a new table. I am surely missing something. I googled for it but cannot get what i was looking for . . . Am … |
| | Hi I have been trying for about a week to connect VB6 to MySQL and have so far been unsuccessful. What I am trying to do is have a login system in VB6 which, when the login button is pressed, searches the "userlogin" table in MySQL. If a matching result …  |
 |  |
| | I few weeks ago, I posted some code that I need help converting to MySQLi, now I need some help converting it to PDO. The code allows you to enter queries and commands and brings back the column headings and the information that I am looking for into a table. … |
| | this code runs at my other sample prog. but when I try to use it to my actual prog., it wont work. (variables changed, connection's ok) . . . cant show data at listview [CODE] Imports MySql.Data.MySqlClient Public Class Form1 Public sconnection As New MySqlConnection Private Sub Form1_Load() If sconnection.State … |
 | I am trying to learn MySQL to, '1 call all records from base '2 count number of records and store number as maxID, '3 display 1st record set by the ID number, '4 -A - add one to ID number- display record set in frame1 :(working_on_page_refresh -B - mins one … |
| | Hello , in a python application i wanted to insert datas to some columns of a table , the columns tha have as name "XS" , "S" , and "M" . i tried this query : `curso1.execute('INSERT INTO donnees (%s) VALUES (%s);',(liste1[i],qtetaillevar[i]))` , but when it compiles it , when …  |
| | I want to backup my database from vb.net 2010 and i am able to do this using mysqldump through vb.net 2010, but i want to backup my mysql database without useing mysqldump only by vb.net code. please help me ???  |
 | hi i am new to php and mysql, i am experimenting with a script for saving data to mysql database. and fetch the data on other page, i managed to get both of them without any trouble. But Here is the one problem. I added a additional input function to … |
 | hello i try this form and script _____________________________________________________ <form action="insert.php" method="REQUEST">backend - insert new record<br> id: <input type="number" name="id"><br> manufacturer: <input type="text" name="manufacturer"><br> transferrate: <input type="text" name="transferrate"><br> cache: <input type="text" name="cache"><br> size: <input type="text" name="size"><br> RPM: <input type="text" name="RPM"><br> use: <input type="text" name="use"><br> price: <input type="text" name="price"><br> seller: <input type="text" … |
| | hello i try this form and script _____________________________________________________ <form action="insert.php" method="REQUEST">backend - insert new record<br> id: <input type="number" name="id"><br> manufacturer: <input type="text" name="manufacturer"><br> transferrate: <input type="text" name="transferrate"><br> cache: <input type="text" name="cache"><br> size: <input type="text" name="size"><br> RPM: <input type="text" name="RPM"><br> use: <input type="text" name="use"><br> price: <input type="text" name="price"><br> seller: <input type="text" …  |
| | <?php $mysqli = mysqli_init(); $mysqli->real_connect("mysq.x.com","me","wordup","inthekitchin"); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $res = $mysqli->query("UPDATE plate1 SET potatoes =('$_POST[potatoes]') WHERE id =('$_POST[id]')"); $row = $res->fetch_assoc(); ?> returnes error `Fatal error: Call to a member function fetch_assoc() on a non-object … |
| | i have created a database with username,age,contact,email.now i want a column in which we can show whether the user is active or not.what sholud we do?if we create a column named as status,what sholud be type of column?boolean or binary or something else...??? i am using php to edit delete …  |
| | `$data= "echo * from table1 where id=$_post[ID] "` can anyone see why this line duz not compute please ? |
 | I am not able to insert data from CSV file with "¤" Character. Please help me to solve the problem. Thanks a lot in advanced. CSV File: FirstName¤LastName¤City¤Year |$| Bill¤Gates¤NW¤2013¤|$| David¤Beckham¤London¤2010¤|$| PHP Code: $csv_file = "Contacts.csv"; $csvfile = fopen($csv_file, 'r'); $theData = fgets($csvfile); $i = 1; do { $insert_csv = … |
| | I have 3 tables as mentioned below: Users Code Name NW London 1 Bill ---- ---- Contacts Code Country 1 USA Location Country City USA NW I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i … |
| | I installed a new script onto a Linux server using cpanel. > ERROR: Nothing parsed, nothing printed > Invalid query > SELECT * FROM `dating_country` WHERE `id` IN () > MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … |
| | Dear Respected Members/Users, I Cannot add/insert mysql last insert id in the third table. Kindly please help me out in adding the para_id into the last insert query. I have demonstrated in the Image file which will help alot in getting my point. Waiting for response. thanks.  |
| | why does this thing keeps on showing? what should i do?  |
| | hello guys i have created the below codes. the first one is the mysql select statement which works fine when i echo. the second one is an html/css table i created. i am stuck to the point where i can merge both of them so that i get a nice …  |
| | Hi All, I want to select rows from dynamic created tables i.e we have tables like web_analytics_mm_yy(ex: web_analytics_06_13, web_analytics_05_13, web_analytics_04_13 and so on) web_analytics -> table name mm_yy -> month_year. I know this can be acheived in PHP by using for loop { // CONSTRUCTING SQL STATEMENT USING // UNION … |
| | firstly I apologise in advance if this has been asked 100 times over.. I've been ambushed by my company i "HAVE" to use an old Mysql 4.1 server something to do with an atiquated system still running that cannot be upgraded for x,y and z reasons. but they want a … |
| | I have a problem that I've racked my brain with for two weeks without success. I have a table named 'user_answers' containing columns 'user_answer_id' and 'user_name'. Each 'user_name' has 25 rows. I'm trying to compare/count the number of rows where user A and user B match answer_id. SELECT COUNT (*) … |
| | Hello, I was wondering how i would create the Units table for this. Would i just set both Unit_ID and Customer_ID in the Units table as foreign keys or do i need to have a primary key like Customer_Unit_ID then have the two foreign keys? Customers Customer_ID Customer_Full_Name Contact_Name Address_1 … |
| | There has got to be a better way of doing this. First of all pay no attention to the lack of validation and error checking. I just want the core of the script to work first. Also, Block 1 and Block 2 execute, Block 3 does not. Whats the best … |
| | hi, i want to store date time whan i click radio button(name login time)in mysql. if i click logout radio button it should store logout time. ples help me... php and mysql code ... |
The End.