going to the next row in a MySQL DB with PHP

Dev Articles Community Forums Sponsor:

June 25th, 2003, 01:45 AM

CHornJr

Contributing User

Join Date: Nov 2002

Location: New York City

Posts: 236

Time spent in forums: 1 Day 1 h 50 m 36 sec
Reputation Power: 7

going to the next row in a MySQL DB with PHP

Lets say I have table called stuff with 3 columns: Id, stuff, type.

id|Stuff |type|
------------------
1|stuff 1| 1 |
------------------
2|stuff 2| 2 |
------------------
3|stuff 3| 2 |
------------------
4|stuff 4| 1 |
------------------
5|stuff 5| 2 |
------------------
6|stuff 6| 1 |
------------------

now to display the whole table in reverse order all I need to do is

PHP Code:


		
			
 $query=mysql_query("SELECT*FROM stuff ORDER BY id DESC");

$createarray=mysql_fetch_array($query);

$loopid=$createarray['id'];

while($loopid=>1)

 {

   echo $createarray['stuff'];

   $loopid--

 }

That should show
"stuff 6stuff 5stuff 4stuff 3stuff 2stuff 1"

But I want it to only display those that are type "1" I know tp use the "WHERE" Clause to select the type but where I am not sure of what to do is how to get it to go to teh next row. I can't use "$loopid--" because it would count id's 5, 3 & 2. SO how can I get it to go to the next row thatmeets the "WHERE" criteria and actually skip over those that need ot be skipped

__________________
CHornJr
"One day I'll know what I am doing"

My Blog
Suanhacky Lodge #49
Rebel Squadrons

June 25th, 2003, 03:46 AM

digitallysmooth

you know how we do

Join Date: Jun 2002

Posts: 788

Time spent in forums: 2 h 34 m 21 sec
Reputation Power: 7

You are almost there.

1. Put the where clause in your SQL statement.
2. Loop through the array only printing the stuff in the "stuff" column

Example:

PHP Code:


		
			
<pre>

<?php



$stuff = array(

  array("id"=>6,

        "stuff"=>"stuff 6",

        "type"=>1

  ),

  array("id"=>4,

        "stuff"=>"stuff 4",

        "type"=>1

  ),

  array("id"=>1,

        "stuff"=>"stuff 1",

        "type"=>1

  )

);



print_r($stuff);



print "<br>";



print "stuff 6stuff 5stuff 4stuff 3stuff 2stuff 1   (hard coded)";



print "<br>";



foreach ($stuff as $item) {

  $concat .= $item['stuff'];

}  



print $concat . " (from array)";



?>

</pre>

In the example I used an array... same thing.
Instead of a loop with foreach as I did, your loop will be a while loop:

PHP Code:


		
			
while ($item = mysql_fetch_object($query) {

  $concat .= $item['stuff'];

}



print $concat;

__________________
__________________________________________________ _
Wil Moore III, MCP | Integrations Specialist | Senior Consultant
Are You Listed...? | DigitallySmooth Inc.

Last edited by laidbak : June 25th, 2003 at 03:50 AM.

Viewing: Dev Articles Community Forums > Databases > MySQL Development > going to the next row in a MySQL DB with PHP

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump