Define array with row = Mysql_fetch_array

Dev Shed Forums Sponsor:

December 8th, 2012, 04:45 PM

BitZoid

Contributing User

Join Date: Nov 2012

Posts: 98

Time spent in forums: 1 Day 2 h 20 m 38 sec
Reputation Power: 1

Define array with row = Mysql_fetch_array

Hi all,

It's been about 6 years since I've read a PHP book - so this may sound trivial to you all, but I'm fretting over this functionality:

I'm trying to simply output 3 mysql results to 3 variables that I can then use inside of a marquee html tag. The mysql query is set to LIMIT 3, to keep the result concise. Here is what I have, but I know it's not right !::!

PHP Code:


		
			
 $queryMan = "SELECT DISTINCT(manufacturer) FROM manufacturer ORDER BY RAND() LIMIT 3";

$resultMan = @mysql_query($queryMan);

$i=0;

while ($rowMan = mysql_fetch_array($resultMan)) {

$man = Array();

$man[$i] = $rowMan[$i];

$i++;

}

?>

<h5><marquee behavior="scroll" direction="left">Text...<?php echo $man1.', '.$man2.', and '.$man3; ?>...more text</marquee></h5>

When i echo $man[$i] within the while loop to test it, I only get one row, while I needed three rows.

Can somebody serve me with the right info here...

December 8th, 2012, 05:05 PM

ptr2void

I haz teh codez!

Join Date: Dec 2003

Posts: 2,477

Time spent in forums: 1 Month 2 Weeks 2 Days 7 h 33 m 54 sec
Reputation Power: 2194

Why would you want to create the $man array with every iteration of the loop?

__________________
I ♥ ManiacDan & requinix

This is a sig, and not necessarily a comment on the OP:
Please don't be a help vampire!

December 8th, 2012, 05:09 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,717

Folding Points: 417516 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 5 Months 1 Week 4 Days 7 h 29 m 55 sec
Reputation Power: 8969

Send a message via Google Talk to requinix

PHP Code:


		
			
 $man = Array();

You keep resetting $man inside the loop. Also

PHP Code:


		
			
 $man[$i] = $rowMan[$i];

$i++;

$rowMan is a single row from the query. If you [$i] that you'll get a value from a column. Your query only has the one column so only [0] is valid - [1] and [2], which your loop tries to get to, will be null (because they don't exist). In fact $i isn't even necessary.

PHP Code:


		
			
 $queryMan = "SELECT DISTINCT(manufacturer) FROM manufacturer ORDER BY RAND() LIMIT 3"; 

$resultMan = @mysql_query($queryMan); 

$man = Array();

while ($rowMan = mysql_fetch_array($resultMan)) { 

$man[] = $rowMan[0]; 

}

Also, $man1 is a variable that doesn't exist. There is no "$man1=" in your code. Instead $man is an array. If you want the first value then use $man[0].

__________________
Site rules and FAQ | Project Suggestions | mod_rewrite guide | PHP New User Guide and FAQ - PHP Stickies | Regex Resources

December 8th, 2012, 05:36 PM

BitZoid

Contributing User

Join Date: Nov 2012

Posts: 98

Time spent in forums: 1 Day 2 h 20 m 38 sec
Reputation Power: 1

This is what I wanted. I was trying every combination of, now apparently clear, wrong syntax.. Thanks requinix, now the site this goes to is more SEO optimized and great looking.

I guess I should start brushing up on my php since I finally finished this 2 and 1/2 month project.

Thank you again.

Define array with row = Mysql_fetch_array

Developer Shed Advertisers and Affiliates