Re: MySQL: How to properly extract fields from retrieved single record ???

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 22 Sep 2003 13:06:37 +0200
"Ignatius Reilly" <ignatius.reilly@free.fr> wrote:

> read the PHP manual and examples under the function
> mysql_fetch_array().
> 
> I find the MySQL manual is very well done and helpful. I've been using
> it as a reference for 2 years. Take a harder look!
>   
I think Ignatius meant the PHP manual... It is rather terse, but the
functions have been categorised to make it easier to find.

See code alteration below.


George Patterson



> Ignatius
> 
> > Hi gang
> >
-snipped--
> >
> > I tried this:
> >
> >      $num2edit = $_POST['edit'];
> >      $link = mysql_connect($host,$username,$password)
> >        or die('Could not connect : '.mysql_error());
> >      mysql_select_db($database) or die('Could not select database');
> >
> >      $query = "SELECT
> > countryNum,country,nw,gov,strat,spy,troops,jets,turrets,tanks,ally,
> > owner FROM a2a WHERE countryNum=$num2edit";
> >      $result = mysql_query($query);
> >
> >      $countryNum = mysql_result($result,1,'countryNum');
> >      $country = mysql_result($result,1,'country');
> >      $nw = mysql_result($result,1,'nw');
> >      $gov = mysql_result($result,1,'gov');
> >      $strat = mysql_result($result,1,'strat');
> >      $spy = mysql_result($result,1,'spy');
> >      $troops = mysql_result($result,1,'troops');
> >      $jets = mysql_result($result,1,'jets');
> >      $turrets = mysql_result($result,1,'turrets');
> >      $tanks = mysql_result($result,1,'tanks');
> >      $ally = mysql_result($result,1,'ally');
> >      $owner = mysql_result($result,1,'owner');
> >
> >      /* Free resultset */
> >      mysql_free_result($result);
> >      /* Closing connection */
> >      mysql_close($link);
> >
> > But all it gives me are errors like this:
> >
> > Warning: mysql_result(): supplied argument is not a valid MySQL
> > result resource in E:\web\mpe\a2aedit.php on line 350
> > Warning: mysql_result(): supplied argument is not a valid MySQL
Duplicate error message delete...
> >
> > Obviously, the first mysql_result line is line 350 in the full code.
> > I've also tried changing the row number to 0, but results in the
> > same errors.
> >

This ain't microsoft anymore...

$num2edit = $_POST['edit'];
$link = mysql_connect($host,$username,$password)
	 or die('Could not connect : '.mysql_error());
mysql_select_db($database) or die('Could not select database');

$query = "SELECT countryNum, country, nw, gov, strat, spy, troops, jets,
turrets, tanks, ally, owner FROM a2a WHERE countryNum=$num2edit";
echo "This is for test only: Print Query-> $query<br>\n";
$result = mysql_query($query);

$row=mysql_fetch_assoc($result); #$row is an array. 

#display the row retrived from the database. For you information only.
 echo "<pre>\n";
print_r($row);
echo "</pre>\n";

$countryNum = $row['countryNum'];
$country = $row['country'];
$nw = $row['nw'];

#then close the database connection... 
As you had it...


> > I can't find any decent reference on the web that shows how to do
> > this - field extraction - when there's only the single record. So
> > I've been mixing code from various places. And I don't even know if
> > it retrieves the right record, or any record at all (how do I test
> > that?).
> >
> > Any help is highly appreciated :)
> >
> > TIA
> >
> > Rene
> > --
> > Rene Brehmer
> > aka Metalbunny
> >

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux