Code is not executing in the first place; you'd at least expect a PHP error. Check your PHP installation; do a "Hello World"; the phpinfo()?.. make sure that your file is a .php (not php.txt....) - means you have to unhide file extensions. On Fri, Jul 26, 2013 at 6:15 PM, Andrew Nduati <nduatiandrew@gmail.com>wrote:
(' .$name. $cname. ''; mysql_close($dblink); ?>) Hey thats is what I'm getting.. Still looks the same as before..
On Fri, Jul 26, 2013 at 5:13 PM, Victor Yegon <viktayeg@gmail.com> wrote:
<?php
//Define database connection
$dblink = mysql_connect("localhost","root","") or die("Could not connect"); mysql_select_db("sample") or die(mysql_error());
$query = mysql_query("select * from Customers");
while($row = mysql_fetch_array($query)) {
$name = $row['CustomerName']; $cname= $row['ContactName']; }
echo '<div>' .$name. $cname. '</div>';
mysql_close($dblink); ?>
Check your table name if C is in uppercase or lowercase.
On Fri, Jul 26, 2013 at 4:01 PM, Andrew Nduati <nduatiandrew@gmail.com>wrote:
Looks like the same problem (*'; } mysql_close($connection); ?>*)
On Fri, Jul 26, 2013 at 3:31 PM, Eugene Maritim < kiprotich.maritim@gmail.com> wrote:
Ok! I just tweaked your code a little, Update the code as suits you!
<?php
//Define database connection $connection = mysql_connect('host', 'username', 'password');
//Select our database if(!mysql_select_db('sample')) { echo 'Could not connect to the database'; die(); }//if
$customers = mysql_query('select * from Customers', $connection);
while($profile = mysql_fetch_array($customers)) { echo $profile['CustomerName'] . ', ' . $profile['ContactName']; echo '<br/>'; }
mysql_close($connection);
On Fri, Jul 26, 2013 at 3:09 PM, Andrew Nduati <nduatiandrew@gmail.com>wrote:
Thanks for the response. The problem is still the same. I've just tried getting rid of the second echo but all I get is a blank screen. And I've confirmed that the DB has records.
On Fri, Jul 26, 2013 at 1:00 PM, Eugene Maritim < kiprotich.maritim@gmail.com> wrote:
Hey!
Find edited code below: 1. Swapped the order params of mysql_select 2. Changed mysql_select.db to mysql_select_db
<html> <head> <title>PHP Test</title> </head> <body> <?php
//SQL Part $host="localhost"; $username="root"; $password="";
$conn= mysql_connect($host,$username,$password) or exit("Connection Error".mysql_error());
mysql_select_db('sample') or exit("Database not found");
//Data from the query is stored in $result $result = mysql_query("SELECT * FROM profiles", $conn);
while($row = mysql_fetch_array($result)) { echo $row['CustomerName'] . " " . $row['ContactName']; echo "<br>"; } mysql_close($conn); ?> </body> </html>
On Fri, Jul 26, 2013 at 2:46 PM, Andrew Nduati < nduatiandrew@gmail.com> wrote:
> Good Afternoon Skunks, > Below is my PHP code that is meant to run an SQL Select > query however it doesn't seem to be working. All I'm getting when I open it > in the browser (*"; } mysql_close($con); ?> "*) > Please assist. > Kind regards. > > > > <html> > <head> > <title>PHP Test</title> > </head> > <body> > <?php > > > //SQL Part > $host="localhost"; > $username="root"; > $password="*****"; > > > $conn= mysql_connect($host,$username,$password) or exit("Connection > Error".mysql_error()); > > mysql_select.db('sample') or exit("Database not found"); > > //Data from the query is stored in $result > $result = mysql_query($conn,"SELECT * FROM Customers"); > > while($row = mysql_fetch_array($result)) > { > echo $row['CustomerName'] . " " . $row['ContactName']; > echo "<br>"; > } > mysql_close($conn); > ?> > </body> > </html> > > _______________________________________________ > skunkworks mailing list > skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards,
Yegon Victor | Web Specialist/Internet Consultant |
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Samuel Waithaka http://twitter.com/samwaithaka