Home » Databases » Page 3
UPDATE users table with a calculated field for current_age
by Christian Seitzer in Databases
I have a users table which has a birthdate field. I'm trying to figure out the syntax that would allow me to loop through the table and update another field name current_age. Using somekind of calculation based of the birthdate field.
I was thinking something like
UPDATE users
SET current_age=(birth_date)/(60*60*24*365.2421896)
in some kid of a loop if I need a loop.

Best way to do search word structure? !! $ !!
by Nick Durcholz in Databases
I want to build up a database where there will be about 400 strings. I want to make the database searchable.
The structure of the database will be like:
Brand | model |additional products | price | search words | (this is 1 string, there will about 400 strings)
There will be between 2 and 50 search words on each string. The search are done by clicking a checkbox and the marked check

PHP, MySQL, IIS7 issue
by JoeKaras in Databases
We moved a site that was developed by outsource company from old to new server and seem to be experiencing some issues on the new server. The products don’t show up anymore and no changes have been done on the code. When I turn errors on like http://mlungisi-001-site1.smarterasp.net/products.php there are some notices but surprisingly it worked on the old server.
Windows 2008, IIS7
TAGS : MySQL IIS7 issue

mysql dumper issue
by mikhaelrasputin in Databases
I want to use mysql dumper database. For that i have applied password protected encryption. Before it was giving 404 error but later on modifying the roor htaccess files by adding
AuthName "MySQLDumper"
AuthType Basic
AuthUserFile "myfilepath"
require valid-user
Errordocument 401 error.html
Errordocument 403 error.html
prompts for the user login.
TAGS : mysql dumper issue

Can certain DB Fields be set to UPPERCASE?
by Ir0nh1de in Databases
We need to set ALL entries in three MySQL Database fields to be in all UPPERCASE.
Is there a script that can be run to do this?
These are used dynamically for META TAGS, so it's not about how to render it on screen.

How do I order MySQL by fields, effectively?
by l1feh4ck3r in Databases
I need to set an order on some fields. So ORDER BY black, rcstock, title.
Problem is, 'black' sometimes is empty', and we need to ensure anything where black is NOT empty, and says "yes" in the field, come before the empty ones.
Help please. As if I set it like so
Syntax: [ Download ] [ Hide ]Syntax: [ Download ] [ Show ]ORDER BY black DESC, rcstock, title ASC
It doesn't show

Need database conversion software recommendation
by Naxxy in Databases
I am looking for solution to change my Oracle database record into MySQL. Is it possible to convert database record from Oracle to MySQL?

View database based on access level
by hochi in Databases
I have a msql database with about 4 access levels. These users are with different regions. I would like each user to only view their region when they log into the database. I am using php/dreamweaver and mysql to accomplish this. Right now they are all able to view all regions.

Display birthday with dd-mm only from mysql date (dd-mm-yyyy
by undeinpirat in Databases
I have a membership msql database with a birthday column. The column has birthday date dd-mm-yyyy but when viewed or displayed with Select using php I would like it to show only dd-mm for lower level access members. How do I accomplish this?

Mysql table to html table !
by Glenntoy in Databases
Hey there Guys,
Im putting together an inspection system this system comprises of 2 parts.
Part 1 - Capturing the data.
I have plus minus 18 forms and these are only going to grow. Each form has a varying amount of inputs and each form has it's own table in the Db. When a form is submitted the data is saved into the corresponding table in the Db. An important piece of data that is c

ORDER BY field from one table, AND by the field of another
by taviso in Databases
I have a query that can sort by any field in that table.
The query runs, and then a secondary query runs within that just to extract certain fields from another table.
Like so...
Syntax: [ Download ] [ Hide ]SXBB[id].writeCmd();Syntax: [ Download ] [ Show ]$result = mysql_query ("SELECT * FROM stock ORDER BY $orderby ASC") or die(mysql_error());

New to PDO: basic script failing. Including ORDER BY...
by Marti in Databases
I am brand new to the PDO style of coding, so please have a little patience with me here, as I am trying to convert from mysql_.
I have run a simple test.php file which opens a PDO conn:
Syntax: [ Download ] [ Hide ]SXBB[id].writeCmd();Syntax: [ Download ] [ Show ]<?php
$pdo = new PDO('mysql:host=localhost;dbname=site_name', 'root', '');
$query = "SELECT

php search query !
by TC. in Databases
Does anyone know a search query that will allow me to search for similar names.For example, if I entered "test", "test_file" might come out as a result.I have tried using the "LIKE" statement, but it only brings out exact matches.
Like Google for example.Google sometimes (or mostly) brings out results that aren't specific or exact matches.
(I also do know this is deprecated, but I just
TAGS : search query

PHP Fatal Error: Call to Undefined Function mysql_connect() !
by JSebok in Databases
Hi Guys
I am running windows xp and php 5.35 and mysql databases 8.0 and apache 2.27
When I run a simple php script (test.php) to connect to a mysql database and retrieve data, I get this:
Fatal error: Call to undefined function mysql_connect()
I know it is because Php cannot locate the mysql library so as adviced on the net I set the following as follows:
1. update php.in

Sql problem... !! $ !!
by br4dz in Databases
Hello, I am creating a downloads section for my site.I have all the information in one table, and on the actual downloads home, I want to display the total number of downloads for that category, when it was last updates and what the name of the last download was.I can do it when I have them all in seperate tavles, but once I join them all in one table, with only the category column to seperate the
TAGS : problem

Need DB structure
by Raphaël Slinckx in Databases
I have a directory website I am using category and sub categories based business I want to provide facility to our users so that they can add there business in multiple categories. can any one provide me Best Database Structure to manage this option. I am using MySql with PHP. My site is http://www.innobit.co.in/
TAGS : Need structure

Lost error reporting after server upgrade
by cerebusPu in Databases
On my development server (not the live server) I want to see mySQL errors on the page and this is what I had before I upgraded to ZEND server 6.1.0. (which also upgraded MySQL to 5.5) But now they are not showing.
My DB connection script includes the following:
I don't want to go to the log to see the errors. I want

ORM tools for linux?
by RomanMtz in Databases
Does anyone have a suggestion for any sql ORM tools (preferably free) that can run on linux? Any favorites?
TAGS : tools linux

delete statement does not work
by Ionith in Databases
I previously posted the topic "Passing multiple variables with url php?" and have the solution requested.
meals_correction.php code snippet:
Syntax: [ Download ] [ Hide ]SXBB[id].writeCmd();Syntax: [ Download ] [ Show ]<?php
                        for ($i=0; $i<$num_result; $i++)

Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .