10,932 Topics
![]() | |
somebody knows how to call mysql Procedure in PHP? i extract almost forum regarding procedure in php on google but didn't find solution. pls. reply ASAP. thanks in advance | |
I am using adodb to import a CSV file into a MySQL database. One of the fields is lastname. One of the contacts being imported has a last name of 'null' (yes, that is really his last name). It always gets valued as a NULL value, not null the string … | |
Hi everyone I was wondering if there is a way to store data to a mysql db after it is screen scraped? Thanks | |
I currently have a database that is just one table with products and is using the myisam engine for the fulltext capabilities on two columns. The question I have is that this database has about 390,000 rows with a lot of duplicate entries namely manufacturer, price. I have been searching … | |
Hi all, I wonder if it is possible that someone can drop me a code or something on this particular problem which I am currently dealing with. in_date out_date 18/03 30/04 20/04 So how am i supposed to pair up 30/04 and 20/04 as 1 pair and show it up … | |
Hello everyone, I'm currently building a cms system and have hit a brick wall in relation to the error I'm getting below. Any help would be greatly appreciated. Thanks James. The error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\widget_corp\includes\functions.php on line 41 The functions.php: … | |
Hi people. This is my first thread, i hope you can help me. I'm a newbie and my english is so bad, but, i hope you can understand me. this is my question: I've a table TURN with this field IDTURN (int) SEASON (string) SORT (string) another table GROUP IDGROUP … | |
Hey, im having a problem getting this email check to work it basicly prints out in a very origional way how manny eails you have... [COLOR="Green"][B]Check Inbox [/B]([I]3[/I]) [/COLOR] Heres the code: [CODE]$find_content = "SELECT * FROM email WHERE email_too_id = '$userid' OR all = 'true'"; $content_sql = mysql_query($find_content) or … | |
how to copyng data from another database postgre to mySQL database without cronjob with realtime... thanks | |
Hey, could use a little help here. I must be brain dead but I can't think at all, I need help. I have a table with a bunch of IP addresses in it and a lot of them are the same, how do I -- Remove all the IP's except … | |
Straight to the point...:) I have problem connect to database. when I click Login button, the code can't read the username in my database. I have checked the codes but i think there are some mistakes, but i don't know where it will be. Please help me. Here with I … | |
I get the following when attempting to view a project I have, I have MySQL 5.0 and Tomcat 6.0. Both services are running. As far as MySQL connectors, I have both "mysql-connector-java-5.0.7-bin" and "mysql-connector-java-3.0.8-stable-bin". This has not worked with either one. HTTP Status 500 - type Exception report message description … | |
I am new to VB. Yesterday I learnt how to connect to a database. My work computer has Microsoft SQL Server (which I could connect to) but I use mySQL at home and do not know how to connect to it. Can somebody please help? | |
I'm a C++ beginner. What's an easy to use (in terms of both installation and use in code) library for using MySQL in C++? Is there one that's a lot more commonly used than others? Note that I'm using MySQL 4.1.22 on GNU/Linux. I've found the following: [LIST] [*][URL="http://dev.mysql.com/doc/refman/4.1/en/cplusplus.html"]MySQL++[/URL] [*][URL="http://www.sqlapi.com/"]SQLAPI++[/URL] … | |
I've fired a query which result some data with the respective count from the table and after that i want to fire a query to get the total number of count on that count which i got it from my first query. Could anyone helps me out to get the … | |
I was trying to create a moving average. Here's the sample data: [code=MySQL] create temporary table if not exists window (id int); delete from window; insert into window(id) select 1 union select 2 union select 3 union select 4 union select 15 union select 6 union select 7 union select … | |
hi all, Is there a code where i can check from all the existing tables if a certain variables exist in it? I am currently working on a project but the tables are not linked properly, having a hard time trying to find out how many tables actually have the … | |
Hi!! I have a problem to connect VB to Mysql database | |
Here is the code. For a short time, I will leave the test results up at [URL="http://superiorminitrucks.com/inventory"]superiorminitrucks.com/inventory[/URL] Clearly, I need to stop it from displaying the final entry twice.. Thanks in advance.. [CODE] <?php $db_connection = @mysql_connect("######", "#####", "####"); if (!$db_connection) exit(); mysql_select_db("tefflox", $db_connection); $result = mysql_query("SELECT * FROM trucks"); … | |
What would be the php mysql code to search more than 1 field in a table ? Im trying to search for a given partial phone number in all three fields home mobile and work .. im trying to use $query = "SELECT `first`, `last`, `home_phone` , `work_phone` , `mobile_phone` … | |
Hello Friends, I have three table and i want to select data from them Table 1 Roll No. --- Name---Age 1------------a--------12 2------------b--------13 Table 2 Roll No.---Name---Age 7------------d------12 8------------b------13 9------------c------12 Table 10 Roll No.---Name---Age 41---------d---------12 43---------b---------13 44---------c---------12 Table 3 Roll No.---Sex 1------------f 7------------f 41----------f i want to select date from Table … | |
| |
Good day to all. I have an existing vb project and my back end is ms access. I changed my database to MySQL and SQL but the problem is I don't have any idea how to connect my VB project to MySQL and SQL throuch ODBC. Your help is very … | |
hi guyzz, i wanted to have two connection using access and mysql in my proj. my access was my main db connection and what ever data in my access will store directly in mysql db when their is internet connection... I declared 2 fuction connection but my problem is the … | |
"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." Now this is a really stupid error. (yes that sums up the error S T U P I D) I am making an update to … | |
I have written this code in Jsp file . [code=JSP]<% Connection con=null; Statement st=null; PreparedStatement ps; String nm=request.getParameter("tnm"); String loc=request.getParameter("tlc"); try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/rahul","root","root"); st=con.createStatement(); try { ps=con.prepareStatement("insert into dept(deptname,location) values(?,?)"); ps.setString(1,nm); ps.setString(2,loc); ps.executeUpdate(); out.println("Value inserted "); } catch(SQLException e) { out.println("sql is not executed"); } } catch(Exception ex) { … | |
I am helping a website owner to transfer a site to new servers. All site files have been uploaded onto the new server, only thing left is the database. In phpmyadmin, when I try to export the DATABASE to my local PC, using zip or gzip to compress, as this … | |
Using rs.open (bla bla bla........) then i need to streamreader each line from MySQL....how can i implement it? thanks |
The End.