10,938 Topics

Member Avatar for
Member Avatar for dreamluverz

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 …

0
78
Member Avatar for dev18

[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 …

Member Avatar for dev18
0
2K
Member Avatar for vidhyaponnusamy

Hi, I am retrieving the below values from the table and use the values in drop down box in php,i don't want to retrieve [B]"All"[/B] value from the table,i tried with except keyword queries, but i din't got the value,please help me out 01 Dean 02 HOD 03 Students 04 …

Member Avatar for vidhyaponnusamy
0
82
Member Avatar for shinejones

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 …

Member Avatar for shinejones
0
91
Member Avatar for csharplearner

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?! …

Member Avatar for csharplearner
0
272
Member Avatar for nadineatwaroo

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

Member Avatar for Fest3er
0
85
Member Avatar for tuse

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 …

0
90
Member Avatar for Josh Connerty

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 …

Member Avatar for somedude3488
0
104
Member Avatar for tecoya

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 …

Member Avatar for noelthefish
0
56
Member Avatar for srpa01red

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

Member Avatar for varmadba
0
85
Member Avatar for srpa01red

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

0
39
Member Avatar for srpa01red

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

Member Avatar for varmadba
0
87
Member Avatar for odysea

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 …

Member Avatar for odysea
0
98
Member Avatar for bas_brain

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 …

Member Avatar for Shanti C
0
135
Member Avatar for chrisscicluna

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 …

Member Avatar for lqdo
0
185
Member Avatar for Kishorey

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.

Member Avatar for Kishorey
0
55
Member Avatar for HB25

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 …

Member Avatar for Josh Connerty
0
204
Member Avatar for zynap

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 …

Member Avatar for ShawnCplus
0
4K
Member Avatar for chrisscicluna

[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 …

0
79
Member Avatar for kinger29

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).

0
97
Member Avatar for chakaox

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); …

Member Avatar for cwarn23
0
125
Member Avatar for externalaw

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 …

0
68
Member Avatar for alvoryx

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, …

Member Avatar for alvoryx
0
85
Member Avatar for mhariharasudan

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 …

Member Avatar for mhariharasudan
0
129
Member Avatar for omidiu

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 …

Member Avatar for Josh Connerty
0
65
Member Avatar for karthikam

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 …

Member Avatar for Josh Connerty
0
118
Member Avatar for lifted

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 …

Member Avatar for lifted
0
154
Member Avatar for dwatycha

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. …

Member Avatar for Airshow
0
149
Member Avatar for genieuk

Hi, If you see my other post about writing data to a file i am not doing that now i am using a database instead. Anyway .... Before i start i would like to say i am very very new to PHP and no very very little about MySQL writing. …

Member Avatar for genieuk
0
158
Member Avatar for genieuk

Hi, I been having allot of help on here certainly from 'Josh Connerty', who has done a fantastic job of helping me. I am learning php and am enjoying it. So before i start a big thanks to Josh Connerty and this forum existing as it is a pleasure to …

Member Avatar for genieuk
0
94

The End.