TalkPHP - View Single Post - Storing multiple file paths inside a database

sarmenhb · 02-17-2008, 04:29 AM

try trowing all the paths into a variable like

Code:

$variable = $path[1]."|".$path[2]."|".$path[3];

$query = "INSERT INTO somename(id,path) VALUES(null,'$path')";
$save = mysql_query($query);

your table structure should be

Code:

create table somename(id NOT NULL ,path mediumblob)
ENGiNE = myisam (or whatever u choose);

then you can do like

Code:

$query = "SELECT path FROM somename";
$output = mysql_query($query);

if(mysql_num_rows($output)) { 


while($row = mysql_fetch_assoc($output)) {

$data = $row['path'];
}

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

echo $data[$i]."<br>";
}
}

let me know if this is what you needed, i got cared away :p