Friday, June 20, 2008

I need to develop a shopping cart which will be easy for the end user- the shop owner and for me to update with a new theme ever two or three months.

I m a bespoke developer and have worked on many shopping carts from scratch- however for this job - given a lack of funding and a quick turnaround issue - I m looking for a pre-written alternative.

Any ideas?

Looking for shared hosing for a website based on e107. Using GoDaddy right now and its slow. When I host the on my home server on a basic DSL connection for testing and development it runs 10x faster than GoDaddy even (NOTE: This is when I m accessing my home box remotely.....sad) GoDaddy crawls..... and I m not sure if its the GoDaddy service- DB- or that it just doesn t agree w/ e107. Want something in the $5-$10 a month range that is known to run a e107 website and run it fast. Need 1-5 gb space- atleast 5+ gb month bandwidth- MySQL- PHP- etc... If you have an e107 website please post the provider- price per month- and opinions. Hoping to elimate the buy/try/switch scenario and pick a good option the 2nd time around..... It shouldn t be hard to find because this site is not traffic intensive and is not graphic or video intensive.

Heed help on query that seems have to be working but its not.
I need to do Left Join with multiple databases/tables.
SELECT db1.table1.id-db2.table1.hits
FROM db1.table1-db2.table1
LEFT JOIN db1.table2 ON db1.table1.id=db1.table2.id WHERE db1.table1.id=db2.table1.id
Mysql error says "unknown column db1.table1.id in ON clause"
Please help :(

I would like to create a simple customer login page.

I am aware of various programs available and different methods with php and mysql which I do not want to spend time learning. Instead my hosting provider provides a feature to password protect certain webpages.

However- my problem is getting my clients to the right page. What I want to do is have a form field on login page in which the user enters their username. The user is then directed to their page and asked for their password.

i.e. - On login page user enters username in form field -> |user1| this entry is then put into a web address -> http://www.mywebsite.com/user1.html The user would then be asked for his/her password and on entering this gain access to his/her personal page on my site.

All help big or small will be greatly appreciated.

Thanks in advance!
Response to answer 1:
I am sending the user to a page which IS password protected by my provider. Therefore- if you enter the address for this user s page you will be asked to enter this user s password. The first page where the user enters their username is simply to direct them to their page where they will be asked for the password.

Thanks anyway for your contribution!
I probably should have worded this differently. I simply want a formfield which when a username is entered it is used to redirect the user. So if the user enters username1 they will be directed to http://www.mywebsite.com/username1.html. If they enter username524 they will be directed to http://www.mywebsite.com/username524.html

Thanks again!

Hello

Just wondering if there were any programs to easily install php on the OS i stated. Something which installs both PHP and Apache and anything else needed. I tried to do it once but it failed so Im wondering about the programs.

Oh- and also MySQL!

Thanks"

Table: datadump

Columns: table- column- data

Data I want to insert: They are variables; $table- $column- $data

I know that the mysql_select_db and mysql_connect is ok and I will not give that for security reasons- but what about this syntax:

$sql = "INSERT INTO datadump (table- column- data) VALUES ($table-$column-$data)";

$mysqlquery = mysql_query($sql-$con);
if(!$mysqlquery)
{
die( Error: . mysql_error());
}

When I run the script with this syntax- I get the following 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 table- column- data) VALUES (index-name-fruits) at line 1

Can you please tell me what to do?
Same problem after taking the first answerer s advice
Same problem again with second answerer s advice

No comments: