[PHP-DB] Searching sql database using php

As per topic anyone know how to do it? Cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Searching sql database using php

ED]">news:[EMAIL PROTECTED]... > Yes. > > If you have a specific question, please post it and I'm sure folks will be > willing to try to help you out. > > Doug > > At 12:50 PM 9/3/01 +1000, Devon wrote: > >As per topic anyone k

[PHP-DB] Searching database tables

I have a database in mysql that only has one table, that table has approx 25 fields . I need to be able to search for data under each of these fields. Field examples: Company, TechContact, AdminContact, Mobile etc etc I need I guess a pull down menu that would select a field (c above) then

[PHP-DB] Searching a table

I have a database in mysql that only has one table, that table has approx 25 fields . I need to be able to search for data under each of these fields. Field examples: Company, TechContact, AdminContact, Mobile etc etc I need I guess a pull down menu that would select a field (c above) then

[PHP-DB] Newbie Help: Searching

$Query = "SELECT * FROM enet WHERE TechContact LIKE '%' AND AdminContact LIKE '%'"; This query simply prints out my entire tables, is there a way using PHP so I can make the '%' a user input so they can search the table under those fields. Cheers -- PHP Database Mailing List (http://www.php.

[PHP-DB] Table Search ... HELP

Below is an example of my code which searches a table and prints the result, the problem is that it only displays the TechContact where I want it to display all the fields that associated with it in that row off the colum eg. Mobile, AdminContact etc etc Any suggestions? if ($TechContact == "")

[PHP-DB] Individual Lines of text

I am pulling down data from a switch which looks like Port 1, 33889029532 Port 2, 0 Port 3, 135852 Port 4, 6652941243 etc etc I need to know if it is possible with PHP to write a script that will pull the individual lines of this text file and store them into a mysql database line by line. Chee

[PHP-DB] Date

Is there a way that the default sql data base date -00-00 can be changed using php? Cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PRO

[PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

I have been scouring the online documentation and experimenting for hours trying to find a solution. I just can't do it. I have two colomns of data that I am retrieving from MySQL: SELECT id, name FROM a_table; I just cannot figure out how to get that data from the resource handle into an as

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

Chris Boget wrote: The original poster actually mentioned an associative array with one db field as the index and another as the value. None of these, just like Ignatius's suggestion, will do the job. Actually, mysql_fetch_assoc() will do quite nicely. Im afraid not. I already tried that. It u

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

Cpt John W. Holmes wrote: while($r = mysql_fetch_assoc($result)) { $array[$r['id']] = $r['name']; } ---John Holmes... Wonderful! Thats exactly what I was looking for! I ended up taking the array out of the equation entirly as suggested by Davic T-G, but the simplicity of your answer was exactly

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

David T-G wrote: Note that I don't recommend this as the best approach, and I don't think that anyone else does, either. Usually you want to avoid sucking an entire database into your script's memory; the database (and its coders) almost always handles data better than we mere mortals. A much be