Click here to Skip to main content
15,889,484 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
AnswerRe: Toolbar image Pin
Luc Pattyn26-Feb-11 23:20
sitebuilderLuc Pattyn26-Feb-11 23:20 
GeneralRe: Toolbar image Pin
dpuskaa1-Mar-11 9:04
dpuskaa1-Mar-11 9:04 
AnswerRe: Toolbar image Pin
Luc Pattyn1-Mar-11 9:15
sitebuilderLuc Pattyn1-Mar-11 9:15 
GeneralRe: Toolbar image Pin
dpuskaa2-Mar-11 8:45
dpuskaa2-Mar-11 8:45 
GeneralRe: Toolbar image Pin
Elham M3-Mar-11 4:10
Elham M3-Mar-11 4:10 
QuestionPython Pin
maliwar24-Feb-11 6:04
sussmaliwar24-Feb-11 6:04 
Questionrun once and insert twice in database Pin
nicholasng19-Feb-11 20:21
nicholasng19-Feb-11 20:21 
AnswerRe: run once and insert twice in database Pin
vicky8719-Feb-11 23:53
vicky8719-Feb-11 23:53 
Questiontrying to write a cookie Pin
MacRaider418-Feb-11 9:16
MacRaider418-Feb-11 9:16 
AnswerRe: trying to write a cookie Pin
Peter_in_278018-Feb-11 10:30
professionalPeter_in_278018-Feb-11 10:30 
GeneralRe: trying to write a cookie Pin
MacRaider419-Feb-11 1:46
MacRaider419-Feb-11 1:46 
AnswerRe: trying to write a cookie Pin
Peter_in_278023-Feb-11 12:34
professionalPeter_in_278023-Feb-11 12:34 
GeneralRe: trying to write a cookie Pin
Al4224-Feb-11 4:48
Al4224-Feb-11 4:48 
AnswerRe: trying to write a cookie Pin
Luc Pattyn24-Feb-11 5:24
sitebuilderLuc Pattyn24-Feb-11 5:24 
GeneralRe: trying to write a cookie Pin
MacRaider422-Mar-11 5:26
MacRaider422-Mar-11 5:26 
AnswerRe: trying to write a cookie Pin
Tony Wright (UK)24-Feb-11 2:39
Tony Wright (UK)24-Feb-11 2:39 
Questionwhy i cound't access apple's server with php curl Pin
wjun1976121918-Feb-11 5:10
wjun1976121918-Feb-11 5:10 
AnswerRe: why i cound't access apple's server with php curl Pin
Tom Chantler23-Feb-11 21:21
professionalTom Chantler23-Feb-11 21:21 
QuestionData normalization Pin
Mutugi from Nairobi14-Feb-11 20:14
Mutugi from Nairobi14-Feb-11 20:14 
AnswerRe: Data normalization Pin
Eddy Vluggen19-Feb-11 3:04
professionalEddy Vluggen19-Feb-11 3:04 
QuestionGetting google photo result by php Pin
ty-exexch-ko10-Feb-11 9:31
ty-exexch-ko10-Feb-11 9:31 
Questionmysql_query error Pin
komanche7-Feb-11 22:31
komanche7-Feb-11 22:31 
AnswerRe: mysql_query error Pin
Gerben Jongerius8-Feb-11 3:13
Gerben Jongerius8-Feb-11 3:13 
Questiondisplay query result in a table using PHP Pin
PermissionDenied6-Feb-11 20:10
PermissionDenied6-Feb-11 20:10 
here's my code... this is intended to display a query result in a table but i am getting unwanted characters and no table was displayed... what could be wrong with my codes? here it is... thanks in advance..

<html>
<body>
<?php

if (isset($_POST['btnSearch'])) {
//connection to the database
$connection = mysql_connect('localhost', 'root', '');

if (!$connection)
die(mysql_error());

//select database
if (!mysql_select_db('bbs', $connection))
die(mysql_error);
$SearchOpt = $_POST['SearchOption'];
if (empty($SearchOpt))
die("You did not select field.");
$SearchKey = $_POST['txtKey'];
if (empty($SearchKey))
die("You did not enter a keyword.");
$sqlQuery = mysql_query("SELECT * FROM t_board WHERE $SearchOpt LIKE '%$SearchKey%' ORDER BY registerTime DESC;");
if(!$sqlQuery)
die(mysql_error());
if (mysql_num_rows($sqlQuery)) {
echo "<tbody>";
$recs = mysql_fetch_array($sqlQuery) or die(mysql_error());
foreach($recs as $rec) {
echo "<tr>";
echo "<th>" . $rec['index'] . "</th>";
echo "<th>".$rec['subject']."</th>";
echo "<th>".$rec['writer']."</th>";
echo "<th>".$rec['registerTime']."</th>";
echo "</tr>";
}
echo "</tbody>";
}
}
?>
</body>
</html>
AnswerRe: display query result in a table using PHP Pin
Jules VDV9-Feb-11 4:56
Jules VDV9-Feb-11 4:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.