Need help making a code. I am a n00b!

[wakerider017]

wakerider017 wrote:

Hi, guys.

I am trying to make a simple .PHP code that will create a random banner in 1 location

I put all the picture/link info in a table in my MYSQL DB..

And now I just ned a simple .PHP code that will create 1 random image at single location.

Hope this makes sense!

I did something like this before except it involved using several images and was also for my vbulletin forums. I am just trying to create something for a regular .PHP website...

Well here was the old code I used:

Maybe this will help in the creation of the new code?

$sql = "SELECT * FROM `ads` ORDER BY RAND()";  

$result = mysql_query($sql) or die(mysql_error()); 
$ads = array();  

while ($row = mysql_fetch_object($result))  

{  

    $ad =& $ads[];  

    $ad['HREF'] = $row->HREF;  

    $ad['SRC'] = $row->SRC;  

    $ad['ALT'] = $row->ALT;  

} 

 <tr><td> 
<a href='{$ads[0]['HREF']}'><img src='{$ads[0]['SRC']}' alt='{$ads[0]['ALT']}' border=0></a></td></tr>  

I will realllllly need help making this code... I am not very good with .php!

[Blulagoon]

Adding a limit to your code will select a single image at random:

$sql = "SELECT * FROM `ads` ORDER BY RAND() LIMIT 1"; 

// then

$result=mysql_query($sql);
$row=mysql_fetch_array($result);

// details you want contained in $row['HREF'] etc.  

HTH - Blu

[wakerider017]

Blulagoon wrote:

Adding a limit to your code will select a single image at random:

$sql = "SELECT * FROM `ads` ORDER BY RAND() LIMIT 1"; 

// then

$result=mysql_query($sql);
$row=mysql_fetch_array($result);

// details you want contained in $row['HREF'] etc.  

HTH - Blu

So This is bascily what I need to insert right?

$sql = "SELECT * FROM `ads` ORDER BY RAND() LIMIT 1"; 
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

{  

    $ad =& $ads[];  

    $ad['HREF'] = $row->HREF;  

    $ad['SRC'] = $row->SRC;  

    $ad['ALT'] = $row->ALT;  

} 

And then below that code I would just enter an HTML code?

<tr><td> 
<a href='{$ads[0]['HREF']}'><img src='{$ads[0]['SRC']}' alt='{$ads[0]['ALT']}' border=0></a></td></tr>  

Sorry but I am very new to .php

[Blulagoon]

No, you don't need any of that $ad stuff, that was used to help manage an array of results, whilst here you only want a single result.

Within the html all you need is:
<a href="<?php echo $row['href']; ?>"><img src="<?php echo $row['SRC']; ?>"></a>

I'm sure you can figure out how to add the alt and the border ......

Blu

[wakerider017]

Blulagoon wrote:

No, you don't need any of that $ad stuff, that was used to help manage an array of results, whilst here you only want a single result.

Within the html all you need is:
<a href="<?php echo $row['href']; ?>"><img src="<?php echo $row['SRC']; ?>"></a>

I'm sure you can figure out how to add the alt and the border ......

Blu

Cool!

So this is what I should have:

 $sql = "SELECT * FROM `ads` ORDER BY RAND() LIMIT 1";
$result=mysql_query($sql);
$row=mysql_fetch_array($result); 

<a href="<?php echo $row['HREF']; ?>"><img src="<?php echo $row['SRC']; ?>"> alt="<?php echo $row['ALT']; ?>"> border=0 </a>

Can you look over my HTML and make sure all that is correct. Thanks!

[Blulagoon]

?>" border=0> </a>

[wakerider017]

Blulagoon wrote:

?>" border=0> </a>

thanks

[wakerider017]

<?php
/*
  $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  [url]http://www.oscommerce.com[/url]

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<?php
  $info_box_contents = array();
  $info_box_contents[] = array('text' => sprintf("Weekly Sales & Announcements", strftime('%B')));

  new contentBoxHeading($info_box_contents);

  $info_box_contents = array();
  $info_box_contents[] = array('text' => '




<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0>





						<TR>
							<TD>					



					$sql = "SELECT * FROM `ads` ORDER BY RAND() LIMIT 1";    
$result = mysql_query($sql) or die(mysql_error());  

$ads = array();    

while ($row = mysql_fetch_object($result))    

{   echo "<border="0">$row->SRC</border="0">";  }



							<br>
&nbsp;</font><table align="center" border="0" cellpadding="0" cellspacing="0" width="98%" id="table1">



<tr>
	<td>





<b>News:</b>

<p><font size="2">Welcome to Florida-Speed.com!
We are currently under-construction. Thank you for your patience!</font></p>

<b>This Week\'s Sales: </b>

<p><font size="2">You will be able to find new Florida-Speed.com special offers here weekly!
</font>
</p>

<b>Group Purchases:</b>

<p><font size="2">You will be able to find all current Florida-Speed.com group purchases here!</font> 
</p>





</td>
	</tr>
</table>



							</TD>
							</TR>
					</TABLE>


					');

  new contentBox($info_box_contents, 0);
?><!-- new_products_eof //-->