List:General Discussion« Previous MessageNext Message »
From:Mike Date:June 8 2002 11:15pm
Subject:Re: TextBox --> Database
View as plain text  
 For the code you posted

>              mysql_connect("localhost", "kryste", "*******");
>              $result = mysql(mydatabase, "select * from Bidder");
>              $num = mysql_numrows($result);
>              $i = 0;

Try $num = mysql_num_rows($result);


Mike
----- Original Message ----- 
From: "Gerald R. Jensen" <gjensen@stripped>
To: "Patrick Hanes" <PKHanes@stripped>; "Mysql" <mysql@stripped>
Sent: Saturday, June 08, 2002 5:07 PM
Subject: Re: TextBox --> Database


> Well, for starters, if you are trying to put data into the database, your
> query should use INSERT ... not SELECT.
> 
> Here's a snippet from one of my scripts ...
> 
> $query_insert="INSERT INTO tablename (column1, column2, textdata) VALUE
> ('$column1','$column2','$textdata')";
> 
> if (!($result_insert = mysql_db_query($DB, $query_insert)))
>  {
>  DisplayErrMsg(sprintf("internal error %d:%s\n",
>  mysql_errno(), mysql_error()));
>  exit() ;
> }
> 
> ----- Original Message -----
> From: "Patrick Hanes" <PKHanes@stripped>
> To: "Mysql" <mysql@stripped>
> Sent: Saturday, June 08, 2002 10:05 PM
> Subject: TextBox --> Database
> 
> 
> How do I take input off of web page text boxes and put them on MYSQL
> database.  This is the page's script.  I also named the file Input.phtml.
> I'm very new to this... what am I doing wrong?
> 
>  <HTML>
> <HEAD>
> <TITLE>
> Input
> </TITLE>
> </HEAD>
> 
> <BODY>
> 
> <P>These are the people I sell to:</P>
> 
>          <TABLE BORDER=10>
>          <?
>              mysql_connect("localhost", "kryste", "*******");
>              $result = mysql(mydatabase, "select * from Bidder");
>              $num = mysql_numrows($result);
>              $i = 0;
> 
>              while($i < $num) {
>                 echo "<TR>n";
>                 echo "<TD>n";
>                 echo mysql_result($result,$i,"Last");
>                 echo "</TD>n<TD>";
>                 echo mysql_result($result,$i,"First");
>                 echo "</TD>n<TD>";
>                 echo mysql_result($result,$i,"Price");
>                 echo "</TD>n";
>                 echo "</TR>n";
>                   $i++;}
>           ?>
> 
>           </TABLE>
> 
> </BODY>
> </HTML>
> 
> 
> ********************************************************
> I get this error: These are the people I sell to:
> 
> 
> Warning: Supplied argument is not a valid MySQL result resource in
> /home/kryste/Input.phtml on line 16
> 
> 
> Thanks,
> Pat
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread111411@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-autodata=execpc.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread111413@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-mike=wkla.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02

Thread
TextBox --> Database(Patrick Hanes)8 Jun
  • Re: TextBox --> DatabaseGerald R. Jensen8 Jun
  • Re: TextBox --> DatabaseMike9 Jun