10,940 Topics
 | |
| | Hello, I know I shouldn't use mysql_. So I have a mysql_query which updates my table (for a hit counter). However, when I open the page, I get to see this: > You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … |
| | So, i want to display data from a table in my db (Mysql), i click the buttonto get the data, it sends request via Ajax and Ajax calls getdata.php file. The table which is supposed to return the data returns in everyfield the written code like "$head" and "$value". I …  |
| | plz tel me how to write a jsp pgm to take values from mysql?plz help me  |
| | I am converting a traditional website to WordPress for an animal rescue charity so members can have a blog and more easily update various pages. All has gone well but I am stuck on one key aspect. Viewers of the original site can click on a page that will then … |
| | Hi, I been learning **OOP** slowly. I'm stuck how to resolved an **function query() on a non object issue**. My files are very basic: This is my **db.php** file: <?php global $db; class foo_mysqli extends mysqli { public function __construct($host, $user, $pass, $db) { parent::__construct($host, $user, $pass, $db); if (mysqli_connect_error()) …  |
| | $query = "SELECT * FROM customers WHERE firstname = '$firstname', lastname = '$lastname'"; $result = mysql_query($query); i keep getting Error: Query was empty  |
 | i tried reverse engineering option in Mysql workbend 5.1, 1stly i imprted DB's script and then created it, Its done :) but when i try to create ERD via Reverse Engineering option , then it doesn't show relations ships btw tbl, it only brings table to front ! why ? … |
| | Hello, When I run the project using my localhost, everything works fie. But when I use an other server I get this error: No suitable driver found for jbdc:mysql:// public void populateList2() { Connection con = null; Properties conProps = new Properties(); conProps.setProperty("user", "abn859"); conProps.setProperty("password", "100011399"); try { con = … |
| | Good Morning. I am writing a little function to record the visits to a landing page, and want to do it in such a way as to not count multiple visits from the same IP address within a 24 hour period. What I was wondering is if there is a … |
 | Hi everyone, Heres my problem: I've installed Qt 4, and there is **no** qmysql.dll/.a in C:\Qt\4.8.4\plugins\sqldrivers\. I am running a MySQL database program and I get Database error: Driver not loaded. Theres not really a lot of help anywhere on google so hopefully DaniWeb will yet again prove itself as … |
 | Hi all. I'm developing a quiz application consisting of multiple choice questions. Here are the tables that I've come up with. CREATE TABLE IF NOT EXISTS `student` ( `s_id` int(10) NOT NULL, `s_name` varchar(30) NOT NULL, `s_email` varchar(30) NOT NULL, PRIMARY KEY (`s_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF … |
| | Status field contains values Open,Awaiting,Approved,Rejected. To store a value what is the best datatype in mysql? Is it TINYINT OR VARCHAR? TINYINT occupies less memory if we store numbers instead of strings ( 1 => Open, 2 => Awaiting ...). Is it cause any performence issue when using joins? I … |
| | Hello all: I would like to query my mysql table for a total number of records inserted during a specified day of the week within a specified time period. More clearly: count number records inserted on Tuesdays during the time period of 2013-01-31 - 2013-02-03. The first day of the …  |
| | Here is my code:- //choose the table and return records $result = mysql_query("SELECT id, state,country_id FROM state ORDER BY country_id"); $string .= '"'.$val.'", '; $country = null; //get group while($row = mysql_fetch_assoc($result)) { if ($row['country_id'] != $country) { echo '<br>'.'<br>'."[".($row['country_id'])."] = parentarray ["; $country = $row['country_id']; } // get list … |
| | Please help. I am trying to change data in my MySql database. I am able to input new data, but when i try to change anything, it doesn't work. Here is my code: <?php $id = $_REQUEST['id']; $newname = $_REQUEST['newname']; $newemail = $_REQUEST['newemail']; $newpassword = $_REQUEST['newpassword']; mysql_connect("localhost", "root", "") or … |
| | I'm pretty new to AJAX so this may look like simple questions but..., so i want my file to be stored in a table in a db i have on my localhost, i'm using iframe <iframe id="upload_target" name="upload_target" src="#" style="width:0;height:0;border:0px solid #fff;"></iframe> what source do i provide, what about the … |
| | Hi I have some code that has 2 querys to fill 2 dropdown boxes. I need to get an id from one depending on which selection is chosen, put it in a variable to use in the second query. My code is below with comments of what I want to … |
| | Hello, I have this code over here: <html> <head> <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1"> <title>Admin area - Sydcul URL Shortener</title> <meta name="description" content="Free URL shortener"> <meta name="keywords" content="sydcul, url, shortener, tiny, url, tinyurl, bit, ly, bitly"> <meta name="author" content="Sydcul"> <link href="../stylesheet.css" rel="stylesheet" type="text/css"> <link rel="icon" type="image/ico" href="../favicon.ico"> </head> <body> <center> <h1>Admin … |
| | 1. I am trying to use this code snippet, to learn how to create a dropdown menu, populated by a mysql database. 2. I have worked out the kinks of the database credentials. 3. I have created and populated a test database. 4. This does actually work, now that it … |
| | HI basically this is my problem. I have created a database and I have created a table. I am trying to verify my username and password. HERE IS THE HTML PART. <body> <h1>Members login</h1> <form method="post" action="check_login.php"> <label for="username">Username:</label> <input type="text" name="username"/> <label for="Password">Password:</label> <input type="password" name="password"/> <label for ="submit">Submit:</label> … |
 | Sirs, please suggest a good way to handle large amount of data. This is my newbie idea: - create a database on one of high powered pc(dedicated for whole company) - then sync every changes to another copy of this database to the online hosting service with security note: theres … |
| | Hello, My script uses the user 'www-data' (my webserver) when connecting to the MySQL Database, while I tell it not to. <?php include ('config.inc.php'); $connection = mysql_connect($host, $user, $password); mysql_select_db($database, $connection); $shorturls = mysql_query('SELECT shorturl FROM `' . $prefix . 'urls`'); $shorturl = rand(100000, 999999); foreach(mysql_fetch_array($shorturls) as $row) { if($row['shorturl']==$shorturl) … |
| | Hi all. I hope I chose the forum to post in, it's an in between kind of question. I'm looking into options to develop my final year project. It's a formative assessment of a theoretical course to grasp students' understanding. The focus is on the ability of students to relate … |
| | Hello guys, I am still encountering a problem regarding my combobox. I am trying to populate it from my MySQL table but I am unable to so far.... Dim connectionstring As String Dim dbCon As MySqlConnection Dim strQuery As String = "" Dim SQLCmd As MySqlCommand Dim DR As MySqlDataReader …  |
| | Hi guys. I'm just wondering why this function always returns true, no matter what the $user_id is. The $user_id variable is determined by what is retreived from the $_SESSION. I am well aware that mysql_* functions are being depreceated etc, no need to tell me :P Thanks guys! function user_mod() …  |
| | I have quiz ID(Q1 for example) and below is the number of items in that quiz. My problem is, I need to display a dash when query cannot find a record in my database, if there is a record it will show up and the missing records will be filled …  |
| | i currently using mysql for database i want to use mysqli can any one tell me any other php server is required for it or i can use it in my bitnami wampstack 5.3.17.0 apache server. |
| | Hi Everybody I tried and failed to display images of employees in jTable. I have a MySQL Table which have 4 fields - ID,Name.Phone,Photo(Blob data type). Now I am able to retrive data from this table and display it in JLabel with other data in JTextField, but How can I …  |
 | Hello Community, I was wondering if there is a way to backup my mysql database. |
| | Hello Community, I was wondering if there is a way to backup my mysql database. |
The End.