Could Use Some Help

[xpack]

How do I do something like this

$promotionalcode = $db->query("SELECT * FROM `<PRE>promotions` WHERE `amount` = '{$main->getvar['promo']}'");

 

I want it to check what the user typed in the box and look for that in the promotions table 'promo' and from there take the amount 'amount' and make that equal to $promotionalcode

[fenway]

What?

[awjudd]

What is the <PRE> in the field name?

 

~juddster

[xpack]

Well I have this

 

 $sql['pre'] = "tht_"; #The mySQL Prefix, usually default unless otherwise  

 

 

So that way I can set <PRE> to whatever the user wants their prefix to be for their tables in mysql, and use that throughout the whole script. And can you better explain.

[awjudd]

Then shouldn't the <PRE> be replaced before going into the query function? ... or does your query function handle it for you?

 

~juddster

[gizmola]

"SELECT * FROM `{$sql['pre']}promotions` WHERE `amount` = '{$main->getvar['promo']}'"

 

[gizmola]

It might be worthwhile setting up an array with the tablenames prepended in advance so that you could have this type of code instead:

"SELECT * FROM `{$tbl['promotions']}` WHERE `amount` = '{$main->getvar['promo']}'"

 

 

 

 

[xpack]

Well the <PRE> works thats not a problem.

 

But I tried this

 

$sql = "SELECT `amount` FROM `<PRE>promotions` WHERE `promo`  = '{$main->getvar['promo']}'"; 
echo $sql; // does this give the query that you are looking for??
$code = $db->query($sql);
$amount = $amountinfo['monthly'] - $code

 

But when Tried that and I got

 

 

As you can see it echoed sql as a string and there is a value promo in the table and when I try that in phpmyadmin it shows the correct value

 

Oh and btw I want it to find amount from promotions table where promo = what the user entered

[gizmola]

Well if the user filled out a form, values from the form will be available to you in the $_POST.

 

 

[xpack]

Yeah I just put texter because that one of the promo names and I just want to test if its actually reading right