m3rajk — Sat, 17 Apr 2004 02:32:17 +0000

i'm not sure of the structure, could you give us something to have a common basis?

give us partial structure. we might be able to actually help you modify to a better structure:

ie: if you need a yes/no feild, a tiny int using 0/1 (true/false) may actually be better than a text feild that will use yes/no.

id est:
main table structure:

pid int # player id number
player char(15) # username
paypal tinyint(1) # uses paypal
stormpay tinyint(1) # uses stormpay

php snippet:

# this grabs everyone who uses paypal/stormpay
$sql="SELECT username FROM users WHERE";
switch($paytype){
case '0': $sql.=" paypal=1"; break; # this gets the paypal users
case '1': $sql.=" AND stormpay=1;" break; # this add stormpay
case '2': $sql.=" stormpay=1;"; break; # storm pay only
}

Suzanne — Tue, 13 Apr 2004 15:41:52 +0000

Okay, you're not actually querying the database, eh? You're just setting up the question, not asking it.

<?php
// longhand for clarity

$sql = \"SELECT ... \";
$qry = mysql_query($sql);
if (!$qry) { echo mysql_error(); }

// shorthand for brevity

if (!$qry = mysql_query(\"SELECT ...\")) echo mysql_error(); 
?>

Normally at this point you get the results of the query and then manipulate them (results with mysql_fetch_array or similar).

I would suggest you rethink your query to be to get the value of paypaluser, then set a condition then.

i.e.

<?php
// select the value for paypaluser (yes/no) from the table for this user
$sql = \"SELECT paypaluser FROM \" . $config[table_prefix] . \"default_listingsDBElements WHERE user_field_name = user_field_value\");
 
$qry = mysql_query($sql);
if (!$qry) echo mysql_error();

while ($row = mysql_fetch_array($qry)) {
    $paypaluser = $row['paypaluser'];
    if ($paypaluser == 'yes') {
        renderpaypal();
    }
    else {
        // do something else, choose another payment method?
    }
}
?>

NYColt — Tue, 13 Apr 2004 13:29:28 +0000

ok this is the query I needed, which works:

if($sql = "SELECT field_name FROM " . $config[table_prefix] . "default_listingsDBElements WHERE
field_name='paypaluser' and field_value = 'yes' ")

What I want to do now is call a function called:

<?php
 renderpaypal(); 
?>

if the result of the query equals yes.

Any suggestions how I can call that function within the if statement?

Thanks for any help.

NYColt

s0da — Mon, 12 Apr 2004 18:24:55 +0000

well either the field `paypaluser` is NOT in the column OR the SQL server is messed up somehow.

NYColt — Mon, 12 Apr 2004 18:15:38 +0000

The table name is:default_listingsDBElemenets
The Column is:field_name
The field is: paypaluser
The field value is: yes or no ( i am looking for all that say yes)

s0da — Mon, 12 Apr 2004 18:07:16 +0000

is that column in your table?

NYColt — Mon, 12 Apr 2004 17:26:11 +0000

this is the error message I get:

Unknown column 'paypaluser' in 'where clause'

s0da — Mon, 12 Apr 2004 16:28:12 +0000

try backticks around the fieldnames; you might have "badwords" that are being used.

SELECT `field_name` FROM `default_listingsDBElemenets` WHERE `paypaluser`='yes'