PDA

View Full Version : combine help


techker
11-25-2008, 06:52 PM
ok guys i got my script going..

so i have an image uploader that inserts in my database a pic with the name and id.

i have a second page with a list box that getts all the pic's names and list them so i can insert in another database the description and location a grid

the grid has 8 tables that will include the pic assigned to it.that were im at.

so pages uploader.php
locater.php and grid .php

see i insert the pics name and location(on the grid)in grid database

the pix are stored in pix databse with the name and blog

so now i need to get the information from grid (to know the pic's name and location)the post the image (from pix) on the grid.

is this confusing?lol or clear

techker
11-25-2008, 07:19 PM
i tryed this


$fileSQL=" SELECT *
FROM `grid` where location=1
LIMIT 0 , 8 ";
$fileLIST=mysql_query($fileSQL, $db_link);
while ($line = mysql_fetch_array($fileLIST))
{
foreach ($line as $pix)

$query=" SELECT *
FROM `pix` where title ='$pix'
LIMIT 0 , 8 ";
$results=mysql_query($query, $db_link);



no succes