While Array

billiondevil

kk i have exploded a string into a var called $items

$items=explode(", ",$string)

and what i wuld like to do is have a while to go through that array like you would do with a mysql array

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){

}

so i would like the while to keep going until i have reached the last $items[''], but how would i code this without involving any mysql?

plz dont move this to the database bit because its nothing to do with databases, i would juts like it to act like a while from an array from a database.

btw thx in advance😃

Weedpacket

[man]foreach[/man]

billiondevil

kk i looked it up and says stuff like

foreach ($arr as $value) {
    echo "Value: $value<br />\n";
}

so mine would be like

foreach ($items as $value) {
    echo "Value: $value<br />\n";
}

but what is the $value thingy about?

billiondevil

kk i tryed this code

<?php

function weaponshop(){

$sql="SELECT * FROM members WHERE username='".$_SESSION['myusername']."'";
$result=mysql_query($sql);
$info=mysql_fetch_assoc($result);

$sql="SELECT * FROM citys WHERE id='".$info['city']."'";
$result=mysql_query($sql);
$info=mysql_fetch_assoc($result);

$weapons = explode(", ", $info['weapon'])

foreach($weapons as $number => $id){
        $sql="SELECT * FROM items WHERE id='".$id."'";
        $result=mysql_query($sql);
        $info=mysql_fetch_assoc($result);

    echo "Name: ".$info['name']." Cost: $".$info['cost']." <br />";
}

}

?>

but it said

Parse error: parse error in D:\xampp\htdocs\weaponshop.php on line 15

which is the line with
foreach($weapons as $number => $id){
writen on it

anyone know why?

Weedpacket

Yup, you're missing the semicolon on the end of the previous line.

Incidentally, comma-separated lists in database tables are usually a symptom of poor database design.

billiondevil

the thing is i dont want to have a load of extra spaces in my table like item1, item2, item3 and it just seems easy to make a list of ids, how would do it?

laserlight

billiondevil wrote:
the thing is i dont want to have a load of extra spaces in my table like item1, item2, item3 and it just seems easy to make a list of ids, how would do it?

Numbered columns do not make for a good database schema design either. The typically correct solution is to create another table, then join where necessary.

billiondevil

kk i have got all my tables to work and it all follows a good schema, but now i need to make a wuiery that links 2 tables together, is that possible and if so how?

laserlight

billiondevil wrote:
but now i need to make a wuiery that links 2 tables together, is that possible and if so how?

It is possible. Search the Web for a tutorial on SQL.

billiondevil

kk i have looked around a bit and i have come up with the sql command

SELECT * FROM useritems INNER items ON useritems.itemid = items.id WHERE useritems.userid='1' AND items.type ='1'

but this comes uo with the error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'items ON useritems.itemid = items.id WHERE useritems.userid='1' AND items.type =' at line 1

thanks in advance

billiondevil

nvm did it