[Resolved] Need help with empy fields

[psycovic23]

I've got 3 forms that you type text into and then it sends it off too a DB.

$info = "update images set url='$url', title='$title', caption='$caption' where id = '$id'";

The problem I'm having is that there is possibly already going to be stuff in 'url' beforehand. Is there anyway I can set it up so that if any of the variables aren't filled, it won't put that into $info?

For example, if $url was empty, instead of

$info = "update images set url='$url', title='$title', caption='$caption' where id = '$id'";

it would be

$info = "update images set title='$title', caption='$caption' where id = '$id'";

Any help would be appreciated.

[eoghain]

Yes, do something like this:

$query = "update images set ";
$sep = "";

if (isset($url)) {
   $query .= "url='$url'";
   $sep = ", ";
}

if (isset($title)) {
   $query .= $sep . "title='$title'"
   $sep = ", ";
}

if (isset($caption)) {
   $query .= $sep . ", caption='$caption'"
}

$query .= "where id = '$id'";

This checks to see if each variable contains data before adding it's section to the query.

[psycovic23]

Thank you very much...but now I have a new problem😃

I have a multiple dimension array (I think that's the right term). It is:

$r[url][# of items]
$r[title][# of items]
and so on.

I want to take each of the 'url' elements and put image tags around them. I don't know how to do this, because it always spits all of the 'url' elements out at once, rather than one at a time, so I can't apply image tags to them.

I got around this before with only one set of brackets ($r[# of items]) by making an incrementing variable and making it print $r[$x], but now I can't do that. I hope this is clear enough. Anyone have any ideas?

[eoghain]

To work with a multi-dimensional array you just keep adding []'s for each dimension. So to get the first entry under $r[url] you'd use $r[url][0].

So if you wanted to write some code to put the image tag around the value stored in your $r[url] array you could do something like this:

foreach ($r[url] as $key => $value) {
   print "<img src=whatever>" . $value . "</img>";

   // or to update the value
   $r[url][$key] = "<img src=whatever>" . $value . "</img>";
}

[psycovic23]

Ah, thank you very much.

[psycovic23]

Hm...something's up with it.

$result = mysql_query ("select * from images");
while ($r = mysql_fetch_array($result))
	{
	$url = $r['url'];
	foreach ($url as $key => $value)
		{echo '$value';
		}
	}
?>

I get

Warning: Invalid argument supplied for foreach() in /home/rightsid/public_html/mimesisprime/imagesubmit.php on line 15

It says it 12 times, so it's showing everything in the array...but something's still up.

It does the same thing if I do:

foreach ($r['url'] as...)

[laserlight]

$r is an array that contains the result set from one row of your query.
$r['url'] is one element one this array.
Now, is this element a scalar, or an array?
It most probably is a scalar, e.g. a string.
As such, you would have to re-write your logic in order to access the way you want to.

[psycovic23]

Hm...okay, now I'm completely lost. I tried laserlight's idea of rather it being an array, just a string. I did a print_r of $r['url'] and it only gives me one row. I need it to give me all the rows and all of the ['url'] elements, while throwing <img> tags around them. I'm rather lost, so any advice would help😃

[laserlight]

If you need to save the $r['url'] elements, then just create a temporary array for them.

Otherwise, you can do your image tag output while looping through with the while loop.

[psycovic23]

Nevermind, I figured it out.