slashpine

no error problems but something is not right with the URL... using your  snippet... I get the following http://maps.yahoo.com/maps?syne=-3008&addr=4&csz=3&country=us regardless of the query results... any ideas?

Thanks fopr the example...I will give it  ashot later tonight or tomorrow... thanks again for the replies

ok I think I got a handle on it but....The "address" record I have is a usually a street number and then a street name etc... all the URLs for the map sites have +'s between the number and the street name... the way I thought to call the data "...{$data['address']}..."  I don't know how to seperate the number and the street name in the string from that column with a + ?

[quote author=AndyB link=topic=106136.msg424252#msg424252 date=1156884938] [quote author=slashpine link=topic=106136.msg424238#msg424238 date=1156882180] What I have in the database in corresponding columns= 'street address' | 'zip code' do I have any options using this data? [/quote] Yes. Yahoo Maps or Google Maps. Either of them conditionally allow the use of their maps.  If you visit one of the addresses in your database you'll see how map services construct their URLs and then you can use your database info to construct specific URLs for each of the businesses that link to the right part of the right map. [/quote] Thanks... I see what you mean...can I use php to query the database and  parse the address and zip  as variables and displays the dynamioc URL ?

Thanks for the reply... What I have in the database in corresponding columns= 'street address' | 'zip code' do I have any options using this data?

Not sure if this is kosher or not...? I have a database of local business listings... without having to hand code every record (over 50k)...I would like to add a link to a map of the address that coincides with each individual record... Can this be done with a single script? could it possibly be done using an html form grabbed from the source code of a free map provider (and hiding the fields) that executes a script that grabs the record from the DB and parses the streed address and the zip code ...this would leave me a "map" button rather than a (text) hyperlink.. any comments or suggestions welcome...

I do appreceiate all the efforts but the fact of the matter is.... what I am seeking  and what I have described in finite detail within this thread could theoretically be used in [u][b]ANY[/b][/u] databse that has an "id" field and one to contain the "link" string...regardless of  any other  fields. i.e.,...what I asked for is the [u]syntax of a string[/u] that when returned as a query result (regardless of any other columns being queried) so that said string would contain the id of the row where the string originally resided.

that is my point this quest has nothing to do with the current query scripts... what I am seeking has no bearing on the originating queries... Right now I have an empty column in an existing tabel row... what I am seeking is the an "<href" string that will parse the actual id of that particular row and return it to the string being displayed in the original results display... the main question of all this is...How do I get the actual row id from a variable that resides in that row?

sorry but I can't make any of that work (too many errors) also the "link" does not parse the row id it only prints : ?id=id

I really do appreciate the efforts but this is not what I am seeking....My whole point is not having to edit or ammend the existing query scripts... thus the want for something (hyperlinked text) that I could put into existing row cells that would capture the id of the row in which it resides...and reflect this (unique row id) in the initially displayed link...

I am sorry I can't seem to make myself clear on this.... what I am looking for is the HTML/php code that when placed in a database row it will be displayed as link to a script that runs a second query on the same database based on the id of the row that HTML code originall resided... This (row id) must be a variable so the (HTML/php) code can be placed on every row (50k+) but when displayed will parse the row id ($variable) as unique to the row.

no I don't think it does... whatever I put into the cell that gest displayed  running the original query has to start with " <a herf="  to get displayed as a hyperlink... how do I ge the this to get the row id ?

something to that effect is what I am looking for but that does not work it just prints "...=$id" it does not parse the actual row id...I have also tried using ...foo.php?query=.$id['id'].">click here</a>" nothing works...that is why I am here...

so this is not possible? >:( thanks for the efforts anyway

thanks for the replies... I probably did not do a good job of citing what I need here... I don't want to have to alter any existing php scripts that presently query my db... I am looking for something (described above) that can be placed in a cell of  db that will reflect the id of the row in which it resides.... when displayed, the row id is parsed into the "link" again...I am not looking for a php script... I am looking for the correct syntax (if it exists) of a hyperlink that will do as said.

that does not do anything... I need something that is going to put a hyperlink in the initial results display is this possible?

can you tell me what to put in the database cell so that when results of that particular row are displayed it displays a link that executes another query based on the id of the row that the link originall resided?

thanks for the reply... what I am looking for the is the exact syntax of the "link" that gets placed in the database cell...i.e: I thought it should look something like this: [b]<a href="h**p://foo.com/foo.php?query=$id">click here</a>[/b] but this does not work...it does not capture the row id

I am not sure this is doable but then it again it may be easy...that's why I'm here, I don't have a clue... I am looking for a way to create (syntax) a variable (row id) in a generic link that can be placed in a database column that when displayed (in a browser) with the other columns in any particular row...the link will end up looking something like ths: ../foo.php?query=123  Where "123" is the id for that particular row. i.e., I want to be able to insert the the same "link" in all the rows but in the returned display they all need to link to ../foo.php?query=$id  (where '$id' will be the actual row id ) hope this is doable...?

I have a script that searches a database for individual business names... way too may users are trying to use this script/form to find business categories, regardless of the fact it is distinctly labled as such... The programmer that originally helped me with this scrpt included such an error message but it does not work... if there are no results the script returns a blank form with no message... how can I get this script to return a message telling users they are using the wrong form when no results are returned here is the part of the scrip that does not work TIA for any help... [code]$PHP_SELF = $_SERVER['PHP_SELF']; $searchTerm = trim($_POST['searchTerm']); $submit = trim($_POST['submit']); $input_form = <<< END <form name="searchForm" action="{$PHP_SELF}" method="post" onSubmit="return checkInput();"> Search by name: <input type="text" name="searchTerm" size="20" maxlength="45"> <input type="hidden" name="submit" value="Search"> <input name="submit" type="submit" value="Search"> </form> END; $error_msg = <<< END <font color="red">We are unable to process your request at this time, please try again in a few moments.</font> <br><br> $input_form END; // if no results, $no_results = <<< END There were no results with the searchterm '<font color="blue">{$searchTerm}</font>', please try again. <br><br> $input_form END; ?> [/code]