how to insert server time to database using mysql
i want to insert server time to table.i will use mysql. ...
mysql
client computer name
After getting the client(Website user) IP address. Now i want to go one step ahead by knowing the Computer name of the user. So, agian i need help from my question viewer to help me regarding computer name of the client(website user). I tried it by myself using google. But at last i thought it is better to ask to all of you who have b...
Mysql - help me optimize this query (improved question)
About the system: - There are tutors who create classes and packs - A tags based search approach is being followed.Tag relations are created when new tutors register and when tutors create packs (this makes tutors and packs searcheable). For details please check the section How tags work in this system? below. Following is the concerned...
Problem in Installing Wordpress
I try to install Wordpress in a Windows Client with WebPI which provided by Microsoft. Everything installed in my client and finally I saw successful message. with a lunch application link. When I click on it I see following error. Your PHP installation appears to be missing the MySQL extension which is required by WordPress. How Can...
Problem with truncation of floating point values in DBSlayer.
When I run a query through DBslayer http://code.nytimes.com/projects/dbslayer the floating point results are truncated to a total of six digits (plus decimal point and negative sign when needed). { ... "lat":52.2228,"lng":-2.19906, ... } When I run the same query in MySQL, the results are as expected. | 52.22280884 | -2.19906425 ...
multiple polls with email submit function
I want to add a 4 sets of polls that each have around 4 radio buttons each for answers - then i would like to add an 'enter your email address' field below these polls. Finally I would like the submit button after the email field to 'submit' the data from the polls and the email address entered - so only one submit button. Just to make...
Find node level in a tree
I have a tree (nested categories) stored as follows: CREATE TABLE `category` ( `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `category_name` varchar(100) NOT NULL, `parent_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`category_id`), UNIQUE KEY `category_name_UNIQUE` (`category_name`,`parent_id`), KEY `fk_categor...
mysql way to make a lock in a php page
Hello, i have the following mysql table: myTable: id int auto_increment voucher int not null id_user int null I've populated voucher field with values from 1 to 100000 so i've got 100000 records; when a user clicks a button in a PHP page, i need to allocate a record for the user so i make something similar like: update myTable set ...
VB.NET, MySQL and Unicode
How to input the textbox's unicode string to MySQL database. I changed utf8 charset the MySQL Database. I'm using VB.NET 2005 and MySQL Database for Window application. Please Help me. ...
How To Get YEARWEEK() To See Sunday As The Start Of The Week?
I'm trying to get the YEARWEEK function to see Sunday as the 1st day of the week. An example date is: Sunday 1st Mar 2009 Here is my sql SELECT YEARWEEK('2009-03-01') and the result is -> 200909 Which is week 9. I believe it is telling me this is week 9 because it sees the sunday as the last day of the previous week. How would I ...
Mysql query for copy the struture of another table and create the table
Mysql query for copy the struture of another table and create the table ...
mysql_real_escape_string() just makes an empty string?
I am using a jQuery AJAX request to a page called like.php that connects to my database and inserts a row. This is the like.php code: <?php // Some config stuff define(DB_HOST, 'localhost'); define(DB_USER, 'root'); define(DB_PASS, ''); define(DB_NAME, 'quicklike'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die('ERROR: ' . m...
How to simplify my country select menu PHP/mysql
I have a select menu that displays countries. It looks at the DB and judging by the value in the db shows the option as selected. Is there a simpler way off doing this than: if ($country == 'AG') {echo '<option value="AG" selected="selected">Antigua</option>';} else {echo '<option value="AG">Antigua</option>';}; if ($country == 'AR') ...
translate a mysql query into nhibernate
Good day! Please, can you help me to translate such a mysql query into nhibernate SELECT sales_id, service_id,dayofyear(dt), max(dt) FROM clients.statistics group by sales_id, service_id,dayofyear(dt); ...
I want to select a particular list of words containing certain characters using php
Hello, I want to select a particular list of words in a paragraph containing certain characters $query_search_text= "SELECT * FROM para where para_main='%text_words'"; I tried using the % sign, but it does not work. It works if I give in the full text. Thanks Jean ...
How to make db structure for multiple input in MySQL and PHP
Below is my current structure for MySQL database id | item_name | item_files ------------------------------------------ 1 | Item A | file1.zip,file2.zip,file3.zip 2 | Item B | file3.zip Example I create simple form to fill up Item Name and Multiple upload files then store it to db. Question :- How to design the db str...
Should I sanitize EVERY form variable passed along?
I have a form with many fields... The action is set to a php page which queries mysql... Should I sanitize with mysql_real_escape_string every single variable? Or can I ignore sanitizing drop-lists and radios for instance? Also, besides mysql_real_escape_string, what else should I do to prevent attacks? Thanks ...
mySQL - How to autogenerate field values
I have a table that contains thousands of URLs. Each URL will have a corresponding folder, so I was considering using mySQL to create a short and usable folder name for each existing URL and for new URLs as they are added to the table. What I would like is to specify something like a field 5 chars long of chars a-z, and have mySQL autog...
"slash before every quote" problem
I have a php page which contains a form. Sometimes this page is submitted to itself (like when pics are uploaded). I wouldn't want users to have to fill in every field again and again, so I use this as a value of a text-input inside the form: value="<?php echo htmlentities(@$_POST['annonsera_headline'],ENT_COMPAT,'UTF-8');?>"> This ...
MySql Driver not loaded
I use Visual Studio 2008, MySQL 5.0.90,Qt 4.6.3 and C++ I try connect MySql but it gives this error messages. Driver not loaded. I am new programmer. How cann I solve this problem? Thank a lot. ...