Re: [PHP] Newbie question, Which way is best?

2008-03-20 Thread George J
Thiago Pojda [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] De: George J [mailto:[EMAIL PROTECTED] So calling the script via the form works i.e it passes the neccessary variables to constrct the sql query for the next call. As Shawn said, if you really need the query again add

Re: [PHP] Newbie question, Which way is best?

2008-03-20 Thread George J
Hi Shawn, My query code- ---SQL query construction block $query = SELECT * FROM prods ; if($catagory != 0){ // if category != 0 $where=WHERE c = $catagory ; if ($manu != 0){ // check manu != 0

[PHP] Newbie question, Which way is best?

2008-03-19 Thread George J
Hi, I have a script that contains a form and a pagination routine that calls itself. I want to pass an sql query along with some other variables to the called script. The code to acheive this, using the form, is working but when I try to write the code, using the scripts URL to call itself, I

Re: [PHP] Newbie question, Which way is best?

2008-03-19 Thread George J
Hi Daniel, WHOA! Passing the SQL query via a URL is a Very Bad Idea[tm]! As a newbie I just have to ask why. I suspect you're going to say it gives the table and field names used in my database. I'm not really aware of all the possible avenues that this method might open up. It just feels

Re: Re: [PHP] Newbie question, Which way is best?]

2008-03-19 Thread George J
Hi Shawn, Shawn McKenzie [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] George J wrote: Hi Daniel, WHOA! Passing the SQL query via a URL is a Very Bad Idea[tm]! As a newbie I just have to ask why. I suspect you're going to say it gives the table and field names used in my

[PHP] Re: algorithm of pages beaking

2008-03-19 Thread George J
Hi, I'm trying to resolve an issue with a pagination routine. Sounds like we're working on a similar routine. I have a query returning products from a database and then display the results in a defined number of products per page. Checkout - 'Newbie question, Which way is best?' in this

[PHP] Re: MySQL Group?

2008-03-19 Thread George J
Hi John, John Taylor-Johnston [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Does anyone know of a good MySQL group? I want to make a relational link from `data` to `shopping` so when I insert a new record in `shopping`, I will see the contents of `data`.`name` and `data`.`email`