Re: [PHP] RE: Help with my first recursion menu

2009-11-01 Thread Lex Braun
Hi, On Sat, Oct 31, 2009 at 11:07 AM, MEM wrote: > > > *From:* Lex Braun [mailto:lex.br...@gmail.com] > *Sent:* sábado, 31 de Outubro de 2009 14:05 > *To:* MEM > *Cc:* php-general@lists.php.net > *Subject:* Re: [PHP] RE: Help with my first recursion menu > > > >

Re: [PHP] RE: Help with my first recursion menu

2009-10-31 Thread Lex Braun
Hi, On Wed, Oct 28, 2009 at 5:22 PM, MEM wrote: > I've been told that stack is the way to go, so I'm trying to understand > the > following code: > http://pastebin.com/m5616c88f > I've commented every line so that any of you could see if I'm interpreting > something wrong: > > > I have two ques

Re: [PHP] supplied argument errors

2009-06-23 Thread Lex Braun
On Tue, Jun 23, 2009 at 4:10 PM, PJ wrote: > I think there is something I do not understand in the manual about > mysql_fetch_assoc(), mysql_affected_rows() > The code works, but I get these annoying messages. > snippet: > What are the warnings?

Re: [PHP] Check out system for Shopping Cart

2009-05-21 Thread Lex Braun
Vernon, CC messages to php-general to keep responses on-list. See my comments inline. On Thu, May 21, 2009 at 12:06 PM, Vernon St.Croix wrote: > > I have amended as you advised and the mysqli errors are now gone. Thanks > for that. > > I however have another one I can't get rid of: > > > *Warnin

Re: [PHP] Check out system for Shopping Cart

2009-05-21 Thread Lex Braun
On Thu, May 21, 2009 at 7:32 AM, Vernon St.Croix wrote: > *Warning*: mysqli_query() expects parameter 1 to be mysqli, object given > in *C:\wamp\www\draft\checkout.php* on line *26* > > ***for the script > > > include("mysql.class.php"); > > include ("header.php"); > > > > //include (

Re: [PHP] Non-Object errors

2009-04-28 Thread Lex Braun
Terion, On Tue, Apr 28, 2009 at 1:14 PM, Miller, Terion < tmil...@springfi.gannett.com> wrote: > Here is my code now: > $query = "select name, age, warrant, bond, wnumber, crime FROM warrants > where ".$warranttype." = ".$warranttype." OR ".$searchname." = > ".$searchname." ";$result = mysq

Re: [PHP] difficult select problem

2009-04-07 Thread Lex Braun
PJ, On Tue, Apr 7, 2009 at 11:37 AM, PJ wrote: > $SQL = "SELECT b.*, c.publisher, a.first_name, a.last_name >FROM book AS b >LEFT JOIN book_publisher as bp ON b.id = bp.bookID >LEFT JOIN publishers AS c ON bp.publishers_id = c.id >LEFT JOIN book_author AS ba ON b.

Re: [PHP] difficult select problem

2009-04-06 Thread Lex Braun
On Mon, Apr 6, 2009 at 2:05 PM, PJ wrote: > My code already has selected the books whose authors last names start > with A as well as the authors themselves. > Within the results some books have 2 authors. If you already have the book IDs where this happens, then for each bookID (probably a for

Re: [PHP] difficult select problem

2009-04-06 Thread Lex Braun
PJ, On Mon, Apr 6, 2009 at 12:32 PM, PJ wrote: > I am trying to limit the search for books to only those that start with > "A" (does not have to be case sensitive); but within that selection > there may be a second author whose name may start with any letter of the > alphabet. > First off, are y

Re: [PHP] & and && and weird results

2009-04-01 Thread Lex Braun
PJ, On Wed, Apr 1, 2009 at 1:40 PM, PJ wrote: > SELECT * FROM book >WHERE id IN (SELECT bookID >FROM book_author WHERE authID IN (SELECT author.id >FROM author WHERE LEFT(last_name, 1 ) = '$Auth' && > LEFT(last_name, 1 ) = '$Auth1' && LEFT(last_name, 1 ) = '$Auth2')); >

Re: [PHP] validation & inserts not working

2009-03-11 Thread Lex Braun
On Wed, Mar 11, 2009 at 5:44 PM, PJ wrote: > haliphax wrote: > > On Wed, Mar 11, 2009 at 4:29 PM, PJ wrote: > > > >> Lex Braun wrote: > >> > >>> PJ, > >>> > >>> > >>> > >>>> Â Â > >>&g

Re: [PHP] validation & inserts not working

2009-03-11 Thread Lex Braun
PJ, > > > $sql1 = "INSERT INTO book ( title, sub_title, descr, > >comment, bk_cover, copyright, ISBN, language, sellers ) > > VALUES ('$titleIN', '$sub_titleIN', '$descrIN', '$commentIN', > >'$bk_coverIN', '$copyrightIN', '$ISBNIN', '$languageIN

Re: [PHP] validation & inserts not working

2009-03-10 Thread Lex Braun
PJ, On Tue, Mar 10, 2009 at 3:46 PM, PJ wrote: > > $sql1 = "INSERT INTO book ( title, sub_title, descr, >comment, bk_cover, copyright, ISBN, language, sellers ) > VALUES ('$titleIN', '$sub_titleIN', '$descrIN', '$commentIN', >'$bk_coverIN', '$copyrightIN', '$ISBN

[PHP] Re: [PHP-DB] Re: [PHP] Re: [PHP-DB] Re: Problems with displaying results

2009-03-05 Thread Lex Braun
On Thu, Mar 5, 2009 at 10:30 AM, Terion Miller wrote: > Still having problems with getting this script to work, the first part of > the query does now work since I used the suggested JOIN, so my results are > there and I can echo them but now I can't seem to get them to display > neatly > somehow: