10,940 Topics

Member Avatar for
Member Avatar for kaleidoscopelex

Im having these problems, it used to work in my website for almost a year then suddenly this error occured.. [B]Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/alexsl/public_html/admin/system/[B]functions.php [/B]on line 291[/B] here's [B]functions.php[/B]: [code=php] <?php // Somery, a weblogging script by Robin de Graaf, copyright …

Member Avatar for stymiee
0
161
Member Avatar for macneato

Hi, Was wondering if anyone could help me with this little problem I'm having. I'd like to have a comma separator after every 3 digits. E.g "3,000,000". How would i go about this? Thanks in advance

Member Avatar for pritaeas
0
132
Member Avatar for john_sm

Hey guys, for an enterprise wide deployment, what will you suggest and why among - Red Hat Linux, Suse Linux and Ubuntu Linux, also, do you think, we can negotiate the support pricing down?

0
63
Member Avatar for arkaprava
Member Avatar for thecurious

Hi everyone. I`m looking to solve an issue. My problem is : i have more tables, but in my example will be only 3 with 2 columns: users (id,nick) comm (id,userID,text) rev (id,userID,text) So , i need to count the comm and the rev that users make, multiiply by a …

Member Avatar for thecurious
0
101
Member Avatar for dodol

How to fastening inserting data on mysql??? I have 5000 record in excels. And I want to insert all record to mysql.. and it take time abaout 6 six minutes.. How to fastening become under 20 second to insert all 5000 records?? Peace DODOl

Member Avatar for clearstatcache
0
146
Member Avatar for Alligator

hi all, I am a developer intending to do Mysql 5.0 Developer Certification. How this certification is valued in the IT industry? Is it worth doing MySql certification? Please advise. And if anything you want to say about Mysql 5.0 Developer Certification. Thanks

Member Avatar for atal
0
90
Member Avatar for muskan

i am writing code and also the error i am facing in database connectivity in jsp to mysql .plz help me .thanx code import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Connection; import java.sql.*; import java.io.*; public class ConnBean { Connection conn; Statement st ; public ConnBean() { String sqlDriver= "com.mysql.jdbc.Driver"; …

Member Avatar for masijade
0
181
Member Avatar for kevted

Hi out there!! I have a problem in creating relationships in MYSQL. could some help me out there? Am a beginner in system development and I would like to learn more. YOuare great

Member Avatar for macneato
0
76
Member Avatar for pulse0

I'm developing a small, web-based poetry sharing website. I'm a beginner in PHP and MySQL. I want users to have a personalized page where they can work on their work in progress, once they feel they can publish it for the other users to view. I've already created a login …

Member Avatar for macneato
0
90
Member Avatar for Anna ms

Hi, I'm newbie here. I just noticed that HR control panel have no feature to check and repair MySQL database if the database got corrupted. I knew CPanel have this feature and I guess the HR control panel look similiar like CPanel (CMIIW), but no feature for Check and Repair …

Member Avatar for macneato
0
99
Member Avatar for piers

I was reading through my java book which is called Introduction To Java Programming Sixth Edition by Y.Daniel Liang and I was reading about databases. I just wondered if java is used in webdesign for the purpose of creating databases and if that was instead of MySql and what the …

Member Avatar for jwenting
0
96
Member Avatar for hoboken411

Greetings. My first post. I'm running a fairly popular wordpress blog (about a million page views a month). I have a plugin called "recent comments" which lists the last 20 or so comments in the sidebar of the site. However, the queries it makes are very disk and CPU intensive. …

0
61
Member Avatar for devknob

PHP version 5.1.6 MySQL version 5.0.27-standard-log Table is super simple, 1 primary key, uid, unixtime(timestamp),blog, pro, bull, pix [code] if($uid > 0 && $id != $uid){ include('connection.php'); mysql_query("INSERT INTO history SET uid='$uid', pro='$id'"); } Thats all. Does anyone know why this would create two identical records every time? [/code] Anyone …

Member Avatar for katharnakh
0
57
Member Avatar for eswar jinugu

hai,i have a table,consists of data which gets updated data time-time.i want to access the data based on date & time.

Member Avatar for iamthwee
0
59
Member Avatar for curly73

I am new to PHP and I don't have a seperate server. I am running Dreamweaver CS3 with Developers toolkit and Xampp 2.1.10. My problem appears to be that I cannot get my head around whether I need to have a seperate server, or whether I can do everything locally. …

Member Avatar for digital-ether
0
94
Member Avatar for pvc4twenty

I have uploaded the site and get this error message on the home page: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/d/t/e/dtedder/html/index.php on line 55 line 55 of index reads like this: $totalRows_rsArticles = mysql_num_rows($all_rsArticles); Any suggestions?

Member Avatar for Ezzaral
0
61
Member Avatar for macneato

hi, dont usually ask for help since i believe in google. But im in a serious fix. intro: currently working on a table that has three fields, 'id' 'current' 'previous'. problem: i want to insert another field (or two - no too sure how to go about it) but with …

Member Avatar for iamthwee
0
84
Member Avatar for john_sm

Hey Guys, I am still in a thinking stage and will like to learn from your experience, and was wondering if any of you folks have a hybrid environment i.e. Linux and Proprietary systems and what kind of issues do you run into. And also, what pieces of technology you …

0
69
Member Avatar for e1seix

Help me out guys. I am probably being such a bonehead but I can't figure out where I've gone wrong with this code for adding Next/Prev buttons to my pages: $ ID = $_GET; $limit=2; // rows to return $numresults=mysql_query("SELECT * from fragrances WHERE ID=$ID ORDER BY title"); $numrows=mysql_num_rows($numresults); // …

Member Avatar for katharnakh
0
125
Member Avatar for ankitagalaxy

I m beginner in Php-Mysql. I have installed apache PHP-Mysql but still it is showing problem in running the script. I really need a help to learn it. Anyone is there who can solve my problem.

Member Avatar for stymiee
0
43
Member Avatar for raghvendra1947
Member Avatar for peter_budo
0
104
Member Avatar for staneja

I am trying to create a calss with a constructior that creates connection with MYSql database , i am using database name as dbetch . I have set the path varable but still it id throwing error package login; import java.sql.*; import java.sql.DriverManager; import com.mysql.jdbc.Connection; public class conn { Connection …

Member Avatar for staneja
0
156
Member Avatar for cancer10

Hi Does anyone know what is the simplest way to backup a database using the [b]mysqldump[/b] function in php? I have googled a lot and the codes i have found are very hard to understand and most of them does not work. Thanx in advance for your help.

Member Avatar for MitkOK
0
283
Member Avatar for kodiak

ok, so i need to insert something to my mysql database. I have seperately tested the connection, and it's good. It's just something wrong with my code. Look at it. [code=php] <?php include("db.php"); $link2=mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); if(!$link2){ echo "could not connect.";} $myusername="test"; $mypassword="test"; $sql="insert …

Member Avatar for kodiak
0
116
Member Avatar for Caled

Hello, I'm developing a small, web-based music sharing application. I used to create static HTML contents. But now, I need a dynamic site that retrieve information from databases (also write data to database). As a beginner in PHP and MySQL, I hope someone from here can help me out.. Here …

Member Avatar for atplerry
0
95
Member Avatar for MitkOK

Hi folks. I Have a question : I'm interested how you generate query string to search DB with more than 1 form with LIKE. For example : We have $_POST['name'], $_POST['title'], $_POST['phone'], $_POST['email']. How do you generate sql query to search with two criteria ( name and phone ) ? …

Member Avatar for dezignwork
0
165
Member Avatar for Cerberus

I am trying to get this function to work and having a few problems. [CODE] if(function_exists("mysql_real_escape_string")) { $value = mysql_real_escape_string( $value ); } [/CODE] and i get an error: [B]Warning[/B]: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in w:\[B]pathname[/B] on line [B]11 [/B] Does anyone know how …

Member Avatar for Cerberus
0
95
Member Avatar for SubeeshBabu

hi , I have four different tables, all are linked together using foreign key relationships. Now i need to insert data in to the tables.How can i use nested insert queries to insert data by a single query?

Member Avatar for pty
0
93
Member Avatar for technobum

Hello all, I will be creating a mySQL database to store telemetry that will be grabbed from an instrument at a rate of once per second. Are there design considerations that I should take into account in order to achieve this insertion rate? The database will eventually grow to about …

0
47

The End.