Re: [PHP] Using GET to build multiple sql queries

2005-06-02 Thread Greg Donald
On 6/2/05, Jack Jackson [EMAIL PROTECTED] wrote: I'd love some help with http://hashphp.org/pastebin?pid=3443 if anyone can... Basically I want to make it so that, if the get in the url specifies no query or a query to a nonexistent row, send to vanilla index. If url specifies c= then set

Re: [PHP] Using GET to build multiple sql queries

2005-06-02 Thread Greg Donald
On 6/2/05, Jack Jackson [EMAIL PROTECTED] wrote: Thanks for the reply, Greg, I see how that is useful. I am confused as to how I would implement it here. Please bear with me as I am a newbie and am now perhaps more confused than ever!: Bummer, sorry. I'm trying to use the number given in

Re: [PHP] Using GET to build multiple sql queries

2005-06-02 Thread Jack Jackson
Thanks for the reply, Greg, I see how that is useful. I am confused as to how I would implement it here. Please bear with me as I am a newbie and am now perhaps more confused than ever!: I'm trying to use the number given in the $_GET URL to build one piece of the sql: If there is

Re: [PHP] Using GET to build multiple sql queries

2005-06-02 Thread Jack Jackson
SORRY - one small correction below: SNIP If that were instead an $s then I would do: ?php //IF there is a valid query by subject, use $s to build the SQL $fields = SELECT art.*,publisher.*,subject.*; $from = FROM art,subject LEFT JOIN publisher ON

Re: [PHP] Using GET to build multiple sql queries

2005-06-02 Thread Jack Jackson
Greg, thank you for all this... See below Greg Donald wrote: On 6/2/05, Jack Jackson [EMAIL PROTECTED] wrote: Thanks for the reply, Greg, I see how that is useful. I am confused as to how I would implement it here. Please bear with me as I am a newbie and am now perhaps more confused than