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:
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
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
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
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'));
>
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
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
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.
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
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 (
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
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?
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
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
>
>
>
>
14 matches
Mail list logo
