Wrong parameter count for mysql_result()
Moderator: General Moderators
- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Yes... third parameter in mysql_result()mhouldridge wrote:Suppose if I use your suggestion I could specify the column to use??
- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am
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;- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Code: Select all
mysql_query($query) or die(mysql_error());- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Please post your code again.... I hope you did not just copy and past what I posted above... It should have been obvious what to do with it.
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;- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am
Yep, I did change it to use my first query... please see below code. I still get zero as my result for the echo part at the bottom of my script..
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;change this bit...
..to..
...and post here what output you get.
This will show us if your query is actually returning any results
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>";This will show us if your query is actually returning any results