Posted: Tue Jan 24, 2006 11:10 am
Suppose if I use your suggestion I could specify the column to use??
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Yes, but if you run the above you'll be able to see where the value is or if your query is even pulling the expected values.mhouldridge wrote:I do not want to return both row data, simply one field within value column.
Yes... third parameter in mysql_result()mhouldridge wrote:Suppose if I use your suggestion I could specify the column to use??
Code: Select all
$os = $_POST['os'];
$cpu = $_POST['cpu'];
$memory = $_POST['memory'];
$hdd = $_POST['hdd'];
$raid = $_POST['raid'];
$os = stripslashes($os);
$cpu = stripslashes($cpu);
$memory = stripslashes($memory);
$hdd = stripslashes($hdd);
$raid = stripslashes($raid);
mysql_connect("localhost","","") or die("Problem connecting");
mysql_select_db("quote") or die("Problem selecting database");
$os_query = mysql_query("SELECT value FROM `os` WHERE id = 1");
$oscost = mysql_result($os_query, 0, "value");
$cpu_query = mysql_query("SELECT value FROM `cpu` WHERE id = '$cpu'");
$cpucost = mysql_result($cpu_query, 0, "value");
$memory_query = mysql_query("SELECT value FROM `memory` WHERE id = '$memory'");
$memorycost = mysql_result($memory_query, 0, "value");
$hdd_query = mysql_query("SELECT value FROM `hdd` WHERE id = '$hdd'");
$hddcost = mysql_result($hdd_query, 0, "value");
$raid_query = mysql_query("SELECT value FROM `raid` WHERE id = '$raid'");
$raidcost = mysql_result($raid_query, 0, "value");
echo $oscost;Code: Select all
mysql_query($query) or die(mysql_error());Code: Select all
$os = $_POST['os'];
$cpu = $_POST['cpu'];
$memory = $_POST['memory'];
$hdd = $_POST['hdd'];
$raid = $_POST['raid'];
$os = stripslashes($os);
$cpu = stripslashes($cpu);
$memory = stripslashes($memory);
$hdd = stripslashes($hdd);
$raid = stripslashes($raid);
mysql_connect("localhost","","") or die("Problem connecting");
mysql_select_db("quote") or die("Problem selecting database");
$os_query = mysql_query("SELECT value FROM `os` WHERE id = 1") or die(mysql_error());
$oscost = mysql_result($os_query, 0, "value");
$cpu_query = mysql_query("SELECT value FROM `cpu` WHERE id = '$cpu'") or die(mysql_error());
$cpucost = mysql_result($cpu_query, 0, "value");
$memory_query = mysql_query("SELECT value FROM `memory` WHERE id = '$memory'") or die(mysql_error());
$memorycost = mysql_result($memory_query, 0, "value");
$hdd_query = mysql_query("SELECT value FROM `hdd` WHERE id = '$hdd'") or die(mysql_error());
$hddcost = mysql_result($hdd_query, 0, "value");
$raid_query = mysql_query("SELECT value FROM `raid` WHERE id = '$raid'") or die(mysql_error());
$raidcost = mysql_result($raid_query, 0, "value");
echo $oscost;Code: Select all
$os = $_POST['os'];
$cpu = $_POST['cpu'];
$memory = $_POST['memory'];
$hdd = $_POST['hdd'];
$raid = $_POST['raid'];
$os = stripslashes($os);
$cpu = stripslashes($cpu);
$memory = stripslashes($memory);
$hdd = stripslashes($hdd);
$raid = stripslashes($raid);
mysql_connect("localhost","","") or die("Problem connecting");
mysql_select_db("quote") or die("Problem selecting database");
$os_query = mysql_query("SELECT value FROM `os` WHERE id = 1") or die(mysql_error());
$oscost = mysql_result($os_query, 0, "value");
$cpu_query = mysql_query("SELECT value FROM `cpu` WHERE id = '$cpu'");
$cpucost = mysql_result($cpu_query, 0, "value");
$memory_query = mysql_query("SELECT value FROM `memory` WHERE id = '$memory'");
$memorycost = mysql_result($memory_query, 0, "value");
$hdd_query = mysql_query("SELECT value FROM `hdd` WHERE id = '$hdd'");
$hddcost = mysql_result($hdd_query, 0, "value");
$raid_query = mysql_query("SELECT value FROM `raid` WHERE id = '$raid'");
$raidcost = mysql_result($raid_query, 0, "value");
echo $oscost;Code: Select all
$os_query = mysql_query("SELECT value FROM `os` WHERE id = 1") or die(mysql_error());
$oscost = mysql_result($os_query, 0, "value");Code: Select all
$os_query = mysql_query("SELECT value FROM `os` WHERE id = 1") or die(mysql_error());
$oscost = mysql_fetch_assoc($os_query);
echo "<pre>";
print_r($oscost);
echo "</pre>";