English (sorry): Using MySQL record as URL in PHP?

03.11.2004, 07:55

Sorry, but I'm a bit desperate.

I have a database in which there's fields of event names and fields of URLs (all entered manually). I need an if/else statement that shows just the event name in a repeated region in a table ONLY if the URL field is NULL. Or else, it should show the event name and link to the URL listed in the corresponding URL field. Here's what I have, but it's not working. Any suggestions?

Info:
weddingEvent is the name given to this particular instance of the bound table. I used Dreamweaver, and it did the row_weddingEvent stuff on its own.
eventName is the name of the event and is a field in the table.
URL is the URL leading to a photo gallery of that event.

I need to get the URL to be used as a link with the text showing up as eventName in the php file when people look at it.

<?php if $row_weddingEvent['URL']=NULL ?><td><?php echo $row_weddingEvent['eventName']; ?></td>

<?php else ?><td><?php echo $row_weddingEvent['eventName']; ?></td>

Is this right? My page is showing up blank, but if I get rid of the if, else, and a href, it shows up fine (with a simple repeated region of weddingEvent['eventName'] by itself). A FULL HTML encoded page can be found here: http://www.dattiliostudio.com/phpExample.txt

-Galen

marsch · 03.11.2004, 09:40

as I already told you...

03.11.2004, 16:24

How do I apply this to my HTML?
Here's what I have so far:

PHP-Code:

 
<tr>

  <td><?php echo $row_weddingEvent['date']; ?></td>

  <?php if (is_null ($row_weddingEvent['URL'])) {

    print (sprintf ('<td>%s</td>', $row_weddingEvent['eventName']));

  } else {

    print (sprintf ('<td>[url="%s"]%s[/url]</td>', $row_weddingEvent['URL'], $row_weddingEvent['eventName']));

  } ?>

  <td><?php echo $row_weddingEvent['location']; ?></td>

  <td><?php echo $row_weddingEvent['type']; ?></td>

</tr>

It now prints the eventName, but not with the link (there was a URL assigned to it from the URL field), and just copying/pasting what you wrote didn't work. I've been looking through the PHP.net tutorials, but none of it really ties into what I'm trying to do: using a variable as a link.

marsch · 04.11.2004, 08:52

If it prints only the eventName, the URL is NULL. Did you spell URL correctly, or shouldn't it be named url instead? I cannot guess how your query looks like and what you are doing with your result set, as nobody can. There is too litlle information at all.

Themen-Optionen
Druckbare Version zeigen Jemanden per E-Mail auf dieses Thema hinweisen
Thema bewerten
Thema bewerten:

Ähnliche Themen
Thema	Autor	Forum	Antworten	Letzter Beitrag
[Erledigt] MySQL - ERROR 1044 bei erstellen einer Datenbank	_youngenterpriser_	Datenbanken	2	05.02.2008 17:56
Mysql Server Einstellunen Optimieren	pchero	Datenbanken	3	01.05.2007 19:50
Kein Zugriff über ODBC mit der IP-Adresse auf MySql DB		Datenbanken	4	09.02.2006 11:04
[Erledigt] Mysql 4.1.x unter php 4.3.9		Datenbanken	3	15.11.2005 13:49
Schnittstelle zwischen PHP und MySQL klappt net !!!		Datenbanken	16	16.10.2005 14:24
[Erledigt] not allowed to connect to this MySQL server		PHP Tipps 2005-2	2	23.09.2005 18:34
mysql_result(): supplied argument is not a valid MySQL		PHP Tipps 2005-2	4	25.08.2005 14:44
[Erledigt] MySQL Befehl für MySQL 4.0.24		Datenbanken	2	23.08.2005 17:35
Suche Tipps für Persormance-Steigerung (Geld für Nützliches)		Beitragsarchiv	18	16.08.2005 10:57
MYSQL läuft nur wenn /tmp auf 777		Datenbanken	5	06.07.2005 08:38
mysql root passwort vergessen		Datenbanken	1	29.05.2005 11:33
Access denied for user: '@localhost' / SYSTEM@localhost		Datenbanken	0	10.11.2004 20:35
English (sorry): Using MySQL record as URL in PHP?		Datenbanken	2	03.11.2004 16:21
js und ie erkennung	me	Beitragsarchiv	12	02.09.2004 17:18
[Erledigt] PHP5 &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;a m p; MySQL		Datenbanken	5	01.08.2004 05:47

03.11.2004, 07:55
Gast Beiträge: n/a	English (sorry): Using MySQL record as URL in PHP? Sorry, but I'm a bit desperate. I have a database in which there's fields of event names and fields of URLs (all entered manually). I need an if/else statement that shows just the event name in a repeated region in a table ONLY if the URL field is NULL. Or else, it should show the event name and link to the URL listed in the corresponding URL field. Here's what I have, but it's not working. Any suggestions? Info: weddingEvent is the name given to this particular instance of the bound table. I used Dreamweaver, and it did the row_weddingEvent stuff on its own. eventName is the name of the event and is a field in the table. URL is the URL leading to a photo gallery of that event. I need to get the URL to be used as a link with the text showing up as eventName in the php file when people look at it. <?php if $row_weddingEvent['URL']=NULL ?><td><?php echo $row_weddingEvent['eventName']; ?></td> <?php else ?><td><?php echo $row_weddingEvent['eventName']; ?></td> Is this right? My page is showing up blank, but if I get rid of the if, else, and a href, it shows up fine (with a simple repeated region of weddingEvent['eventName'] by itself). A FULL HTML encoded page can be found here: http://www.dattiliostudio.com/phpExample.txt -Galen


Mister Ad PHP Code Flüsterer Registriert seit: 21.08.2005 Beiträge: 4682 PHP-Kenntnisse: Fortgeschritten

03.11.2004, 09:40
marsch Erfahrener Benutzer Registriert seit: 19.10.2004 Beiträge: 498	as I already told you... __________________ Cheers, Marco

03.11.2004, 16:24
Gast Beiträge: n/a	How do I apply this to my HTML? Here's what I have so far: PHP-Code: `<tr> <td><?php echo $row_weddingEvent['date']; ?></td> <?php if (is_null ($row_weddingEvent['URL'])) { print (sprintf ('<td>%s</td>', $row_weddingEvent['eventName'])); } else { print (sprintf ('<td>[url="%s"]%s[/url]</td>', $row_weddingEvent['URL'], $row_weddingEvent['eventName'])); } ?> <td><?php echo $row_weddingEvent['location']; ?></td> <td><?php echo $row_weddingEvent['type']; ?></td> </tr>` It now prints the eventName, but not with the link (there was a URL assigned to it from the URL field), and just copying/pasting what you wrote didn't work. I've been looking through the PHP.net tutorials, but none of it really ties into what I'm trying to do: using a variable as a link.

04.11.2004, 08:52
marsch Erfahrener Benutzer Registriert seit: 19.10.2004 Beiträge: 498	If it prints only the eventName, the URL is NULL. Did you spell URL correctly, or shouldn't it be named url instead? I cannot guess how your query looks like and what you are doing with your result set, as nobody can. There is too litlle information at all. __________________ Cheers, Marco