Noob PHP mysql prob :P

$key="id=22";
$result = mysql_query('SELECT `tblproducts`.`configoption3` '.' FROM tblproducts '.' WHERE `tblproducts`. $key ') or die(mysql_error());
$row = mysql_fetch_assoc($result);

Edited by Taras (Sun 06-Jun-10 15:56:41)

In reply to a post by Taras:

$key="id=22";
$result = mysql_query('SELECT `tblproducts`.`configoption3` '.' FROM tblproducts '.' WHERE `tblproducts`. $key ') or die(mysql_error());
$row = mysql_fetch_assoc($result);

What am I doing wrong with the above in regards $key variable. Basically i want declare the id once and use the $result multiple times (ie resusable ) and change the id value as when and where

Edited by Kenneth (Sun 06-Jun-10 16:13:44)

In reply to a post by Kenneth:

In reply to a post by Taras:

$key="id=22";
$result = mysql_query('SELECT `tblproducts`.`configoption3` '.' FROM tblproducts '.' WHERE `tblproducts`. $key ') or die(mysql_error());
$row = mysql_fetch_assoc($result);

What am I doing wrong with the above in regards $key variable. Basically i want declare the id once and use the $result multiple times (ie resusable ) and change the id value as when and where

is your id column = "tblproductsid"?

I would always just store the the id as a number and do something like
$sql = "SELECT p.configoption3 FROM tblproducts p WHERE p.id = ${id}" if I wasn't using prepared queries as it makes it much clearer what the SQL is

edit: or even `tblproducts`. $key' (you need double quotes to parsed variables I believe) - and I don't believe you need the mysql quote char ` (which makes it hard to read I find)

In reply to a post by Taras:

No the id being refered to is in the table tblproducts - so tblprodutcs.id...

1
23
45

$key="id=22";
$sql = "SELECT  configoption3 FROM tblproducts WHERE ${key} ";// you can then put a debug statement to see what SQL you are calling here
$result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_assoc($result);

final code

$key=22;
$options= "configoption3";
$prodid="SELECT `tblproducts` . `". $options ."`". "FROM tblproducts WHERE `tblproducts`.`id`='$key'";
$result = mysql_query($prodid) or die(mysql_error());

Getting error "Unknown column 'tblproducts.$key' in 'where clause' "

Its probably a silly syntax issue but am in programmers blind spot tongue .. As I've not really touched php that much or "programming proper " for years.

1
23

$key="id=22";
$result = mysql_query("SELECT `tblproducts`.`configoption3` FROM tblproducts WHERE `tblproducts`.$key ") or die(mysql_error());$row = mysql_fetch_assoc($result);

What am I doing wrong with the above in regards $key variable. Basically i want declare the id once and use the $result multiple times (ie resusable ) and change the id value as when and where