Home » Databases » Page 5
hello everyone please i need to develop a php application but this
time around i want to use php and oracale 11g database enterprise
edition which server should i go for ???? can i still use my
phpmyadmin(easyphp/wamp) if yes then how can i do it please need help
......
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.
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 checkboxes words
will be searched for in the database.
My question is how is the
best way to index all the search words?
I’m thinking of 2
ways:
1.
In the field | search words |all searchable words
will be displayed like: 1GB RAM, 512GB RAM, ATA, SATA… an
Hi
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 Server
Errors turned on
Notice: A session had
already been started - ignoring session_start() in
H:oothomemlungisi-001wwwsite1libsproducts.php on line 27
Syntax:
[ Download ] [ Hide ]Syntax: [ Download ] [ Show
]session_start();
Notice: Undefined v
Hi,
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
or
Errordocument 401 error.html />Errordocument 403 error.html
prompts for the user login. But on
adding the login credentials it is taking to same window again and
again asking for login info again. Any idea how to solve this??
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.
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 those
where "black" is empty.
Just tried this too, and it doesn't do
anything differently:
Syntax: [ Download ] [ Hide ]Syntax: [
Download ] [ Show ]ORDER BY rcstock, title ASC, FIELD(black,
'yes', '') DESC
I am looking for solution to change my Oracle database record into
MySQL. Is it possible to convert database record from Oracle to MySQL?
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.
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?

- Technology - Languages
+ Webmasters
+ Development
+ Development Tools
+ Internet
+ Mobile Programming
+ Linux
+ Unix
+ Apple
+ Ubuntu
+ Mobile & Tablets
+ Databases
+ Android
+ Network & Servers
+ Operating Systems
+ Coding
+ Design Software
+ Web Development
+ Game Development
+ Access
+ Excel
+ Web Design
+ Web Hosting
+ Web Site Reviews
+ Domain Name
+ Information Security
+ Software
+ Computers
+ Electronics
+ Hardware
+ Windows
+ PHP
+ ASP/ASP.Net
+ C/C++/C#
+ VB/VB.Net
+ JAVA
+ Javascript
+ Programming
Privacy Policy - Copyrights Notice - Feedback - Report Violation 2018 © BigHow