Jump to content

Street-Car

New Members
  • Posts

    4
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Street-Car's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hi again, okay i've been reading and playing some with trying to get a little form working that will create a table in mysql. The HTML is this: [code] <html> <body><form action="create table.php" method="POST"> Table Name: <input type="text" name="ntable" /> <input type="submit" /> </form></body> </html> [/code] The PHP is this: [code] <?php // Set Mysql Variables $host = 'localhost'; $user = 'user'; $pass = 'pass'; $db = 'db'; if ($HTTP_POST_VARS['submit']) { $con = mysql_connect("$host","$user","$pass"); if (!$con)   {   die('Could not connect: ' . mysql_error());   } $ntable=$HTTP_POST_VARS['ntable']; $sql = "CREATE TABLE '$ntable' ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, model VARCHAR(30), date VARCHAR(30), fuel VARCHAR(60), enginecap VARCHAR(30), cylinders VARCHAR(30), valves VARCHAR(30), power VARCHAR(30), torque VARCHAR(30), drivenwheels VARCHAR(30), stdtransmission VARCHAR(60), optstdtransmission VARCHAR(60), bodystyle VARCHAR(30), seatingcap VARCHAR(30), maxspeed VARCHAR(30), 0-60 VARCHAR(30), mpg VARCHAR(30), lenth VARCHAR(30), width VARCHAR(30), height VARCHAR(30), wheelbase VARCHAR(30), kerbweight VARCHAR(30), co2 VARCHAR(30), ukins VARCHAR(30), ncp VARCHAR(30), usncap VARCHAR(30) PRIMARY KEY(id)); mysql_query($sql,$con); echo "Table Created!"; or die(mysql_error()); mysql_close(); } ?> [/code] I keep getting loads of things like "Parse error: parse error, unexpected $ in /hm/dir/create table.php on line 57" and when i try and fix that its on another line :( Sorry im still new and cant put my finger on whats wrong. Thanks in advance to all.
  2. Hi thanks for the replies i would like to make it so's that they can Browse the car specs. A main list of all the manufactors and then indise each list will be a list of car models Ex Mazda 323F Then a list of all the Mazda 323F cars specs will be pulled from the database Thanks again
  3. [!--quoteo(post=372258:date=May 8 2006, 08:46 AM:name=ober)--][div class=\'quotetop\']QUOTE(ober @ May 8 2006, 08:46 AM) [snapback]372258[/snapback][/div][div class=\'quotemain\'][!--quotec--] I'm impressed with the header graphic work... some of the best I've seen on car sites. I'm also impressed with the integration with VBulletin... great work. But I definately agree... you need to move all that great info out of the forums and onto the main page. I don't know what would be the best "system" to use... are you just looking for a decent CMS? I suppose PostNuke would probably be a fair bet, but I've never used it. I'd think a home-grown version might do best for you, however. [/quote] Thanks for that :) Okay well im not sure on what to use as im still new to this. I was hoping that somone could recomend a GUI based database for me to put all the specs into. I need to be able to arange them easy, add new specs, edit older ones and also have pictures too. Something that will be good and easy for the guests to navigate around on my site too. is there such a web based gui database system (MySQL) ? I will be very greatfull on anything you guys can recomend me Thanks again
  4. Hi all I've got a site that we've running for approximately a year now and now we have quite a bit of info together on car specifications i thought i would get some form of system sorted so's that people can view the info without having to search through the forums where its currently stores with no order (not much) :( So i would like if you guys could take 2 mins out of your time to have a look at my site and recommend to me a system that i could use to display and organize the specifications we have. Many thanks in advance. The main site (the links to the cars take you to the forums where they are kept at the mo) [a href=\"http://www.street-car.net\" target=\"_blank\"]http://www.street-car.net[/a] The Specs page index (forums again) [a href=\"http://www.street-car.net/forums/showthread.php?t=758\" target=\"_blank\"]http://www.street-car.net/forums/showthread.php?t=758[/a] Thanks guys
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.