PHP with MySQL problem

**riscphree** · 03-20-2005, 09:20 PM

ok, so i've got a site im integrating with a MySQL database.

on the index page i have a table with space for a date and text and whatnot, but right now, my current code will not get the text from the database. here is what i have:

PHP Code:


<body>

<?php include ("secure/mysqlsubs.inc");

connect_to_cms(); ?>

thats to start the body. and below that is a mess of tables that looks good when you view it smile.gif

and then in this specific table:

PHP Code:


<div class="cboxes">

<h4>

<?php

$find = mysql_query("select * from News");

$f=mysql_fetch_array($find);

$NewsDate=$f["NewsDate"];

echo "$NewsDate ";

?>

</h4>

i know the code is right, but nothing is getting output!

if anyone knows PHP/MySQL/HTML better than i seem to, i can let you look at the full source if you want. i just cant figure this out!

**Rawhide** · 03-25-2005, 05:55 PM

Let me preface my comments by saying that I'm not a PHP/MySQL developer.

Is there data in the table and field?

Try changing this line:

echo "$NewsDate ";

To this:

echo $NewsDate;

Otherwise, try reading through this: http://us3.php.net/manual/en/functio...etch-array.php

**riscphree** · 03-25-2005, 07:44 PM

nope that wasnt it. it was becuase at first i had made it all html and had the <?xml tags at the top with some xml stuff, i guess that confused it. i took those out and it worked fine.

Thread: PHP with MySQL problem

Thread Tools

Display

PHP with MySQL problem

Posting Permissions