10,938 Topics
 | |
| | Hi. I'm programming an e-commerce/online store using servlets and a MySQL database, and I'm having some problems with the db right now. Hope somebody here smarter than me can give me a hand. There are two kinds of users, both having their own table in the db: customers and admins. … |
| | Is using php with MS SQL server over MySQL a good practise? Ive been using MySQL for quite sometime and what I like about it is that it is free. Are there any advantages of using MS SQL server over MySQL? Or any challenges. |
| | I downloaded the php. MySQL and the apache but, I am facing a problem in which the code is being displayed and not the web page. There must be a configuration problem. Any help would be much appreciated. |
| | Hey there =) Im struggling to save a file to my MySQL database. I managed to save a image to the database with this code [CODE] SqlConnection con = new SqlConnection(Properties.Settings.Default.NorthWestConnectionString); SqlDataAdapter da = new SqlDataAdapter("Select * From MyImages", con); SqlCommandBuilder MyCB = new SqlCommandBuilder(da); DataSet ds = new DataSet("MyImages"); … |
| | hi i know there is a lib for mysql in c++, but i can't seem to install it properly! someone has a place i can find a tutorial for mysql for: Windows XP, Codeblocks. thx for helping. Checklist for Fast Responses: 1: Search before you post. Does what you're looking …  |
| | I;m trying to move a database created with WAMP from one computer to another. I've exported it as a .sql file and imported it by creating a new database and then importing into it. The problem I'm facing with this approach is that none of the data in the tables … |
| | I have code where I am pulling data from my database and it needs to be separated by commas except the last value (that part works) so I can take those values and input into another SQL query. Here is the working code: [CODE]$biz_id = $row_businesses['id']; $query_related = sprintf("SELECT * … |
| | Hello Friends, I am working in JME. Now, I have situation in which, I suppose to connect with Database which has been used with PHP. So, How can I access to Mysql? As usual same as to connect mysql with JDBC? Is Mysql and Mysql in WAMP Server different? Please … |
| | i can't finde my.ini or my.cnf i installed XAMPP and it can't start mysql and the error is: because of port 80 and 3306 and i look up with netstat i don't find any program use these 2 ports and my firwall is off what can i do to start … |
| | I'm having trouble with a MySQL INSERT query. I've used this exact code in many places, and even in different pages on the same web server. I feel like I've tried every variation of INSERT query with no luck. Here are a couple that I've tried so far: [CODE] $name … |
 | how does one search mysql where one fields has multiple entries. example: in my db i have two fields in table, one field is the type field: id | Garment | Type 1 | Satin Shirt | "Chemical Clean" 2 | Silk Shirt | "Dry Clean", "Chemical Clean" When i … |
 | Query Runs in mysql but gives an error when I run in PHP here is the query [CODE]select p.pid as pid, s.sid as sid, s.status as staus, p.name as name, p.mobile as mobile, p.email as email, c.name as course from students as s, prospects as p, courses as c, batch … |
| | I'm not sure where to begin on this... I have a survey engine that supports 7 types of questions and really an unlimited number of entries per question (yes/no being one exception). So, I have 7 tables and each table correspondes to one answer type so I have: response_bool (true/false … |
| | Hey there =) i have 2 tables with a relationship between them. a Primary key in the one table, and a secondary key referencing the primary key, in the second table. Now usually when i want to display data in my db i INNERJOIN the two tables, so i can …  |
| | Hi I'm not an asp .net developer although I have done web development with php and mysql, I'm more of a software developer for desktop and mobile devices. So this is my first big project with ASP .NET. I have a question with the ASPNETDB database, understand that the database … |
| | I have the php which can import the csv files into mysql. But how to avoid the wrong data replace the data database. What is the code in php for checking before insert into the database? Thanks!  |
| | Hello to all,m kawal had rcecntly started my carrier in php so requests to help me in my projects.... I wana know how to generate a password by the admin panel itself..for ex.If if m running a company and handling admin panel,how can i generate a password to a new … |
| | I don't know how to enquiry the "informationtype" which are message and email? How to rewrite the below code? [CODE] $information = mysql_query("SELECT * FROM table WHERE informationtype='message'"); $row = mysql_fetch_assoc($information); $result=($row['informationno']); [/CODE]  |
| | I'm trying to run this code but there is error message: PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource [code] <?php if (mysql_connect('localhost','root','') && mysql_select_db('guestbook')) { //echo 'connected today'; $time= time(); $errors= array(); if (isset($_POST['guestbook_name'], $_POST['guestbook_email'], $_POST['guestbook_message'])) { $guestbook_name = mysql_real_escape_string(htmlentities($_POST['guestbook_name'])); $guestbook_email = mysql_real_escape_string(htmlentities($_POST['guestbook_email'])); $guestbook_message = … |
| | I'm going a little crazy here trying to figure this out. Any help would be greatly appreciated. MySQL version: 5.0 I'm trying to make a very ugly php page used to basic queries. I have a similar page working that creates new records in the specified table, so I know … |
| | I have problem in code for IF statement. Im looking in a mysql table if there is a field (fld_comleted) that has record with "NO" in it. If there is a record that has "NO" in it it has to do something (send email to client) if there is no … |
 | Hi, I wrote a qyery: [CODE] SELECT introtext FROM jos_content JOIN jos_sections ON jos_content.sectionid = jos_sections.id WHERE jos_sections.title = 'Redaktores zodis' ORDER BY publish_up, DESC; [/CODE] If I don't use ORDER BY then it works. But with it it throws error: Query : select introtext from jos_content join jos_sections on … |
| | Hello to all,m kawal had rcecntly started my carrier in php so requests to help me in my projects....thanks  |
| | Hello Friends, I am working in JME. Now, I have situation in which, I suppose to connect with Database which has been used with PHP. So, How can I access to Mysql? As usual same as to connect mysql with JDBC? Is Mysql and Mysql in WAMP Server different? Please … |
| | i have designed a windows forms which has a textbox in it,in that textbox i will enter path and on click of button i will bind that data to database(mysql) and i am done with it.but if the entered path contains ''(escape character) it will be ignored while binding for … |
| | Hello all. The Java Date and time classes are difficult. I think I have to use java.sql.Date which is a sub class of Date but is not a date unless the time is normalized to zero. so I've heard. I would like to work with my studentDOB first by collecting … |
| | Hello, I have the following situation which I can seem to resolve. When I do an "ALTER TABLE" in mysql (v5.5) it hangs in with "waiting for metadata lock". Here is how I got there: - i have an xml which i want to import into a table; i use … |
| | Hello Guys, I'm having the biggest headache over this issue. I have a system that I designed which uses a standard php login script to a MySQL database. The system has account registration etc. For the past 5 months I've tested multiple accounts and logged in with one primary account … |
| | Hello! I am interested how can I find the connection string in order to be able to connect to MySQL Server 5.1.50 using OleDbConnection(C#). I used this auto generated string (after adding new data source in Visual Studio): [QUOTE]erver=localhost;User Id=MyID;password=MyPassword;database=MyDatabase[/QUOTE] but I always get the same annoying error saying: [quote]An … |
| | Guys Is there a way to export the record of a table in csv format and then send that csv as attachment in mail to anyone using php? Thanks |
The End.