|
|  |
The PHP developers network
551 hits
| Dec 01, 2003 12:15 am |
|
re: re: in a bind... |
rawk on
 | |
this seems to work...
SELECT * FROM phn_input WHERE phn_num = phn_num OR
(areacode = areacode AND phn_num = phn_num);
but i'm still caught up on displaying the results, and sending it to the sorry statement if the number is found. i could possibly send you the two files if you like.
> Jean-Paul HOUNKANRIN wrote:
> hey, I am not too sure what you want. But as far as I understand the telemarketer enters a phone number in a textbox and you have to such the database for it. The best way to do this is to send a sql query with a where keyword. it will actually look like this:
>
>====================POSSIBLE SOLUTION==============
>$q = "SELECT * FROM customers_table WHERE phn_num='$data_entered_by_telemarketer";
>$result = mysql_query($q) or die(mysql_error());
>==================END OF SOLUTION==================
>from here, make sure you've got some results returned using mysql_num_rows($result) and then get them using mysql_fetch_array($result).
>
>This might sound a little bit confusing, but I can only help if I have to write the whole code for you. You can get more information and be able to do this yourself by going to: http://www.phpbuilder.com/columns/jesus19990308.php3
>
>> rawk on wrote:
>> i was wondering if anyone could lend me a hand. i took on my current project knowing a little about sql and database driven websites. being a designer at heart with a little sql knowledge i thought i could complete this on my own. i have a page with a form, one field for the area code(areacode) and one for the phone number(phn_num). the area code and phone number are inserted into the database table. this page is for the client to enter a phone number. the next page is one for the telemarketer (it's a long story i wont get into it). anyways the telemarketer has to be able to search the database for a client's phone number. this is where im stuck. i havn't been able to find any documentation on searching a table in a database. after they enter in the phone number (two different fiels again, one for area code and one for the phone number) if the phone number is found it will take the telemarketer to a page with a form mail application in which they use to send the product info to our servers (this is already completed). if anyone would be willing to rough out an example or some code hints that would be great. so far i've been using the application intregration service in Dreamweaver MX 2004 database connection and server behaviours. thanks in advanced to all who reply. Private Reply to rawk on (new win) |
|
