Web Hosting Vodahost    

Home Take The Royal Tour! Order Now Features Prices
Go Back   Web Hosting > VodaHost Web Hosting Support > mySQL & PHP

Notices

mySQL & PHP Discussions, information and help with mySQL and PHP.

Reply
 
LinkBack Thread Tools
  #1  
Old 04-22-2007, 03:27 AM
TrickyRick's Avatar
First Sergeant
 
Join Date: Feb 2007
Location: Morris, Al
Posts: 78
Default SQL database

I need a little help on embedding a database on my site. I would like to build a for sale page that would bring up a list of articles for sale. When one is clicked on, it would launch a detail page on the selected item. Any help will be greatly appreciated.
__________________
It can be a great day but it's your choice!

Rick
P.S. Don't let the world pass you by, ride out ahead of it on a motorcycle!

http://www.deepsouthrides.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 04-22-2007, 10:33 AM
Collectors-info's Avatar
General
 
Join Date: Feb 2006
Location: London (UK)
Posts: 5,703
Default Re: SQL database

Hi Rick,
Depends a little on how many bikes/cars you will be selling. If it’s only a list of 20 or so it will be fine just using BV as normal. Similar to this http://www.collectors-info.com/testing/dsr.html (been playing again) But if it’s more items you need to sell, & you need a database, it maybe worth looking at one of the free shopping karts that BV has. (Soho)? These are all databases. The other advantage of a cart is you can have different areas for selling by category. IE: Bikes/Clothes/Tools/oil/chains/ & so on. Would be a better long term move.
If you use Soho I believe you will have to set up another domain on your account as I think it will only install in the route directory. But this can also be done by creating a sub domain for free. IE: http://www.shop.deepsouthrides.com & then installing it there.
Worth a look at the pro’s & cons that carts can offer, you hear a lot of people prefer one over another because of the different functions they may have.

Good luck.
__________________
Regards Chris,
Sites are view in FF & IE, with res @ 1024 x 768 on 19” screens.


How to ask for help on the forum. - VH prices. - BV Tutorials. - Using PIXresizer - Image/Photo Tips -
Collectables, Collecting
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old 04-22-2007, 10:48 AM
TrickyRick's Avatar
First Sergeant
 
Join Date: Feb 2007
Location: Morris, Al
Posts: 78
Default Re: SQL database

Chris,

Thanks for the quick response. That looks great and is along the lines of what I would like to do. I am not sure if the shoping cart is what I am looking for. I want to be able to do just what you did in your example and that is list bikes, cars too, for sale for others. I don't know how large it will get which is why I thought a database might be the solution.

Would soho be the solution for larger scale?
__________________
It can be a great day but it's your choice!

Rick
P.S. Don't let the world pass you by, ride out ahead of it on a motorcycle!

http://www.deepsouthrides.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old 04-22-2007, 11:45 AM
Collectors-info's Avatar
General
 
Join Date: Feb 2006
Location: London (UK)
Posts: 5,703
Default Re: SQL database

Hi Rick,
You may need watdaflip or Navals help with this one, as a database is a script that will interact with mysql. But this would need a lot of thought on layout, plus scenarios for every action the database would take after asking it to do something. That’s why I was thinking along the cart side of things.
Have sent that page if its of any use, just for ideas.

Cheers.
__________________
Regards Chris,
Sites are view in FF & IE, with res @ 1024 x 768 on 19” screens.


How to ask for help on the forum. - VH prices. - BV Tutorials. - Using PIXresizer - Image/Photo Tips -
Collectables, Collecting
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 03:07 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC7
2005-2009 VodaHost Web Hosting Your Perfect Web Host - All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176