10,940 Topics
 | |
| | I have eight tables with the same schema but containing different data: `node_a_data` ( `node_a_data_id` int(5) NOT NULL auto_increment, `timestamp` int(10) NOT NULL default '', `user_count` int(5) NOT NULL default '0', PRIMARY KEY (`node_a_data_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=795 ; The timestamp field just contains a Unix 10 digit timestamp … |
| | i am designing a site...under xampp with php...now,i have a table called link where i want to link some special links by fething it from database...but my problem is when i open it ....it happens something like below... suppose I give a url "www.intel.com" in the database by hyperlinking a … |
 | cannot connect to mysql server error 10060 on sqlyog on my other domain but ok on the other one. Just awhile ago I can connect to both domains but after restarting my pc I can't connect to the other one. Some said to turn off firewall which I did, it … |
| | [code=java] public static void setValues(PreparedStatement statement, Object... values) throws SQLException { for(int i = 0; i < values.length; i++) { if(values[i] instanceof Integer) { int value = (Integer) values[i]; statement.setInt(i, value); } else if(values[i] instanceof String) { String value = (String) values[i]; statement.setString(i, value); } } } public static ResultSet … |
| | |
| | I am developing a portal using php and mysql. I am facing a problem in the database design because my database is going to take million of records. I am not very much experienced in database design. So I request some experienced people to come forward for my help. I … |
 | Hello all, I work on MySQL and i have knowledge about it. I have no idea of what Apache is? I googled and came to know just like MySQL it is also a Web Server and nothing more about it. When people ask me if i have experience with Apache?! … |
| | Hey All, I wanted to find if it this is possible. I have a db in sql server with some large tables and I would like to transfer the entire db from one server to another server without having to create the tables and so on. Is this possible? Thanks |
 | In a application for online test, the rank list is computed as follows- [CODE] select * from test order by marks DESC[/CODE] How can we make sure that the first record gets rank1, second rank2 and so on... I want to add the field to the table. Can this be … |
| | I have done these scripts a thousand times. I still however can't seem to sort out this issue. The issue is that this block of code should return 3 images although it doesn't it only returns one image. The other one I am getting is from a different loop that …  |
| | Hey Everybody - I'm looking into creating a calculating form for a website. I know that i can be done in JavaScript but my boss is requiring it be done in SQL as well as probably CF. I usually use SQL/CF for only simple databases or form submissions, so this … |
| | hello hi i am using mac osx 10.5 i want to start mysql in it with --log-bin option so as to take incremental backup.so how can i start mysql with that option. i start mysql as mysql -u root -p. plz help me. where can i find my binlogs |
| | hi all i had taken backup of my database and added some tables so as to take inc.backup i had a binary log as mysql-bin.000001 now i want to make a incremental backup from it. plz help me how can i use this log for inc.backup in mysql |
| | Currently connected to remote server but remote configuration is not yet possible this is msg shown when trying to connect remotely to a database what does it means |
| | hi guys, found out about this forum a few weeks ago and found it very useful in regards php issues, i started to experiment with the language lately so i'm still a beginner, i need some help the following code: [CODE]<body> <?php ob_start(); include 'cms/core/config.php'; include 'cms/core/opendb.php'; if(isset($_POST['save'])) { $description … |
| | hi, i am a newbie in mysql and i have some questions about performance tuning. 1-) in a system where you have to store information about a user, such as, user_name, id, last_log, is it better to store all the information needed in one table (lets assume 30 fields in …  |
| | Hi i installed the system as instructed but when i try to login with my username and password this error is shortly being displayed: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smledit/public_html/sms/classes/crc_login.cls.php on line 129 You can check it out at: [url]http://www.sml.com.mt/sms/pages/crc_login.php[/url] Looking Forward to …  |
| | Hi, I created a sample frame in Java and connected with the database and when i converted to exe file the database is not accessible ..can any1 suggest me is it possible to access database in exe else wat method do i need to implement in order to acheive this. |
| | Hi I will explain what I am trying to do: I have used MYPHP admin to create a database where user booking details will be stored in a table called bookings. Now I need to retrieve all the bookings for a specific date. For achieving this I have created two … |
| | Hello, I am trying to add hyperlink to my mysql query result. I have a table called EastLondon which consist of the following: [code] (restaurant_id INT UNSIGNED PRIMARY KEY, restaurant_name VARCHAR(20), phone_number VARCHAR(20), picture varchar(8), website varchar(40)); [/code] I extract all these info into a table using php. What I …  |
| | [I]<< Split from [URL="http://www.daniweb.com/forums/thread6923.html"]http://www.daniweb.com/forums/thread6923.html[/URL] >>[/I] Hi i installed the system as instructed but when i try to login with my username and password this error is shortly being displayed: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smledit/public_html/sms/classes/crc_login.cls.php on line 129 You can check it out … |
| | I have a java applet on my web page. How do i get it to send data to my mysql database? I was looking at jdbc but i don't think it works on remote servers(I am using a web hosting service). |
| | Hi I am brandnew to php and my sql. i am trying to put guest entry to my web. when i run my web, i get this error : `Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource` Here are the surrounding lines $SQL="SELECT * From Guestbook"; $Content=mysql_query($SQL); …  |
| | I need to put some static pages into a mysql table This is a sample static page HTML Code: <title>acquital</title> <meta>acquital</meta> <type>lawglossaryitem</type> To be acquited of a crime is to be deemed to be innocent of the charges after a court hearing. This is different from a <a href=lawglos_Discharge.html>Discharge</a>, where … |
| | Hello everyone ! This mysql user management fcking damn BULLSHIT (i think we can state it) begins really to drive me mad.. I got a win 2003 server running mysql, somehow i lost root access from the localhost meaning that i'm actually unable to make a backup from my database, … |
| | hi everyone i want to insert and retrieve images from the mysql using php(in wamp server).actually i searched the net and tried with many codes but cudnt find a solution.in the last one tht i tried,i created a table tht includes a blob datatype for one of its attribute and … |
| | Hi there Guys! I migrated my site to a new server and I had backed up my site. I uploaded the compressed version of the backup to the new server. But when the upload was completed i saw that i wasn't compressed. Anyways, I'll tell you step by step of … |
| | I need mysql queries for the following : (A)i have table with column headings emp name and password sno empname password 1 ani abcdefgh 2 venus bcde 3 joe bcdef 4 mary abcdef Q1:I want a mysql query to select and display the passoword whose character length is from 3 … |
| | Hello, i'm very new to c++ and i'm trying to create some sql but dont really know how. i need a very simple query in php i would do something like: [CODE] $page = "pagedata"; $sql = "INSERT INTO data SET field = '$page'"; [/CODE] i know i cant do … |
| | relative php noob needs help, have tried 3 or 4 differnet ways to get an image along with other post data from an html form to save into a mysql db. other data saves fine, no luck at all with image. php and form code below. HELP. Thanks in advance. …  |
The End.