10,940 Topics
 | |
| | What driver do you need to connect vb.net to MySQL? How do I create a Data source to MySQL? ...am only getting the options for SQL and MS-database! Please help... am designing a reg system for a college! Thanx :-) |
| | |
 | Hi All, Im getting and error from the following mysql statement when running it in the browser. Any help would be appreciated. "you have an error in your sql syntax near -nextq accounts" on line 1" this is the code [code] <?php $result = mysql_query("SELECT DISTINCT(source) FROM accounts WHERE source …  |
| | Hello everyone, I have a little bit problem here.I have installed PHP version 4.4.1 and it's working well. I want to connect PHP with MySQl . I have also installed MySQL and it installed successfully. Inorder to configure PHP to work with Mysql, I did the following changes in the … |
| | I have tried and tried and looked and looked, but I still can'y get this to work.... I am trying to (a)check form data on-the-fly, (b)once all required data is entered, then CLEAN the data and insert into MySQL database, and ONLY IF (a) and (b) have completed, then (c)send … |
| | I was trying to backup a database with the name test. I got the error as below: ERROR 1064 (42000): You have an error in your SQL syntax; check...... This error occurred when I am executing (command line) mysql> mysqldump -u root -p password test > test.sql; How could this … |
| | Hi I m using xampp server in my localhost. I m having problem. When I change value by phpmyadmin of any table. query does not give proper result. For example In contact table I have change user id number from 3 to 10 by phpmydmin. When I query by user … |
| | I have a screwed install of MySql Server on my Machine its a 10.04 64-bit Ubuntu. I can neither Remove it or Install a new one. [CODE]I tried apt-get remove [/CODE]and [CODE]dpkg --purge mysql-server-5.1[/CODE] They both reach [CODE]dpkg --purge mysql-server-5.1[/CODE] and stay stuck there. Can anyone please help me completely … |
| | I'm alowing a user to save their "configuration" from a form to the database> I also want the user to be able to load that configuration back onto the form from the database. Now tbh I've got no idea how to do it. I'd like this to be done without … |
| | I need an Event Registration Script that allows for payment with Paypal & saves form details and Paypal transaction ID to my MySQL DB After the payment has been finalized. I want to have ppl be able to register for camp, and with that choose if they want to preorder … |
| | I have a mysql table full of pictures(their path) that are owned by many different users. I need to run the following query and return the results into a 5 column table. The number of rows will be however many it takes to display all the pictures. My query is …  |
| | Hello every one… I need help with VB 6 and MySQL. How to format the font in rich text box / text box (like - M3(M to power of3) 6 and also need store and select same text. Kindly help me. For information: I just tried some methods with the … |
 | I'm trying to pass several create statements through mysqli->multi_query, I tested the multi_query statements with a couple of queries and it works and when I called it with my actual create statements it just wouldn't go through... there weren't any errors and it returned true. I tested the query itself … |
| | hi, i want to add an end time in my query using my time to call column. at the moment i have a time to call which will be the start time however i want to add timetocall as endtime which is 15 mins after the timetocall column. i am … |
 | So I have a basic database of books set up. I am trying to use PHP to query the db and send back the results. I can sort of get it to work, but not working how I would like. The issue is that the search term that queries the …  |
| | Hello, I have set up a searchable database code for my website and I was wondering if it is possible to filter the database if I have two of the same names. Example: my database consists of names and other information, but I have similar names but different information for … |
| | Hi all, Fairly new at SQL, and running into the following problem. I am trying to create a query to count the number of unique fields in a column and display, but can't seem to get it right. For example, each day there are x number of entries from y … |
| | hi i manage to upload 1 file and save it to the server. how can i add more button to upload a file and save it to mysql? i want is after the user upload a file theres another a button to upload again another a file how can i … |
 | Hi There! I have a Ajax Function copied from W3Shools I have modified them as my Requirement but it won able to send the xmlHTTP request to my PHP page for result here the function [CODE] function showUser(str,txtId,mth,url) { if (window.XMLHttpRequest) { xmlhttp=new XMLHttpRequest(); } else { xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } … |
| | You could say I bit off more than I could chew... However, what's done is done and I'm pulling the rest of my hair out and looking to the DaniWeb community for help... I am building a site that people can log in to and select classes that are owned … |
| | --You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #10' at line 1--- [code] <html> <body> <form action="login.php" method="post"> <div> <table width="100%"> <tr> <td><img src="Logofinalcopy.gif"></td> </tr> <tr> <td bgcolor="aqua"><h2>Login</h2></td> </tr></table> <table align="right" … |
| | Hi There, I am using a sql query to show a row to users. The Problem is in the database there are single as well as duplicate records. My 1st code is – Works good if user has no duplicate records; [CODE] SELECT contacts.forenames, contacts.surname, addresses.postcode, contacts.contact_number FROM contacts LEFT … |
| | hi.... can anybody give me link for php compiler exe file???? and mysql...whateva needed to build a web application.... i'll be thankfull.... |
| | |
| | i had created a function which convert the string in Proper case but i want to modify all the records in a particular table by just providing the table name to the function so the function/procedure will have to update all the records in proper case, in record by record … |
| | I was following this tut. on how to install Apache, PHP, Mysql, and PHPmyadmin. I need a bit of help! I get a [B]"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\mysql_test.php on line 15"[/B] everytime I test the mysql thing. What ive …  |
 | When I try to log into mysql with the command [icode]mysql -u root -p[/icode], i enter the password then it gives me the error: [code] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/sbin/mysqld/mysqld.sock' (20) [/code] I really don't know why it's trying to use '/usr/sbin/mysqld/mysqld.sock' because … |
| | Alright, so I have been working on building a photographer a website. She requested that she would like a page that would allow users to log in and view their proofs and only allow THEM access to their own pictures. I have successfully created a log in page using sessions … |
| | #include <my_global.h> #include <mysql.h> int main(int argc, char **argv) { printf("MySQL client version: %s\n", mysql_get_client_info()); } I got the error when i try to compile the above code.  |
| | Hello, I have a txt file of the following format: 315151,34.56,1,1,54442221,23344445 512512,12.54,1,1,23444442,45612345 I am using the following code to parse it and it works: while( fgets( output,sizeof(output) ,file) != NULL ){ i=0; token[i] = strtok(output,","); while( token[i] != NULL){ i++; token[i] = strtok (NULL, ","); } dec2bin(atol(token[4]),binaryBefore); dec2bin(atol(token[5]),binaryAfter); dec2bin is … |
The End.