sasa
-
Posts
2,804 -
Joined
-
Last visited
-
Days Won
1
Everything posted by sasa
-
what is Spry menu? can you post same code
-
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_find-in-set WHERE FIND_IN_SET('$colname_producto', id_compania)
-
$query = "DELETE FROM events WHERE town='colchester' AND date < $some_date";
-
http://hr.php.net/array_intersect
-
SELECT * FROM mytable ORDER BY ranks+0
-
fetch_array in a table loop 3 columns per row
sasa replied to samtwilliams's topic in PHP Coding Help
try <table width="100%" border="0" align="center" cellpadding="2" cellspacing="2"> <tr class="headercolour"> <td width="37%"><div align="center"> <div align="left">><? echo $col1; ?></div> </div></td> <td width="39%"><div align="center"> <div align="left"><? echo $col2; ?></div> </div></td> <td width="16%"><div align="center"> <div align="left"><? echo $col3; ?></div> </div></td> </tr> <? i = 0; while ($row = mysql_fetch_assoc($result)) { if ($i++ == 0) { ?> <tr class="tr" onMouseOver="h(this)" onMouseOut="n(this)"> <?php } ?> <td><? echo $row['customername']; ?>test</td> <?php if($i==3) { $i = 0; ?> </tr> <?php } } ?> </table> -
$values= " ('".implode("'), ('", $_POST['podcast_programming_exspertise']). "')"; $sql = "INSERT INTO table_name (field_name) VALUES $values";
-
<input type="radio" value="225.67;Microsoft Windows Vista Ultimate ($255.67)" name="os">Microsoft Windows Vista Ultimate ($255.67) and explode(';', $_POST['os'])
-
How do i use php code to do $date - $singup_date
sasa replied to lkh11lkh's topic in PHP Coding Help
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff -
try <?php require_once('../Connections/Sencore.php'); ?> <?php mysql_select_db($database_Sencore, $Sencore); $query_subVer = "SELECT * FROM `1067` ORDER BY decoderVersion"; $subVer = mysql_query($query_subVer, $Sencore) or die(mysql_error()); $row_subVer = mysql_fetch_assoc($subVer); $totalRows_subVer = mysql_num_rows($subVer); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <link href="../assets/css/style.css" rel="stylesheet" type="text/css" /> </head> <body> <table border="1"> <tr> <td>IPAddress</td> <td>Notes</td> <td>alias</td> <td>unitversion</td> <td>tssid</td> <td>stationname</td> </tr> <?php $curr_dec=''; do { if ($row_subVer['decoderVersion'] != $curr_dec){ echo "<tr><td colspan=\"6\">decoderVersion: $row_subVer[decoderVersion]</td></tr>"; $curr_dec = $row_subVer['decoderVersion']; } ?> <tr> <td><?php echo $row_subVer['IPAddress']; ?></td> <td><?php echo $row_subVer['Notes']; ?></td> <td><?php echo $row_subVer['alias']; ?></td> <td><?php echo $row_subVer['unitversion']; ?></td> <td><?php echo $row_subVer['tssid']; ?></td> <td><?php echo $row_subVer['stationname']; ?></td> </tr> <?php } while ($row_subVer = mysql_fetch_assoc($subVer)); ?> </table> </body> </html> <?php mysql_free_result($subVer); ?>
-
-
http://www.cit.gu.edu.au/doc/php_doc/function.mysqli-store-result.html
-
change value="<?php $row_query4['ID']; ?>" to value="<?php echo $row_query4['ID']; ?>"
-
print number_format($cost, 2);
-
http://hr.php.net/number_format
-
try <?php $test = 'This is a block of "Text" blah "sasa" <span class="foo">bar</span> ddddddd "xxxx"'; $patern = '/(^|>)[^<]+/s'; function my_qoute($a){ return str_replace('"', '"', $a[0]); } $test = preg_replace_callback($patern, 'my_qoute', $test); echo $test; ?>
-
$recs .= "$row"."$column".",";
-
UPDATE table_name SET cityID2=cityID WHERE 1
-
no when you 1st time call header('Location: ...') function curent page stop working
-
try <?php $test = 'http://www.phpfreaks.com/forums/index.php/topic,239826.0.html'; $a = parse_url($test); //print_r($a); echo $test = str_replace($a['host'], '[LINK REMOVED]', $test); ?>
-
try if ($name=="") { $error[] ="Name is a required please fill in and submit again."; } if ($email=="") { $error[] ="Email is a required please fill in and submit again."; } for ($i=0; $i<count($error); $i++) { echo $error[$i]; } [/code]
-
[SOLVED] Getting previous and next record in database
sasa replied to tail's topic in PHP Coding Help
yes and change order to ORDER BY `artist` DESC , `song` DSSC -
[SOLVED] Getting previous and next record in database
sasa replied to tail's topic in PHP Coding Help
( SELECT * FROM `tracks` WHERE `artist` = ( SELECT `artist` FROM `tracks` WHERE `id` = '$db_id' ) AND song > ( SELECT `song` FROM `tracks` WHERE `id` = '$db_id' ) ) UNION ( SELECT * FROM `tracks` WHERE `artist` > ( SELECT `artist` FROM `tracks` WHERE `id` = '$db_id' ) ) ORDER BY `artist` , `song` ASC LIMIT 1 -
[SOLVED] Getting previous and next record in database
sasa replied to tail's topic in PHP Coding Help
ups try this SELECT `id` FROM `tracks` WHERE `id` > '$db_id' AND `artist`=(SELECT `artist` FROM `tracks` WHERE `id` = '$db_id') AND `song`=(SELECT `song` FROM `tracks` WHERE `id` = '$db_id') ORDER by `artist`,`song`, id ASC LIMIT 1 UNION SELECT `id` FROM `tracks` WHERE `artist` > (SELECT `artist` FROM `tracks` WHERE `id` = '$db_id') AND `song` > (SELECT `song` FROM `tracks` WHERE `id` = '$db_id') ORDER by `artist`,`song`, id ASC LIMIT 1 -
[SOLVED] Getting previous and next record in database
sasa replied to tail's topic in PHP Coding Help
SELECT `id` FROM `tracks` WHERE `id` > '$db_id' AND `artist`>=(SELECT `artist` FROM `tracks` WHERE `id` = '$db_id') AND `song`>=(SELECT `song` FROM `tracks` WHERE `id` = '$db_id') ORDER by `artist`,`song` ASC LIMIT 1