Web Database Development

Database design and development using MySQL, Oracle, Access, MS SQL and others.

ASP, Access and Windows Server 2008

She has: 25 posts

Joined: Sep 2004

We are running Windows Server 2008. I'm using an Access database for my ASP pages. I used the 32-bit ODBC to set up the database. The ASP pages that are pulling info from the database is not working. I get an error. Any ideas on what could be wrong? TIA

What is the most efficient way of doing this...

DarkLight's picture

He has: 251 posts

Joined: Oct 2007

Hi guys, it's been a while since my last question. But now I'm stuck, so here I am Smiling

I have a database (MySQL) with a table containing millions of rows.
I read/write to this table upto 100 times per minute at peek-time.

I was contacted by my hosting company, and told that I didn't have enough power on my shared-host, and needed a VPS.

SQL help - Count and sort 2 columns with multiple choices

They have: 425 posts

Joined: Feb 2005

I am building a simple system that registers users. I am only using one table to store everything. Each row consists of a userid, email address, phone number, gender, hair length

Gender can be male or female and hair length can be long, medium or short.

What I am trying to do is show how many males and females have long medium or short hair in a table like the below

See imageshack image here

but I cant figure out the SQLso that I can do this in one query. So far I am here:

SELECT COUNT(1) as 'Gender',

PHP code to INSERT values into MULTIPLE tables

They have: 5 posts

Joined: Jan 2012

can anyone help me !!!!!!!!!!!!!!!!

im trying to get the values from the select box in HTML form , and if the value is "Male" the user info will be inserted into the "male" table. and if the value is "female" then the info will be inserted into the "female" table........

i dont know where i made the mistake................

connect

They have: 1 posts

Joined: Dec 2011

What is the source code for connected the database in a php file?

how to Redirect using .htacces

They have: 14 posts

Joined: Dec 2011

Hi i know ho to redirect 1 page to another page in your website but i want to Redirect over 90 Pages to new pages . how to do this ? can any one help me here.

MySQL on XAMPP on CentOS6

They have: 7 posts

Joined: Aug 2011

I am trying to install a program on Xampp (in Centos 6) and I get the error that I listed below. I am not sure whats wrong, because I just went to PHPMyAdmin, created a table called 001 and it was all that I needed to do. I looked at the info, but it is kind of hard to figure it out at this point. Does anybody have an idea what it is?
Thank you.

Fatal Error
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 49

What is webtraffic ?

seolang's picture

He has: 29 posts

Joined: Oct 2011

Hi guys,
Can anybody explain
What is web or SEO Traffic?
Please give me clear information related to it.
Thanks a lot in Advance.

JOOMLA cutomization

devisrimari's picture

They have: 38 posts

Joined: Sep 2011

hi,
could you pls any one help me out how to create a joomla 1.5 component that will retrieve the data from the database?

thanks

NOABL - UK Wind Speed Database

stormie's picture

He has: 4 posts

Joined: Nov 2007

Hi Guys,

I have an interesting problem if anyone fancies a shot at it.
This database was built in the 1980's and has; I'm guessing about 10'000 entries. I need to make a simple app for a wind prospector to search the database and retrieve the locations of high wind-speeds.

It is built on the back of the Ordnance Survey 6 digit locations (SS7456 for example) a full OS ref has 8 digits of course.

Subscribe to this feed: Syndicate content