Jump to content

Why sin't this working?!


HCProfessionals

Recommended Posts

$newsletter_settings_query = "SELECT * FROM newsletter_settings";
$newsletter_settings = mysql_query($newsletter_settings_query) or die("There was a problem with the SQL query: " . mysql_error());

$header_image = $newsletter_settings['sHeaderImage'];
$header_name = $newsletter_settings['sHeaderName'];
$header_text = $newsletter_settings['sHeaderText'];

 

None of those variables are displaying data.

Link to comment
https://forums.phpfreaks.com/topic/232755-why-sint-this-working/
Share on other sites

For those vars to work you need to add mysql_fetch_assoc

 

$newsletter_settings_query = "SELECT * FROM newsletter_settings";
$result = mysql_query($newsletter_settings_query) or die("There was a problem with the SQL query: " . mysql_error());
$newsletter_settings = mysql_fetch_assoc($result);

$header_image = $newsletter_settings['sHeaderImage'];
$header_name = $newsletter_settings['sHeaderName'];
$header_text = $newsletter_settings['sHeaderText'];

np

 

you can also use that inside a loop like this

 

$select = mysql_query("SELECT * FROM newsletter_settings'") or die(mysql_error());
while ($newsletter_settings = mysql_fetch_array($select)) {

$header_image = $newsletter_settings['sHeaderImage'];
$header_name = $newsletter_settings['sHeaderName'];
$header_text = $newsletter_settings['sHeaderText'];

}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.