Re: help passing string with spaces

Thanks! This isn't pretty, but it works beautifully: some php logic ?> <a href="show_more.php?d_title=<? echo urlencode($val)?>"> <? echo "$val</a></font></td>"; more php --- David Robley <huntsman@www.nisu.flinders.edu.au> wrote: > On 23 Aug, Zen Rodeo wrote: > > Here's some code to print some data from MySQL > into a > > table data cell. The idea is you click on the link > to > > see the entire row: > > printf ("<a > > href=\"show_more.php?d_title=%s\">%s</a></td>", > > ($val), ($val)); > > > > And here's the code from show_more.php that's > supposed > > to bring up the entire row : > > $my_query = "SELECT * FROM driver WHERE > driver_title = > > '$d_title'"; > > > > This all works fine when the data is a short > string > > like Major. But the page containing the SQL query > > doesn't see the whole string $d_title when the > string > > is Major Tom. It doesn't like the empty chars. > > However, in the URL area of the browser window, > the > > entire string is visible, and of course it's > visible > > in the table. > > > > We're using PHP4 with magic_quotes_gpc = on. Tried > > addslashes, stripslashes, urlencode, etc. > > > > How can the entire string be passed to the next > page > > and then used successfully in a SQL query? > > > > Thank you. > > urlencode is what you want. Try echo to output the > URL and use urlencode > on $val. Something like > > <a href="show_more.php?d_title=<?php echo > urlencode($val)?>"></a></td> > > or similar. > > Cheers > -- > David Robley | WEBMASTER & > Mail List Admin > RESEARCH CENTRE FOR INJURY STUDIES | > http://www.nisu.flinders.edu.au/ > AusEinet | > http://auseinet.flinders.edu.au/ > Flinders University, ADELAIDE, SOUTH > AUSTRALIA > __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/