[mysql] Forum Topics

Hi Hope someone can help with this as I dont really know where to start. I am trying to automate a quite large txt feed I get from an external url to import into database. I currently do it manually through database software, but it takes too long each day. …

What if I set up a database table for an ad form that has optional fields. Do i need to select anything when creating rows for these fields other then the type?

So Heres The problem code i get a Parse error: syntax error, unexpected $end in /home/crysta21/public_html/4dM1n1STr4+10nB4nk.php on line 149 from <?php /* MCCodes FREE cyberbank.php Rev 1.1.0c Copyright (C) 2005-2012 Dabomstew This program is free software; you can redistribute it and/or modify it under the terms of the GNU General …

Hello there, today I noticed there are two operation in PhpMyAdmin, Replication and Synchronization. and now I want to use these operation as the following scenario. I have local db, I want to copy its content to remotly db so when I connect to any db I see the same …

I am trying to make a movie list for myself, I got everything working like add and delete but the edit gives me some headace. I get all the values fine, id, movie title, director and year are all filled in, well not what category I added using radio buttons …

I am having trouble with a registration script that I am trying to implement. When I click the "Register" button, I get this error: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens This is my coding for the register function: `public function register() { …

Hello, I have made an Employee Time clock application. I have been working on connecting my application to a MySQL database, I have a textbox wich is used to add an employee name to my database (this is working perfectly.), but I also a combobox where I want the list …

My while keeps looping and i dont know why: code <?php $result = mysql_query("SELECT * FROM tag WHERE point='$pagename'"); while($row = mysql_fetch_array($result)) { $result = mysql_query("SELECT * FROM tag WHERE point='$pagename'"); //username echo $row["user"] . " ||"; //alias check $result = mysql_query("SELECT * FROM tag WHERE (user='$my_name' && point='$pagename')"); if …

Hi i have a query that i want to display the pulser1 pulser2 pulser3 pulser4 from table but only when the input type for each pulser=2 when i run the query not working as i want it please check my query $netw is a variable it can be any value …

Hi, I want users on my website to upload their company logo (if they have one) while filling out my form. Right now i only have one row designated for the company logo called 'images' with the type set to BLOB. Is this adequate for both uploading images and displaying …

I am new in using MySQL database and need some help. The scenario is pretty much like this: I collect data from some sensor which come with their own software. The software builds a .db file as it takes data from the sensors and saves it locally in the computer. …

trying to search by the file name keep getting a "expects parameter 1 to be resource, boolean" error what am i missing? $pagename = basename($_SERVER['PHP_SELF'], ".php"); mysql_select_db("tagpoint", $con); $sql="SELECT * FROM tagpoint WHERE title = '".$pagename."'"; $result=@mysql_query($sql); $row = mysql_fetch_array($result);

is it possible to use a string array in mysql using the set data type and add a valuse to it, like a list of names?

I have been having problems with this code and i cant find out why I am trying to add a new element to an array. it says it goes throu butwhen i check its empty: $sql="UPDATE $title SET arole = CONCAT_WS(',', arole, '$name') WHERE op = '$name'"; if (!mysql_query($sql,$con)) { …

Hi, I want to select all records from a table where the DateAdded field's date and time (Default value Timestamp field) is more than say 3 hrs ago. eg: something like SELECT tbldata.* FROM tbldata WHERE (tbldata.DateAdded <= now()-3); I can get it working with days difference but do not …

I have a script that uploads documents, it uploads them in the destination folder, but not the info about the document. Pleasa help i need this as soon as possible. No errors show. <?php $UploadDirectory = 'C:/wamp/www/agenda1/uploaddok/uploads/'; //Upload Directory, ends with slash & make sure folder exist $SuccessRedirect = 'http://localhost:8080/agenda1/index2.php'; …

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

$query = "SELECT * FROM customers WHERE firstname = '$firstname', lastname = '$lastname'"; $result = mysql_query($query); i keep getting Error: Query was empty

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 …

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 …

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 …