picture viewer

[jr_yeo]

<?
$query1 = "SELECT $uniquerow,  prev_path, filename FROM $tablename";
$rs = mysql_query($query1);
$randomId = array();
while($row = mysql_fetch_array($rs))
  array_push($randomId, $row['id']);
$randomId = $randomId[rand(0, count($randomId))]
?>
<script>
function populateSelect(selectobj){
for (var i=0; i<randomId.length; i++)
selectobj.options[selectobj.options.length]=new Option(randomId[i], randomID[i])
if (selectobj.options.length>1){
selectobj.selectedIndex=0
showpicture(document.getElementById("picsform").picslist)}}</script>

is the code possible? tnx.

[djr33]

Er.... is WHAT possible?

[jr_yeo]

the code that i just posted?

[djr33]

Yes, you just posted code. Very possible.
But, what, exactly, would you like to do with the code?
If you've run it and there are problems, what are they? What would you like different? Etc.
Or, is, perhaps, this simply an easier/smaller version of what is on the site?
I didn't see the code there, so I'm not sure what specifically you are referring to.


Note that:
"Does this work?"
and
"How do you do this...?"
are very different questions, though both do require more information.

[jr_yeo]

on this link, the images are being read by using 'getpics.php'.
now i have a database for images. i want to get images from the database and the resultset pass thru the script, something like:

<?
$query1 = "SELECT $uniquerow,  prev_path, filename FROM $tablename";
$rs = mysql_query($query1);
$randomId = array();
while($row = mysql_fetch_array($rs))
  array_push($randomId, $row['id']);
$randomId = $randomId[rand(0, count($randomId))]
?>
<script>
function populateSelect(selectobj){
for (var i=0; i<randomId.length; i++)
selectobj.options[selectobj.options.length]=new Option(randomId[i], randomID[i])
if (selectobj.options.length>1){
selectobj.selectedIndex=0
showpicture(document.getElementById("picsform").picslist)}}</script>

the code betwen the <script></script> tags are just part of you will see in the link provided. how do i make this work?

[djr33]

Ah, now we're getting somewhere.

You've run it? What doesn't work?

First... this is php, I think, right? Looks like it from the code, and the link... you don't have an open php tag; you need to start it <?php, not <?.
Maybe that's the whole issue?

Too tired right now to analyze the wholet thing.


You will also need to output the values to the javascript, not just keep them in PHP.
For exaple:
<script>
<?php echo "var = 'value';"; ?>
</script>

[jr_yeo]

from what read somewhere in this forum, PHP and javascript dont mix very well. like oil and water

You've run it?,

not yet. coz logically speaking, its correct. but script wise, i know m missing something. i just dunno what.

Too tired right now to analyze the wholet thing.

sure np anytime ur batteries are recharged

[BLiZZaRD]

I am not a JS or a php guy, I am still trying to learn them myself... but if you are trying to access and pull images from the database, don't you need the host/user/password, etc to connect?

[jr_yeo]

don't you need the host/user/password, etc to connect?

yupz but do i have to post that info here?

[BLiZZaRD]

No, not expecting you too, LMAO... just making sure it was there is all. I usually XXXXX my info like that when I post. I just didn't see the spots for it, so I was just checking