&quot;Splitting entries&quot;

"Splitting entries"

Myriadz

Hi, please help me as Im stuck with this.

domain_id | domain_name | client_id |

123 | here.com | 77 |

 124         |         there.com      |        77          |

I have a table named domain_names of which contains the
fields as stated above.

Say I "SELECT domain_name FROM client_id
WHERE client_id = 77";

How do I make it that here.com is $variable1 and there.com is another $variable2?

As in "split them" into 2 variables.
Normally, I know how to split arrays through their column names, but this is through rows.

Using arrays? Please help.

PHP-Editors_com

Why not use a 3d array?

$qry = mysql_query("SELECT domain_name FROM client_id 
WHERE client_id = 77");

$i=0;
while($res = mysql_fetch_array($qry)) {
 // will loop each row
 $variable[$i][0] = $res[0];
 $i++;
}

hope this helps

Myriadz

domain_id | domain_name | client_id |

123 | dunno.com | 77 |

124 | great.com | 77 |

125 | hmmm.com | 77 |

Hi, I don't quite get multi-dimensional arrays. Ok, what would the code be for getting variables like these

$domainName1 = "dunno.com"
$domainName2 = "great.com"
$domainName3 = "hmmm.com"

Are there any good tutorials for multi-demensional arrays as well?
I can't seem to find any good ones. Thanks in advance!

deuce868

in your query results you can run through them in a foreach loop.

$query = "your query here";

if (!($result = @mysql_query($query, $connection)))
	showError();


while( $row = mysql_fetch_array($result))
{
  $domain  = $row["domain_name"];
  // do your stuff here

}

Or you can save the values by placing them in an array in the while loop.

Myriadz

/ Select the domain names for the standard packages /
$query_domains = mysql_query("SELECT domain_name FROM domain_names WHERE client_id = '$client_id'");

$get_domains = mysql_fetch_array($query_domains);

$count = count($get_domains);

for ($i = 0; $i < $count; $i++) {

echo $get_domains[$i];

}

I tried doin it this way but it only displays the 1st row of the domain. No 2nd row onwards...why?
As in it only prints dunno.com

PLease help thanks.

Myriadz

domain_id | domain_name | client_id |

123 | dunno.com | 77 |

124 | great.com | 77 |

125 | hmmm.com | 77 |

/ Select the domain names through the client_id/

$query_domains = mysql_query("SELECT domain_name FROM domain_names WHERE client_id = '$client_id'");

I would like...it to be....

Something like...

The code auto-detects how many domains there are under
the client and assigned variables accordingly.

All clients have different number of domains under he/her.

Say the code detects that Mike has 4 domains.

How do I go about assigning EACH ROW of the column "domain_name" to a corresponding variable.

I don't want to get the all domains dumped into a single variable.
I would like each domain to be assigned its own variable.

$domainONE = dunno.com
$domainTWO = great.com
$domainTHREE = hmmm.com

I been stuck at this for a few days now and all the code I tried doesn't work. Please help!

deuce868

I tried doin it this way but it only displays the 1st row of the domain. No 2nd row onwards...why?

because you only fetched one array from the result set. The lines

$get_domains = mysql_fetch_array($query_domains); 
$count = count($get_domains);

both need to be in the loop as well.

Try it this way

$query_domains = mysql_query("SELECT domain_name FROM domain_names WHERE client_id = '$client_id'"); 

$i=0; // set the counter we will use
while($get_domains = mysql_fetch_array($query_domains))
{
  // so long as there are results left we will go through this loop
 echo $get_domains[$i]; 
 $i++; // increment out counter

}

$count = $i+1; //since $i started at 0 you need to add one to get the number of domains.