|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
I was thinking something like
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
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.
|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
Errordocument 401 error.html
Errordocument 403 error.html
prompts for the user login.
|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
Is there a script that can be run to do this?
are used dynamically for META TAGS, so it's not about how to render it on
|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,
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
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
|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.
runs, and then a secondary query runs within that just to extract certain
fields from another table.
Syntax: [ Download ] [ Hide
]SXBB[id].writeCmd();Syntax: [ Download ] [ Show ]$result = mysql_query
("SELECT * FROM stock ORDER BY $orderby ASC") or
|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_.
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
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
|PHP Fatal Error: Call to Undefined Function mysql_connect() !|
| by JSebok in Databases|
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
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
|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
|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.
connection script includes the following:
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?
|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.
Syntax: [ Download ] [ Hide ]SXBB[id].writeCmd();Syntax: [
Download ] [ Show ]<?php
for ($i=0; $i<$num_result;