how do i echo all rows in php?

[mkx]

Is there a way to show all rows in a database table without having to echo row[0] echo row [1] for each field?



did select * from blah where id=1 but theres about 50 fields (keyword tags) so can i just echo them all?

[SmellyNose]

It depends what you're using to get your data.

You could do

foreach($data as $v) {
    echo $v;
}

Or if you're using mysql_fetch_array (or _assoc) you could do:

$r = mysql_fetch_assoc($mysql_resource_link_doo_dar_thing);
while($r) {
    echo $r['tag']; // Use $r[index_of_Tag] if you are using _array
    $r = mysql_fetch_array($mysql_resource_link_doo_dar_thing);
}

I'm on ICQ if you need 594086663

[mkx]

thx dude, ill give it a try

[mkx]

hmm cant figure it out, heres my code:

$alltags = mysql_query("SELECT * FROM tags WHERE user_id=$id");


while($row1 = mysql_fetch_array($alltags))
  {
echo $row1['tag_cen']; //i want to echo fields here instead of just tag_cen

  }

[Brujah]

while($row = mysql_fetch_array($alltags)) 
{
   echo implode(', ',$row);
}

[SmellyNose]

hmm cant figure it out, heres my code:

$alltags = mysql_query("SELECT * FROM tags WHERE user_id=$id");


while($row1 = mysql_fetch_array($alltags))
  {
echo $row1['tag_cen']; //i want to echo fields here instead of just tag_cen

  }

Add another echo in your while loop to see if it is actually going into it.

And add:

if($alltags === false) {
    die("Query failed");
}

uk3.php.net/mysql_fetch_array

And $id is definitely numeric isn't it?

$id = preg_replace('/[^0-9]/', '', $id);

Otherwise you could be open to mysql injection

[mkx]

that works good, thanks very much guys,

btw, is there anyway to skip the first field from echoing? since the first field is the id and i dont want to echo it. the 30 fields that follow are tags

[SmellyNose]

You could do it in MySQL, but I'd probably do it in the PHP as MySQL limits are usually what break things.

You could use an int to see where you are, like this:

$c=0;
while($row) {
if($c==0) { break;}
echo $row['tag'];
$c++;
}

[mkx]

thanks again

[SmellyNose]

No problem. Anybody looking for a web developer, ICQ Me: 594086663

[Richard - Triplexcash]

No problem. Anybody looking for a web developer, ICQ Me: 594086663

Can you drop me an email please or hit me on my icq...can't seem to locate you with my IM client on ICQ.

Thanks.