"Find" logic

[jamesh]

I have a question regarding pulling results from a MySQL db using a "find" button. Here is the setup:
I have a contact field where I allow users to enter in the name of someone that they want to do a search on. Then they can hit a "Find Company" button to fill a text box with the information on the company that the contact works for. Currently, the code looks like this (as suggested to me):

Contact: <input type="text" name = "contact">
<input type="button" name="find" value="Find Company!">
Company: <input type="text" name="company" value="<?=$co ?>">
<input type="hidden" name = "co" value="<?=$co ?>">

In the top of the code, I also did a search of the db (mysql_connect, mysql_query, etc). There are no parse errors, but the text box doesn't fill in when the button is pushed.

Can you tell me what I am missing? (and yes, I am a newbie to this, but learning very quickly).

Thanks!!

[Anon]

I don't see any form tags and I would use a submit rather than a button...
Thats what my 2 cents...

God Bless,
Jim

[jamesh]

Ah....sorry. Yes, there are form tags before this section, I just didn't include them. I did change the "button" to a "submit", and that is working a little better. However, now it is not able to perform my query.....hmmm....back to the drawing board....

[jamesh]

I guess it would help if I posted the search logic as well.....here it is://perform sql search
$sql="select contacts.contact_id, ship_add.ship_co
from contacts, ship_add where contacts.contact_id = $contact and
ship_add.contact_name = contacts.contact_name";

//execute query
$sql_result = mysql_query($sql, $dbc) or die("Couldn't execute query");

//Get results
while($row = mysql_fetch_array($sql_result)) {
$co = $row["ship_add.ship_co"];
}

endif;

Connection to db was made successfully, I just get the "Couldn't execute query" message. I have tried the $co = to both $row["ship_add.ship_co"] and just ["ship_co"].

Still confused, but still working at it.

Thanks!

[amcgrath]

Is contact_id a number? if not, then put single quotes around $contact like this:
where contacts.contact_id = '$contact'

[jamesh]

Thanks, Allen....I actually found that I was calling different fields in the db (should have been contact_name, not contact_id). I used the single quotes, and that got me past the error. However, now it executes the query, but doesn't fill in the field. Instead, it just blanks the whole form out.

shrug

Well, still working on it...😉....again, still learning.

Thanks!!

[amcgrath]

Print the query to the screen and run it in the database terminal window... your query is doing a match (field = value) you may want to change it LIKE %$contact%' (Upper/lower case will probalby be an issue to deal witha s well).