Selecting Values from One Row

Okay, I am trying to fetch information from a database that has the following three columns:

ID

Service_Name

Price

Now, I am trying to select all the information in a Single Row, based on a variable.

I have stored 2 types of service/packages in the datbase for our SEO Packages, which is as follows:

SEO Budget Package, $250
SEO Economic Package, $300

So, let's say someone choose the SEO Budget Package, I want it to select the row, that is for the Budget Package, and then store the $Service_Name as well as the $Price, so Ican send that information to a script to process the payment.

Here is the script I have, please help:

<?php

$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="client-center"; // Database name
$tbl_name="services"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Retrieve data from database
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$chosen = "SEO Budget Package";

// Select all coulumns from one row.
$sql = "SELECT * FROM $tbl_name WHERE column_name='$chosen'";

?>

<p>You have chosen <? echo $sql['service_name']; ?> as your package</p>
Click to expand...

Log in or Sign up

Selecting Values from One Row - MySQL

LindseyInteractive Well-Known Member

iama_gamer Active Member

Log in or Sign up

Selecting Values from One Row - MySQL

LindseyInteractive Well-Known Member

iama_gamer Active Member

Useful Searches