(SOLVED) Crazy learning PHP for a UDT. Can you help...

[Andrew Prior]

I have around 100 images that need to display randomly in a couple of locations across a CMSMadeSimple site (1.9)

All will have title tags, some will contain urls as well.

I constructed a two column table called cms_pics, with the columns: id, titletag.
Id is simply an auto increment number, title tag is the code for the image eg

Code: Select all

<img src="uploads/images/{$num}.jpg" alt="Australia" title="Australia" />

{$num} is a randomly generated mumber corresponding to a row in the table

I tried to follow online tutorials but am totally lost. My UDT will accept the code below as valid, but displays nothing.

What I am trying to arrive at is an output string something like this:

Code: Select all

<img src="uploads/images/25.jpg" alt="Bicycle on Road" title="Riding the Great Ocean Road" />

This is my non working code. What do I need to fix?

Code: Select all

mysql_connect("localhost","user","password");
mysql_select_db("mydatabase");  
$result = mysql_query("SELECT * FROM cms_pics WHERE id = '1' ");  //id = $num
while($rows = mysql_fetch_assoc($result)){
echo $rows[$titletag]; 

}

You can tell me I know nothing... because it is true!
Any help would be great

[Duketown]

Andrew,

Maybe you can use:

Code: Select all

// Make a connection to the database
$db = cmsms()->db;
$query = 'SELECT * FROM '.cms_db_prefix().'pics';
$dbresult = $db->Execute($query );

// Now show the images information
while ($dbresult && $row = $dbresult->FetchRow())
{
  $num = $row['num'];
  $alt = $row['alt'];
  $title = $row['title'];
  echo '<img src="uploads/images/'.$num.'.jpg" alt="'.$alt.' title="'.$title.'" />';
  echo "\n";
}

Hope this helps,

Duketown

[Andrew Prior]

Well, mate
if you are ever in Adelaide, Google me.
I owe you a beer.
That code is nothing like what I was imagining! But it shows me the images, which is great.

I am actually wanting to show only one image when the page loads, based on a random generated number, so I need some kind of WHERE statement. I will try and work this out, but you may be able to do it in 3 or 4 keystrokes, which I would gratefully accept!
Andrew

[Andrew Prior]

Dketown, adjusting your code below (line 4) gives me just one image by choosing the image where num=2.

Code: Select all

// Make a connection to the database

$db = cmsms()->db;
$query = 'SELECT * FROM '.cms_db_prefix().'pics WHERE num=2';
$dbresult = $db->Execute($query );

// Now show the images information
while ($dbresult && $row = $dbresult->FetchRow())
{
 $num = $row['num'];
  $alt = $row['alt'];
  $title = $row['title'];
  
echo '<img src="uploads/images/headers/header_'.$num.'.jpg" alt="'.$alt.'" title="'.$title.'" />'; 
  echo "\n";
}

However i cannot seem to define a random number which is then parsed by that line. If I make a variable which equals 2, for example, this will not work.

Code: Select all

$fred="2";
$query = 'SELECT * FROM '.cms_db_prefix().'pics WHERE fred=2';

Can you tell me the correct syntax?

[Jos]

How about this:

Code: Select all

$query = "SELECT * FROM ".cms_db_prefix()."pics ORDER BY RAND() LIMIT 0,1";

[Andrew Prior]

Thankyou Jos and Duketown. Works Great. It's at onemansweb.org The code is in the pictures on the left bottom of the page. Andrew