Home » Databases » Page 2
We have had a script running that enters codes into a stock field, but
with two additional characters at the start, such as this: />es5656565
es3jgjr
esXL55
es7fg
I want to replace
the "es" with "fr". There are hundreds. I'm sure there is a
'REPLACE' script but cannot quite work out how to do it. I'd say it
should do it only if it finds 'es' as well, in case there are some
where there is no 'es' in there.
Syntax: [ Download ] [ Hide ]Syntax: [ Download ] [ Show ][Mon Mar
31 11:07:25 2014] [error] [client 180.76.5.27] PHP
Notice:  Constant DBHOST already defined in
/var/www/vhosts/site.co.uk/httpdocs/dbconn.php on line 9
[Mon
Mar 31 11:07:25 2014] [error] [client 180.76.5.27]
PHP Notice:  Constant DBUSER already defined in
/var/www/vhosts/site.co.uk/httpdocs/dbconn.php on line 10 />[Mon Mar 31 11:07:25 2014] [error] [client
180.76.5.27] PHP Notice:  Constant DBPASS already defined in
/var/www/vhosts/site.co.uk/httpdocs/dbconn.php on line 11 />[Mon Mar 31 11:07:25 2014] [error] &
Hi,
I'm using Debian(jessie). I created a database(Cars) using
phpMyAdmin's Create database function. I'm following along a book
"The Joy of php". After the table is created the author wants to
create a table (INVENTORY) using SQL commands. Well, phpMyAdmin will
not let me enter any text in the SQL query text area. I created the
table using the Create table function(buttons). If I click on the
INVENTORY table in the left window-pane or the tab above I get the
following error message:
Error
SELECT 'prefs' FROM
'phpmyadmin' . 'pma__table_uiprefs' WHERE 'username' = 'jeff' AND
'db_name' = 'Cars' AND 'table_name' = 'INVENTORY'
MySQL said: /><
Hey guys and gals,
I am a noobie to programming and these boards
so first greetings to everyone. I started learning html/css/php/mysql
a couple of weeks ago and think I am progressing nicely but as I got
into databases I started having some set up problems. A couple of
stats:
Mac OSX Mountain Lion
XAMPP 1.8.3-3
PHP
5.5.9.
I am learning from TheNewBoston tutorials and all the code
from their videos there worked fine - untill I tried connecting to a
database with mysql_connect function. Sometimes it worked, sometimes
it didnt but after a while I learned about the deprecated functions
and the new mysqli class. This is what I am trying to do - I have a
I have 5GB database that need to upload in phpmyadmin.There is any
solution that can less time to upload it?Please do help me by showing
step in uploading the sql file. I have search through internet but
could not understand.
Hi
i got a php code on internet that works fine. It retrieves
details of suppliers from a mysql table "suppliers". All column
headings are displayed horizontally.
It retrieves data and
displays as shown below:
ID | NAME | ADDRESS | PLACE |
PHONE | EMAIL />---------------------------------------------------------------- />1 | TOM | XYZ | ABC | 123 | FDS@FDSF.COM />However i would like to format the output to appear as shown below
in image file "desired-output.png":
DESIRED OUTPUT.PNG (4.46
KiB) Viewed 340 times

I want all my column
headings to appear in one colu
Hi..I am new and beginner in programming. I try to display live data
at localhost by http://localhost/alimtest/ but it show this error. />Server error!
The server encountered an internal error and was
unable to complete your request. Either the server is overloaded or
there was an error in a CGI script.
If you think this is a server
error, please contact the webmaster.
Error 500
localhost />Apache/2.4.7 (Win32) OpenSSL/1.0.1e PHP/5.5.6[/u][/b]
I put my
alimtest folder that consist of php codes in htdocs.My localhost
running well therefore in order to display the data, do I need to
configure anything?
#Please do help me.
I am a PHP beginner.
Every x days (every 7 days for example), I
would like all the values in a certain column in my MySQL database to
reset back to '1'. How do I do this?
Please note: My web host
does NOT have the MySQL event scheduler enabled so that is not an
option. Also, my web hosting plan does not allow me to do cronjobs so
that is not option either. Any other ideas?
Thanks!
We have an issue where one or more fields of the database has the same
data in it - ie same product stock codes.
We use this to show
tickboxes on screen to select "additional accessories".
Trouble
is, for whatever reason we have "mini ***" and then "small ***", which
are actually the same product.
I'm not bothered about disabling
one to be seen, but moreso creating a simple page that shows those
products where there are duplicates.
Such as: "SELECT code1,
code2, code3, code4 where <any of them> = <any of
them>".
I'm trying to find it in a Google search, but not
having luck, as most of these duplicate queries are to see if more
than one
I have two table and want to fetch data from them.
This query
working fine:
"Select * from myads join users on myads.id =
users.id";
but the problem is I want to use one of the field as
counter
For the Single table this works for me:
"SELECT
*,(30-DATEDIFF(now(),updateDate)) as counter FROM myads";
Now, my
question is how can i combine this two querys.. any help will be
helpful.

- 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