PHP / MySQL Troubles

Newbie Question

[Racecar78]

Hello - Im a total newbie, so please - be kind.

I am developing a very simple site, that, is no longer simple to me.

The following code does not work for me:

<?
$db = mysql_connect(host, user, pass)or die(mysql_error());
mysql_select_db(NAME,$db) or die(mysql_error());

$query = "SELECT * FROM list WHERE \"%$form_type%\"='1'";
$result = mysql_query("$query") or die(mysql_error());

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
print $row[name];
}

?>

...Any idea why? Looks like the SQL statement works, but nothing prints out.

Thanks,
- RC78

[Knowles]

Where does this VAR %$form_type% come from? Maybe I am just missing what this does. Also I dont think you want to have the \'s infront of the " for that. I am guessing though.

[Racecar78]

%$form_type% is passed through a form to this phtml script...

[Knowles]

Have you tried printing the varible only? Just to make sure it is passing correctly from the form?

[Racecar78]

Yes, I have.

At the top of the results script, I am using the following:

print "$form_type\n";

That prints the form element of that name, which is also a table column name.

So, when it passes through to the SELECT statement, it should just pull results based on the values of that column, right?

[sugarkane]

You could also try

print(mysql_num_rows($result));

before entering the while loop - this would tell you how many results your query returned, which might give an indication whether your query is correctly constructed...

[Knowles]

Try changing your select to "SELECT * FROM list WHERE '$form_type'='1'";
See if that changes anything. You are only trying to select one result right?

[Racecar78]

sugarkane...
Thank you!

I just implemented that, and the SELECT statement is not returning any records at all, leading me to believe that I have something going wrong.

I will take a look into why, and post back if I have future problems.

Thank you agin.
RC78

[mavherick]

this line here:

$query = "SELECT * FROM list WHERE \"%$form_type%\"='1'";

should be:

$query = "SELECT * FROM list WHERE ".$form_type."='1'";

but that's only going to pull values that ColX as a value of 1... Is that what you're expecting?

[Racecar78]

Knowles, no, I am returning a series of results, not just one.

[Knowles]

Thats where your problem is coming in then. Your select statment is only pulling the result that is equal to 1 in table form_type. So if this is actually a list of names thats why its not working. it should be ".$form_type." = ".$name.""; and you will need to find a way to define $name in the form. Or have it static but that would cause alot of select statements.

<added>Thank you Mavherick I knew I was typing that select wrong but was trying to go off memory which I dont have!</added>

[edited by: Knowles at 2:57 pm (utc) on Aug. 14, 2002]

[Racecar78]

Everyone...

Thank you for helping!

The script works fine now, based on all of your input.

Thank you again for your help - glad I came out of "lurk mode" here!

RC78

[ergophobe]

$result = mysql_query("$query")

Nobody mentioned this - if query is a variable, the "" are not necessary. They don't hurt anything, but they serve no purpose.